Guides · By software

How to find unbilled work in QuickBooks

Reconcile QuickBooks invoices and estimates against completed field work, with export paths and the desktop quirks.

Last updated Fri Oct 30 2026 00:00:00 GMT+0000 (Coordinated Universal Time) · 6 min read

How do you find work in QuickBooks that was never invoiced?

Short answer: QuickBooks only knows what was invoiced — it never knows what work happened. The reconciliation has to come from outside: your field software's completed-jobs export (or your dispatch board) against QuickBooks' invoice list. Any completed job without a corresponding invoice in QuickBooks is unbilled work.

The QuickBooks side

QuickBooks Online: Reports → Sales → Invoice List (or Transactions → Sales → filter Invoices) → export. Columns that matter: Invoice No., Customer, Txn Date, Amount, Balance, Status. Also export Estimates (Sales → Estimates) — accepted estimates with no invoice are a classic gap.

QuickBooks Desktop: Reports → Sales → Invoice List by Customer, then File → Export Report to Excel. Desktop's quirk: deleted and voided invoices leave the sequence numbers gapped. A gap in the Invoice No. sequence is worth chasing — find out whether it was a void (fine) or a deleted invoice for real work (the leak).

The reconciliation

  1. Export the completed-jobs list from your field system (ServiceTitan, Jobber, HCP, or the paper board if that's your reality).
  2. Match invoices to jobs on the job/PO reference. If techs put the job number in the invoice memo or PO field (make this a rule — it takes two seconds), the join is trivial.
  3. Fall back to customer + date window: invoice date within [completion − 3 days, completion + 14 days].
  4. Check amounts, not just existence. An invoice for a $1,140 job at $486 means something was dropped.
  5. Check estimates: accepted, expired-without-invoice, or converted-to-nothing.

A worked example

Your dispatch board shows job #20431 completed Sept 16 for "Blanchard Property Group", $486. QuickBooks invoice list for September shows nothing for Blanchard except their monthly statement roll-up — which this account isn't on. The customer was hand-typed into a new invoice for a different job two days earlier.

Job #20431: no invoice, $486, parts confirmed by the supplier statement. In QuickBooks everything reconciles to the bank account (money came in for something). Only the outside view shows the hole.

Common mistakes

  • Assuming the P&L proves billing. Revenue proves cash or receivables, not that every job was billed at its recorded value.
  • One customer, many names. Normalize (strip LLC/Inc, punctuation, case) before matching, or matches silently fail.
  • Desktop voids vs deletes. Void keeps the record with $0; delete removes it. Both are safe for warranty work and dangerous for service calls.
  • Trusting the memo field is always filled. It isn't, until you make it a habit. The customer+date fallback carries those weeks.

What this doesn't catch

QuickBooks can't tell you about parts that were consumed but never invoiced — that needs the supplier statement. And it can't tell you hours logged vs billed — that needs the field system's time data. Those are the other two reconciliations.

Author: Unbilled. We do all three reconciliations from your exports — or let us run it: send three files, get a one-page report.

Or let us run it: send three files, get a one-page report.

Related