Flat-rate price book audit: finding the tasks that stopped making margin
Last updated November 16, 2026 · 6 min read
Short answer
The audit asks three questions per task: does the price cover today's parts cost, does it hit your target margin, and does it exist where the techs look for it? One shop's audit found a $610 capacitor task priced from a $485 cost basis — $125 of margin lost per use, on the book's most common repair.
The data reality
Where to export: Price book export (task, parts list, labor, price) crossed against current supplier costs; the check recomputes margins per task and flags underpriced, stale, and duplicated entries.
Columns that matter: Task · Parts cost · Labor · Book price · Recomputed margin
Price books export cleanly but their costs are as-of-import dates — supplier price updates never flow back into the book. Tasks get duplicated across categories, and mobile lookups may show a different version than the office's. The check treats book cost as a stale snapshot, recomputes from current costs where provided, and flags margin drift.
Why this system leaks
The price book was built from a supplier catalog at import — and the catalog's prices froze that day. Two years of supplier increases happened on top of a static book. The capacitor task still prices at $610 against a parts cost that rose to $485. Every use of the task is a correct-looking invoice that delivers a thinner margin than the book's own math promises. The tech cannot see it, the office cannot see it, and the flat-rate consistency that was the book's whole point now enforces the erosion uniformly.
Flat rate decouples the invoice from the actual parts bill of sale — the book's promise is consistency, and consistency hides drift. The book's prices are computed once from costs as-of-then; the world's costs move; no mechanism in the book notices. Only an audit that recomputes margins from current costs restores the book's own promise.
The book's prices are a snapshot; costs are a movie
Flat-rate consistency is only as good as the cost basis underneath it, and cost bases age without anyone touching the book. The audit's recompute — current costs into the book's own margin formula — is the only mechanism that notices the rot, because everything inside the book is internally consistent with a world that no longer exists.
Audit the high-frequency tasks first
Margin drift on a rare task costs little; drift on the top-twenty tasks — capacitors, contactors, blowers, ignitors — compounds weekly. The audit ranks tasks by use frequency times margin shortfall, so the first page of results is where the money is, and the fix (repricing the task) takes minutes.
Make the audit annual, the drift monthly
A full book audit once a year; a monthly check of the high-frequency tasks against current costs in between. The rhythm keeps the book's promise — consistent pricing that actually delivers its margin — instead of the hollow version that looks right on every invoice and underperforms on every one.
A worked example
Capacitor replacement task — the book prices $610 from an import-era cost basis of $485 (parts $310, labor $175). Current supplier cost for the same parts: $485. The task's real margin has fallen from the book's intended 20% to 20% of a shrinking base — every use loses $125 against the book's intended economics.
- Recorded work
- $610.00
- Invoiced
- $485.00
- Residual
- $125.00
Residual = $125 per use — the margin the book intended and the invoice no longer delivers. On the shop's most common repair, three uses a week is nearly $20,000 a year of intended margin silently forfeited. The audit found it in one pass.
What the data cannot show
- Flat-rate books legitimately round and pad — the audit compares against the book's own stated margin targets, not against time-and-materials, so padding is not flagged as error.
- Supplier pricing varies by account and contract — the check recomputes from the costs you provide; where supplier invoices are uploaded, the recomputation uses your actual landed costs.
Questions shops ask
How often should a flat-rate price book be audited?
Fully, annually — every task recomputed against current supplier costs. High-frequency tasks should be spot-checked monthly, since they carry most of the drift cost. The check automates both passes from your book export and supplier costs.
How do I know if my price book margins have eroded?
Recompute a few top tasks: take today's supplier cost for the task's parts, apply the book's intended margin, and compare to the book's price. A gap means erosion. The audit does this for every task and ranks the results by annual impact.
Can't the price book company update my costs?
Some services offer update subscriptions — but 'updated' means refreshed from their catalog, not reconciled against your supplier's actual prices and your margin targets. The audit verifies the book against your costs, which is the check that matters.
One file, one report
One file, one report