How can I get a total for each vendor in 2018

Thanks for dropping by the Community, @tegethoff.

That's a great question! I can help walk you through the steps on how you can get a total for each of your vendor in QuickBooks Online (QBO).

You can run the Transaction List by Date report. This will give you the total of all vendor payments in the date range selected. Here's how:

1. Go to Reports menu at the left panel, then enter Transaction List by Date on the search bar.
2. Set the Report period to Last Year and from the Group by drop-down, choose Vendor.
3. Click Run report.

You can also filter the transaction type by going to the Customize tab. Here's how:

1. On the report, click the Customize at the upper right.
2. In the Filter section, choose your preferred Transaction Type on the drop-down.
3. Select Run report again to refresh.

For your reference, you can also check out this article for further guidance: Run a report for all vendor payments.

That's it! Please let me know how it goes or if you're referring to something else in the comment section below. I'd be glad to answer should you have any additional questions or concerns. Cheers!

Is there any way to get only the totals for each vendor, rather than all the vendor transactions with totals at the bottom of each one?

Thanks!

This provides each vendor transaction with their total at the bottom of each group. Is there any way to get only the total for each vendor?

Thank you.

We can run the Expenses by Vendor Summary report, gregono.

This report displays the total only of all your vendors. Let me guide you with these steps:

1. From the Reports tab, enter and select Expenses by Vendor Summary.
2. Click the Customize button.
3. Filter the Report period.
4. Click the Filter drop-down.
5. Click Customer, and then select All.
6. Select All from the Vendor drop-down.
7. Click Run report.

You can click the print or export icon if you want to print or export this report.

I'll be around if you need more help.

This is great. I had missed this report earlier.

Thanks, Adrian_A!

"Expenses by Vendor Summary" doesn't come up for me in "Find Report by Name".

Entering "vendor" in that "find" text box returns "Transaction List By Vendor" and "Vendor Contact List", neither of which offers the Customization functionality you describe.

Why isn't "Expenses by Vendor Summary" available? Is that a feature restricted to certain service levels? 

Thanks

Thanks for joining in on this thread, @hgravois.

At this time, Expenses by Vendor Summary report are available for QuickBooks Online Essentials, Plus, and Advanced subscriptions. You can find out which reports are included with each subscription by viewing this Community article: Reports included in your QuickBooks Online subscription.

If you have any additional questions or concerns, please don't hesitate and reach back out! I'll be here to help you in any way that I can. Have a beautiful day.

OK, that explains it. Thanks! 

This report only shows the payments that are classified as "expenses". It doesn't include purchases for resale, for example.

Thank you for joining the thread, @John-N-.

In your case, you can open the Transaction List by Vendor report, then filter the transaction types to what you need. I can show you how.

1. Click on Reports at the left pane, then look for Transaction List by Vendor on the search field.
2. Open the report.
3. Go to the Customize menu.
4. Set the date, then choose the transaction type you want to display under Filter.

To group the transactions, you can click on the drop-down arrow under the Group by section.

For an additional reference while running or customizing your reports, you can open this article: Run reports in QuickBooks Online.

If you wish to save the current customization settings of your report, you can memorize it by clicking on the Save customization button. To learn check, check out this link.

I'm always here to ensure you'll be able to get the information you need. If you have any other questions, please feel free to add a comment below. Keep safe!

This isn't working at all. There is no "Group By" feature. Has Quickbooks Online changed, and this post is obsolete? What is it so hard to get the total paid to a vendor???

Hello there, loveburns. I appreciate you for joining here.

It could be that you're using QuickBooks Online (Simple Start). That's why the Group by feature is not showing on your end. If so, you may want to upgrade your subscription to make this option available on your report. You can check this article: Learn how to change your plan level to get more or fewer accounting features. 

Once done, you can follow the recommendation shared by my colleague above to get the total paid to a vendor FritzF. Still, you can run the Transaction List by Date report to view all the transactions made. To learn more about customizing and memorizing QuickBooks reports, check the links I've added below:
 

• Learn how to get the most out of your financial reports. 
• How to find, run, export to excel, and edit/delete a memorized report. 

Please stay in touch if you have other concerns. I'm right here to help you figure them out. Take care and stay safe.

I have several companies

How can I get a total for all the companies that one vendor without going into each company that the vendor is in

Thanks for joining in on this post, mb70.

I'll be happy to share a report.

You can run the Expenses by Vendor Summary. This report will display your total expenses for each vendor.

Here's how:

1. Go to Reports on the left panel.
2. Type Expenses by Vendor Summary in the search field.
3. Select the Report period and other field.
4. Click Run report.

Here's a sample screenshot for a visual guide:

To check what reports are included in your subscription and how to customize them, you can read these articles:

• Reports included in your QuickBooks Online subscription
• Customize reports in QuickBooks Online

You can always get back to me if you're looking for other reports. I'm always around to help. Have a great day!