Free Job Card & Production Plan Excel Template

If you run a machine shop or a component plant, the job card is the one piece of paper the floor actually lives by. It says what to make, how many, by when, which operations and machines the part goes through — and it comes back at the end of the shift showing what was really produced, and what was rejected. This free template gives you that job card and a simple production plan in one clean Excel sheet, so you can stop scribbling on a printout and start with a format that adds up.

We built it the way a real shop uses it. There is a bold, bordered header row that stays frozen while you scroll, one clearly-marked sample row you delete before you start, and thirteen columns that cover the full life of a work order — from the day you release it to the count of good and reject pieces at the last operation. It is a standard business format, not fabricated data, so you can hand it to a supervisor and they will know exactly what to write where.

What a job card and a production plan actually do

People use the two words loosely, so it is worth being clear, because this sheet does both.

A production plan is the forward view: across all the orders on your books, what are we making, how much, and by when. It sets the sequence and the target so the floor is not guessing at the start of the day. A job card is the execution of one of those orders — the shop-floor packet for a single work order. It carries the part, the quantity and the due date at the top, then a row for each operation on the route, and against each operation it captures the planned quantity and what actually came off the machine: good pieces, reject pieces, and who ran it.

Put together, the plan tells the floor what should happen and the job card records what did. When the two sit on the same sheet — as they do here — you can see at a glance whether an order is on track, where pieces are being lost to rejection, and which operation or machine is the bottleneck. That is the whole point of writing it down instead of carrying it in your head.

Every column in the template, explained

Thirteen columns, each with a job. Fill the top five once per work order, then add a row per operation for the rest.

Good and Reject are kept separate on purpose. A single "actual" total hides your yield; splitting good from reject at each operation shows exactly where pieces are being lost, which is the first thing you need before you can cut your rejection rate.

How to use it in six steps

Keep one file per work order, or one sheet per week — whatever your team can keep tidy. The template does not lock you into either; it just gives everyone the same columns so the numbers reconcile when you add them up.

When the spreadsheet stops being enough

Be honest about where a spreadsheet job card runs out of road — it is usually the same four places for every shop:

• Many orders at once. One file is fine; twenty live work orders across three shifts is a version-control nightmare, and the "latest" file is never the one on the floor.
• Material never reconciles with stock. The job card says you consumed material, but the store's stock does not move with it, so you find shortages only when a machine stops.
• Rejection and rework get lost. A reject noted in a cell rarely becomes a traceable action — you cannot easily show which lot, which operation and which operator, or whether the reworked pieces made it back.
• No audit trail. When a customer asks how a batch was made, a spreadsheet cannot show who changed what and when.

None of this means the template is wrong — it means you have outgrown it. The next step is software that keeps the same simple idea (a job card per work order) but makes every number live and traceable.

How Fast Production turns this job card live

Fast Production is shop-floor manufacturing execution software built for Indian discrete manufacturers and job shops. It keeps the exact idea behind this template and removes the re-keying:

• A work order is raised against a released Bill of Materials — the same header you fill at the top of the sheet, now driving the whole order.
• Material is reserved and issued to that order straight from stock, so what the floor consumes and what the store shows always agree.
• Operators book good and reject at each operation against the machine and the operator — the same Good/Reject columns, captured live as work-in-progress.
• Line rejection and rework are booked to the work order, so a rejected piece is traced, reworked and either salvaged to finished goods or scrapped — never lost in a cell.
• Finished goods transfer back into inventory automatically, ready to dispatch, with the full history behind them for any customer or quality audit.

It runs on its own or alongside the rest of the Fast Suite, and it integrates with your existing systems including Tally, so accounts keep running where they are while production moves onto the floor properly. If you also need deeper demand and material planning, production planning software hands work orders straight into it.

Job card & production plan template — FAQ

Next steps