Job Card Template for Excel: Free Editable Spreadsheet for UK Workshops
Most downloadable job card templates on the internet are PDF files — print them, fill them in with a biro, stick them in a filing cabinet. That's not a template; that's a piece of paper.
An Excel job card template works differently. It auto-calculates line totals, keeps a searchable history of every job you've ever done, and gives you a foundation you can actually evolve into something better. It also costs nothing and every UK workshop owner already has Excel (or a free spreadsheet equivalent).
This post walks through the exact column structure to use, the formulas that do the work, and the point at which a spreadsheet stops being enough.
Why Excel Beats a PDF Template for Workshop Job Cards
A paper or PDF job card captures one job in one moment. An Excel job card template does three things a paper version can't:
Auto-calculates totals. Multiply hours by rate, sum parts by row, add parts + labour + subcontract in one cell. You stop making arithmetic mistakes when you're invoicing.
Creates a history. Every job you complete adds a row to a spreadsheet you can search, filter, and sort. "What did we charge on a John Deere 6930 rear axle last year?" becomes a one-minute lookup instead of a trip to the filing cabinet.
Gives you structured data. Once job information is in columns — not prose — you can build reports: hours by technician, margin by customer, parts spend by supplier. None of that is possible with paper.
The honest limitation: a spreadsheet is still a single user tool. If two people try to edit the same workbook at the same time, one of them loses their changes. For small workshops (1-3 staff) that's fine. Above that, the shared-editing conflicts start to hurt.
The Column Structure That Actually Works
Start with one row per job, not one workbook per job. Every job card adds a new row. This makes the sheet searchable and lets you calculate aggregate metrics — the whole point of using Excel over paper.
Core columns (non-negotiable)
| Column | Purpose | Example |
|---|---|---|
| Job no. | Unique reference for invoicing and customer queries | JC-2026-0417 |
| Date arrived | When the machine came in | 09/04/2026 |
| Date completed | When the work was done and signed off | 11/04/2026 |
| Customer name | For invoicing | Smith Engineering Ltd |
| Customer phone | For authorisation calls | 01234 567890 |
| Machine make | For history lookup | Case IH |
| Machine model | Specific model reference | Puma 185 CVX |
| Serial / reg no. | Unique machine identifier | ZJRF123456 |
| Fault reported | What the customer said was wrong | Hydraulic leak from rear remotes |
| Work done | Brief summary of actual work | Replaced valve block seals, pressure-tested |
| Technician | Who did the work | D. Morgan |
These 11 columns capture what matters for every job. If you don't have space for all of them, you're not tracking enough.
Parts tracking — separate tab
Parts are best held in a linked tab rather than crammed into the job card row. One parts entry per row on a "Parts" tab, linked by Job no.
| Parts tab columns | Example |
|---|---|
| Job no. (foreign key to main tab) | JC-2026-0417 |
| Part description | Hydraulic seal kit |
| Supplier | Pirtek |
| Quantity | 1 |
| Unit cost (£) | 47.50 |
| Line total (£) | =D2*E2 |
The Line total column is a formula, not a typed number. That prevents the common mistake of entering "3 seals at £47.50" and typing 47.50 in the total column.
To get parts total per job back onto the main tab, use SUMIFS:
=SUMIFS(Parts!F:F, Parts!A:A, [@[Job no.]])
This reads "sum the line total column on the Parts tab where Job no. matches this row's Job no." It updates automatically every time a part is added.
Labour tracking — separate tab
Same structure as Parts but with hours and rate:
| Labour tab columns | Example |
|---|---|
| Job no. | JC-2026-0417 |
| Technician | D. Morgan |
| Date | 09/04/2026 |
| Hours | 3.5 |
| Rate (£/hr) | 35.00 |
| Labour total (£) | =D2*E2 |
Logging per-day entries (not just a total) lets you see the actual pattern of work. A job that shows "3.5 hours on day 1, 1.5 hours on day 3" tells you something different from "5 hours on one day" — useful for quoting similar jobs later.
SUMIFS again pulls labour total onto the main job row:
=SUMIFS(Labour!F:F, Labour!A:A, [@[Job no.]])
Job totals on the main tab
Once parts and labour are flowing in from their tabs, add three more columns to the main tab:
| Column | Formula |
|---|---|
| Parts total (£) | SUMIFS from Parts tab (above) |
| Labour total (£) | SUMIFS from Labour tab (above) |
| Job cost (£) | =[@[Parts total]]+[@[Labour total]] |
If you subcontract work out, add a Subcontract column and include it in the Job cost sum.
Invoicing and margin
Two more columns close the loop:
| Column | What goes in | Formula or notes |
|---|---|---|
| Invoice price (£) | What you charged the customer | Typed manually — your quote |
| Margin (£) | Profit on the job | =[@[Invoice price]]-[@[Job cost]] |
| Margin (%) | Profit as a percentage | =[@[Margin]]/[@[Invoice price]] (format as percentage) |
The margin column is the most important column in the whole spreadsheet. It shows which jobs make money. After 30 completed jobs, you can filter to "margin below 15%" and see the patterns — specific job types, specific customers, specific technicians — where your pricing isn't working.
Setup — 30 Minutes, One Time
To build this from scratch:
- Create a new Excel workbook. Three tabs:
Jobs,Parts,Labour. - On the Jobs tab, add the 11 core columns in row 1. Format row 1 as a table (
Ctrl+T). This makes[@[Column name]]formula references work. - On the Parts tab, add the 6 parts columns. Format as table. In the Line total column, enter
=[@Quantity]*[@[Unit cost]]. - On the Labour tab, add the 6 labour columns. Format as table. In the Labour total column, enter
=[@Hours]*[@Rate]. - Back on Jobs tab, add the Parts total / Labour total / Job cost / Invoice price / Margin columns. Enter the SUMIFS and calculation formulas.
- Add a row of fake data on the Parts and Labour tabs referencing Job no. "TEST-1" and check the Jobs tab formulas pull through correctly.
- Save the workbook as your template. Copy it every financial year so each year is its own file (spreadsheets get slow past a few thousand rows).
That's it. From now on, every new job is a new row on the Jobs tab, with parts and labour added to their respective tabs as the work happens.
Excel vs Google Sheets — Which to Use
Either works. The formulas above are the same in both.
Use Excel if:
- You already have Microsoft 365 or a perpetual Office licence
- Everyone in the workshop is on Windows
- You don't need shared real-time editing
Use Google Sheets if:
- You want free forever (no licence cost)
- Multiple people need to open the same workbook from different machines
- You want it accessible from a phone without extra setup
Google Sheets has one genuine advantage for a workshop: concurrent editing. Two people can update the same spreadsheet at the same time without overwriting each other. Excel has this too if the workbook is saved on OneDrive or SharePoint, but the setup is clunkier.
For a 1-3 person workshop on Windows machines, Excel is the simpler choice. For anyone with a mix of devices or multiple users entering data simultaneously, Google Sheets removes friction.
What Excel Can't Do (The Upgrade Point)
Every workshop that runs on Excel eventually hits the same four limits. Worth knowing in advance so you can plan for the transition.
Shop-floor data entry is slow
Excel on a phone is not a pleasant editing experience. Adding a part from the workshop floor requires opening the app, navigating to the right tab, scrolling to find the right Job no., and tapping into cells. It takes a minute per part — fine when you have five seconds to spare, not fine when three machines just came in at once.
By the time you have 40+ jobs per month with multiple technicians, the parts entry step becomes the bottleneck. Either parts get logged at the end of the day (at best) or not at all (at worst).
No customer history lookup
"What did we do on this machine last time?" is a question asked daily in a busy workshop. In Excel, you answer it by searching for the serial number in the Serial column, which works — but only if the serial was typed consistently last time. ZJRF123456 and ZJRF 123456 don't match. Accessing photos from a previous job requires digging through a folder system that may or may not be organised.
No real-time status for customers
Customers ask "is my tractor ready?" constantly. An Excel sheet is a private record. The customer can't check. The receptionist has to open the sheet, find the row, and relay the status verbally. For 5 jobs a week that's fine. For 40 jobs a week, that's a full-time job.
No accounting sync
At month-end, someone has to open the spreadsheet, read each completed job row, and manually type the customer, parts, and labour into QuickBooks or Xero. A workshop processing 40 jobs per month spends 3-5 hours on this every single month — over 40 hours a year of pure data re-entry. That's the clearest signal that the spreadsheet has outgrown its purpose.
When to Stay on Excel, When to Move On
Excel is the right answer if:
- Your workshop is 1-3 people
- You process fewer than 20-30 jobs per month
- Nobody is trying to check job status from a phone
- Your bookkeeper is happy transcribing at month-end
Excel is the wrong answer if any of these apply:
- Multiple technicians need to update the same job simultaneously from the shop floor
- You're losing parts data because logging feels too slow
- Month-end re-keying into accounting software takes more than 2-3 hours
- Customer history lookups are taking more than 30 seconds
The transition point isn't revenue or staff count — it's when the tool starts creating drag instead of saving time. Most workshops hit that point between 30-50 jobs per month.
Take Our Excel-Ready Template
Build the structure above yourself — the column names, formulas, and tab layout are all in this post. If you want an online version that auto-fills the customer and machine details from a form and outputs a PDF, try our free workshop job card template tool.
For a deeper look at what job cards should cover regardless of format, see our complete guide to workshop job sheets. And if you're already tracking hours and parts in a spreadsheet and wondering what the per-job profit looks like, our free job costing calculator runs the same margin calculation from this post without needing to build the formulas yourself.
This template structure works for UK workshop operations handling reactive (walk-in, breakdown, and phone-booked) jobs. For HMRC record-keeping guidance, see gov.uk's records guidance.
We're building JobCardApp as the purpose-built upgrade path from spreadsheet to proper digital job cards — shop-floor parts entry in under 30 seconds, customer history lookup by machine serial, and QuickBooks/Xero sync that ends the month-end re-keying. Join the waitlist for early access.
Last reviewed: 15 April 2026