Which payroll records should you bring to the tracker?
Collect payroll gross pay, employer burden and attendance records alongside job-clock and sold-hour exports for the same dates. Align the reporting period before interpreting any ratio, particularly when payroll is biweekly but the shop dashboard reports calendar months.
Use a code for each technician during preliminary diligence. Include role, tenure, relevant certification and pay plan without circulating personal identifiers. Note whether the person handles diagnosis, production repair, inspections, warranty rework or training. A lead technician who rescues difficult jobs can look less productive than a colleague whose work is already diagnosed and staged.
Enter actual gross paid compensation, including earned bonuses and overtime where applicable. Use the employer burden separately so benefits or payroll taxes are not counted twice. A quoted flat-rate wage tells you the pay basis; it does not necessarily equal the actual payroll cost for the period. Tie the total to payroll before using the number for pricing or acquisition assumptions.
What identifies a comparable technician pay period?
The first section, Define the period and people, gives you these prompts and room to document your evidence.
- Code the roster. Assign an anonymous ID, tenure, role, certifications and pay plan. Keep the private identity crosswalk with the seller.
- Use one pay period. Gather paid attendance hours, time clocked on repair work, billed hours, gross wages and employer-paid burden for matching dates.
- Identify owner labor. Include the owner if they turn wrenches. Mark gaps in payroll truthfully and estimate replacement cost separately.
Technician roster and pay-plan tracker preview| Section | Topics covered |
|---|
| Define the period and people | Code the roster · Use one pay period · Identify owner labor |
| Read the output | Productivity · Efficiency · Loaded cost per billed hour |
|---|
How do productivity and efficiency differ here?
Productivity measures job-clock hours divided by attendance hours. Efficiency measures billed hours divided by job-clock hours. Name both denominators whenever you present the figures because different shop systems may label them differently.
Someone can work quickly on assigned repairs and spend much of the day waiting for parts. That combination can produce high efficiency and low productivity in the same period. A different technician can stay busy on a diagnostic issue yet bill fewer hours than they recorded. Review dispatch flow, documentation, work mix and warranty treatment before changing compensation or reducing staffing.
If you’re selling, explain how the shop credits a helper on a shared job and whether the owner bills under their own ID. If you’re buying, ask to reconcile a handful of shared and reopened orders across timekeeping, ticket and payroll records. The goal is to understand capacity that will remain after the transaction.
What do the three outputs say about the same technician?
Illustrative composite — not a real client.
Suppose a technician attends 40 hours, works 32 job-clock hours and bills 36 hours. Productivity is 32 ÷ 40 = 80%. Efficiency is 36 ÷ 32 = 112.5%. With $1,200 gross wages and $240 employer burden, loaded labor cost per billed hour is $1,440 ÷ 36 = $40. If payroll stays fixed and billed hours fall to 30 in the next comparable period, the cost rises to $48. Check job mix and parts delays before calling the difference a performance problem.
How do you build a row that can be compared with the next pay period?
Start with the actual pay-period end instead of a convenient calendar month. Give the technician a stable Anonymous ID and use it again when importing the next period. Keep the name-to-ID crosswalk with the authorized payroll custodian. Under Role / certifications, distinguish the person who regularly performs electrical diagnostic work from a helper assigned to service and inspection. If certification status affects a deal assumption, obtain appropriate evidence through an authorized reviewer. Record the version of the roster and the payroll population it covers so your team can tell which people were excluded and why.
Use Attendance hours for the agreed attendance measure and Job-clock hours for time attributed to work on jobs. Ask how the shop records paid training, vacation, lunch, a morning meeting and interrupted jobs. Record the convention in Pay record / comments and apply it consistently across your comparison. If you exclude approved vacation from available hours, a report of gross wages may still include vacation pay. Explain the difference before comparing loaded cost across pay periods. A busy owner who diagnoses customer concerns and answers the front desk may need a separate row, especially if a buyer expects another employee to absorb both responsibilities.
What would paid training and a parts delay look like in the numbers?
Illustrative composite — not a real client. A diagnostic technician attends 40 hours, including eight hours of paid training. The shop records 24 job-clock hours, bills 30 hours, pays $1,050 in gross wages and records $210 of employer burden. On this shop’s stated basis, productivity equals 24 divided by 40, or 60 percent. Efficiency equals 30 divided by 24, or 125 percent. Loaded cost per billed hour is $1,260 divided by 30, or $42. The three values describe different aspects of the week. None locates the cause of the remaining eight attendance hours.
Pull the dispatch board and ask the advisor what happened to the unfinished vehicles. If a customer approved additional testing after a supplier cutoff, a vehicle may occupy a bay overnight without producing another job-clock hour. Enter the repair-order reference and delay in the comments to support your explanation. Compare a period with a similar job mix and show training explicitly. Changing Attendance hours to 32 would give 75 percent productivity on a different basis. Relabeling the denominator halfway through your analysis can make an apparent improvement that nobody on the floor experienced.
How do you handle shared repairs, warranty work and an empty output?
Sample a ticket assigned to two technicians. Confirm whether the shop splits billed hours by operation, by a fixed allocation or during a later payroll adjustment. Follow both anonymous IDs through the ticket report and prove that the combined credit equals the actual hours billed. When a helper assists a senior technician, labor expense may be split even though the ticketing system gives credit to just one person. Keep that reporting convention in the comments and examine the team total before attributing the complete difference to individual output.
Trace an unpaid comeback from the service history to the hours report. The technician’s attendance and job-clock time may increase even when the shop bills no additional hours. An empty efficiency or cost output can occur when the required denominator is zero or a required input is missing. Inspect the actual records before interpreting a blank as good or poor performance. If the payroll system reports employer taxes, benefits and insurance separately, identify exactly which costs you included as employer burden. A benefits amount entered in gross pay and then included again in burden will overstate loaded cost.
How should you present the roster to a buyer or incoming manager?
Prepare a summary by role and period and retain the detailed anonymous rows for authorized follow-up. Build a team rate by totaling the underlying hours or costs first. Averaging one technician’s efficiency percentage with another gives both people the same influence even if one supplied far more hours. Test the result against the labor section of your shop management export. If the two do not agree, check unassigned jobs, owner-billed work, warranty work and tickets closed after the pay period. Document the remaining difference and who can reproduce the check.
Give the new manager one operational question arising from the completed comparison. If apprentices lose time waiting for a shared scan tool, have dispatch record those delays for an agreed interval and then review the evidence before buying equipment or changing the pay structure. Send financial reviewers the role-level figures and the wage and burden assumptions they need for forecasting. Keep personally identifying details and individual compensation within the appropriate release process. The person reviewing your workbook should be able to reproduce the team totals, see which jobs depend on one specialist and explain why an unusual week differs from the next.
Which measures should you compare across the technician team?
Read the three outputs together and trace unusual results back to clock entries, billed operations and payroll.
- Productivity. Divide job-clock hours by attendance hours. Use clock records to distinguish idle time, training and missing punches.
- Efficiency. Divide billed hours by job-clock hours. Check shared job credits, rework, service mix and flagged hours before comparing individuals.
- Loaded cost per billed hour. Divide gross pay plus employer burden by billed hours. A zero denominator leaves the output blank and calls for a review of the underlying period.
How should you use a change in loaded cost?
Compare similar work across periods and trace large changes to payroll, billed production or job assignment. A cost per billed hour increase may be an expense change, reduced available work or a timing mismatch.
Use the technician payroll and productivity tool to examine a different mix of hours and compensation. Refer to the SMS report request checklist if you cannot reproduce the sold-hour total. If you need to normalize the owner’s contribution, identify the duties that will transfer and obtain an actual market-pay estimate for that role.
Discuss personnel-specific issues privately with the appropriate manager. Do not put employee disciplinary or health information into transaction workbooks. Share the level of detail needed to verify aggregate payroll and technical capacity while following your advisors’ guidance on employee information and applicable wage requirements.