by Fil Ramirez & Haley Jennings · Service profit & stipend: Hacker Tracker Wk1+Wk2 · Comp B weekly from HT · Updated 8/6/2026 · v45
Valued Auto Care · Bonus & Payroll
Detailing payroll · Franklin
Tips on the W-2 paycheck only · SOP-TIP-W2-001 · Not Cody’s 58% gate or Hacker Tracker
Detailers
—
Tips this period
$0
Hourly pay
$0
Bonus
$0
Paycheck total
$0
Detailer payroll
Jacob is the detailer. Pay = hours × rate + tips + bonus. Load a timesheet or Hacker Tracker to fill hours and cars.
Tip log (same period)
Matches SOP-TIP-W2-001. Reconcile to Tekmetric Tip / Gratuity fees and QBO Tips Payable before you run payroll.
Date
RO / customer
Amount
Detailer
▸ EOD whole-shop cross-check (optional — not used for service bonuses)
Upload End of Day PDF to compare whole-shop sales/profit to Hacker Tracker & Profit Details. Bonuses use Hacker Tracker (Wk1+Wk2) + hours — not EOD.
No PDF loaded — or type numbers manually
Employees with timesheet hours. Use + Line on a row for another leave entry (2nd day or other week). + Add employee for someone new. Multiple lines per person OK for QBO.
Holidays and approved Time Off fill in by themselves from the shop calendar. Requests not approved yet are listed below — approve them on the Time Off page. Hours left come from Staff & Pay (QBO upload) or Time Off, whichever is newer.
Employee
Wk1 Hrs Off
Wk2 Hrs Off
Type
Note / Dates
+ Line = another leave day/week for same person · Delete = remove that line only
Pick Profit Details + Hacker Tracker at the same time (timesheets / tech hours too). The page reads the file name and columns and puts each in the right box.
No batch loaded
True paid profit · auto-excludes Cody’s Automotive AR
No Profit Details loaded
Close ratio / RO counts — optional
No Hacker Tracker loaded
One week only. This box does not touch Week 2.
No file loaded
One week only. This box does not touch Week 1.
No file loaded
One week only. This box does not touch Week 2.
No file loaded
One week only. Drop the Week 2 Technician Hours file here.
No file loaded
Multi-select Tekmetric Employee Timesheets Details CSVs (e.g. Alan Mendez’s…). Only if someone is short of 40h for the week. Marks days under 5 hours (e.g. Tue 7/28 · 1.85h) and fills Adj Hrs + Note.
No detail files — load only when someone is short
Service profit
—
HT Wk1+Wk2 service profit
Service GP %
—
58% gate
EOD net profit
—
Whole shop posted
Management total
—
Role stipend only (58% gate)
Advisor bonuses
—
Comp A + Comp B $
Wk1 service profit
—
Comp B base week 1
Wk2 service profit
—
Comp B base week 2
Management Stipend (58% GP gate)
Enter EOD Net Sales, EOD Profit %, and Shop GP %. Load billed hours for Comp B. Role stipend is $0 if shop GP < 58%. Adam/Jordan tech Comp B is under Service Advisor Bonus (not gated).
Service Advisor Bonus
Jameson & Judah are auto sales — excluded here. Use Auto Sales Commission below or open Sales Floor for leads and inventory.
Upload the Hacker Tracker CSV (RO-level) to see advisor Sales, Profit %, Close Ratio, and bonus %.
Auto Sales Commission (Jameson & Judah)
Not on service advisor Comp A/B. Record vehicle-sales commissions here for QBO / payroll. Track the deal on Sales Floor. Hours still appear under tech/hourly tables if on timesheets.
Employee
Dept
Units / deals
Gross profit $
Commission %
Commission $
Note
Jameson Shannon
Auto Sales
Judah Siegand
Auto Sales
Commission $ can be typed directly, or leave blank and enter Gross profit + % (calc on blur). Not included in service advisor or tech Comp B.
Hours & Technician Bonus
Load one week at a time. Export each week separately in Tekmetric, then:
Wk1 timesheet + Wk1 billed, then Wk2 timesheet + Wk2 billed.
Upload Timesheets (clocked) + Tech Billed Hours CSVs for both weeks. All employees with hours will appear; tech bonus applies only to the 7 technicians.