Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
chaneymillerinc
Level 2

Estimate and Progress Payment Report for specific customer in QB Desktop

I am wondering if there is a report that will show the Estimate Total, the Progress Payments Total and what the balance of the Estimate currently is at.

 

When our customers do progress payments, a few of them would like to see a report that shows what the initial Estimate was, the amount of their Progress payments made and what the "balance due" is currently.

 

When I invoice the customer, I am doing it as follows:

Home page of QB Desktop
Create Invoices
Customer Job

Select the estimate to invoice

Create invoice for selected items or for different percentages of each item (customer doesn't pay the remaining amount, now a percentage of the estimate)
Enter in the $ amount customer wants to pay
Invoice populates and then I email it off

When the customer pays I do the following:
Home Page

Receive Payments

Received from

Payment amount

and it applies towards that particular invoice.

 

What I would like to do is have a report that shows the total of the original estimate, the payments made towards that amount and what the remaining balance is. 
The only thing I have found so far is the Job Progress Invoices vs. Estimates. 
It prints out for all customers for the time frame indicated and I want something for one customer. 

 

1 Comment 1
ReymondO
Moderator

Estimate and Progress Payment Report for specific customer in QB Desktop

Thanks for sharing your concern in QuickBooks Community, @chaneymillerinc.

 

For now, the option to create a report that shows the original estimate, the payments made towards its invoice, and its remaining balance is unavailable in QuickBooks Desktop. 

 

Since estimates can only be linked to an invoice and not the actual payments, you'll have to run two separate reports to show these data in QuickBooks. One is to run the Job Progress Invoices vs. Estimates report to show the original estimates and the remaining balance. Here's how:

 

  1. Go to the Reports menu.
  2. Select Jobs, Time & Mileage.
  3. Click Job Progress Invoices vs. Estimates.

 

To track the payments made, you can run the Transaction Detail report. Go back to the Reports menu and select Custom Reports. Then, click the Transaction Detail report.

 

You can also export the data from these reports and combine them in Microsoft Excel to easily review your sales and estimates. 

 

Moreover, you can send feedback to our developers about this matter. They can review your suggestions and mostly include them in future updates. 

 

Additionally, here are some resources that'll guide you in running and customizing reports to show the correct data:

 

 

Let me know in the comment section if you need more help in running and customizing reports. I'll be right here to keep assisting.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us