How does a small shop run a monthly billing reconciliation?
Short answer: First full week of the month, for the previous month. Pull three exports (jobs, invoices, supplier statement), run the four matches (jobs→invoices, totals, parts, fees), and disposition every finding in one sitting. Sixty minutes once the habit exists; three hours the first time.
The calendar
| When | What | Who | |---|---|---| | Day 1–5 | Export completed jobs + invoices for last month (invoice dates widened ±14 days) | Office | | Day 1–5 | Download supplier statements (or forward them to your reconciliation inbox) | Office | | Day 5 | Run the four matches; list every unmatched item | Office/owner | | Day 5 | Disposition each finding: bill it, document why it's correct, or mark "not a leak" | Owner | | Day 6 | Bill what's real | Office |
The four matches
- Jobs → invoices. On job number where it exists; on normalized customer name + date window (completion − 3 days to +14 days) where it doesn't. Every completed job must land in exactly one of: invoiced correctly, invoiced short, not invoiced, legitimately $0.
- Totals. Invoiced total vs job recorded total. Differences need a reason on the record.
- Parts. The month's significant supplier lines vs invoice lines, matched on part number or description similarity.
- Fees. Service calls completed vs trip/diagnostic lines billed, adjusted for your waiver policy.
The dispositions
Every finding gets exactly one of three outcomes, decided in the meeting, that day:
- Bill it. Create the invoice or the correction. Same day — the customer's memory is fresh.
- Document why it's correct. Warranty, callback, monthly account, approved discount. Write the reason down.
- Mark "not a leak" with a pattern. If it's the fifth trip-charge waiver this month and all five had approved repairs, the pattern is the finding — teach the rule, don't chase instances.
The documentation is the asset. By month three, "not a leak" items stop needing discussion, and the remaining list is pure signal.
The numbers to track
Four numbers, every month, on one line of a spreadsheet:
Jobs completed | Invoices issued | $ unbilled found | $ unbilled found last month
When the fourth number trends toward zero — not because you stopped looking, but because the leaks stopped happening (the reconciliation has a training effect on the office) — the habit is working.
A worked example
October 1, "Apex Heating & Air" runs it for September:
- Exports pulled (20 min). 412 completed jobs, 388 invoices, one supplier statement (Jobber + a parts house). Invoice window: Aug 18 – Oct 15.
- Match 1 — jobs → invoices (10 min). 396 jobs match on job number. 16 remain: 9 are warranty ($0 invoices exist — check 8), 3 are callbacks, 4 have no invoice at all.
- Match 2 — totals (10 min). Two invoices below job value: one documented discount, one $486 job invoiced at $176 — the blower motor line is missing.
- Match 3 — parts (15 min). Five most expensive supplier lines: three match invoices, one matches a $0 warranty invoice, one — a $440 motor — matches nothing.
- Match 4 — fees (5 min). 132 service calls, 119 with fees-or-approved-repairs, 13 unexplained — 12 turn out to be approved repairs with the waiver applied, 1 is a declined repair with no fee.
Findings: 4 uninvoiced jobs ($2,204), 1 short invoice ($310), 1 unmatched part ($440), 1 missing fee ($89). Total: $3,043. Dispositions the same afternoon: three jobs billed, one voided by the customer (documented), the motor and fee billed, the discount left alone.
Common mistakes
- Doing the four matches across four days. Context is lost; do it in one sitting.
- Letting "documented" exclusions live in memory. If it isn't written down, next month it's a finding again.
- Widening the invoice window and then forgetting why. Jobs completed late in the month get invoiced early next month — the ±14-day window prevents false alarms, but the report must state the window it used.
- Skipping the disposition step. A findings list that nothing happens to is a cost, not a control.
Why this fails in most shops
Not the analysis — the exports. Pulling them takes longer than reading them, systems change column names, and the person doing it also answers the phone. That's the actual bottleneck. Everything else on this page is one hour of focus.
Author: Unbilled. We exist to remove the export-joining: the four matches run automatically, you get the findings list and disposition them. Send three files, get a one-page report.