Log each sale once and see revenue after fees, top products and your best channels clearly.
View on EtsyRunning out of your best seller almost never happens because you were careless; it happens because the stock count lives in your head or on a sticky note. This inventory tracker spreadsheet keeps every item, its cost, its price and its live count in one place, and warns you while there is time to reorder.
Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.
Stock problems usually start quietly. The count lives in your head, on a sticky note, or split across notebooks that never agree, and the gap only shows when a customer wants the thing you just ran out of. This tracker gives your inventory one home: what you have, what it cost you, what it sells for, and exactly when to reorder, while there is still time to act.
The Inventory List holds each item with its SKU, category, supplier, unit cost, selling price and reorder point, while current stock, both stock values, margin and status keep themselves. Log deliveries on Stock In and sales on Stock Out; item names and suppliers fill in from the SKU, and totals flow back to the list. The moment an item reaches its reorder point, it appears on Low Stock Alerts with a suggested quantity.
The Dashboard shows items tracked, units in stock, stock value at cost and at retail, plus units sold, revenue and gross profit. The Sales Summary breaks those figures down per item, so your best earners and your shelf warmers are impossible to miss. The list holds 20 items, and the example file follows a handmade candle and home goods shop through a full month of trading.
The things buyers ask us most.
Yes. Give every finished product a SKU, log what you make on the Stock In tab with your cost per unit, and log sales on Stock Out. The tracker works the same whether you buy stock in, make it yourself, or do a bit of both, which is how most small makers actually run.
You set a reorder point on each item: the level where a new order still arrives in time. The moment an item's current stock falls to that point, it appears on the Low Stock Alerts tab with a suggested reorder quantity and the supplier to call. There is nothing to switch on, and no email alerts to set up or dig out of a spam folder.
It keeps the running count for you: opening stock, plus everything you log in, minus everything you log out. You spend a few seconds logging each movement, and it does all the arithmetic, including what your stock is worth at cost and at selling prices. A quick physical count now and then keeps it honest.
The Inventory List holds 20 items, and you can rename any of them, change costs and prices, or adjust reorder points at any time. Just spell the SKU the same way in the Stock In and Stock Out logs, and everything keeps flowing to the list, the alerts and the summaries.
Three more workbooks from the same shelf.
Log each sale once and see revenue after fees, top products and your best channels clearly.
View on EtsyLog petty cash in and out, record top-ups, and check counted cash against the expected balance.
View on EtsyA 13 week cash flow forecast that flags tight weeks before they arrive.
View on Etsy