cancel
Showing results for 
Search instead for 
Did you mean: 
JoyceGTX
Level 2

print vendor total report

I would like to print a report listing vendors and total amount paid within a given time period. I do not need transaction details, just total paid to XYZ vendor. I know I can print the vendor transaction detail and there would be a  total there, but then I'd have to filter out the transactions. Surely there's a way to just get the totals?

 

thanks for your help

3 Comments
Ryan_M
QuickBooks Team

print vendor total report

Hi @JoyceGTX,

 

I'll share insight on the type of report you can run that's specific for your needs. 

 

I suggest you run the Expenses by Vendor Summary report. It has the option to display only the total amount paid per vendor.

 

Here's how:

 

  1. Go to the Reports menu.
  2. Type in Expenses by Vendor Summary on the search box.
  3. On the report page, set the Report period that you need.
  4. Change the Display columns by drop-down menu to Totals Only.
  5. Hit Run report.
  6. Click the Print icon to proceed with printing the report. 

In case you need to edit reports within QBO, see the full details in this article: Customize reports in QuickBooks Online. It includes a short clip of the customization process as your reference.

 

Also, you can save your custom reports so you don't need to go and customize their original reports each time you need it. Take a look at this article: Memorize reports in QuickBooks Online

 

Feel free to place a comment below if you have other questions. I'll be sure to get back to you. 

JoyceGTX
Level 2

print vendor total report

Thank you for your response. I found that report  after I posted this question. However, that report doesn't give me the option of seeing vendors by GL expense account. When preparing budgets, I would like to give my IT department a list of vendors that hit their GL expense accounts and  the totals spent.  

 

e.g.  GL Expense

         Internet  Connectivity

               Google             $2000

               Microsoft         $1000

 

This current report lists all vendors. Any thoughts?

Nick_M
QuickBooks Team

print vendor total report

Hi there JoyceGTX.

 

Thanks for dropping by this afternoon, I'm happy to show you how to run the General Ledger expense report you're looking for. Follow along below. 

  1. Go to Reports.
  2. Under For my accountant, select General Ledger.
  3. Click Customize.
  4. On the Filter menu, select Account.
  5. Click the drop-down arrow and you'll find a wide array of categories to customize. 
  6. Click Run report.

If you have any other questions or concerns, feel free to post here anytime. Thank you and have a lovely afternoon. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us