Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get a report that shows how much you spent with a vendor

I want to see how much we have spent with specific vendors over a few different periods (our fiscal year, our contract year with the vendor, and the calendar year).  I can't find anything in vendor reporting that doesn't seem to only focus on bills outstanding, not bills already paid.  The vendor purchase reports give me 0 so I am not sure where it pulls its info.  If I go through the vendor itself and do a quick report, it doesn't give me totals!  I can get a quick total right in the vendor itself, but only on the screen (it won't printout) and not for all the date ranges I want.  

This seems like a really simple, common report and I feel like I must be missing something right in from of my face!

QuickBooks Team

Re: How to get a report that shows how much you spent with a vendor

Hi again jmkentel,


I know there are many vendor reports, so sometimes it can be a little tricky to track down the right one for what you need. I'll give you a few suggestions and let you work your magic to try to customize them to see specific vendors or any other way that you need.


Have you taken a look at the Expenses by Vendor Summary or Expenses by Vendor Detail reports? If not, I'd start there. Each of these show the company's total expenses with the vendors and the detail report gives you a more in-depth look at where those totals are coming from. You can run either of these reports for the time period you need and export or print them for your comparison.


The Purchases by Vendor Summary or Purchases by Vendor Detail reports will show you the company's total purchases per vendor.


Another report to consider is the Transaction List by Vendor report. It'll show you all transactions for each vendor. The only thing you'll be missing are totals.


To find these reports and search for others that may help, I recommend going from the Reports Centre directly. Go to the Reports menu in the top menu bar and then choose Report Centre. You're able to see more options there by scrolling through or using keywords to search.


I encourage others to share their thoughts as well if you've found something that works for you.


Check out these articles below to learn about customizing reports.

Have a great day!

Established Community Backer **

Re: How to get a report that shows how much you spent with a vendor

You're right! It should be simple and is possibly available in US versions of QB. I can't see any report for Vendor Purchases or Expenses by Vendor. I use the Vendor Balance Detail Report (go to Reports>Vendors and Payables>Vendor Balance Detail). When the report opens, click the Customize tab, then Filter>Transaction Type: Bills and Bill Credits (and Credit Card if you ever use CC to purchase). Now you have a total of everything purchased from ALL Vendors. Memorize the report as is for future use. Each time you need to check on a Vendor, open the Memorized report and filter for the Vendor and dates you need and print.

QuickBooks Team

Re: How to get a report that shows how much you spent with a vendor

Hi impossible,


We can run the Rebuild and Verify Data Utility tool to check and resolve possible data damage to your company file.


To run the Rebuild Data tool:

  1. Click File, then click Utilities and Rebuild Data.
  2. On the QuickBooks Information window, select OK. Then, follow the prompts to save a backup.
  3. Click OK when you see Rebuild has completed.

To run the Verify Data tool:

  1. Click File, then click Utilities and Verify Data.
  2. If you see QuickBooks detected no problem with your data, select OK
  3. If Verify finds an issue with your data, you will be prompted to Rebuild Now.

Please check out this article for more information: Resolve data damage on your company file.


After that, you can check the Vendor Purchases or Expenses by Vendor report again.


Though, filtering the Vendor Balance Detail Report also works.


Let us know if there's anything else you need. We're always here to help.