Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
D
daniel-busby-nwl
October 25, 2022
Question

Progress Invoices not adding up in the Estimate page

  • October 25, 2022
  • 7 replies
  • 18 views

I am using progress invoices against estimates.  There are a couple of customers that I've already invoiced to about 75% of the final amount.  However, as I go to submit the final invoice I notice that the "submitted invoices" are a completely different number.  How do I correct this?

 

For example, on one job the 3 linked transactions are invoices for $15,000, $2,000, and $14,500.  However, the Invoiced Subtotal at the bottom is $17,556.99.  Where does that number come from, if not the linked invoices?  The customer has paid the previous invoices, but they're not being reflected in this estimate.

7 replies

Angelyn_T
Angelyn_TModerator
Moderator
October 25, 2022

Hi there, Daniel. Let me give you insights about progress invoices against estimates.

 

Generally, the system will only absorb whatever data is recorded or added. When converting progress invoices from the estimates, payments will only reflect on your invoice transactions. The Estimate page will show you the number of linked transactions with the invoice amounts during creation. 

 

Once you open your estimate, the linked transactions will give you the total amount before payment. However, the invoice subtotal shows you the account summary of the customer's transaction. It may include the balance forward, payments and credits, new charges, and the total amount due. As you mentioned, the customer has paid the previous invoices. And accepting customer payments can lower their invoice balance.

 

On the other hand, if you need to make changes to your transactions, you can delete and recreate your entries. 

 

For additional hints about estimates and progress invoices, you can open this article: Set up and send progress invoices in QuickBooks Online. The same resource will guide you on how you can review your progress invoices by checking your reports.

 

Feel free to mention my name in the comment section below if you have other questions about estimates and invoices. I'm more than happy to help. Have a good one!

D
daniel-busby-nwlAuthor
October 25, 2022

Angelyn_T,

 

Here are the real numbers:

Estimate Total: $45,200.

Invoice #1: $14,000

Invoice #2: $20,700

Both invoices are linked to the estimate and have been fully paid. So in this case the invoices are the same as the payments. However when I go to generate the final invoice instead of it being $10,500 as I expect, it's $23,309.08. What could be causing this discrepancy? I am trying to submit the final invoice and it now registers as not the final to the customer.

 

I have been doing progress invoices against my estimates for dozens of other estimates.  But, for some reason this estimate and another one to a different customer are not lining up.  They both have "Invoiced Subtotals" that are thousands of dollars less than what I've actually invoiced (and been paid).  The help files address what to do when the numbers add up, but they don't address what to do when the numbers don't.

    J
    JamesAndrewMModerator
    Moderator
    October 25, 2022

    Hello there, @daniel-busby-nwl.

     

    Let's unlink the progress invoices of your estimates and relink them. We can also delete and recreate them to trigger the system to correct the changes.

     

    To unlink a progress invoice in your estimate:

     

    1. Click the bin icon next to the estimate line item within the invoice.
    2. Select Yes, unlink it.

     

    You can refer to this link for detailed steps in deleting your entries: Void or delete transactions in QuickBooks Online. Afterward, you can proceed to recreate them.

     

    We can also perform basic troubleshooting steps to determine if it is a browser-related issue. There are times when the stored cache and cookies on your browser can be corrupted leading to problems processing our transactions. To start, access your QBO account using an incognito window. This will prevent storing browser history.

     

    Kindly refer to these keyboard shortcuts depending on your browser type:

     

    • Google Chrome: Ctrl + Shift + N
    • Mozilla Firefox: Ctrl + Shift + P
    • Microsoft Edge: Ctrl + Shift + P
    • Safari: Command + Shift + N

     

    You might find this helpful in the future if you want your customers to keep track of their projects, you may consider checking out this article: Add project estimate summaries to a progress invoice in QuickBooks Online.

     

    I'd be happy to hear any updates after performing the steps as I want to ensure this is resolved for you. Don't hesitate to reach us again. Have a great day ahead!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement