How to Build a Worksheet For Pottery Monthly That Actually Works
Most studio spreadsheets look good on paper and fall apart the second you try to use them. I spent three years tracking clay, glaze, firing logs, and inventory across two kilns before I figured out what actually moves the needle. The trick isn't complexity. It's making sure every row you fill out ties directly to something you'll need to answer at the end of the month — whether that's "how much did this batch actually cost" or "why did the reduction firing misfire again." Here's the structure I use and why each column earned its place.
Core Columns for a Worksheet For Pottery Monthly
Week/Date Range — Use actual dates, not "Week 1." When a kiln cycle runs overnight into Tuesday, you need to know which month it hits. Project Name / Client Order # — This is your anchor. One project can span throwing, drying, bisque, glazing, and final firing across different weeks. If you don't tag it at the top and carry the tag through every row, the numbers will contradict themselves by month-end. Clay Type & Weight (lb) — Record the raw weight, not the finished weight. Shrinkage varies by clay body and hydration level, and the difference matters when you're pricing per piece. I once underreported my stoneware usage by about 14% because I was logging greenware weight instead of the starting slug. Took me two months to catch it by cross-referencing supplier invoices against my log.
Throwing Time (min) — This one gets ignored until someone asks "where is my hourly rate going?" If you're wheel-throwing centering and pulling at roughly eight minutes per standard vase, that number compounds fast. Track it once and you'll spot inefficiency in real time. Kiln Load ID — Every kiln loading needs a unique ID. Kiln #1 load A, B, C across the month is clearer than "Tuesday night firing" because you'll forget which Tuesday. When a kiln shelf collapses or a piece sticks to another, you'll know exactly which load group was affected. Bisque / Glaze Fire Settings — Cone number, ramp rate, hold time, and atmosphere. I keep this as a combined field like "Cone 06 | 150/hr | 30 min hold | oxidation" because the four variables move together. If you separate them into four columns, you'll either leave two blank or forget why you split them.
Get the Full Details
Glaze Batch ID — Not just the name. "Shino D" is meaningless three months from now. Use the batch number from your mixing log so a glaze failure can be traced back to a specific pour, not a recipe that was adjusted mid-week. Pieces Loaded / Pieces Successful — Record both. Yield percentage is your silent profit driver. A bisque firing that loses 18% of pieces to thermal shock is a different problem than one that loses 3% to glaze running — and the fix is different too. I track the rejection reason in a short code: TS for thermal shock, GR for glaze run, CS for cooling crack, ST for sticking. Finished Piece Count — This is the number that feeds your pricing model. Everything else supports it.
Cost Inputs — Clay cost, electricity for that specific load (kiln amps × hours × your rate), glaze cost per piece (batch cost divided by yield), and any subcontracted work. Separate them if you want accuracy, combine them if you want speed. Most small studios combine clay and glaze into a single material cost per piece and move on. That's fine as long as you update the blended rate quarterly when raw materials shift.
How I Handle Kiln Scheduling Conflicts
Here's the problem most people hit by week three: your worksheet shows six loads pending and your kiln can only fit four. The solution isn't a second kiln. It's adding a Priority Flag column with three values — A for customer deadlines, B for stock pieces, C for experimental work. When the schedule collides, you move C out and rearrange B to balance the load. Simple, but it stops the weekend scramble. I also add a Notes column that stays short. One line per row. "Shelf 3 wobble noted" or "Glaze batch mixed 10/12 not 10/05." These notes don't look like much month-to-month, but when you're debugging a consistent pinhole issue in November, the October note about that batch mix-up is the only thing that points at the real cause.
Monthly Roll-Up Formula Structure
At the bottom of your sheet, build a summary section with these rows: Link each summary cell to a SUMIF or FILTER formula that pulls from your weekly rows. Don't retype numbers from the log. A single typo in a summary row ruins the whole month's reconciliation. I learned that after a supplier raised clay prices by $0.40 per pound and my summary still reflected last quarter's rate. Caught it when my margin dropped to negative on a mid-tier vase order I should have priced higher. The biggest mistake is making the log too detailed too early. If every row requires ten columns to fill out, you'll skip weeks. Start with the core set above, then add columns only when you notice a pattern you can't explain. The second mistake is not backing up the file weekly. I keep a copy on an external drive and a cloud folder. One power surge took out my primary spreadsheet last spring, and I had three months of firing data recoverable because I'd been lazy about backups.
A third mistake is ignoring raw material expiry. Some glazes and slip recipes separate or crystallize after ninety days. If your worksheet doesn't include a Material Expiry column tied to the batch ID, you'll be surprised when a glaze that looked fine produces crawling on the bisque test tile.
File Format and Sharing
Use Google Sheets or Excel with protected summary sheets. Let assistants or studio helpers fill in daily rows without touching the formulas. Lock the roll-up section with a password. This keeps the math honest even when someone accidentally deletes a SUMIF range. If you share the file across a team, set up view-only access for anyone who needs the summary and edit-only access for the people actually doing the throwing and firing. I used to give everyone full edit rights. The result was a spreadsheet that looked clean but contained contradictory numbers from three different people editing the same cell at the same time.
When to Switch Tools
A spreadsheet works well up to about eight hundred pieces per month or two kilns running staggered schedules. Beyond that, the manual entry burden starts eating into production time. At that scale, you'd want an inventory management system with barcode scanning and automated kiln load tracking. But most pottery studios never hit that threshold, and the spreadsheet approach remains the fastest way to get usable cost data without learning a new platform. The worksheet below captures the essential structure. Copy it into your preferred sheet tool and adjust the column widths to fit your studio's cadence. Add rows for additional glaze types or subcontracted services as needed. Keep the summary section linked, not retyped, and review the monthly roll-up before you close the books each quarter. Download the base template here: Worksheet For Pottery Monthly Template
If your studio runs multiple kilns with different schedules, consider building a separate kiln log tab and linking it to the main monthly sheet with the Kiln Load ID. That keeps the firing details readable without cluttering the production overview. Most problems I see in pottery studio accounting trace back to a single missing link between the kiln log and the cost summary. Fix that link and the rest of the worksheet usually falls into place.
