QuickBooks income vs work orders: the comparison that quantifies your billing leak
Last updated November 16, 2026 · 6 min read
Short answer
Sum the value of work orders completed in a period; compare it to QuickBooks income for the same period. After timing, tax, and deposit adjustments, a persistent shortfall is unbilled revenue — and the check itemizes it down to named jobs.
The data reality
Where to export: Completed work-order export (FSM or spreadsheet) summed by month, crossed against QuickBooks income by month (Reports → Profit & Loss, monthly columns); the check aligns periods and itemizes the difference.
Columns that matter: Month · Work-order value · QB income · Difference · Jobs in gap
QuickBooks income includes taxes unless the report is set to exclude them; deposits received before work completion land in earlier months; credits and refunds subtract from income without touching work orders. The check adjusts for all three before comparing, so the residual gap is real leakage.
Why this system leaks
The P&L is reviewed monthly and looks healthy — income grows, expenses are known. Nothing in the review compares income to work performed, because work-order totals live in another system nobody joins to the P&L. A month with $618,500 of completed work-order value but $583,000 of recorded income reads as a good month. The $35,500 difference is not a trend or a tax artifact; it is a stack of specific jobs that never invoiced, hiding inside an aggregate nobody questioned.
The P&L is self-referential: it compares money to money. Work is not money until someone invoices it, so work that never invoiced is invisible to every financial report by construction. The comparison that reveals it — work-order value against income — requires joining the operational side to the financial side, which no native report does.
Aggregate gaps, named jobs
A number like '$35,500 short' is an abstraction nobody can act on. The check's value is the itemization: each dollar of gap traces to a specific job — or is explained by timing, deposits, or a documented no-charge. The unexplained remainder is your real leak, with an invoice attached to each line.
The P&L cannot do this
Financial statements compare money to money. Work-order value is operational data, and the join between operational and financial data is exactly the join that small businesses never build. This check is that join, run every month, with the adjustments that make the comparison honest.
A percentage you can manage
Once the leak is a monthly percentage, it becomes a managed number — reviewed, tightened, and reported to the owner alongside margin and cash. Shops that adopt the rhythm watch the percentage fall toward one percent and stay there. Shops that never measure it usually float between three and seven, indefinitely.
A worked example
One month: work orders completed totaling $6,185 (tax-exclusive, deposits adjusted); QuickBooks income for the same month $5,830. The $355 gap itemizes into two uninvoiced jobs, one under-billed invoice, and one invoice recorded at quote instead of final.
- Recorded work
- $6,185.00
- Invoiced
- $5,830.00
- Residual
- $355.00
Residual = $355 — about 5.7% of the month's work. Shops consistently find between two and seven percent on a first income-vs-work comparison; the exact number is knowable only by running it.
What the data cannot show
- Timing shifts distort single months — work completed on the 31st invoices on the 1st; the check compares quarters as well as months so timing alone cannot fake a gap.
- Non-billable and internal work is excluded from work-order totals where the export distinguishes it; where it does not, the office marks known non-billables from the itemized gap list.
Questions shops ask
How do I compare QuickBooks income to completed work?
Sum completed work-order value by month from your FSM or job log; compare to QuickBooks income by month, excluding taxes and adjusting for deposits and timing. The check automates the alignment and itemizes every dollar of difference by job.
What is a normal gap between work orders and income?
Two to seven percent of completed-work value is typical on a first comparison, falling below one percent with a monthly rhythm. A persistent zero is the goal — timing noise aside, every completed job should appear in income.
Does this work if we bill only from QuickBooks?
It requires an independent record of work — work orders, dispatch logs, or job sheets. QuickBooks alone cannot answer the question, since income already reflects whatever was invoiced. Pair the check with your FSM exports or a disciplined job log.
See a sample report for your export
See a sample report for your exportRelated
- QuickBooks contractor reconciliation: finding the invoices that should exist but don't
- Finding missing invoices in QuickBooks: the comparison QuickBooks cannot run
- Monthly billing leakage calculator: size your leak before you measure it
- Spreadsheet invoice checking vs automated reconciliation: the honest comparison