Work order tracking: 6 steps from paper to digital

Most CNC shops still track work orders the same way: quantity, date and operator name handwritten on the back of the drawing or on a form, then typed into Excel in the office that evening. With 3 machines, this works for years. At 6 machines, two shifts and 80 work orders a month, it breaks. This article covers that breaking point, a sensible order for going digital, and what really happens in the first month.

Where paper and Excel break down

The problem with paper and Excel is not that they are "old". It is that information lives in two places at two different times.

Information is created at the machine but recorded in the office. An operator finishes 40 parts at 2:00 pm and writes it on the form. The form reaches the office at 6:00 pm and is entered into Excel the next morning. When a customer calls at 3:00 pm asking "where is my job?", nobody has the right answer; someone walks out to the floor to check the form.

The same number is written in more than one place. The quantity goes on the form, then into Excel, then onto the delivery note, then onto the invoice. Every copy is a chance for error. What we see most often: a job showing 200 in Excel, 180 on paper and 190 at shipment. Which is right? Nobody knows; usually the customer counts.

History cannot be searched. The answer to "how many minutes did this part take last year?" sits in a binder in the archive. Nobody checks it when quoting; the time is guessed from memory, and the quote is either too high or loses money.

Scrap is invisible. On a paper form, the "scrap" column either does not exist or is mostly left blank. At month end someone notices the gap between the raw material invoice and the parts shipped, but not why or on which job.

Excel depends on one person. When the person who keeps the file goes on leave, tracking stops. Three versions circulate by email, and the "which is the latest" debate never ends.

None of these alone will sink a shop. Together, they mean the manager spends most of the day answering "where, how many, when" questions, and decisions get made from memory.

6 steps to going digital

The most common mistake when going digital is trying to change everything at once. The order below moves forward without overwhelming the team and gets results from week one.

1. Start by listing machines and parts

Whatever software you use, you need two basic lists: machines and parts. The machine list is short and easy. The parts list is longer, but you need not enter the whole catalog on day one: parts with a work order in the last 3 months are enough, and the rest get added as they come up. This takes half a day and gives the team a first sense that "the system knows us".

2. Open work orders in one place only

From now on, new work orders are opened in one place only: the system. Paper does not disappear; a work order printed from the system goes to the machine. But the paper is now a copy, not the source. If it gets lost, the information is still there.

3. Have operators enter data at the machine

This step is the heart of the whole transition. Someone in the office typing up forms after the shift is not a digital process; it is an expensive copy of the paper one. When a job is finished, or at the end of the shift, the operator enters quantity, scrap and time on a phone or tablet at the machine. If an entry takes over 30 seconds, the screen is wrong; it should take a few taps.

4. Record downtime from the same place

Once production entry has settled in (usually in week two), add downtime recording: why the machine stopped, and for how long. Keep the reason list to 6 to 8 items; longer lists push people toward "other".

5. Record scrap with its reason

A scrap record should be more than a number: it needs a reason (out of tolerance, surface finish, broken tool, material defect, program error) and the work order it belongs to. By the end of month two, this becomes your first real data for reducing scrap rate.

6. Open the report on the same day every week

The point of collecting data is to look at it. Once a week, on a fixed day, open the production and downtime report by machine together with the team. At first it takes 10 minutes and the verdict is "data is missing"; that is normal. After week four, the meeting ends with one data-based decision, such as "this week we look at setup time."

Operator resistance

When going digital fails, the cause is usually people, not software. Operator resistance is real, and often justified:

• "They're going to watch me." Operators see data entry as performance monitoring. The answer is not hiding the data but sharing it with operators from month one. If 60% of downtime is waiting for material, that is a planning problem, not an operator problem, and once operators see that, they own the system.
• "It's a waste of time." They may be right. A 2-minute entry screen is acceptable in an 8-hour shift, but repeated 15 times a day it adds up to 30 minutes. Simplifying the screen is the software's job; "get used to it" is not a solution.
• "I can't use the phone." Less common, but it happens. The solution is a fixed tablet or a shared kiosk screen, not requiring every operator to use a phone.
• "The old way worked." The hardest one. The best approach is to involve your most experienced operator from week one and adjust the screen to their suggestions. Once they are convinced, the rest follow.

A warning: tying rewards or penalties to entries does not break resistance. In shops that "penalize" missing entries, the data fills up within a month and becomes meaningless; operators enter what is expected, not what happened.

The first 30 days: what happens

A realistic timeline:

Week	What you do	What you see
1	Machine and parts lists, first work orders in the system	Paper and system side by side; data incomplete
2	Operator entry starts, downtime recording added	60% to 70% of entries are made
3	Scrap recording, first weekly report meeting	First numbers are surprising; mostly due to missing data
4	Screen adjustments, chasing missing entries	Entry rate passes 90%; first real trend

After the first month you have a reliable habit, not perfect data. Each week you check how many numbers hold up; in month two you move on to derived figures such as OEE and scrap rate.

Three things save the first month: a single owner (one person running the transition), short screens, and never skipping the weekly meeting. Three things kill it: turning on every module in the same week, banning paper on day one, and using the first numbers to question people.

Related articles: Operator terminal: production tracking on a shop tablet, 7 ways to reduce scrap rate in a CNC machine shop, What is Spindeo? Production tracking for CNC machine shops.

Frequently asked questions

Do we have to get rid of paper completely?

No, at least not at first. The work order sheet stays at the machine alongside the drawing; the difference is that it is printed from the system and is no longer the source. Many shops drop paper on their own after a few months, because nobody looks at it.

Is this worth it for a small shop with 2 machines?

If you track fewer than 20 work orders a month and run a single shift, paper and Excel may be enough. Even so, part history (how many minutes each part took) makes a real difference when quoting, and it is hard to keep on paper. Starting with a free tool means the history is ready when you grow.

How is data completed if an operator does not enter it?

A missing entry shows up as a work order left "open" or a shift with no records, which beats paper because the gap is visible. In the first weeks, the shift supervisor closes out the open items at the end of the day. After a month, this work tapers off.

Which data pays off most to start with?

Production quantity and downtime. Within a month, these two reveal machine utilization, and in most shops that is where the biggest surprise appears: the machines are running far less than everyone thought. Scrap and cycle time data come second.

Spindeo's free Production Tracking plan covers the basic steps in this article (work orders, production entry from the operator terminal, downtime and scrap count recording) with no credit card and no time limit.