cancel
Showing results for 
Search instead for 
Did you mean: 
CharlieBrown69
Level 2

Where can i pull up a vendor report that will give me the total paid to that vendor in a specified time?

 
6 Comments 6
Easton at J E Cole Bookkeeping
Level 4

Where can i pull up a vendor report that will give me the total paid to that vendor in a specified time?

Hey Charlie,

 

The report you are looking for is the Transaction List by Vendor report. This can be found by selecting the report tab to the left, scrolling down to the Expenses and Vendors section and it should be on that list. You can even customize the report to filter on specific vendors. Hope this helps!

CharlieBrown69
Level 2

Where can i pull up a vendor report that will give me the total paid to that vendor in a specified time?

It does not give me the total paid to that vendor, though, unless I do not have the settings customized correctly.

CharlieBrown69
Level 2

Where can i pull up a vendor report that will give me the total paid to that vendor in a specified time?

I cannot get the total amount paid to the vendor.  Unless i have one of the customized settings wrong.

Angelyn_T
QuickBooks Team

Where can i pull up a vendor report that will give me the total paid to that vendor in a specified time?

Thank you for joining the thread, @CharlieBrown69.

 

The Transaction List by Vendor report will show you the expenses or transactions you have for your vendors but won't show the total amount paid. You need to manually add the amount to achieve the total. However, you can pull up the Expenses by Vendor Summary to get the total expenses for each vendor selected.

 

To run the report:

 

  1. Click on Reports at the left pane.
  2. Look for Expenses by Vendor Summary on the search field, then click the report.
  3. On the report's page, make the necessary customization (reports period, the vendor you want to display, and others).
  4. Tap on Run report to refresh the page.
  5. You can see the total expenses you had for your vendors under the Total column.

c9 3.PNGc9 4.PNG

 

To achieve the process of customizing the reports, you can also read this article: Customize your reports in QuickBooks Online.

 

Also, you can memorize your reports for future use, for the steps, refer to this article: Memorize reports.

 

Keep me posted if you have any other questions. I'll keep an eye to help. Have a wonderful day!

CharlieBrown69
Level 2

Where can i pull up a vendor report that will give me the total paid to that vendor in a specified time?

Yes, I can can that report but I want it to show me the grand total paid to the vendor to date.

 

Michelle_b
QuickBooks Team

Where can i pull up a vendor report that will give me the total paid to that vendor in a specified time?

Thank you for coming back here in the Community, @CharlieBrown69.

 

Currently, reports that show the total of each vendor is unavailable in QuickBooks Online. As a workaround, you can pull the Transaction List by Vendor as by @Easton at J E Cole Bookkeeping mention above. Then export the report to Excel and from there, you can get the sum of the total checks for each vendor. 

 

To access the report: 

 

  1. Go to the Reports tab, then in the search box type Transaction List by Vendor.
  2. Click the Customize button at the upper left.
  3. Hit Row/Columns, then under Group by choose Vendor.
  4. Click Filter and in the Transaction Type drop-down arrow choose Bill Payment (Check)
  5. Tap Run Report

 

reportss.PNG

 

To accomplish the process of customizing the reports, you can browse this article: Customize your reports in QuickBooks Online.

 

You can memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use, you can check this article: Create, access and modify memorized reports. This way, you do not have to go through the customization process again. 

 

If there's anything else you need, let me know. It's always my pleasure to help. Take good care!

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

Need to get in touch?

Contact us