Transaction List by Vendor Report

Hey there, GAJ. 

Thanks for stopping by! There absolutely is a Transaction List by Vendor report, to access it all you have to do is follow these few steps. 

1. Sign in to your QBO account. 
2. Click Reports on the left. 
3. Type Transaction list by vendor on the right side. 
4. If you want to Customize the report, click Customize. 

If there's anything else I can help you with in the meantime, feel free to post below. Thank you for your time and have a nice evening. 

Hi Nick,

How do I get subtotals by vendor in the Transaction List by Vendor Report?

Thanks.

Thanks for getting back to us, GAJ.

The subtotal option is only available in customer-related transactions. Vendor-related transactions only display the Total amounts. Hence, the Transaction List by Vendor report doesn't have an option to see subtotals.

The closest report that I can think of is the Transaction Detail by Account report. We can customize it to see the details of your vendor transactions:

1. Click Reports on the left menu and search Transaction Detail by Account.
2. Click the Customize button and go to the Filter section.
3. Mark the vendor-related transactions in the Transaction Type field.
4. Mark the vendors you want to see.
5. Click Run Report.
   You can export it to Excel if necessary.

The report will now display the amounts per line item or account of the vendor transactions.

We'll be right here if you need anything else. Have a great day!

Hi Nick, James

Thank you for your look-sees on my question.

FYI, you led me to the Transaction Detail by Account Report, customized to group by Vendor.

This gives me detail by vendor with vendor subtotals, exactly what I need. 

The Expenses By Vendor Summary, w/o the detail, is also very useful.

Unfortunately I have two QBO accounts, one personal Simple Start, one business Essentials.

Both of these reports are not available in the Simple Start plan, so I will have to download to Excel, or upgrade.

I very much appreciate both of your times to help me out here.

Thank you.

Gary 

When I try to run this report and only select a few of my vendors, it returns every vendor.

Hi there, nduffy!

Allow me to add inputs.

It will return to showing every vendor if you reopen the report. Supposedly, you would export the data to Excel or save it (Save Customization) to add the customized report to your list of Custom reports. See more info about customizing reports.

You can always visit us back through this thread if you have more questions.

i need a trend report for all vendors summarized so i can see how much we spent with each vendor on a monthly basis. Is there such a report in qb? 

There's a report that will show all your money spent on your vendors, @mgolabchi.

We can run the Expenses by Vendor Summary. Let me show you how:

1. Sign in to your QuickBooks Online account.
2. From the left menu, choose Reports.
3. In the Find report by name field, search and choose Expenses by Vendor Summary report.
4. Select the date under the Report Period.
5. In the Display columns by section, choose Months.
6. Once done, click Run report.
   
   

We can also customize to drill-down and add some details to your report. 

For future reference, I've added these resources to guide you manage your reports in QBO: 

• Memorize reports
• Popular custom reports

Feel free to let me know if you have other concerns in running reports in QBO. I'll make sure to get back to you right away. Have a wonderful day.

I am trying to print a transaction report that will show my vendor payments that will include the vendor invoice(s) number(s) included in that payment.  I have been able to create a report that shows the payments but will not list the invoices that were paid.  Thanks,

I know a report that shows the information you need, @Paige L.

I’m happy to see you here in this thread. Allow me to provide instructions so you can generate a report that shows vendor payments, bills/invoices, numbers, and even their statuses.

You can run Transaction List by Vendor report in QuickBooks Online. Just make sure to filter the details so everything will show up. Here's how:

1. Go to your Reports menu.
2. Enter/select Transaction List by Vendor in the search field.
3. Select Customize, then filter the necessary details.
4. Hit Run report.
5. Press the Small gear icon, then mark the A/P Paid.
6. Select the Print icon.
   

To learn more about our report features in QuickBooks, see this article about running reports. It includes instructions on how to modify and memorize them.

In case you need more tips and information on how to manage your account and business finances. We have available training videos and webinars to help you understand our product features, functions, and benefits of QuickBooks.

Don’t hesitate to respond on this thread if you have additional questions or concerns about reports. We’re here anytime to help. Always take care!