Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello all, I've followed directions from another topic to get a Quickbooks Desktop report of all invoices and all payments made on them, which is great, but I would like each invoice to be a single total rather than broken down into accounts (in my case, Administration, Tech Support, Engineering, Equipment, etc.). The payments can stay broken up into transactions since sometimes we receive payments from multiple sources to a single invoice.
An example is in the screenshot; the report gives me all the line items within the invoice depending on their Account, and I just want to see the one total for the invoice, for all my invoices to date.
If this was a poor way to set up QuickBooks, I apologize, this is a 14-year-old system that I inherited and I am but a simple engineer trying to do two people's jobs.
Hi myforumID.
Thank you for stopping by the Community today. Unfortunately, QuickBooks Desktop doesn't have a report that breaks down the invoice by account used. However I can see how that would be beneficial to you and your business and many others as well. So I'm going to suggest this feature to our product engineers, that way they can look into implementing it in a future update. In the meantime, you can keep an eye on the QuickBooks Blog for any changes and updates to our products. If you have any other questions, don't hesitate to post here anytime. Thanks again have a lovely day.
Unfortunately, QuickBooks Desktop doesn't have a report that breaks down the invoice by account used.
Hi Nick, nope, that's the opposite of what I'm asking-- the report IS breaking down the invoice totals and I don't want that to happen.
Welcome back to the Community, myforumID.
I can see how essential for your business to have a report that shows the total for all invoices to date. Let’s run the Open Invoices Report and customize it to show the data you need.
The report will show all invoices for each customer and the total amount. I’ll help you build the statement.
Here’s how:
For more insights into the process, check out this article. It provides detailed information on how to use the Display, Filter, Header/Footer, Fonts & Numbers tabs: Customize reports in QuickBooks Desktop.
Additionally, this link outlines the complete instructions about customizing customer, job, and sales reports.
Please let me know if I can be of further assistance. I’ll be around to lend a helping hand. Wishing your business continued success.
I did some more poking around and found that what I was looking for was to set the Account in filters to Accounts Receivable and "Include Split Data" to "No". Cheers.
Can you direct me to the initial post and/or directions you followed to get this report?
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