Job Tracking Spreadsheet for Workshops: Free Template and Where It Breaks Down

Plenty of workshops run their whole operation on a spreadsheet. One row per job, a few columns for parts and labour, a running total at the bottom. It's free, it's familiar, and for a small shop it genuinely works — for a while.

This post covers how to set up a job tracking spreadsheet that actually earns its place: the columns worth having, the formulas that do the arithmetic for you, and the honest list of things a spreadsheet will never do well. If you're tracking jobs on paper or in your head right now, a spreadsheet is a real step up. If you're already on a spreadsheet and it's starting to creak, the last section is for you.

Why a Spreadsheet Beats Paper for Tracking Jobs

A pile of paper job cards tells you about one job at a time. A spreadsheet tells you about all of them at once — and that's the whole point.

You can see everything in one view. Sort by status and you instantly see what's incoming, what's in progress, and what's waiting on parts. No walking to the whiteboard, no shuffling cards.

The maths does itself. Parts cost plus labour cost, multiplied out and totalled, in a cell that updates the moment you type a number. No more adding up a column of figures with a calculator at month-end.

You build a history without trying. Every job you log is a row you can search later. "What did we charge that haulage firm for the trailer brake job in March?" becomes a thirty-second filter instead of a trip to the filing cabinet.

The catch is that a spreadsheet is built for one person at a desk. Two people editing the same file at once is where the trouble starts — but we'll get to that.

The Columns That Actually Matter

Resist the urge to add forty columns "just in case." A job tracking sheet works best when it's quick to fill in, which means keeping it lean. Here's a column set that covers a reactive workshop without becoming a chore:

Column	Why it's there
Job number	A unique reference for every job (JC-001, JC-002...). This is how you cross-reference with your accounts later.
Date in	When the work arrived. Lets you spot jobs that have been sitting too long.
Customer	Name and a phone number. Keep it consistent so you can filter by customer.
Machine	Make, model, and serial or registration. This is what turns the sheet into a service history.
Fault / work	A short description of what's wrong or what's needed.
Status	Incoming / In progress / Awaiting parts / Done. The single most useful column for daily management.
Parts cost	Total parts for the job (or break parts into their own tab — see below).
Labour hours	Hours worked on the job.
Labour rate	Your hourly charge-out rate.
Total	A formula: parts + (hours × rate). The number you invoice from.
Invoiced?	Yes/No. Stops jobs slipping through to month-end uninvoiced.

That's eleven columns. A technician or front-counter person can fill a new row in under a minute, and you can read the whole workshop's state at a glance.

The one formula worth setting up

The Total column is where a spreadsheet stops being a glorified notepad. If parts cost is in column G, labour hours in H, and your rate in I, the total in column J is:

=G2+(H2*I2)

Fill that formula down the column and every job calculates its own total. Add a =SUM(J2:J200) at the bottom and you've got a live monthly revenue figure. It sounds trivial, but eliminating manual arithmetic is where most of the time saving comes from — and it removes the transcription errors that creep in when you're adding up by hand at the end of a long week.

If you want to track per-job profitability rather than just revenue, add a column for your parts cost (what you paid the supplier) alongside the parts price (what you charge the customer), and the margin falls out of a second formula. Our free job costing calculator does this maths for a single job if you want to see the shape of it before building it into your sheet.

One Sheet or Many? Structuring the Workbook

The most common spreadsheet mistake is starting a new tab (or a new file) for every job. Don't. That makes searching and totalling impossible — the two things a spreadsheet is good at.

Instead, use one row per job on a single "Jobs" tab. If you need to log lots of individual parts per job, add a second "Parts" tab where each row is one part line, tagged with the job number, and pull the per-job parts total back into the Jobs tab with a SUMIF. That keeps the main view clean while still capturing line-item detail.

For workshops moving from paper, there's a natural starting point: our free workshop job card template shows the field structure a complete job card needs, and our guide to building a job card template in Excel walks through the column layout and formulas in more depth, including the Excel-versus-Google-Sheets trade-off.

Excel or Google Sheets?

Both work. The deciding factor is usually how many people need to touch the sheet:

• Excel suits a single person doing the admin — it's fast, everyone knows it, and it works offline. Shared editing is possible via OneDrive or SharePoint but the setup is fiddly.
• Google Sheets suits a workshop where two or three people update jobs from different machines. Real-time concurrent editing is built in, and it opens on a phone without any setup.

If your whole team needs to see and update the board, Google Sheets is the more honest fit. If it's one person at the counter doing all the data entry, Excel is fine.

Where a Job Tracking Spreadsheet Breaks Down

A spreadsheet is a great first system. It is not a great tenth system. Here's where workshops hit the wall:

Concurrent editing conflicts. The moment two people edit the same workbook at the same time, someone's changes get overwritten. Google Sheets handles this better than Excel, but neither is built for a busy workshop where the counter, two technicians, and the bookkeeper all want to update jobs through the day.

No mobile reality. A technician with oily hands pinching and zooming a spreadsheet on a phone is not going to keep it up to date. The parts get scribbled on a scrap of paper "to enter later" — and later never comes. Spreadsheets weren't designed for shop-floor data entry.

Re-keying into your accounts. The spreadsheet doesn't talk to QuickBooks or Xero. At month-end, someone still copies every completed job across by hand. You've moved the re-keying from paper to a screen, but it's still re-keying. For most workshops this is the single biggest hidden cost of staying on a spreadsheet — see our breakdown of how to stop re-keying job cards into QuickBooks.

No photos, no documents. Damage photos, delivery notes, and customer authorisations live on people's phones, disconnected from the job row. When a warranty query lands six months later, the evidence is nowhere near the record.

It degrades quietly. Spreadsheets work until the person who built it leaves, the formulas get broken by a careless paste, or the file balloons to the point where opening it takes thirty seconds. There's no one to maintain it because it was never really a system — it was one person's clever workaround.

None of this means a spreadsheet is the wrong choice today. It means you should recognise the ceiling so you're not surprised when you hit it.

When to Move On

A good rule of thumb: a spreadsheet is fine while one person can keep it current. The day you need more than one person updating jobs in real time — or the day month-end re-keying starts eating a full day — is the day a spreadsheet starts costing you more than it saves.

At that point the upgrade isn't a fancier spreadsheet. It's a system designed around the workshop workflow: a shared board everyone can see and update, mobile-friendly data entry that survives the shop floor, and a direct sync to your accounting software so completed jobs become draft invoices without anyone re-typing them. Our guide to what's actually available in job sheet software for UK workshops covers the options — and the gap most tools leave for reactive, non-automotive workshops.

To put a number on what your current process costs, run it through our paper-to-digital savings calculator — most workshop owners are surprised by the month-end figure.

This guide covers spreadsheet-based job tracking for UK workshops as of mid-2026. We're building JobCardApp as the purpose-built next step up from a spreadsheet — a shared board, under-30-second mobile parts entry, machine history by serial number, and QuickBooks/Xero sync that ends the month-end re-keying. Join the waitlist for early access.