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
- Export the completed-jobs list from your field system (ServiceTitan, Jobber, HCP, or the paper board if that's your reality).
- 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.
- Fall back to customer + date window: invoice date within [completion − 3 days, completion + 14 days].
- Check amounts, not just existence. An invoice for a $1,140 job at $486 means something was dropped.
- 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.