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

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

6 Comments 6
Ryan_M
Moderator

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 3

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. 

lahatte
Level 3

print vendor total report

What Quickbooks is this?????? There is no "search" option in the menus. I have Quickbooks Premier 2019. I cannot find ANY information on doing this that matches my software. Quickbooks is terrible. Making difficult what should be simple.

Mich_S
QuickBooks Team

print vendor total report

Hi there, @lahatte.

 

The steps provided by my colleague @Ryan_M are only applicable for QuickBooks Online version that's why you're unable to see the Search option when running the report.

 

Nonetheless, I can share with you how you can access the Expenses by Vendor Summary report on your QuickBooks Desktop account.

 

Here's how:

  1. Click on the Reports menu.
  2. Select Company & Financial.
  3. Once done, click on Expense by Vendor Summary to open the report.

Refer to this diagram for your convenience.

 

 

 

Feel free to check out these articles to learn more on how you can manage reports in QBDT:

 

We're always here to back you up if you need further help with reports or QuickBooks. Just leave a comment below. Stay safe.

 

lahatte
Level 3

print vendor total report

Thanks for the information.

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us