Why you shouldn't use a spreadsheet to track your handmade inventory
Thinking of setting up a spreadsheet to track your handmade inventory? Before you do, read this. Spreadsheets feel like the obvious choice — until they're not.
We get it. Spreadsheets feel like the obvious choice.
They’re free (or nearly free). You already know how to use one. And when you’re just starting out — a dozen SKUs, a handful of materials, orders trickling in — a tidy Excel file or Google Sheet feels like it’s more than enough.
But here’s the thing most spreadsheet tutorials for makers don’t tell you: the problem isn’t where you start. It’s where you end up. Spreadsheets don’t fail dramatically. They fail gradually, quietly — usually at the worst possible moment.
Need to get your raw material and product inventory under control?
Try Craftybase - the inventory and manufacturing solution for DTC sellers. Track raw materials and product stock levels (in real time!), COGS, shop floor assignment and much more.
It's your new production central.
Why Spreadsheets Feel Like a Good Idea at First
Let’s be fair about this. Spreadsheets have real advantages for a new maker business.
You control the format. You can add columns for whatever you care about — dye lots, fragrance suppliers, batch numbers. There’s no subscription fee, no onboarding, no learning curve. And for the first few months, the numbers actually stay manageable.
The trap is that this works well enough for just long enough. You tweak the formulas, add a new tab for 2024, link in your Etsy order totals manually. Before long you’ve got a system — it just happens to be a system that exists entirely inside your head, propped up by a spreadsheet that only you understand.
That’s the hidden cost. Not the spreadsheet itself. The mental overhead of maintaining it.
5 Ways Spreadsheets Fail Inventory-Tracking Makers
1. They’re not perpetual — so your stock numbers are always stale
The fundamental problem with a craft inventory spreadsheet is that it isn’t a perpetual system. Perpetual means your stock levels update automatically every time you sell something, use a material, or receive a supplier order. Spreadsheets don’t do that.
What you get instead: a snapshot. A number that was accurate when you typed it, and drifts further from reality every day you don’t update it. If you’re selling on Etsy and Shopify simultaneously, that drift can happen fast.
The result? You’re running physical stock counts more often than you should have to — and still not fully trusting the numbers.
2. COGS stays unknown until year end — and the surprise is never good
With a spreadsheet, your COGS (Cost of Goods Sold) figure isn’t known until you sit down and calculate it at year end. That means you’re flying blind for 12 months.
This matters more than most makers realise. If your cost of manufacture is higher than you assumed — because material prices crept up, or you forgot to account for packaging — your tax liability can be higher than expected. And you find out right when you can least afford surprises.
Tiana from Winding Wick Candles ran into this exact problem. Her spreadsheet tracked finished goods, but it couldn’t flag that she was double and triple ordering fragrances. She was making purchasing decisions based on numbers she thought were accurate — they weren’t. When she switched to automated inventory management, those ordering errors disappeared almost immediately.
3. Audit risk is real — spreadsheets don’t show their working
The IRS expects you to be able to document your material unit costs and show exactly how you arrived at them. They want to see that your calculations follow an accepted method — FIFO, LIFO, or Rolling Weighted Average.
A spreadsheet can contain these calculations. But can you prove the formula didn’t change between January and October? Can you show that a cell wasn’t accidentally edited? Probably not.
Auditable records require a log — something that timestamps every change, every transaction, every cost update. Spreadsheets weren’t built for that. If you’re ever targeted for an audit, “trust me, my formulas are right” is not a defence.
4. They don’t scale — and the migration costs more than you think
This is the one that catches most makers off guard. They know they’ll eventually need something better. What they don’t expect is how painful the switch will be after two or three years of spreadsheet data.
Robin from Messy Play Kits reached this point managing 24 multi-component kits. Excel simply wasn’t up to the job anymore — tracking which components went into which kit, at what cost, across which batches. The system that worked fine at 6 SKUs was actively making it harder to run the business at 24.
Jeff from Spade to Fork had a similar experience. His network of custom spreadsheets became unwieldy as his organic gardening supply business expanded across Amazon, Shopify, and Faire. Formula errors during critical growth phases weren’t just annoying — they were genuinely risky.
Kasia from Rustic Maka used spreadsheets until the growing complexity of SKUs and batch sizes for her natural body care business made them unworkable. She’s now been on Craftybase for over 10 years, managing inventory across Shopify, Square, Amazon, and Faire with a two-person team. And Martin from Miller Lights made the switch from pen-and-paper and Excel back in 2012 — and has been running his handcrafted lighting business across Shopify, Etsy, and Amazon ever since.
The pattern is consistent: spreadsheets fail at scale. And the later you switch, the more data entry the migration requires.
5. Tax time becomes a crisis you could have avoided
Put all of the above together, and what do you get? A brutal end-of-year crunch. Your COGS figure needs calculating from scratch. Your stock counts need reconciling. Your audit trail needs piecing together from multiple tabs and files.
All of this happens in January and February — the same window when you’re probably still recovering from the holiday rush, fielding late orders, and trying to get 1099s sorted.
This is entirely avoidable. The makers who have a smooth tax season aren’t necessarily more organised than you. They just made a different tool choice.
What a Perpetual Inventory System Actually Does
So what’s the alternative?
Perpetual inventory systems — Craftybase, QuickBooks Premier, and Unleashed are three options worth looking at for small DTC businesses — work by updating your stock levels and cost calculations in real time.
Every time you sell a product, the system deducts the materials used to make it. Every time you receive a supplier order, it updates your material costs. Every time you manufacture a batch, it records what went into it and at what price.
The result is a running ledger that’s accurate right now — not as of your last physical count.
Here’s what that unlocks:
- Visible COGS throughout the year. Not a surprise at year end. You can see your cost of goods month by month, spot when material prices are eating into margins, and adjust pricing before the damage compounds.
- Low stock alerts. No more discovering mid-order that you’re out of a key material. Set a threshold; the system tells you when to reorder.
- Auditable records. Every transaction is timestamped and logged. If the IRS asks, you can show exactly how you calculated every unit cost — and exactly when.
- Cycle counts instead of full stock takes. Instead of counting everything once a year, you count a portion of inventory regularly throughout the year. Much less painful, much more accurate.
The year-end process becomes generating a report, not an archaeological dig through spreadsheets.
Spreadsheet vs. Craftybase — Side by Side
| Feature | Spreadsheet | Craftybase |
|---|---|---|
| Real-time stock tracking | No — manual updates only | Yes — updates on every sale and manufacture |
| COGS calculation | Manual, year-end only | Automatic, visible year-round |
| Auditable records | No version history | Full transaction log |
| Multi-channel sync (Etsy, Shopify, Amazon) | No | Yes — automatic nightly sync |
| Low stock alerts | No | Yes — configurable per material |
| Year-end reports | Manual calculation | One-click export |
When to Know You’ve Outgrown Your Spreadsheet
There’s no single moment. But here are the signs that usually show up first:
- You’ve added a second tab (or a third) and the structure is starting to feel fragile
- You sell on more than one channel and reconciling them is its own weekly task
- You’ve had at least one stockout or over-order that cost you money
- You’re not entirely sure your COGS figure is right
- You’ve caught a formula error — or you’re worried you might have missed one
- Tax season involves more dread than it used to
- You’ve hired someone (or you want to) and onboarding them to your spreadsheet sounds exhausting
- You’re approaching the 100-SKU mark, or you’re working with components and recipes
If more than three of those apply, you’re past the point where a spreadsheet is serving you. You’re at the point where it’s costing you.
The best Etsy inventory spreadsheets can still be a good starting point when you’re very early stage — but they’re a starting point, not a long-term system.
Frequently Asked Questions
Can I use a spreadsheet for handmade inventory management?
Yes — at the very start. A spreadsheet works fine when you have a handful of SKUs and materials and you're still figuring out your product line. The problem is that spreadsheets aren't perpetual systems: they don't update automatically when you sell, manufacture, or reorder. Once you're managing recipes, multi-channel sales, or 50+ materials, a spreadsheet starts costing you more time than it saves.
What is a perpetual inventory system and how does it work?
A perpetual inventory system updates your stock levels and material costs in real time — every sale, manufacture run, and supplier order is logged automatically. Instead of a static snapshot that drifts out of date, you always have a current picture of what you have on hand and what it cost. Craftybase uses a rolling average calculation to keep material unit costs accurate throughout the year, so your COGS is always visible — not just at year end.
How do I calculate COGS if I use a spreadsheet?
COGS in a spreadsheet is calculated as: beginning inventory + purchases − ending inventory. You'll need accurate opening and closing stock counts, and you'll need to assign costs using an accepted method — FIFO, LIFO, or weighted average. The catch is that this only gives you a number once per year, and getting it wrong (or being unable to document your method to the IRS) can mean penalties. Craftybase calculates COGS automatically, year-round, with a full audit trail.
When should I switch from a spreadsheet to inventory software?
The clearest signals: you're selling on more than one channel, you've had a stockout or over-order that cost you money, you're unsure whether your COGS figure is accurate, or tax season has started feeling like a crisis. Most makers wait too long — switching is harder once you have years of spreadsheet data to migrate. Earlier is almost always better, even if your current system "kind of works."
Does Craftybase work with Etsy and Shopify?
Yes. Craftybase syncs automatically with Etsy, Shopify, Amazon, Square, and Faire — pulling in orders nightly so your inventory and COGS stay current without manual data entry. Makers who switch often say this is what they notice first: instead of copying order totals from one platform to another by hand, the numbers flow in automatically and your stock levels update accordingly.
