Skip to main content
S
sguidice
August 8, 2023
Question

Estimate to Invoice Balance Detail

  • August 8, 2023
  • 1 reply
  • 0 views

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. 

1 reply

A
Archie_B
August 8, 2023

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.

S
sguidiceAuthor
August 8, 2023

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.

    S
    SirielJeaB
    August 8, 2023

    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!

    Terms & ConditionsAccessibility statement