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
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.
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.
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
This current report lists all vendors. Any thoughts?
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.
If you have any other questions or concerns, feel free to post here anytime. Thank you and have a lovely afternoon.
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.
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.
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.