Skip to content

WIP Tracking Excel Template: What's Started and Stuck

A free WIP tracking Excel template: every unfinished batch with its stage, days in stage, days allowed, a stuck flag, and the materials tied up in it.

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 20, 2026 · 6 min read

Work in progress is everything you've started and can't sell yet: sauce fermenting, soap curing, bottles waiting for labels. A WIP tracker has one row for each unfinished batch, with its stage, the date it entered that stage, and the days that stage should take. From those it works out days in stage and raises a flag when a batch has been sitting longer than it should. It also carries the materials tied up in each batch, because WIP is money you've spent and can't yet get back. The flag is the reason to keep it. Batches don't fail loudly. They stall, behind a missing label or a full shelf, and the tracker is how you notice on day four and not day eleven. Below is a tracker for a made-up hot sauce maker, and the file.

The short version

  • One row for each batch that's started and not finished.
  • A stage, the date it got there, and the days that stage should take.
  • Flag anything over its days. Ask what it's waiting for.
  • Add up the materials in WIP. It's cash on a shelf.
  • Delete the row when the batch becomes finished goods.
  • TaroStack keeps each stage as a batch, with what it used and what it cost. More below.

A tracker

A made-up hot sauce maker, as of November 20.

Batch Product Stage Entered Allowed In stage In all Stuck? Materials so far
HS-1028 Habanero, 60 L Fermenting Oct 28 30 23 23 OK $214
HS-1104 Jalapeño, 60 L Fermenting Nov 4 30 16 16 OK $168
HS-1014 Habanero, 58 L Blended, resting Nov 12 7 8 37 STUCK $231
HS-1007 Garlic chili, 380 bottles Bottled, no labels Nov 9 3 11 44 STUCK $612
HS-0930 Habanero, 372 bottles Labeled, to case Nov 18 3 2 51 OK $655

Five batches, $1,880 of materials in progress, two stuck.

What the flags found

HS-1007: eleven days without labels. The stage should take three. The note says the labels are being reprinted and are due on the 21st. Meanwhile $612 of sauce and glass is finished in every way but one, and the order it was meant for was due on the 17th. The fix isn't in production. It's ordering labels when the batch starts, not when it's bottled.

HS-1014: one day over. Blended on the 12th, pH checked, and waiting for bottles to arrive. One day over a seven-day rest isn't a crisis. It's flagged so someone asks, and the answer (bottles on the truck) is written in the notes.

The two fermenting batches aren't flagged, at 23 and 16 days, because fermenting is allowed 30. That's why the days allowed sit on each row. One limit for every stage would either cry wolf about every ferment or never notice the labels.

Stages

Write down your stages once, in order, with how long each should take.

Stage Should take What ends it
Fermenting About 28 days pH at target
Blended, resting Up to 7 days Bottles and a free bottling day
Bottled, no labels Up to 3 days Labels on
Labeled, to case Up to 3 days Cased, counted, into finished stock

Four is plenty. The test of a stage is that something has to arrive or be decided before the batch can leave it. "Waiting" stages are the useful ones, because that's where batches get stuck. A soap maker's would be poured, curing, trimmed, wrapped. A potter's are greenware, bisque, glazed: see pottery inventory tracker.

The money column

Materials so far is what's gone into the batch at cost: peppers, salt and vinegar at first, then bottles and caps, then labels. It climbs as the batch moves.

In ferment $382
Blended $231
Bottled and labeled, not yet in finished stock $1,267
Work in progress $1,880

Two-thirds of the money is in batches that are almost done. That's usual, and it's why the last stages matter most: a delay there holds up the most cash and is closest to a customer. For the books, WIP is its own line between raw materials and finished goods. The accounting sum is in work in process inventory formula.

Using it

Update it when a batch moves, not on a schedule: change the stage, the date and the days allowed. Type today's date on the Limits sheet when you open it, and the days recount. Read the stuck column every morning. It takes ten seconds, and it's the list of things to chase.

When a batch is cased and counted, delete its row. A tracker full of finished batches is a history, and nobody reads those. The plan that decides what to start next is in production schedule example, and the cost of a batch in batch cost calculator.

Get the template

Download the WIP tracking template. Two sheets and a read-me: the tracker, where days in stage, days in all and the stuck flag work themselves out, and a Limits sheet where you type today's date. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

The tracker is one more thing to update, by hand, at the moment a batch moves, which is the moment everyone is busy. And "materials so far" is a figure someone has to work out. So the stages lag by a few days, the money column is last week's, and the two numbers an owner most wants (what's stuck, and how much is tied up) are the two least likely to be current.

How TaroStack does it

TaroStack tracks the batch because the batch is how the work is recorded.

A production order has a status: planned, approved, started, completed. Recording the batch takes the ingredients from stock, from the lots you used.

Steps as batches. Ferment, blend and bottle can each be a recipe that uses the one before, so the sauce shows as fermenting stock, then blended stock, then bottles.

What it's waiting for. "What could I make right now" says whether the bottles, caps and labels for the next step are on the shelf, before the batch is ready for them.

The cost so far is the batch's own. Each step is costed from what it used, so the value of what's in progress isn't worked out by hand.

Alerts for production orders that are due, and for plans that will fall short.

The job WIP tracker In TaroStack
Which stage is it in Typed when someone remembers Stock of each stage: fermenting, blended, bottled
Stuck for lack of labels Found on day eleven What could I make right now, on day one
Materials tied up Worked out by hand The cost of each batch
What's due A date column An alert

Recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes); planning is on Growth. 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

How do you track work in progress?

List every batch that's been started and isn't finished, with its stage, the date it entered that stage, and how long the stage should take. Flag any that run over.

What counts as WIP inventory?

Anything you've started making that can't be sold yet: a ferment, a cure, bottled product waiting for labels.

How do you value work in progress?

At what has gone into it so far: materials at cost, plus labor and overhead if your books add them. Ask your accountant how yours are set up.

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.