Materials and finished stock counted in one workbook, instead of remembered across six boxes and a shelf you haven't looked at since Tuesday. This Etsy inventory tracker keeps both numbers in the same place, so what you can sell today is something you read rather than something you guess. You put in a count; the totals and the availability picture follow.
| Item | SKU | In stock | Reorder at |
|---|---|---|---|
| Mug 11oz | A-101 | 142 | 40 |
| Tote bag | A-102 | 67 | 25 |
Illustrative example — the workbook itself is a clean spreadsheet.
This shelf is a picture of the idea, not the product: change the order quantity on the ticket, or the counts on the hang-tags, and watch the verdict ribbon answer. In the workbook itself, the same counts are kept for real — materials and finished stock in one file, with the formulas built in.
An order comes in for four of your best-selling item and you have three. Or you spend an evening driving to the supplier for more kraft card, get home, and find a full unopened pack behind the printer. Neither of these is a business problem — they're what happens when stock lives in boxes and memory rather than in a place that adds things up. And it's a strange kind of tired, because you did the work twice: once when you bought the materials, once when you went looking for them.
The first time it costs you a sale. The second time it costs you an evening and a bit of your confidence in your own shop. Meanwhile the things you're genuinely low on are invisible, because the only signal you have is a vague feeling that the shelf looks emptier than it did.
This Etsy inventory tracker replaces the feeling with a count. It's a ready-made Excel workbook with the structure already in place: one part for the materials you buy and hold, one part for the finished pieces ready to go out, and both of them sitting in the same file so the relationship between them is visible. How many of this can I actually sell right now? is a question the workbook is built to answer, and answering it doesn't require you to be in a good organisational mood.
What changes is quieter than a big systems overhaul. You stop ordering materials you already have. You notice a bestseller running down while there's still time to do something about it. When someone asks whether you can make twelve by Friday, you check a file instead of walking to the cupboard with a torch.
One thing to say plainly before you read on: the visuals and interactive elements on this page are illustrations, made only to introduce the product and show what it's for. What you're buying is the Excel workbook described here — those illustrations aren't part of the file you receive.
Most sellers hold two separate pictures in their head: what's in the materials box, and what's on the finished shelf. Neither knows about the other, so the answer to "can I fulfil this order?" requires a walk around the house. Here they're counted side by side in the same workbook, so the two numbers are always read together, and the gap between "I have the stuff" and "I have the thing" closes.
The moment materials and finished pieces are counted in one place, availability becomes a fact rather than an instinct. That matters most on the good days — the custom request, the market you're stocking for, the message that starts "could you do six of these by Saturday?" You can answer with a number instead of a hopeful yes you'll regret on Thursday night.
The two ways stock goes wrong are opposite and equally expensive: running out of a material mid-order, and buying more of something you already have. An inventory tracker for Etsy sellers fixes both by keeping the count visible between purchases. You order what's genuinely short, and you stop paying for shelf space twice.
The formulas come built in, so every total updates the moment you change a number — no re-adding a column by hand, no wondering whether last week's figure includes this week's delivery. That's what makes a quick count worth doing at all: the payoff arrives immediately, while you're still standing at the workbench.
Because the workbook's structure is already decided, a count is a matter of typing numbers into rows that exist. There's no blank-sheet hesitation, no deciding how to organise it, and no starting over when your categories shift. You can count one shelf and stop, and the file is still correct about everything you've entered.
Excel, Google Sheets and LibreOffice Calc all open this workbook, so it fits the laptop on your desk, the browser you keep open, or the free suite on an older machine. That flexibility matters in a workshop where the computer is often covered in dust and the phone is doing the real work.
The workbook is built around two counts and the line between them. One part holds your materials — the blanks, cloth, clay, card, wax, hardware and packaging you buy in bulk and draw down as you make. You record what you have, and when you buy more, you record that too. The count stays honest because it's the only place the number lives.
A second part holds your finished stock: the pieces that exist, are ready, and could be posted tomorrow. This is the number that stops you selling the same three keyrings twice.
The two parts are designed to be read together, and that's where the workbook earns its keep. A finished piece represents materials already spent; material on the shelf represents pieces you could still make. Because both counts sit in one file, what's available to sell stops being a single number and becomes a range you can actually see — what's ready now, and what's still possible. When you draw down materials to make a batch, you're not just recording an expense or a sale; you're keeping two related counts in step.
The whole thing is used in the order your workshop actually runs: count, make, update, sell. Nothing has to be tidied up at month end, because nothing was left messy in the first place.
The first sheet you open — the workbook's starting point.
Where your materials and finished stock are counted.
Where stock movements are recorded as they happen.
The sheet that explains the file.
Short walkthroughs for this workbook. Nothing loads until you press play.
Short, focused walkthroughs of the Etsy Inventory Tracker are being recorded — getting started, working each sheet, and the month-end routine. When they are published, they will appear right here, filed under the categories above.
What can I sell right now? — the workbook's core question in miniature, running live in your browser. Enter your finished pieces and the material behind them, item by item, and see how many more you could still make and how many you could sell in total. It runs entirely here: nothing is stored, and no data leaves the page. The full workbook remains the complete version.
For each item, enter the finished pieces on hand, the material you hold, and how much of that material one finished piece uses. Still makeable is the whole pieces that material can still become; Total sellable is finished plus still makeable. If material used per unit is 0 or blank, still makeable reads 0. Material amounts can be decimals; finished counts are whole pieces.
| Item | Finished on hand | Material on hand | Material used per unit | Still makeable | Total sellable | |
|---|---|---|---|---|---|---|
| 40 | 52 | |||||
| 3 | 6 | |||||
| 0 | 0 |
A negative or non-numeric amount is rejected — it counts as 0 until it is fixed.
This table shows up to 12 items. That limit belongs to this tool only and says nothing about the workbook — the file itself is the complete version.
This workbook is for Etsy sellers who make or hold physical products: the candle maker with shelves of wax and jars, the seamstress with fabric in three cupboards, the reseller with boxes stacked in a spare room. If you've ever run out of something mid-order, or bought what you already had, it was built for you. If you're comfortable typing counts into a spreadsheet, you have every skill it asks for.
It isn't for sellers whose shops are entirely digital, because there's nothing physical to count. And it doesn't connect to your Etsy shop and update itself. You type your counts in.
You pay once on Etsy, and the file is yours to keep and reuse.
It arrives as an instant download the moment you check out, with nothing shipped and nothing to wait for.
Open the workbook in Microsoft Excel, Google Sheets or LibreOffice Calc and type in your first counts — the built-in formulas take over from there.
The workbook opens in Microsoft Excel, Google Sheets and LibreOffice Calc, so you can use whichever you already have. It arrives as an instant download the moment you check out, with nothing shipped and nothing to wait for. You pay once on Etsy, and the file is yours to keep and reuse.
No. Start with the shelf or the material you're least sure about and enter that one count; the workbook is still accurate about everything else you haven't touched. Most sellers build the full picture over a few sittings rather than one long session.
No. It's a workbook you type into, so you enter your counts as stock moves. The built-in formulas then recalculate the totals as you type.
You enter your own items and counts, so how finely you split variations is your decision — one row per listing, or one row per size or colour. The file doesn't impose a structure you have to fight; you name the things you're counting.
You pay once on Etsy, and the file is yours to keep and reuse.
Instant download after checkout — one payment, and the workbook is yours to keep and reuse.