Why You Should Track Your Pottery Output

I used to keep all my production data in my head. That stopped working about three years ago when I had six kiln loads in progress simultaneously, missed a client order because I forgot which glaze batch it was in, and fired new greenware into a kiln that still had wet clay from the previous load. The cost was roughly $400 in lost materials and two unhappy customers. I bought a spreadsheet and never looked back. A pottery tracker is simply a system — digital or otherwise — that logs your production cycles, inventory movements, kiln firings, order status, and material usage. The Top 10 Pottery Tracker approaches each of these categories with a specific workflow, and the difference between a functional tracker and one you abandon after two weeks usually comes down to how much friction you build into the data entry itself.

What Actually Makes a Pottery Tracker Useful

Most free tools on the market are built by people who don't fire their own clay. They create fields for things like "glaze batch number" and "client email" without understanding that a potter needs to see at a glance whether a piece is wedged, dried, bisqued, glazed, or fired. The most useful trackers force you to think about the actual sequence of a piece's life, not just record-keeping for its own sake. The core fields I track for every piece are: date received or started, clay body, form or category, current stage, kiln load number, firing schedule (cone and duration), glaze applied, and expected ready date. That's it. When I started using my current setup, data entry took about 45 seconds per piece. If you're building your own tracker and find yourself spending more than two minutes entering data, you've added unnecessary fields.

My Recommended Structure for a Pottery Tracker

Start with a master inventory sheet that lists every piece currently in your studio, regardless of who it belongs to. Use color coding for stage status — green for bisqued and waiting for glaze, yellow for glazed and waiting for firing, red for fired and ready for pickup. This is a visual system that works even when you're standing in front of a shelf and can't think about spreadsheets. Next, maintain a separate kiln log. This is where most trackers fail. People put the kiln info in the same sheet as the piece inventory. When you have multiple firings per week, those two datasets diverge and you end up cross-referencing two different tabs constantly. The kiln log should capture: date, maximum temperature reached, atmosphere (oxidation or reduction), kiln shelf positions, any problems encountered, and total elapsed time from start to cool-down. I once had a kiln thermocouple fail mid-fire and only caught it because my log showed the temperature plateauing at cone 04 when it should have been climbing through cone 6. That log entry saved me an entire shelf of work. A third sheet — and this one is optional but recommended — tracks your glaze inventory by batch. Record the base recipe, water-to-glaze ratio, buckets used, and any observations about how it performed on test tiles. Glazes change. A batch that worked perfectly in March might run different in October because your clay body or water source shifted. Writing down what you actually did, not what you remember doing, prevents you from blaming a glaze recipe when the problem is the water.

Get the Full Details

Pottery Inventory Tracker Google Sheet, Pottery Business Inventory Management Excel Spreadsheet ...
Pottery Inventory Tracker Google Sheet, Pottery Business Inventory Management Excel Spreadsheet ...

Common Mistakes That Kill a Tracker System

The biggest mistake is building a tracker that requires too many clicks or taps to update. I've seen potters invest in $200 subscription software only to stop using it within a month because logging a single piece required filling out twelve fields. Your tracker should be something you can update with your phone while standing next to a wheel, not something you sit down at your desk to fill out properly. Another mistake is tracking everything but nothing actionable. Recording that a piece is "in progress" tells you absolutely nothing. Use specific stage names: wedged, thrown, leather hard, trimmed, bone dry, bisqued, glosted, fired. These are universally understood terms in the studio. If someone else needs to cover for you, they should be able to read your tracker and immediately understand where everything is. I also recommend against tracking glaze measurements in fractions unless you have a digital scale that reads in fractions. I used to write "1/3 cup soda ash" and then spent twenty minutes one morning trying to figure out whether I meant 1/3 US cup or 1/3 UK cup. Now I use grams exclusively. It's slower at first, maybe three extra seconds per ingredient, but it eliminates an entire category of error.

Free Tools That Actually Work

Google Sheets is the most common recommendation and for good reason. You can build a functional tracker in about an hour, share it across devices, and automate notifications. Set up conditional formatting so that when a piece reaches the "fired" status, the row turns green and you get a calendar notification for the pickup date. I use this approach with a companion Google Calendar event for each piece, so I never have to open the tracker to know when something is ready. Notion is another option if you prefer a more visual interface. The downside is that Notion loads slowly on mobile, which defeats the purpose of quick updates in the studio. I tried it for three months and switched back to Sheets because the latency made me forget to log entries mid-process. If you want something that doesn't require any setup at all, a simple printed notebook with a grid layout works fine for small studios. I know that sounds absurd, but I've run successful studios with nothing more than a spiral-bound notebook and a pen. The advantage is that there is no login screen, no battery concern, and no interface to break. The disadvantage is that searching for a specific piece three months later requires flipping through pages manually.

Advanced: What Serious Studios Do Differently

Once you're moving beyond hobby-level output, the tracker becomes a business tool. At that point, you start adding columns for cost of goods — clay, glaze materials, electricity per firing, packaging — and revenue per piece. This is where the tracker stops being about organization and starts being about profitability. I discovered that my most popular mugs were actually losing money because I hadn't accounted for the glaze waste from the dipping process. The tracker made it visible. That insight changed my pricing within a week. Studio managers sometimes integrate their tracker with their online store or point-of-sale system. This is overkill for most potters but makes sense if you're running a full production studio with five or more people. The key is making sure the two systems talk to each other automatically. I once spent two days manually updating both a Salesforce CRM and a separate inventory tracker because they weren't connected. Never again. Whatever system you choose, ensure it's either a single source of truth or has API-level integration from day one. The bottom line is that the tool matters less than the habit. A $15/month software subscription you don't use is worse than a cheap free tool you check every single day. Start simple, add complexity only when you feel the friction, and write down everything that goes wrong so you can fix the process instead of just the symptom.

Pottery Inventory Sheet Printable PDF, Ceramic Studio Inventory Tracker, Handmade Pottery Log ...
Pottery Inventory Sheet Printable PDF, Ceramic Studio Inventory Tracker, Handmade Pottery Log ...