Auto Repair Shop Manager Spreadsheet | Repair Orders, Tech Workload, Parts Markup and Shop Profit — Google Sheets

Which jobs actually made the shop money?

Every shop owner can tell you what the week billed. Far fewer can tell you, job by job, what each repair order PROFITED — after the tech's time, after the parts markup, after the job that sat in the bay for three days. This spreadsheet does that math for you, in one focused Google Sheets file built for a small shop.

Log each repair order once, move it through the pipeline as the work moves, and the board keeps score: labor billed, parts price at YOUR markup, the RO total, and the profit on every single job — plus each tech's open load and booked hours, so you can see who's buried, who's free, and who's actually earning.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

WHAT'S INSIDE — 6 focused tabs, not a 20-module system:

- Start Here — a plain-English guide, quick-start steps, and exactly how the math works

- Dashboard — the shop at a glance: open vs. completed ROs, total revenue, gross profit, average RO, parts profit, ROs by status, and per-tech revenue and profit

- Repair Orders — the pipeline board: RO number, customer, vehicle, tech, and status (Checked-in → Diagnosed → Approved → In Progress → Done → Picked Up), with labor hours, labor rate, parts cost, and your parts markup % — labor $, parts price, RO total, and profit all calculate themselves

- Tech Board — every tech side by side: open ROs, hours booked on open jobs, total hours, labor billed, RO revenue, and gross profit

- Parts Log — every part used, by RO, with line costs and a grand total that cross-checks the parts costs on your ROs

- Customers & Vehicles — your customer list builds itself from the RO board, with each customer's job count and total billed

HOW IT WORKS

1. After checkout you get a PDF with your private link. Click it and choose "Make a copy" — the spreadsheet is yours.

2. Set one number on the Dashboard: your blended tech labor cost per hour. Every profit figure in the file is built from it.

3. Log each job on Repair Orders and move its status as the work moves. A minute per job is plenty.

4. Read the Tech Board and Dashboard any time — tech load, revenue, and profit are always current.

THE MATH, IN PLAIN ENGLISH

Labor $ = labor hours × your labor rate. Parts price = parts cost × (1 + your markup %) — set the markup per job. Profit on an RO = your labor margin (labor billed minus the hours at your tech cost rate) plus the markup you earned on parts. No hidden formulas: the Start Here tab spells out every rule the sheet follows.

WHY THIS ONE

The big shop systems brag about 20 modules and a monthly subscription to match. This is the opposite: the six screens a working shop actually checks — the board at the counter, the tech load, and the profit — with the math done for you. It comes loaded with eight fictional sample repair orders across three techs (brakes, a water pump and timing job, an alternator, a CV axle) in every stage of the pipeline, so you can watch every rule work before you replace the samples with your own jobs.

A FINISHED FILE, DELIVERED INSTANTLY

You receive the finished spreadsheet file exactly as shown — open it, add your own jobs and customers, and use it right away. It is a complete digital file delivered to you, not a service and not a setup project. Nothing about the file is customized, personalized or built to order. If you ever find a genuine error in a formula or a number, tell us and we will send you a corrected copy of the file, free, forever.

REQUIREMENTS: a free Google account. Your spreadsheet lives in Google Sheets — no Excel needed, and it works at the counter, in the office, and on your phone.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.