QuickBooks contractor reconciliation: finding the invoices that should exist but don't

Last updated November 5, 2026 · 5 min read

Short answer

QuickBooks Online records money, not work — there is no completed-job concept inside it. Unbilled work is found outside-in: export work orders from your FSM, export invoices from QBO, and reconcile the two. The invoice list alone always looks complete.

The data reality

Where to export: Sales > Invoices > select rows > Export to Excel. For all sales types: Sales > Transactions. Customers: Customers > Export.

Columns that matter: Invoice No. · Customer · Invoice Date · Total · Balance · Status

Balance is outstanding, not billed — a paid invoice shows 0.00. Credit memos are a separate transaction type that invoice-total scans miss. There is no job column unless the shop encoded one in a memo or custom field.

Why this system leaks

The tech completes work in the field software; invoicing happens in QBO. If the office never creates the invoice, QBO has nothing to show — the absence itself is invisible inside QBO.

QBO's own reports can only count what exists. 'Missing invoice' is a statement about work that exists somewhere else, which is why the reconciliation must be outside-in: work list first, money list second.

The memo field is the bridge

The most reliable shops put the job number in the invoice memo or a custom field — that single habit makes REF_FIELD matching possible and cuts ambiguity to near zero. Without it, matching degrades to customer-plus-date, and two jobs for one customer in the same window create genuine ambiguity that must stay unmatched, not guessed.

What 'unbilled' means in QBO terms

An invoice that was created and voided bills zero. An invoice that was created and deleted never existed. An invoice never created is the leak. Only the outside-in reconciliation distinguishes the three — and only the third one is money you can still collect.

A worked example

Work order #20431 from the FSM export: compressor replacement for Sunridge Properties, completed October 12, $1,140 recorded.

Recorded work
$1,140.00
Invoiced
$0.00
Residual
$1,140.00

The QBO invoice export for October shows three invoices for Sunridge Properties — none referencing job #20431, none dated inside the completion window that isn't already matched to another work order. Residual = $1,140 − $0 = $1,140 of recorded work with no invoice behind it.

What the data cannot show

  • QBO alone cannot answer the question at all — the work-order side must come from the FSM export.
  • Deposits and progress invoices complicate 'total billed': a partial payment still bills real dollars and counts as coverage.

Questions shops ask

Can QuickBooks show missing invoices?

Not on its own. QBO counts what exists; 'missing' requires the completed-work list from your field software. The reconciliation is the check that compares the two.

Is a voided invoice unbilled work?

It bills zero dollars, but it is not automatically a leak — void-and-replace is a normal correction. The reconciliation counts the replacement, never the void twice.

See a sample report for your export

See a sample report for your export

Related