Skip to content

Production Tracking Board: Batches, Stages, Blocks

A production tracking board for a small maker: one row for each batch, the stage it's at, how much is done, what's blocking it, and a free spreadsheet.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A production tracking board is the one place that shows every batch in the building and where it stands. It can be a whiteboard by the door or a spreadsheet on a screen. Either way it has a row for each batch, and each row says what it is, how many were planned, which stage it's at, when it's due, and, if it has stopped, what it's waiting for. A schedule says what should happen this week. A board says what is happening now, and its whole value is in the rows that aren't moving. Below is a board for a made-up granola maker, how to choose stages, the rules that keep a board honest, and the file.

The short version

  • One row for each batch that's waiting, in work or just finished.
  • A few stages, named after real steps on your floor.
  • A due date on every row.
  • "Blocked" is a stage, and it always comes with a reason.
  • The person who moves the batch moves the row.
  • Clear finished rows at the end of the day.
  • TaroStack shows each batch's state from its record. More below.

An example board

November 20, mid-morning.

Batch Product Planned Stage Due Done Status Note
B-1117 Energy bites 600 Done Nov 19 100% DONE
B-1118 Granola, honey almond 480 Packing Nov 20 75% IN WORK
B-1119 Granola, maple pecan 320 Baking Nov 21 0% IN WORK
B-1120 Trail mix 240 Blocked Nov 21 0% BLOCKED Bags not delivered. Supplier says the 21st, in the morning
B-1121 Granola bars 400 Queued Nov 23 0% QUEUED

Five rows tell the day. Honey almond is three quarters packed, 360 of 480 bags, and due today. Maple pecan is in the ovens. The bars haven't started and don't need to yet.

The row that matters is B-1120. The trail mix is mixed and can't be bagged, because the bags haven't come. On the board, that's visible to everyone who walks past, including the person who can phone the supplier. Off the board, it's a tub on a rack that each person assumes someone else is dealing with.

Choosing stages

Stage What it means Who moves the batch on
Queued Planned, not started. Materials checked Planner
Mixing Weighed and mixed. Lots written on the batch sheet Mixer
Baking In the ovens or cooling on racks Baker
Packing Being bagged, sealed, labeled and cased Packer
Blocked Stopped, waiting for something named in the note Whoever stopped it
Done Counted, lot coded and put away Packer

These are this maker's stages. Yours are the steps a batch really passes through, where it changes hands or changes place. Four to six is plenty. A stage nobody can see the start or end of, such as "in progress", tells you nothing.

"Queued" means ready. This maker doesn't put a batch on the board until its materials have been checked. If it had done that check for the trail mix on the 19th, the bags would have been chased a day sooner. What to check is in MRP spreadsheet template.

Rules that keep it honest

  1. The person who moves the batch moves the row. A board kept by a manager from memory is a day behind.
  2. A blocked row names what it's waiting for and who is chasing it.
  3. Every row has a due date, so a batch that's merely slow shows up too.
  4. Done rows come off at the end of the day, after someone has checked the count and the lot code.
  5. Look at it together once a day. Five minutes at the board each morning, starting with the blocked rows.

A whiteboard or a spreadsheet?

A whiteboard wins on the floor: everyone sees it without opening anything, and a marker is faster than a laptop with floury hands. A spreadsheet wins when someone who isn't on the floor needs to know, when you want to see what was blocked last month and why, or when the floor is two rooms. This maker uses both: the board on the wall, and a typed copy at the end of the day.

A board shows today. How long each batch has sat in its stage, and the money tied up in it, is a different sheet: see WIP tracking Excel template. Cards that travel with the work are in kanban card template. The day's output and rejects go on a production report template, and the week's plan on a production schedule Gantt chart.

Get the board

Download the production tracking board. Two sheets and a read-me: a board that works out how much of each batch is done and marks a blocked one, and a list of stages to change to your own. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

A board knows a batch's stage because someone told it. It doesn't know that B-1120 can't be packed until that person finds out and writes it up. It can't say which lots of oats went into B-1118, or whether there are almonds for tomorrow's batch. It's a picture of the floor, kept by hand, and it's only as current as the last person who touched it.

How TaroStack does it

In TaroStack a batch's state comes from its own record.

Each batch is a record that is planned, started and finished, so what's waiting and what's in work is a list you don't have to keep.

"What could I make right now" says which batches the materials on hand will cover, before one is started.

Planning, on Growth, names what will run short or arrive too late, in plain words, days ahead.

The batch notes the lots it used, automatically, and your own checks are fields on its record.

Barcodes by phone camera or scanner for recording a batch on the floor.

The question Whiteboard In TaroStack
What's in work now Read the board The batches that are started
Can tomorrow's batch be made Find out tomorrow What could I make right now
What will run short this week Unknown Planning, on Growth
Which lots went into B-1118 The batch sheet, if it's filled in On the batch record

TaroStack doesn't replace a board on the wall for a crew that likes one. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes, with planning). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What is a production tracking board?

A board, on a wall or in a spreadsheet, with a row for each batch showing its stage, how much is done, when it's due and what, if anything, is stopping it.

What should a production board show?

The batch, the product, the quantity planned, the stage, the due date, the amount done and a note for anything blocked. Keep the stages few, and name them after real steps.

How is a production board different from a schedule?

A schedule is the plan for the week. A board is the state of the floor right now. The board shows where the plan has stopped, and why.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.