← Back to Blog

How to Track Production Progress in a Small Workshop (Without Losing Your Mind)

If you run a small workshop, you already know the feeling. A customer calls asking about their order, and you have to walk out to the floor, find someone who knows where that job is, and hope they remember. That works when you have five jobs. It falls apart at twenty.

Maybe you check the whiteboard. Maybe you dig through a spreadsheet. Maybe you just know because you were the one who started it yesterday.

Production tracking is simply knowing where every job is at any given moment: which stage it's in, who's working on it, how much is done, and when it'll be finished. It sounds simple, but as your workshop grows, keeping that picture clear becomes one of the hardest parts of the job.

Why Workshops Struggle with Tracking

Most small workshops start with some combination of paper, whiteboards, and memory. There's nothing wrong with that at a certain scale. But these methods share a common weakness: they depend on someone actively updating them, and they're only visible if you're standing in front of them.

The problems tend to stack up around the same time: when you hit 15–30 active jobs, when you add a second shift or hire new workers, when customers start asking for delivery updates more frequently, or when you realise that one workstation has become a bottleneck but you can't prove it with data.

At that point, the whiteboard becomes a liability. It's out of date by mid-morning. The spreadsheet gets updated once a day if you're lucky. And you're spending an hour every day just figuring out what's happening instead of making decisions about what should happen next.

Method 1: The Physical Board

The simplest digital-free approach is a structured physical kanban board. Create columns for each workstation or production stage, write job details on cards, and move them as work progresses. This is better than a list or whiteboard because it gives you a visual flow.

The downsides are obvious: no remote access, no historical data, and it only works if people actually move the cards. But if you have a single-room operation with fewer than ten active jobs, it can work.

Method 2: Spreadsheets

Most workshops graduate from paper to Excel or Google Sheets. You create a table with columns for job name, client, status, workstation, and due date. Some workshops get quite sophisticated with conditional formatting, dropdown menus, and even basic dashboards.

Spreadsheets are flexible and familiar. But they have real limits for production tracking. They don't show you a visual flow of work across workstations. They require manual updates (and the more columns you add, the slower updates get). Multiple people editing the same sheet causes conflicts. And there's no time tracking, no photo logging, and no way for a floor worker to update their status without sitting at a computer.

For many workshops, spreadsheets are the tool that gets them from five employees to twenty. But somewhere in that range, they start to feel the friction.

Method 3: Digital Kanban Boards Built for Production

The next step is purpose-built production management software that uses the kanban board concept but adds the features a workshop actually needs: drag-and-drop cards that represent jobs, columns that represent workstations, live updates when workers log progress, time tracking, photo attachments, and the ability to see everything from your phone or a TV screen on the shop floor.

This is the approach that scales. A good production kanban system gives you real-time visibility without requiring you to physically walk the floor. Workers update their progress on a kiosk or mobile device, and the board updates in real time. You can filter by client, department, status, or date range. You can print the board for your morning meeting, or display it on a screen so everyone sees the same picture.

What to Look For in a Production Tracking Tool

If you decide to move beyond spreadsheets, here's what matters for a workshop environment:

• Visual workflow management — see jobs flow through workstations at a glance
• Time tracking — workers can start and stop right from the floor
• Mobile or kiosk access — your workers are at machines, not desks
• Custom fields — track what matters to your business specifically
• Simplicity — the most powerful software is useless if your workers won't open it

The Transition Doesn't Have to Be Painful

Switching from spreadsheets to dedicated software sounds like a big project. But for most workshops, the transition takes days, not months. You set up your workstations, create templates for your common products, import your current jobs, and put a tablet on the floor. Within a week, your team has a new habit.

The payoff is immediate: fewer phone calls interrupting your work, faster answers for customers, data on where jobs actually spend their time, and the confidence that comes from actually knowing what's happening without having to go check.