Skip to content

Pottery Inventory Tracker: Clay, Glaze and Pots in Progress

A free pottery inventory tracker for a studio: clay and glaze on hand, pots counted at each stage from greenware to finished, firing losses, seconds, a file.

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

A pot takes two or three weeks and two firings to become stock, and it can be lost at every step. So a pottery inventory tracker counts more than clay and finished mugs. It counts pots at each stage: greenware drying on the rack, bisque waiting for glaze, finished firsts on the shelf, and seconds in a bin. That middle of the sheet is what tells you whether a 60-mug order can ship next week or next month. Clay by the box, mixed glaze by the gallon, kiln supplies and packaging fill out the rest, and the Lots sheet records clay deliveries, glaze batches and firings. Below is a sheet for a made-up studio, and the file.

The short version

  • Clay by the box, glaze by the gallon, with reorder points.
  • Pots counted at each stage: greenware, bisque, finished.
  • Firsts and seconds on separate rows. Only firsts fill a wholesale order.
  • Each kiln firing is a lot: what went in, what came out, what was lost.
  • Note which glaze batch went on which firing.
  • TaroStack records each stage as a batch and shows what the pipeline holds. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Stoneware clay, 50 lb box box 14 10 $28.00 $392.00 OK
Glaze, celadon, mixed gal 1.5 2 $16.50 $24.75 REORDER
Mugs: greenware each 46 0 $1.60 $73.60 OK
Mugs: bisque each 38 0 $2.40 $91.20 OK
Mugs: finished, firsts each 52 40 $4.10 $213.20 OK
Mugs: finished, seconds each 7 0 $4.10 $28.70 OK

Twelve rows in all, $1,080.55 of stock, with celadon glaze and finished bowls to reorder, which for bowls means throw more.

The pipeline

Stage Mugs Ready to sell
Finished, firsts 52 Now
Bisque, waiting for glaze 38 After the next glaze firing: about a week
Greenware, drying 46 After bisque and glaze: about three weeks
In the pipeline 136

The shop wants 60 mugs. There are 52 firsts. The other eight are sitting in the bisque row, and they need a glaze firing, so the honest answer is "a week from Friday". Without the middle rows, the answer would have been a guess or a no.

The costs climb by stage because each one adds something: clay and time at greenware, a firing at bisque, glaze and a second firing at finished. Count work in progress at what it has cost so far, not at the finished price.

Firings are lots, and losses are numbers

Date Firing In Firsts Seconds Lost
Nov 6 Bisque firing 41 40 mugs 38 2 cracked
Nov 13 Glaze firing 28 33 mugs 30 3 (pinholes)

Of 40 mugs into the bisque, 38 survived. Of 33 into the glaze firing, 30 came out as firsts. Across both firings that's about 86% of what was thrown ending up as a first. So an order for 60 firsts means throwing about 70.

Three seconds with pinholes went into the seconds bin for the studio sale. The firing's note names the glaze: celadon batch GZ-1102. If the next firing with that batch pinholes as well, the glaze is the suspect, and the lot is how you'd know. Mixing and recording a glaze batch is in glaze batch calculator.

Clay

Fourteen boxes is 700 lb, plus 85 lb of reclaim. A mug starts as about a pound of clay, so that's several hundred mugs before trimmings come back around. The clay lot matters less for tracing than for feel: this studio notes the date the clay was pugged, because a box from the back of the stack that's sat six months throws stiffer than a fresh one. Oldest first, here too.

Seconds

Seconds are real stock with a real price, usually half. Keep them on their own row so two things don't happen: a second going out in a wholesale box, and the firsts count looking healthier than it is. Pricing both is in how to price pottery, and stock for a market day in craft fair inventory sheet.

Get the tracker

Download the pottery inventory tracker. Four sheets: inventory with value and REORDER, lots for clay, glaze batches and firings, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. The year's sums for a studio are in pottery business plan.

Where this stops working

Every firing moves pots from one row to the next, less the ones that cracked. That's three rows to change each time, and a kiln unload is not when anyone wants to open a laptop. After a month the stage rows are fiction, and the pipeline that made the sheet useful is the first thing to go.

How TaroStack does it

TaroStack records each stage as something you make from the stage before.

Each stage is a recipe. Greenware from clay. Bisque from greenware. Finished from bisque and glaze. Recipes can contain other recipes, so a finished mug's record leads back through its firings to the clay.

A firing is a batch. Record 40 in and 38 good out, and the greenware comes off and the bisque goes on. The loss is on the record, and the batch is costed on the good pots.

Glaze batches are lots. Use one in a firing and the batch record notes it automatically.

"What could I make right now" says how many finished mugs the bisque and glaze on hand allow.

Recipe truth. From your own firings, TaroStack shows what share really comes out good.

The job Spreadsheet In TaroStack
Move pots between stages Three rows by hand Recorded with the firing
Firing losses over time Add up notes Recipe truth
Which glaze batch was on these A note On the batch record
Mugs ready next week Read the bisque row What could I make right now

Stock, lots, recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). A mug with three stages uses three recipes, so a studio with several forms will want the 50. 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 keep track of pottery inventory?

Count clay and glaze as materials, and count pots at each stage: greenware, bisque and finished, with firsts and seconds apart.

How many pots are lost in firing?

It varies by studio, clay and kiln. In the example, about 86% of mugs thrown came out as firsts after both firings. Record your own for a few months.

Should seconds be counted in inventory?

Yes, on their own row. They have a value, and keeping them apart stops them being promised to a wholesale order.

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.