The usual mistake with a job tracker for trades is building it from the diary: one row per visit, cleared once the day has gone. A diary shows where you'll be. It doesn't show the job that still needs a part, a return visit or an invoice, so those are the jobs that drop out of sight. A tracker that works keeps one row per job from the day it's booked to the day it's paid, with a status and a next action date on every row.
Below are the columns to set up, headings to paste into Excel, Google Sheets or a similar spreadsheet app, eight statuses, colour rules that flag the jobs waiting on you, a filled-in example and a Friday check that keeps it current. It's written for owner-run plumbing, heating, electrical, building, joinery and roofing firms that aren't ready for a job app. For how a tracker fits alongside software, see the guide to choosing job management software for trades.
What the diary doesn't tell you
Most small firms run their jobs from three places: the diary, the job sheets coming back from site and whatever the owner remembers. On a quiet week that holds together. On a busy one, three things slip.
The first is the job that's waiting on something. A cylinder thermostat is on order, the customer is choosing tiles, or the landlord hasn't confirmed access. The diary has nothing in it for that job, so no one looks at it until the customer rings to ask what's happening.
The second is the return visit. The first day is in the diary; the second day, to fit the part that arrived late, gets booked when someone remembers. Meanwhile the job is half done and can't be invoiced.
The third, and the one that costs the most, is the finished job that hasn't been invoiced. The work is done, the van has moved on, and the job sheet sits in a tray. Nothing in the diary says "invoice this", and the customer won't ask for a bill.
A job tracker catches all three because every unfinished job stays on the sheet, with a date for the next thing that has to happen, until the money is in.
The columns, from booking to payment
Set the columns up in this order, from left to right. The ones you'll change every week sit together in the middle, and the dates that show how quickly you invoice and get paid sit at the end.
| Column | What to write | Why it's there |
|---|---|---|
| Job no. | Your job reference, such as J-0415 | Matches the job sheet, photos and invoice |
| Quote no. | The accepted quote's reference, or "None" for a call-out | Links back to the price you agreed |
| Date booked | The day the job was confirmed | Shows how long jobs wait to start |
| Customer | Name, and the company for a landlord or business | Who the job is for |
| Job and postcode | A few words, such as "Kitchen rewire, NG3" | Tells you which job it is at a glance |
| Agreed value (ex VAT) | The quote total before VAT, or your estimate for a call-out | Adds up the work in hand |
| Extras (ex VAT) | The total of agreed variations | Stops extras missing the invoice |
| Who | Whoever is doing or chasing the job | One name, so it's never no one |
| Start date | The first day on site | Lets you sort the week ahead |
| Status | One of the eight in the list below | The column every rule depends on |
| Next action | What has to happen next, such as "Ring merchant" | Turns the sheet into a to-do list |
| Next action date | When it has to happen | Turns the row red when it's due |
| Finished | The day the work was completed | Starts the clock on invoicing |
| Invoice date | The day the invoice went | Shows how long finished jobs wait |
| Paid date | The day the money arrived | Closes the row |
Use values before VAT, so the totals compare like with like whether or not a job carries VAT. Leave out a column only if you know you won't use it: a sole trader can drop Who, and a firm that only does call-outs can drop Quote no.
Copy the headings into a new sheet
Open a new spreadsheet and name the first tab Jobs. Click cell A1 and paste the line below. It will land in one cell; then use your spreadsheet's option to split text to columns, with a comma as the separator, and the headings spread across row 1 in the right order.
Add a second tab called Summary for the totals in the formula table further down. Then make three settings. Freeze the top row so the headings stay in view. Turn on the filter for row 1, so you can show only the jobs at one status. And set the six date columns to a date format, so the formulas can count days.
Keep one shared copy online, in an account with a strong password, and share it with named people instead of emailing the file around. A file saved on a laptop and another emailed to the office are two different trackers within a week. Don't type key safe codes, alarm codes or door entry numbers into it: the sheet gets opened in the office, on the sofa and in the van. Keep access details with the job record the engineer uses on the day.
Eight statuses, from Booked to Paid

The Status column needs the same words every time, or the colour rules and totals miss rows. Use your spreadsheet's data validation option to give it a drop-down list with these eight choices, in the order a job moves through them:
1. Booked: confirmed, with a start date. 2. Waiting for part: started or ready, but held up by something you've ordered. 3. In progress: on site now. 4. Return visit: part done, with a second visit to book or already booked. 5. Ready to invoice: finished, and the job sheet is back. 6. Invoiced: the invoice has gone. 7. Paid: the money is in. The row is closed. 8. Cancelled: the job won't go ahead.
Waiting on a customer, a landlord or a decision isn't a status of its own. Keep the status as it is and put the detail in Next action, such as "Ring landlord about access", with a date. The status stays clean enough to count, and the next action tells whoever opens the sheet what's going on.
Every row except Paid and Cancelled needs a next action date. A job with a status and no date is the same as a job in the diary that's already passed: no one will look at it until something goes wrong.
Colour rules for jobs that need you
Two colour rules do most of the work. Select the rows from A2 down to the bottom of your list, add a conditional formatting rule using a custom formula, and paste each formula exactly, starting with the equals sign. The four totals go in the Summary tab. All of them work in Excel and Google Sheets.
=AND( $J2 < >"Paid", $J2 < >"Cancelled", $L2 < >"", $L2 <=TODAY())=AND( $J2="Ready to invoice", $M2 < >"",TODAY()- $M2 >=2)=COUNTIFS(Jobs!L:L," <=" &TODAY(),Jobs!J:J," < >Paid",Jobs!J:J," < >Cancelled")=SUMIF(Jobs!J:J,"Ready to invoice",Jobs!F:F) +SUMIF(Jobs!J:J,"Ready to invoice",Jobs!G:G)=SUMIF(Jobs!J:J,"Invoiced",Jobs!F:F) +SUMIF(Jobs!J:J,"Invoiced",Jobs!G:G)=IFERROR(SUMPRODUCT((Jobs!M2:M1000 < >"") *(Jobs!N2:N1000 < >"") *(Jobs!N2:N1000-Jobs!M2:M1000))/SUMPRODUCT((Jobs!M2:M1000 < >"") *(Jobs!N2:N1000 < >"")),"")The letters assume your columns are in the order above, with the headings in row 1: J is Status, L is Next action date, M is Finished and N is Invoice date. If you add or remove a column, change the letters to match.
If a row matches both rules, either colour means the same thing: deal with it today. To see the average days from invoice to payment as well, copy the last formula and change M to N and N to O.
Where the quote tracker hands over
A job tracker starts where a quote tracker stops. While a quote is open, it belongs on the quote sheet, with its follow-up dates. The day the customer says yes, mark it Won there and give it a row here, with the same quote number in the Quote no. column.
Keep the two as separate tabs or separate sheets. They answer different questions: the quote sheet tells you which customers to chase for a decision, and the job sheet tells you which jobs to chase to the invoice. Mixing them into one list means filtering out half the rows every time you open it. If you don't track quotes yet, our quote tracker spreadsheet for trades gives you the columns and formulas, in the same layout as this one.
Feed it from the job sheet and variations
The tracker is only as current as the information coming back from site. Each time a job sheet comes in, whoever keeps the tracker changes three things on that row: the status, the next action and its date. If the job is finished, the Finished date goes in too.
That works best when every job sheet carries the job number and a clear status. Our job sheet template for trade visits has a status line with a short fixed list, and its Ready to invoice and Waiting for part boxes use the same words as the tracker, so each sheet updates a row without any translating.
Extras need the same care. When a customer agrees extra work on site, add its price to the Extras column the same day. Our variation form template for extra work gives each change a number and a price, so the Extras column adds up from paper you already have. A variation that lives only in someone's memory is the one that misses the invoice.
On a busy week, a text from site is enough: "J-0415 finished, sheet in the van, ready to invoice." The person keeping the tracker updates the row, and the job is on the invoice list before the van is back.
Illustrative example: an electrician's Friday check
This is an invented example to show the tracker in use. The firm, customers and figures are made up, and some columns are left out to fit the page; the ones shown are in spreadsheet order.
| Job no. | Customer | Job and postcode | Agreed value (ex VAT) | Status | Next action | Next action date |
|---|---|---|---|---|---|---|
| J-0412 | Mrs Hale | Consumer unit swap, NG5 | £780 | Paid | ||
| J-0413 | Kerr Lettings | EICR and two repairs, NG7 | £340 | Invoiced | Chase payment | 20/11/2026 |
| J-0414 | Mr Ansari | Kitchen rewire, NG3 | £2,950 | Waiting for part | Ring merchant about cooker switch | 12/11/2026 |
| J-0415 | Ms Fenwick | Garden office supply, NG5 | £1,640 | Ready to invoice | Send invoice | 13/11/2026 |
| J-0416 | Mr and Mrs Cole | Outside socket and lights, NG4 | £420 | Return visit | Fit lights once delivered | 18/11/2026 |
| J-0417 | Greenway Café | Emergency lighting test, NG1 | £260 | Booked | Confirm access with manager | 16/11/2026 |
Illustrative example: an electrician works with an apprentice, and his partner keeps the tracker on Friday afternoons. On Friday 13 November she filters out Paid and sees two red rows. The Ansari job was due a call to the merchant yesterday; she rings, finds the switch has arrived, and changes the status to In progress with Monday's date. The Fenwick job is red and amber at once: it finished on Tuesday 10 November, three days ago, and the invoice is due today.
The Fenwick job also has £95 of extras from a variation for an extra socket in the garden office, so the Summary tab shows £1,735 ready to invoice. She sends the invoice that afternoon, with the extras on it, and fills in the Invoice date. Without the tracker, that job would have waited until someone found the job sheet under the seat of the van.
A fifteen-minute Friday check
A tracker only works if someone opens it at a fixed time. Friday afternoon suits most firms, because the week's job sheets are back and next week's diary is taking shape. Put the slot in the diary and give it to one person.
In that slot, work through the same five steps:
1. Add every job booked this week that isn't on the sheet yet. 2. Update each row from the job sheets and texts that came in: status, next action, date, and the Finished date for completed jobs. 3. Filter out Paid and Cancelled, then work down the red rows: ring, order, book or chase, and write the new next action and date. 4. Invoice every amber row before you finish, or write down why it can't go and when it will. 5. Look at the Summary tab: actions due, value ready to invoice, value owed, and days to invoice.
Most weeks that's fifteen minutes. A paper version works the same way: a whiteboard grid, one row per job, with the status written in and a date beside it. What matters is that every unfinished job has a row and a date, and that someone looks at them every week.
Days to invoice: the number to watch

Of the four totals, days to invoice tells you the most. Payment terms start when the invoice arrives, not when you finish, so every day a finished job waits for its invoice adds a day to the wait for the money. It's the only part of that wait that's entirely up to you.
Compare the figure with your own last month. If it's creeping up, the Ready to invoice rows show why: job sheets back late, extras not confirmed, or invoicing left to month end. Our invoice template for trades lists what each invoice must carry, so none waits while someone looks up a VAT or CIS detail.
Old rows are business records
A tracker with invoice and paid dates is part of your business records, so move paid jobs to a tab called Closed instead of deleting them.
GOV.UK says the self-employed must keep records of all sales and income, with proof such as sales invoices. If you use traditional accounting rather than the cash basis, your records also need to show what you're owed but haven't received, and the value of work in progress at the end of your accounting period. The Invoiced rows and unfinished jobs give your accountant a start on both.
The self-employed must keep records for at least 5 years after the 31 January submission deadline of the relevant tax year. A limited company must keep them for 6 years from the end of the last company financial year they relate to, or longer in some cases. The tracker points to your invoices and bank records; it doesn't replace them.
These HMRC rules apply in England, Scotland, Wales and Northern Ireland. This is not legal advice or tax advice; ask your accountant what to keep.
Moving the jobs into an app
A spreadsheet starts to strain when several engineers need the day's jobs on their phones, or the same customer details are typed into the tracker, the diary and the invoice. A job app can hold the job, status, photos and invoice in one record. Before you pay for one, list what your tracker does today, because that's the minimum any app must do, and keep the sheet running for the app's first month.
Start with the jobs you haven't invoiced
Set up the sheet tonight with the headings and the two colour rules. Go through last month's diary and the job sheets in the van, and give every unpaid job a row, a status and a next action date. Start with anything finished and not invoiced: that's money you've already earned.
Sources checked for this guide
Record-keeping points checked against GOV.UK guidance for the self-employed and for limited companies. These are the primary sources used in this guide.
- GOV.UK, Business records if you're self-employed: what records to keep
- GOV.UK, Business records if you're self-employed: how long to keep your records
- GOV.UK, Running a limited company: company and accounting records


