Question

print vendor total report

Forum|Forum|6 years ago
August 20, 2020
6 replies
36 views

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

QuickBooks Online

R

Ryan_M

Moderator

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:

Go to the Reports menu.
Type in Expenses by Vendor Summary on the search box.
On the report page, set the Report period that you need.
Change the Display columns by drop-down menu to Totals Only.
Hit Run report.
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.

J

JoyceGTXAuthor

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?

N

Nick_M

Level 4

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.

Go to Reports.
Under For my accountant, select General Ledger.
Click Customize.
On the Filter menu, select Account.
Click the drop-down arrow and you'll find a wide array of categories to customize.
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 up

Login with SSO

Let's get you signed in

Login with SSO