Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Report showing invoices and subsequent payments without breakdown by account

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.

Screenshot 2021-02-04 120509.png

 

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.

4 Comments
QuickBooks Team

Report showing invoices and subsequent payments without breakdown by account

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.

Level 1

Report showing invoices and subsequent payments without breakdown by account

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.

QuickBooks Team

Report showing invoices and subsequent payments without breakdown by account

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:

 

  1. Go to the Reports menu at the top to choose Customers & Receivables and Open Invoices.art.png
  2. Set the correct period in the Dates field.
  3. Click the Customize Report button open the Modify Report screen.art.1.png
  4. Choose the Display tab and remove the items that you don’t want to show on the report.
  5. Hit the Filters tab and type Transaction Type in the field box to select Invoice.
  6. Press the OK button.
  7. Scroll down to the bottom of the page to see the total amount for invoices.art2.png

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.

Level 1

Report showing invoices and subsequent payments without breakdown by account

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.

 

Screenshot 2021-02-05 090547.png

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us