What should an HVAC shop check every month for billing leaks?
Short answer: Twelve checks, in this order: completed jobs vs invoices, zero-dollar invoices, invoice-vs-job totals, supplier parts vs invoice lines, logged hours vs billed hours, trip charges, diagnostic fees, warranty invoices at $0, callbacks, monthly accounts, duplicate charges, and stale quotes. Budget 90 minutes with exports open side by side.
The checklist
1. Completed jobs with no invoice. Export completed jobs and invoices. Any completed job without a matching invoice (and without a documented reason) is the loudest leak there is.
2. Zero-dollar invoices on non-warranty jobs. Filter invoices at $0. Warranty and callback: fine. Everything else: a job someone closed without billing.
3. Invoice total below job total. The invoice exists but came out less than the completed job's value. Either a decision (documented) or a dropped line (money).
4. Supplier statement vs invoice lines. Pick the month's five most expensive parts. Find each on a customer invoice. Unmatched expensive parts are where compressors and motors hide unbilled.
5. Logged hours vs billed hours. On T&M work: hours on the job sheet vs hours × rate on the invoice. Anything over half a day of cumulative variance deserves a question.
6. Trip charges. Count completed service calls. Count invoices containing a trip/diagnostic line. The difference should equal your waiver policy (waived when repair approved). If you don't know that count, you're guessing.
7. Diagnostic fees. Same check for the diagnostic fee — especially on jobs where the customer declined the repair. A declined repair should leave a diagnostic fee. If the invoice is empty, you paid for a sales visit.
8. Warranty jobs at $0. Correct — but verify each has a warranty claim filed where the manufacturer program pays labor. A $0 invoice with no claim is a donation to the manufacturer.
9. Callbacks. Confirm callbacks are $0 and tracked to the original job. A callback billed as new work is a customer-trust problem; a callback with parts billed at full margin is both.
10. Monthly accounts. Builders, property managers, restaurants on monthly billing: confirm the roll-up invoice went out and covers every completed job in the month.
11. Duplicates. The same part number billed twice on one invoice, or a job invoiced twice (once per visit, once at completion). Rarer, but embarrassing when a customer finds it before you do.
12. Stale quotes. Quotes sent 30–90 days ago with no follow-up. Not unbilled work yet — but accepted quotes with no job created are money you already sold and never delivered an invoice for.
A worked example
Apex Heating & Air, September, 412 completed jobs. Run time: 75 minutes, exports side by side.
- Check 1: 412 jobs, 388 invoices → 24 unmatched. 15 explain themselves ($0 warranty invoices exist), 9 do not → 9 leaks, $3,880 combined.
- Check 2: 11 invoices at $0. 8 warranty, 2 callbacks, 1 on a regular service call → $486 job, closed and forgotten.
- Check 3: invoice below job value → 4 cases; 3 documented, 1 short by $310 (motor line missing).
- Check 4: top-5 supplier parts vs invoices → 1 motor, $440, no invoice line anywhere (different from check 3's — that one was billed on the right invoice short; this one has no line at all).
- Check 5: 6.5 h logged vs 3.0 billed on one T&M job → $332.50.
- Checks 6–7: fees vs completed service calls → 1 trip charge, $89, no approved repair.
- Check 8: warranty $0 invoices with no claim reference → 2 jobs, ~$300 of unclaimed labor.
Total: $5,457.50 across 15 findings — none visible on any single screen, all visible in the join.
Common mistakes
- Running checks 1–2 and stopping. The parts and hours checks are where the individually-small, collectively-large money hides.
- Using calendar months on both sides. Invoice dates must be widened ±14 days or late-month jobs become false alarms.
- Not writing down the exclusions. By month three the same warranty/monthly-account items get re-investigated every time — and real leaks hide in the noise.
- Treating the checklist as an audit of people. It's an audit of process. The tech who finished at 6:40pm didn't fail; the handoff did.
Scoring the month
| Count | Meaning | |---|---| | 0 findings in checks 1–5 | Either clean or the data isn't complete enough to tell — check data coverage | | 1–3 findings | Normal for a shop without a reconciliation habit | | 4+ findings | Systemic — usually the handoff between techs and the office |
Total the dollars. In a 400-job month, shops running this for the first time typically find $2,000–$6,000 of recorded work that never reached an invoice.
The failure mode of checklists
Checklists decay when the person running them has to chase six exports across two systems. If the checklist takes more than two hours, it stops happening by March. Automate the export-joining; keep the human judgment for the findings.
Author: Unbilled. We run all twelve checks automatically on your exports — send three files, get the result as a one-page report.