cancel
Showing results for 
Search instead for 
Did you mean: 
Kaylafett
Level 1

Is there a report showing the paid amount to date against my customers' invoices?

I am trying to see if there is a report showing whats been paid to date against the estimate, what is still open and what is left to be invoiced..

4 Comments 4
Regina_Lend_A_Hand_Accounting
Level 9

Is there a report showing the paid amount to date against my customers' invoices?

Yes. The "Invoices and Received Payments" Report under "Who Owes You".

Regina_Lend_A_Hand_Accounting
Level 9

Is there a report showing the paid amount to date against my customers' invoices?

QB users already have the phone number for QB support. They simply want answers to their specific QB questions, which I already provided.

MaryGraceS
Moderator

Is there a report showing the paid amount to date against my customers' invoices?

Hello there, @Kaylafett.

 

Great to see you here in the QuickBooks Community. I'd be happy to help share the steps how you can generate the report that you need.

 

You can customize the Job Progress Invoices vs. Estimates report to show the paid amount against the estimate, what is still open and what is left to be invoiced. However, it won't show the paid amount date against the customers' invoices.

 

In the meantime, you can enter a memo on the invoice, estimate, and payment for you to easily identify in which transaction it's against.

 

Here's how:

  1. From the Reports menu, select Jobs, Time & Mileage.
  2. Select Job Progress Invoices vs. Estimates.
  3. At the top left, click the Customize Report button.
  4. Click the Display tab.
  5. Type Open Balance and Memo in the COLUMNS section, then put a checkmark beside them.
  6. Click the Filters tab, then type Transaction Type in the CHOOSE FILTER section.
  7. Click the Transaction Type drop-down, then select Multiple Transaction Types.
  8. In the Select Transaction Types window, select Invoice, Estimate, and Payment.
  9. Click OK twice.

You can also memorize this report to save its customization. Feel free to read these article for the detailed steps:

That should do it. I'm just a post away if you have any other questions about the report showing the paid amount date against the invoice. I'll be happy to help you further.

Regina_Lend_A_Hand_Accounting
Level 9

Is there a report showing the paid amount to date against my customers' invoices?

I have noted a QuickBooks Online report above. I just realized that the question was specific to the desktop version of QuickBooks. There are multiple way to customize payment reports in the desktop version using the customize report feature.

Need to get in touch?

Contact us