The job tracking problem
You have 12 active jobs in your shop right now. Three are on the CNC. Two are waiting for material. One just came off the saw and needs to go to the mill. Four are in various stages of finishing. And two more are supposed to start today but you’re not sure which machines are free.
A customer calls. “Where’s my order?” You know the answer is somewhere between the whiteboard, the spreadsheet, and your memory. You tell them you’ll call back. Then you walk the floor to find out.
This is the job tracking problem. It’s not that you don’t know what’s happening. It’s that the answer is scattered across five different places, and piecing it together takes time you don’t have.
Job tracking in manufacturing doesn’t have to be this way. Whether you run a machine shop with lathes and mills or a fabrication operation with saws and press brakes, fixing it requires understanding why it breaks down in the first place.
Why job tracking gets hard at 3+ machines
One machine is easy. You know what’s on it. You know what’s next. The whole schedule fits in your head.
Two machines is still manageable. You can keep track of both without much effort.
Three machines is where things change. Now you have three parallel timelines that interact with each other. Job A needs the saw first, then the CNC. But Job B is on the CNC until Thursday. And Job C needs the same saw as Job A but has a tighter deadline.
The interactions between machines create complexity. It’s not three separate schedules. It’s one schedule with dependencies, conflicts, and tradeoffs that multiply with every machine you add. This is why double-booking machines becomes such a common problem.
By the time you have 5 to 8 machines, the number of possible conflicts is more than any person can hold in their head. That’s not a criticism. It’s math.
What good job tracking looks like
Good job tracking answers four questions at any moment, for any job:
- Where is it? Which machine, which station, which step in the process.
- Who’s on it? Which operator is running it right now.
- What’s next? What happens after the current step finishes.
- When is it due? How much time is left before the deadline.
If you can answer those four questions for every active job in your shop without walking the floor, without opening three different files, and without asking somebody, you have good job tracking.
Most shops can answer those questions for their top 2 to 3 jobs. The ones with the tightest deadlines or the biggest customers. It’s the other 10 that slip.
The multi-step problem
Here’s where most tracking systems fall apart.
A simple job might just need one machine. Cut a piece of bar stock to length. Done.
But most real jobs have multiple steps. A typical job might look like this:
- Cut raw material on the band saw
- Mill the profile on the CNC
- Deburr edges at the bench
- Heat treat in the oven
- Final grind on the surface grinder
- Inspect and pack
Each step happens on a different machine. Each step might need a different operator. Each step takes a different amount of time. And each step can’t start until the previous one finishes.
If you track this as one line item on your schedule, all you know is “Job 247: in progress.” That tells you nothing. Is it on the saw or the grinder? Is it waiting between steps? Has it even started?
To track multi-step jobs, you need to track each operation separately. That means each step gets its own entry with its own machine, operator, start time, and status.
This is where whiteboards run out of space. This is where spreadsheets get complicated. A job with 5 operations across 5 machines is 5 separate entries to track, update, and coordinate. Multiply that by 12 active jobs and you’re tracking 60 individual operations.
That’s 60 things that can be in the right place or the wrong place at any given moment.
How shops track jobs today (and where each method breaks)
The whiteboard
How it works: Write job names on the board. Group them by machine or by status. Update with markers as jobs move through the shop.
Where it works: Small shops with fewer than 10 active jobs. Shops where everyone works in the same room and can see the board.
Where it breaks:
- You can’t check it from home or from the other end of the shop
- Erasing and rewriting gets messy. After a few days, the board is a mess of smudged text and crossed-out entries
- No history. Once you erase a job, it’s gone. A customer asks about a job from two weeks ago and you have no record
- Multi-step jobs don’t fit. You can write “Job 247” in one column, but where do you track which step it’s on?
The spreadsheet
How it works: Rows for jobs or machines. Columns for dates, operators, status. Color coding for priorities. Maybe some formulas for calculating end dates.
Where it works: Shops with 1 to 3 machines and an owner who likes spreadsheets. Works best when one person maintains it.
Where it breaks:
- Multiple people editing creates version problems
- Multi-step jobs need complex layouts that are hard to maintain
- No conflict detection. Two jobs on the same machine at the same time? The spreadsheet doesn’t notice
- Mobile access is painful. Try updating a detailed spreadsheet on your phone at the machine
- It takes constant maintenance. Every status change requires manual editing
For a deeper look at these problems, read the real cost of running your shop on spreadsheets.
Paper job travelers
How it works: A printed sheet follows each job through the shop. Operators sign off on each step as they complete it.
Where it works: Quality tracking. Knowing who did what and when. This is standard practice in shops with quality requirements.
Where it breaks:
- You know where a job has been, but not where all your other jobs are. Each traveler only tracks itself
- No schedule view. You can’t see all your machines and all your jobs at a glance
- Paper gets lost, damaged, or covered in coolant
- The information is only available to whoever is holding the paper
The combo approach
Most shops use all three. Whiteboard for the big picture. Spreadsheet for the details. Paper travelers for quality tracking.
The problem isn’t any one method. It’s that they don’t connect. You update the spreadsheet but not the whiteboard. The traveler says the job is done but the spreadsheet still says “in progress.” Someone checks one source and gets a different answer than someone checking another.
You become the sync mechanism. Every question gets routed to you because you’re the only person who knows the current state across all three systems.
A better approach to job tracking
You don’t need a complicated system. You need one system that does four things.
1. One place for everything
Every job, every machine, every operator, every material. One place. Not three files and a whiteboard. One screen that shows the current state of your shop.
This solves the version problem and the “human router” problem at the same time. When there’s one source of truth, people check it instead of asking you.
2. Track operations, not just jobs
Each step in a multi-step job gets its own entry. You can see that Job 247 is on step 3 of 5, running on the CNC, assigned to Mike, due Thursday. Not just “Job 247: in progress.”
This level of detail is the difference between knowing something is happening and knowing exactly what’s happening.
3. See all your machines at once
A schedule view that shows every machine and what’s on it. When something finishes, you can see which machine opens up and which job should go on it next.
This view should catch conflicts. If you try to put two jobs on the same machine at the same time, the system should flag it. This is what a scheduling board does.
4. Access from anywhere
The schedule should work on a phone, a tablet, and a desktop. Your floor workers check it from the machine. Your office staff check it from their desk. You check it from home at 9 PM when a customer texts you asking about their job.
Same data, same view, everywhere.
How to set up job tracking that works
Start small. Don’t try to overhaul everything on day one.
Week 1: List all your machines and their current status (active, idle, down). List all your active jobs with their operations and due dates. Put this information in one place.
Week 2: Start assigning each operation to a specific machine and operator. Update the status as jobs move through the shop. See how it feels.
Week 3: Look at the data. Where are the bottlenecks? Which machine is always overloaded? Which jobs are consistently late? The answers will show up when you’re tracking things in one place.
Ongoing: Make it a habit. Five minutes at the start of the day to review. Quick updates as jobs move. A glance at the end of the day to plan tomorrow.
The hardest part isn’t choosing a tool. It’s building the habit of keeping it current. A tool that’s 80% accurate is useful. A tool that’s 50% accurate is worse than nothing because people will trust information that’s wrong.
Key takeaways
- Job tracking breaks down at 3+ machines because of the interactions between parallel schedules
- Good job tracking answers four questions: where is it, who’s on it, what’s next, and when is it due
- Multi-step jobs need per-operation tracking, not one line item per job
- Most shops use a combination of whiteboards, spreadsheets, and paper. None of them connect
- The fix is one system that tracks operations across machines with conflict detection and mobile access
- Start small: list machines, list jobs, assign operations, and build the habit of daily updates
Frequently asked questions
What is job tracking in manufacturing?
Job tracking is knowing where every job is in your shop at any given moment. Which machine is it on? Who is running it? What step is it on? When is it due? If you can answer those questions without walking the floor, you’re tracking jobs.
How do I track production jobs in a small shop?
Start by listing every active job, its operations, and its current status. Then choose a system that your whole team can see and update. The key is one source of truth that everyone trusts.
What’s the best way to track multi-step manufacturing jobs?
Break each job into individual operations (cut, mill, deburr, heat treat, etc.). Track each operation separately with its own machine assignment, operator, and status. This way you know exactly where a job is in the process, not just whether it’s “in progress.”
When should I switch from manual job tracking to software?
When you have more than 10 active jobs across 3+ machines, manual tracking starts failing. Signs include lost jobs, missed deadlines, double-booked machines, and spending more than 20 minutes a day updating your tracking system.
Moving forward
Job tracking in manufacturing is not about buying software. It’s about knowing where everything is, all the time, without having to piece together information from five different places.
Whether you use a whiteboard, a spreadsheet, or a dedicated tool, the principle is the same. One place. Current data. Accessible to everyone who needs it.
If you’re spending more time figuring out where jobs are than actually moving them forward, the tracking system needs to change. Start by putting everything in one place. The rest follows from there.