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.
