QuickBooks reports vs the unbilled work check: the boundary of the books
Last updated November 16, 2026 · 6 min read
Short answer
QuickBooks reports are excellent at everything financial that exists — and structurally blind to completed work that never produced an invoice. Map each report's boundary, and the check that reads outside the books.
The data reality
Where to export: QuickBooks reports used: Invoice List, Sales by Customer, A/R Aging, Open Estimates. Check inputs: those same exports plus the completed-jobs export from the FSM or job log. The check joins what QuickBooks holds to what happened outside it.
Columns that matter: QB report · What it covers · What it misses · Gap found
QuickBooks' coverage depends on which instrument billing used — estimates, invoices, sales receipts — and jobs that skipped every instrument appear nowhere. The check credits all instruments before flagging, so 'QuickBooks missed it' means truly absent, not just filed differently.
Why this system leaks
The monthly QuickBooks review is thorough: P&L trends, A/R aging, open estimates scanned, sales by customer skimmed. Every report is accurate and every one is self-referential — they describe the financial events that occurred. A $486 blower repair completed in May exists as a job record and as nothing in QuickBooks; no report can surface it because there is no QuickBooks object to report on. The review's confidence is real and its boundary is invisible — the reviewer never sees the work that stopped short of the books.
The accounting system is a ledger of financial events; uninvoiced work is the absence of a financial event. Absence is not a row, so no report — however well designed — can list it. The comparison that finds it must import the operational side (completed jobs) and join it against the books. That import-and-join is the check, and it is categorically outside what any QuickBooks report does.
The boundary of the books
QuickBooks is complete and accurate about financial events — and blind to work that produced none. The blind spot is not a missing report; it is categorical: no ledger can list its own omissions. The check supplies the operational side and joins it against the books, which is the only direction that sees across the boundary.
Every QB report, mapped to its blind side
Invoice List: cannot show uninvoiced jobs. A/R Aging: only issued invoices. Open Estimates: only estimate-flow work. Sales by Customer: only recorded revenue. Each is excellent within its boundary; the check draws the boundary explicitly and covers its blind side with the completed-jobs join.
Keep the review, add the join
The monthly QuickBooks review stays — it is the right tool for the books' interior. The check adds ten minutes: upload the completed-jobs export, receive the uninvoiced list, back-invoice what it names. The review and the check together cover both sides of the boundary.
A worked example
A shop's QuickBooks review, one quarter: P&L on trend, A/R aging clean, open estimates all legitimate. The same quarter's check: three completed jobs with no invoice — a $186 coil swap, a $148 blower repair, a $152 capacitor-plus-labor — totaling $486, invisible to every QB report.
- Recorded work
- $486.00
- Invoiced
- $0.00
- Residual
- $486.00
Residual = $486 across three jobs — none of which exists in QuickBooks at all, which is why a flawless QB review cannot find them. The check imports the completed-jobs list and names what the books never held.
What the data cannot show
- The check complements QuickBooks, not replaces it — invoicing, payments, and books remain the system's job; the check adds only the one comparison QuickBooks cannot build.
- Where the shop bills entirely inside QuickBooks with no external job record, the check needs an independent work source (dispatch sheets, job log); without one, absence is unprovable.
Questions shops ask
Can QuickBooks show me uninvoiced work?
Only work tracked through estimates or unbilled-charges features — jobs completed outside those flows appear nowhere, because they never created a QuickBooks object. The check imports your completed-jobs list and joins it against the books to name the absences.
Which QuickBooks reports should I run for billing health?
Invoice List, A/R Aging, Open Estimates, and Sales by Customer — they cover issued billing well. Pair them with the check, which covers the side no QB report reaches: completed work that never produced any of those objects.
We bill everything from QuickBooks — are we safe?
Only if every job is invoiced, which is the thing in question. The check needs an independent record of work — dispatch sheets or a job log — to verify. If no work record exists outside QuickBooks, that discipline gap is the first fix.
See pricing
See pricingRelated
- QuickBooks contractor reconciliation: finding the invoices that should exist but don't
- Finding missing invoices in QuickBooks: the comparison QuickBooks cannot run
- QuickBooks income vs work orders: the comparison that quantifies your billing leak
- Bookkeeper vs billing reconciliation: excellent at the books, blind outside them