Reconcile QuickBooks progress invoices against an accepted estimate

A milestone can be billed, paid, or both. Reconcile the accepted estimate to its linked invoices, then reconcile those invoices to receipts and credits.
Upload a case

Key facts

Unbilled equals the estimate less amounts already billed on the same scope. Open billed equals the unpaid balance on issued invoices. Check both before you send another invoice or chase payment.

Compare the estimate with the invoices

Start with the accepted estimate and the latest written changes to scope. Confirm the customer, estimate number, amount and currency. Open the linked transactions on each progress invoice or use the Estimates & Progress Invoicing Summary by Customer report. Record each invoice number, milestone and amount on the same basis as the estimate. If the estimate excludes tax, compare like with like.

Compare the linked list with the customer’s issued invoices. An invoice entered separately may already bill the milestone while sitting outside the estimate’s linked totals. Look for matching service dates, line descriptions, milestone references and amounts before deciding that the estimate has room for another invoice.

Worked example: what remains to bill and collect?

Suppose an accepted estimate is $20,000. Two linked invoices total $12,000 and receipts applied to them total $7,000. Assuming no credits, that gives $8,000 to bill and $5,000 still open on issued invoices.

  • If the customer ledger reveals a separate $2,000 invoice for the same scope, supported billed value is $14,000. Remaining scope to bill is $6,000. Confirm the separate invoice is valid and whether it has been paid before adjusting the balance to chase.
  • If the separate invoice duplicates a linked milestone, identify and resolve the duplicate in the billing ledger before issuing another invoice. Keep the original numbers and the approved correction together.

Leave two figures for the next owner

Record the amount still to invoice and the amount open on issued invoices with an as-of date. Route unbilled work to the project owner and follow up only balances that are due. For a disputed milestone, collect the milestone acceptance evidence before escalating.

Source: Intuit’s guide to progress invoices.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.