Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here