A repair shop's profit is decided on individual repair orders — a comeback here, an unbillable diagnostic hour there. This tracker ties expenses to the orders and bays that created them, so the shop's pricing rests on evidence instead of habit.
Repair work has a costing problem other trades envy for its clarity: every job already has a number. The repair order is a natural container for costs — parts, fluids, sublet work, and supplies all belong to a specific vehicle and ticket. Yet most shops track expenses only as monthly totals, which means the RO-level truth the paperwork already supports is never actually assembled.
The second leak is the unbillable middle: diagnostic time that finds no fault, shop supplies consumed by the case, disposal fees for fluids and tires, and comebacks that eat a bay for half a day. Each is small. Together, in a busy shop, they routinely amount to several points of gross margin that pricing never accounted for.
Attach costs to repair orders as the work happens, and let the weekly roll-up build itself.
The split mirrors a repair order's anatomy — parts, labor support, consumables, and the compliance costs of handling what comes out of vehicles.
Parts cost. OEM, aftermarket, and remanufactured parts charged to repair orders, including cores until credits return. The core-return lag is why this line needs its own watch.
Shop supplies and consumables. Brake cleaner, solvents, rags, gloves, absorbent, and small hardware consumed across jobs — the classic unbilled leak.
Fluids and chemicals. Engine oil, coolant, transmission and brake fluid, and refrigerant bought in bulk and drawn down per job.
Sublet services. Alignments, machining, glass, key and module programming, and any work sent outside, tied to the RO that needed it.
Hazmat and waste disposal. Used oil and filter handling, coolant and solvent disposal, and tire disposal fees — regulated costs that scale with job mix.
Diagnostic equipment and information. Scan tools and updates, service-information and estimating subscriptions, and oscilloscope or specialty tool purchases.
Technician wages and payroll costs. Flat-rate or hourly pay, employer taxes, and benefits — recorded weekly so labor cost can sit beside parts cost per RO.
Training and certifications. ASE testing, manufacturer or aftermarket training, and the paid hours techs spend in class instead of in a bay.
Facility, lifts, and utilities. Rent, lift maintenance and inspection, air compressor service, and utilities for the bays — the fixed floor under every ticket.
Most shops feel comebacks as frustration; the tracker converts them into a priced category. When comeback parts and bay hours are flagged on original orders for a quarter, the total usually shocks owners — and it decomposes usefully. Comebacks cluster by job type, by vehicle system, and sometimes by a single parts brand whose failure rate the supplier should answer for.
Each cluster has a different remedy: a torque or road-test checklist for one job type, a brand change for a failing part line, or a second-look policy on intermittent faults. None of those remedies can be chosen, or their payoff verified, until the cost is a number. That is the entire argument for tracking this category separately.
A general repair shop follows one of its three bays through a week of 14 completed repair orders producing $7,260 in parts and labor sales. The week's costs recorded against that bay's work:
The tracked rows total $3,684. Non-labor tracked costs of $3,684 frame the week's parts-and-support picture; the comeback line alone, $168 of parts plus unrecorded bay time, is the entry the owner takes into the Monday meeting. Supplies at $132 across 14 orders — about $9.43 per RO — replaces the shop's guessed $5 supply fee with a measured one.
| Category | Amount |
|---|---|
| Parts charged to repair orders | $2,418 |
| Shop supplies consumed | $132 |
| Fluids drawn from bulk | $214 |
| Sublet (two alignments, one programming) | $265 |
| Hazmat and tire disposal | $74 |
| Comeback parts on a flagged RO | $168 |
| Diagnostic subscription (weekly share) | $63 |
| Lift inspection and facility share | $350 |
| Total tracked | $3,684 |
A busy shop cannot add paperwork; it can only move the recording to where the cost already surfaces:
The Auto Repair Shop Profit Tracker includes RO-level parts and supply tracking, comeback flagging, and bay-level weekly summaries in Excel and Google Sheets.
You do not count rags — you measure the bulk category monthly and allocate it with a standard per-RO charge, then true the charge up or down quarterly against actual purchases. Allocation from measured totals beats both guessing and item-counting.
Yes, in the tracker's management view. The original ticket's price was set expecting the job to stay fixed; assigning comeback parts and time back to it shows which work is truly profitable and which only appears to be.
Record the core charge as part of parts cost on the RO and the credit as a negative entry when the supplier issues it. The net figure is the real parts cost, and the open-core balance is a number worth reviewing monthly.
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you.
DYMO Authentic Multi-Purpose Labels 30334, 1,000 Roll — genuine DYMO 30334 multi-purpose labels, 1,000 to the roll.
HP 10bII+ Financial Calculator — for straightforward time-value and amortization math on a simpler keyboard.
SanDisk Extreme Portable SSD, 1TB — the rugged portable SSD alternative for backups that travel.
Payroll Accounting 2025, 35th Edition — Bieg & Stomberg — the standard payroll textbook: withholding, FICA, and year-end payroll reporting done right.
More books and gear live on the Resources page.