How to keep a job tracking sheet that actually gets used

A job tracking sheet is the one list of live work: who it is for, where it sits, what happens next, and who owns it. Without it you hunt through texts, van notes and memory, and jobs stall. This guide shows a sheet you will actually update, a process that fits a van or shop floor, and the mistakes that make sheets die.

What a missing job tracking sheet actually costs you

It is not the paper. It is the time you spend reconstructing the day. You ring a customer to check a date you already wrote on a scrap. You send two people to the same site. A part sits in the van because nobody marked it against the job. The customer rings you because nobody told them the next step.

That hassle stacks. Morning starts with a scramble instead of a glance. Evenings vanish into catching up. Staff ask you the same status questions because the list lives in your head. You cannot see which jobs have gone quiet until they explode.

A tracking sheet does not need to be fancy. It needs to be the single place everyone trusts, and it needs to be fillable in thirty seconds with dirty hands or a phone in a car park.

What a good job tracking sheet looks like

Keep it to columns people will actually fill. If a field needs a novel, it will stay blank. Aim for one line per live job, plus a short note if something is stuck.

Fields that earn their keep

• Job number or short name you can shout across the floor.
• Customer and site, not a full address unless you need it for the van.
• Date in, and the promised next date if you gave one.
• Status in plain words: booked, waiting parts, on site, waiting customer, ready to invoice, done.
• Owner: the person who must move it next, not a team name.
• Next action in one line: order filter, call for access, fit tomorrow am.
• Parts or kit: ordered, in van, missing.
• A tiny notes cell for the one fact that would otherwise get lost, such as a gate code or a dog.

Drop anything you never look at. Estimated hours, profit, and marketing source belong elsewhere. The tracking sheet is for movement, not accounts.

A process that works off the van

The sheet fails when update is a desk job at 7pm. Build three tiny habits around the work you already do.

1. Morning: one glance. Read only the jobs with a next date of today or overdue. Confirm who is going where. Change owner if someone is off.
2. On site or on the floor: when the status actually changes, change the line. Waiting parts becomes on site. On site becomes waiting customer. Do it before you drive off, not later from memory.
3. End of day: close or park. Mark done jobs as done, or write the next action and the next date. If nothing moved, write why in the notes cell so it does not look live when it is stuck.

If you work from a van, a printed sheet in a clip folder still works if you photograph it at the end of the day and someone copies the changes. If two people need it at once, a shared sheet on a phone is kinder than three paper copies.

Paper, whiteboard or a shared sheet

Pick the format you will update, not the one that looks organised in a photo.

A hybrid is common: whiteboard for today, shared sheet for the full live list. The rule is one source of truth for status. If the board and the sheet disagree, the sheet wins and the board gets wiped to match.

What an agent would do with the tracking

A custom AI agent built around this job would not replace the sheet. It would keep the sheet honest. You still decide the work. The agent would take the messy inputs you already create: a photo of a paper list, a voice note from the van, a text from a customer, a parts invoice, and turn them into the same short line on the list.

It would flag jobs with no next action, jobs past the promised date, and jobs sitting in waiting parts with no order date. It would not invent status. If it cannot tell whether the job moved, it would ask you one question, not ten.

What to watch out for

Too many statuses. If you have twelve colours, nobody remembers them. Stick to a handful of plain words and use the next action cell for the rest.

Two lists. The diary, the whiteboard, and the sheet all claiming to be live. Pick one for status. Use the diary for appointments only.

Nobody owns the line. If the owner cell says workshop, it means you. Put a name.

Done jobs lingering. Archive them off the live sheet every week or the list becomes wallpaper. Keep a simple done pile if you need it for invoices, not mixed in with live work.

Updating only when something goes wrong. That is when the sheet is already late. The cheap habit is the thirty second change when the job actually moves.

If staff will not touch it, the sheet is too long or they do not trust it. Cut columns. Walk the morning glance together for a week until the list matches reality. Trust comes from the list being right, not from a lecture.

What Cleo would do

A custom Cleo built for this job would work from the process you already run, not a new system you have to learn. It would take the notes, photos and messages you already create and keep one live list of jobs, owners and next actions. It would surface jobs that have gone quiet so you are not reconstructing the day from memory. You still decide the work. Cleo keeps the tracking current.

Common questions

Do I need a job number on a tracking sheet?

Yes if you have more than a handful of live jobs, or more than one person. A short number or a shoutable name stops two people talking about different jobs with the same customer surname.

Should the tracking sheet also be the invoice list?

No. Keep live movement on the tracking sheet. Move done jobs to a simple done pile or your invoicing routine. Mixing them makes the live list too long to scan in the morning.

What if the van has no signal?

Use paper or a photo of the sheet, then copy changes when you have signal. The rule stays the same: one source of truth, updated when the job actually moves, not when you get back to a desk.

How often should I clear done jobs off the sheet?

At least once a week. Daily is better if the list is long. A live sheet full of finished work is as useless as no sheet at all.