← The Automation Files
Small Business Tech Automotive 3 min read · June 2026

The Flat Rate Spreadsheet Is Running Your Payroll and It Is Wrong at Least Once a Month

Every week someone pulls flagged hours out of the SMS and rebuilds payroll in a spreadsheet by hand. Every week the spreadsheet gets a new chance to be wrong.

Every week in independent auto repair shops across the country, someone sits down with a spreadsheet and tries to calculate what each flat rate technician is owed. They pull the flagged hours from Mitchell 1 or Tekmetric, apply the commission rate, subtract the comeback jobs and warranty work, remember to adjust for the one job that ran over and the tech is disputing, account for any parts delays that cost flag hours, and then feed the result to Gusto or ADP or QuickBooks Payroll.

This process takes two to four hours per week depending on the size of the shop. It has a meaningful error rate because it involves manual transcription at every step. And it is the source of more technician disputes than almost any other operational issue in independent shops, because the tech knows exactly what they flagged and the spreadsheet number does not always match what they expected.


The overtime trap

The Department of Labor has specific guidance on how overtime is calculated for flat rate employees, and it is not the same as overtime for hourly employees. Most shop owners either do not know this or have chosen to interpret it favorably and hope for the best.

The basic issue: a flat rate tech who works more than 40 clock hours in a week is still entitled to overtime on the additional hours. The calculation method for how much that overtime pays is specific to the DOL flat rate rules and is different from simply multiplying the hourly equivalent by 1.5. Shops that have been paying flat rate for ten years without correctly applying overtime rules to clock hours are carrying back-pay exposure that will only surface if an employee files a complaint with the Department of Labor or the shop gets acquired and the buyer does due diligence on the payroll records.


The efficiency number the tech sees and the owner doesn't

Technician efficiency ratio is flag hours billed divided by clock hours worked. A tech who flags 48 hours in a 40-hour clock week is at 120% efficiency. A tech at 75% efficiency is billing 30 hours of flag work in a 40-hour week, which means they either have a problem with the jobs they are being assigned, a parts availability problem, or a skills gap that needs addressing.

The technician knows their efficiency number every single week because it shows up directly in their paycheck. The shop owner usually does not know unless they go looking for it. Tekmetric's technician productivity report generates this automatically when clock-in and flag tracking are both configured. Shop-Ware has an equivalent dashboard. Most shops that have these platforms have one or both modules turned off.


The parts delay contribution

Parts delays eat flat rate hours in a way that shows up in the tech's pay but not in any report the owner sees. A tech waiting 35 minutes for a part that was ordered late or from the wrong supplier is not flagging during those 35 minutes. That time is invisible to the shop and visible only to the tech as a worse week than they expected.

Shops that have PartsTech configured for multi-supplier real-time ordering reduce the frequency of delays because the parts are ordered from whoever has them in stock right now, not from the default supplier out of habit. The connection between parts ordering efficiency and tech compensation is real and it almost never gets discussed as a retention issue even though it directly affects every flat rate tech's income every week.


The spreadsheet is not the problem. It is the symptom of a configuration gap in the SMS that, once fixed, turns the payroll calculation from a two-hour manual process into a report that runs automatically and produces a number the owner and the tech can both verify.


Take the Automotive Shop Assessment to see how your current technician compensation and payroll setup compares.

Michelle Onizuka is co-founder and Systems Architect at Onizuka Studio. She builds automation and AI systems for small businesses — including automotive operations across Tampa Bay and beyond.

← Auto Repair Shops Miss 23% of Their Calls. Here Is What That Actually Costs. The Disputed Repair That Was Authorized. Verbally. →

See where your shop actually stands

Five minutes, no keyboard gymnastics, instant results. Find the gaps costing you time and money — and what closing them looks like.

Take the free assessment →

Related reading