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

Vendor totals

Is there a way to run a report that shows just the totals paid to a particular vendor and GL account? I need to run a report for insurance showing the totals of all of our subcontractors used and the 1099 report doesn't work because most of them don't receive a 1099. If I run vendor totals it's going to be a report for every single vendor which I don't want. I need a report for one or more GL accounts with vendor totals if at all possible. 

2 Comments 2
SarahannC
Moderator

Vendor totals

Let me help you take a few steps to get this done, loilars.

 

Getting all the details paid to a particular vendor and GL account in one report in QuickBooks Desktop would be great. However, there's a workaround to include them in one report. 

 

The closest report you can run is the Transaction List by Vendor report. Then, export it to Excel to get the total paid to a vendor and accounts.

 

  1. Go to the Reports menu.
  2. Under the Vendors & Payables section, choose Transaction List by Vendor.
  3. Click the Customize button.
  4. Under Display, tick Account. You can include Debit and Credit.
  5. In the Filter section, search for Preferred Vendor. Add the vendors you need.
  6. Click OK to reflect the changes.
  7. Select the Excel drop-down arrow and select Create New Worksheet. Follow the on-screen instruction to complete the process.

 

You can also run the General Ledger report and customize this to get the data you need. Export it to Excel and manually edit it to get and eliminate the data you don't need. You can combine the two reports.

 

Here's an article for more tips about customizing reports in QuickBooks Desktop (QBDT): Run and customize reports in QuickBooks Desktop.

 

You can always add a new post in this thread about generating reports. I'm always here to help you in any way that I can. 

loilars
Level 2

Vendor totals

Thank you for your time and the response. Unfortunately, this is some version of multiple things I've tried. I don't understand why there is the option of "total only" on so many reports but not the Transaction List by Vendor does not have this. Because that's what I need. 

Running a report and exporting to Excel and customizing that report is what I did. It just seems this is something Quickbooks reports should be able to easily do. 

 

Thank you again. 

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

Need to get in touch?

Contact us