Auto Repair Shop CRM
Manage customers, vehicles, service history, and job pipeline in one spreadsheet. Built for independent mechanics and small garages who want organised customer records without expensive shop management software. What's Included Customer + vehicle database (make, model, year, VIN, mileage) Full service history log per vehicle Job pipeline from estimate to invoice Parts and materials tracker per job Warranty and follow-up reminder system Seasonal service alert (oil change, tyre rotation due) Revenue dashboard by job type Lifetime updates Compatible with: Google Sheets and Microsoft Excel The Auto Repair Shop CRM tracks the one thing that makes customers return: knowing their car. With a complete vehicle service history, upcoming maintenance alerts, and a job pipeline from enquiry to invoice, you'll never lose track of a customer or miss a service opportunity again. Know every car that's walked through your bay. Know what was done, when, and what's due next. That's how independent garages keep customers from going to the dealership. Why a Spreadsheet CRM? Auto shop management platforms like AutoFluent, Mitchell1, or Shopmonkey cost $150–$300/month. For independent mechanics and small garages, this template captures everything that matters — customer records, vehicle history, job tracking — for a one-time payment with no ongoing fees. Included Sheets Sheet Purpose Dashboard Active jobs, revenue this month, vehicles due for service, and top customers Customers Contact database with vehicles owned and total spend Vehicles Vehicle records with make, model, year, VIN, and current mileage Service History Every job logged by vehicle: date, work done, parts used, cost, and mileage Job Pipeline Active jobs tracked by stage: Estimate → Approved → In Progress → Complete → Invoiced Parts Tracker Common parts log with supplier and price Reminders Vehicles flagged for upcoming service (oil change, MOT, tyre rotation) Who It's For Independent mechanics and sole-trader garages Small auto repair shops with 2–5 bays Tyre and exhaust specialists managing a regular customer base Compatibility Fully functional in Google Sheets (recommended) and Microsoft Excel 2016+.
Get it → viasheet.gumroad.com