Auto Repair Shop Business Kit (Digital Download)

Built with input from people who work in auto repair, for independent mechanics and small shops who want to know their numbers without paying for shop software every month.

Write up the job, print the estimate for a signature, turn it into an invoice, then log the RO. The dashboard shows car count, ARO, labor and parts gross, and how efficient each tech is, all on one screen.

Light or dark, your choice

You get the kit in two looks: Daylight (bright and clean) and Midnight (a dark mode that's easier on the eyes in the back office). Same tabs, same formulas. Work Order and Invoice stay white in both so they print cleanly.

What's inside

• Auto Repair Shop spreadsheet (.xlsx) for Excel and Google Sheets
• FREE: Midnight dark-mode version of the spreadsheet (same features)
• Printables (one .zip file): Repair Order, Multi-Point Inspection, Estimate & Authorization and Invoice in US Letter, A4 and Low-Ink
• Quick-Start Guide (PDF)

The shop dashboard

• Car count, ARO, labor gross, parts gross, shop efficiency and total sales
• Progress bars for monthly sales, car count and ARO goals, plus month-end pace
• Tech efficiency gauges (flagged vs clocked) for each tech
• Status lights for parts and labor gross, gross profit and hours per RO
• Open repair orders with days open, plus 4 charts

Spreadsheet tabs

• Settings: labor rate, tax rates, shop supplies % with a cap, parts markup, goals, warranty text and techs
• Customers & Vehicles with VIN and plate, visits and lifetime spend
• Parts & Labor catalog: 33 common jobs with example book hours you can edit
• Work Order / Estimate with concern, cause, correction, 8 labor lines, 10 parts lines and an authorization line
• Invoice that fills itself from the work order
• Repair Order Log, monthly Tech Efficiency and Vehicle History lookup by VIN or plate

How it works

1. Check out. Your download link appears right after checkout and in your order confirmation email, so you can download instantly.
2. Open the .xlsx in Excel, or upload it to Google Drive and choose Open with > Google Sheets.
3. Fill in Settings, clear the sample data, and write up your first work order.

Compatibility

• Microsoft Excel 2016 or newer (Windows and Mac)
• Google Sheets (free with a Google account)
• Printables: any home or office printer, US Letter or A4
• No macros and no add-ons. Not built for Apple Numbers

FAQ

Is this shop management software?
No. It's a spreadsheet kit. No subscription, no login, and you own your data.

Are the book hours accurate?
They're examples for a typical car. Always check your labor guide and type in your own hours.

Does it handle multiple techs?
Yes. Up to 10 techs, each with their own pay rate and efficiency tracking.

Will it calculate my state's tax?
You enter your own parts and labor tax rates. It doesn't give tax advice.

Questions? Email sales@buckeyebrandingcompany.com. We're The Buckeye Branding Company, a small family-run shop in Copley, Ohio, and we answer our own email.

Digital download only. No physical item ships. For use in your own shop. Please don't share or resell the files.