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

Estimate to Invoice Balance Detail

How I do my invoicing for my customers through QB is as follows: I create an Estimate under the certain customer name with individual prices on the line items depending on the work. From there, I create an invoice from the estimate. When I look at my customer profile, I can see that original estimate shows the original amount and the open balance (open bal is lower because I am drawing money out for invoices). I can't find a report that will now show me what my original estimates line items were, how much I have previously invoiced, and the total amount remaining. It shows what I want when I create a new invoice but I can't print on the invoice what I have previously billed or the percentage of previous billed. 

5 Comments 5
Archie_B
QuickBooks Team

Estimate to Invoice Balance Detail

Hello there, sguidice.

 

I'll share some information to help you understand how to manage your estimates and invoices, as well as which reports you can use in QuickBooks Desktop.

You can turn on and use progress invoicing in QuickBooks Desktop. This feature lets you split an estimate into multiple invoices, allowing you to request partial payments throughout the project. This also keeps your customer payments organized and ensures a smooth transition from the initial estimate to the progress invoice.

 

To set up the progress invoicing feature in QuickBooks Desktop, follow these steps:

 

  1. Sign in to QuickBooks Desktop as an admin.
  2. Go to the File menu and then hit Switch to Single-user mode.
  3. Go to the Edit menu and click Preferences.
  4. Choose Jobs & Estimates from the list of menus.
  5. Select the Company Preferences tab.
  6. Click Yes in the DO YOU CREATE ESTIMATES? section. Then hit Yes in the DO YOU DO PROGRESS INVOICING? section.
  7. Select OK to save and close your preferences.
  8. If you need to, go back to the File menu and click Switch to Multi-user mode.

 

Once you've set up progress invoicing, you can run the Job Progress Invoices vs. Estimates report. This report will show you the original estimate amount, previous invoiced amount, and total amount remaining for each customer.

 

Here's how:

 

  1. Go to the Reports Center.
  2. Select the Jobs, Time & Mileage from the list.
  3. Scroll down to the Job Estimates section.
  4. Then, click Job Progress Invoices vs. Estimates.

 

More information on progress invoicing can be found in this article: Set up and send progress invoices in QuickBooks Desktop.

 

I've added this link as a future reference if you need to email sales forms, invoices, and statements in QuickBooks Desktop.

 

Come back to this thread if you require any further assistance with customer transactions or reports. I'll be happy to help. Have a good one.

sguidice
Level 1

Estimate to Invoice Balance Detail

Thank you for that information however it does pull the information I need. When I write an estimate, my "GL Code" is "Contracting". I have multiple line items such as "Building Permit, demo, framing, painting, flooring, etc" which all have individual price points. I would like to have a report show me what my original estimate had as a "scheduled price' and the report to then pull what i have progress invoiced off that estimate and how much is remaining to bill on the estimate.

SirielJeaB
Moderator

Estimate to Invoice Balance Detail

Welcome to the Community, sguidice. It is a pleasure to assist you with your query. Please allow me to provide you with some information regarding this matter.

 

We aim to make QuickBooks Desktop (QBDT) easy to use for all your tasks. Currently, the reports you want to run within your program that display the information you need are not available in QBDT. We suggest submitting a feature request to our software engineers. They can consider adding this functionality in future product updates. Here are the steps to follow:

 

  1. Select the Help option, then click the Send Feedback Online option.
  2. Tap Select the Product Suggestion option. A pop-up window appears.
  3. Enter your feedback suggestion.
  4. Hit the Send Feedback button. 

 

Please feel free to visit the following articles for your reference in managing reports moving forward:

 

 

Should you have further inquiries about QuickBooks, kindly click the Reply button below or submit your concerns in the Community section. May you have a pleasant day ahead, sguidice!

icjerk1
Level 2

Estimate to Invoice Balance Detail

I too, have been looking for a report that would show this info!

AnneMariee
QuickBooks Team

Estimate to Invoice Balance Detail

Hello there, icjerk1.

 

The ability to track individual items in your estimate and the amount you've already invoiced your customer is a valuable feature that could greatly benefit your business. However, this option isn't available in QuickBooks Desktop. Therefore, I recommend submitting a feature request through the feedback section. You can follow the steps provided by my colleague above to do so.

 

In the meantime, you'll need to manually check your estimates for your progress in invoicing customers. To help you with this, you can run the Job Progress Invoices vs. Estimates report. Then, double-click each transaction to view them. From there, you can check how much progress you've made in invoicing your customer.

 

If you'd like to learn more about progress invoicing, please refer to this article: Set up and send progress invoices in QuickBooks Desktop.

 

If you have customized a report and would like to save its settings, here's an article that explains how to do it: Create, access, and modify memorized reports.

 

If you have any other concerns about running specific reports in QuickBooks, please feel free to leave them in the comments below. I'll be around to help you out.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us