Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
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.
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:
- Go to the Reports menu at the top to choose Customers & Receivables and Open Invoices.
- Set the correct period in the Dates field.
- Click the Customize Report button open the Modify Report screen.
- Choose the Display tab and remove the items that you don’t want to show on the report.
- Hit the Filters tab and type Transaction Type in the field box to select Invoice.
- Press the OK button.
- Scroll down to the bottom of the page to see the total amount for invoices.
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.
