Free tool
Job tracking template
Keep every custom order on one sheet: its stage, its due date and whether it is late. Your sheet is saved in this browser. No account needed, and nothing you type is sent to a server.
Checking whether this browser can save your sheet…
Job tracking sheet
Stages: Received → Planning → In progress → Review → Ready → Delivered
| Ref. | Customer | Job | Stage | Due | Updated | Notes |
|---|---|---|---|---|---|---|
What this tool does
The job tracking template is one sheet for every custom order your shop has in progress. Each job has a customer, what is being made, its current stage and a due date. The sheet counts jobs by stage, marks the ones that are overdue and keeps the date each job last moved. You can print it, save it as a PDF or download a CSV. You do not need an account.
Who it is for
It is built for print shops, sign shops and other small businesses that make things to order and keep track of jobs on a whiteboard, in a spreadsheet or in their head. One list sorted by due date shows at a glance what is waiting, what is late and what is ready.
Fields explained
- Stages: the steps every job goes through. Start from the print shop, sign shop or custom work stages, then rename, add, remove or reorder them, from 2 to 12. The last stage means the job is finished.
- Customer: who ordered the job.
- Job: what is being made, in a few words.
- Reference: your own order number, if you use one.
- Stage: where the job is now. Changing it sets Last update to today.
- Due date: when the customer needs it. A job past its due date that is not in the last stage is marked Overdue.
- Last update: the day the job last moved. You can correct it when editing a job.
- Notes: anything worth remembering about the job, up to 500 characters.
- Business name and page size: printed at the top of the sheet, on Letter or A4.
The sheet holds up to 200 jobs.
Example
Select Load example to fill the sheet with eight jobs for an invented print shop, from race day T-shirts to yard signs. Their dates are set around today, so one job, the wedding programs waiting for approval, is always overdue when you load it.
This is invented sample data. The businesses and orders do not exist.
Print a blank sheet
With no jobs added, Print or save as PDF prints your stage list and 20 empty rows to fill in by hand. With jobs added, it prints them sorted by due date, with a count by stage.
Limits
- The sheet is saved in this browser on this device only. Clearing the browser's site data, or opening the page on another device or browser, starts a new sheet. Download a CSV now and then as a copy.
- Clear this device deletes the sheet saved by this tool and nothing else.
- Nothing you type is sent to a server, and the sheet is not shared with anyone. Your customers cannot see it.
- The CSV opens in Excel and Google Sheets. It is a copy; the tool cannot read it back.
Common questions
Where is my job tracking sheet saved?
In this browser on this device, using its local storage. It is not sent to a server. Clearing the browser's site data or using another device or browser means starting again, so download the CSV now and then as a copy.
Can I change the stages of the job tracking template?
Yes. Start from the print shop, sign shop or custom work stages, then rename, add, remove or reorder them, from 2 to 12. A stage that still has jobs in it cannot be removed until you move them.
When is a job marked as overdue?
When its due date is before today and it is not yet in the last stage. The last stage counts as finished, so a completed job is never overdue.
Can I print a blank job tracking sheet?
Yes. With no jobs added, printing gives you the stage list and 20 empty rows to fill in by hand. With jobs added, it prints them with a summary by stage.