● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Inventory Tracker
Hero image of the Inventory Tracker, showing the full workbook at a glance
BOOKKEEPING & BUSINESS FINANCE

Inventory Tracker

Running 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.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Know your stock before the shelf goes empty

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.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the workbook into your own Google account
  • BLANK Excel workbook, clean and ready for your own numbers
  • EXAMPLE Excel workbook filled with sample data, so you can see how everything works first
  • Quick Start Guide PDF with the setup steps in plain language
  • Four separate files delivered as an instant download, with no ZIP to unpack

Good to know

  • Runs in Microsoft Excel (2021 or Microsoft 365) and in free Google Sheets
  • Works on your computer, tablet and phone
  • Every currency works, because the amounts are plain numbers
  • No warehouse software and no monthly subscription to keep paying
  • Questions after purchase? Message us through Etsy and we will help you out

Questions about this template

The things buyers ask us most.

I make handmade products. Is this built for me?

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.

How do the low stock alerts work?

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.

Does it count my stock automatically?

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.

Can I add more items or change the ones there?

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.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Sales Tracker

Log each sale once and see revenue after fees, top products and your best channels clearly.

$7.50 $3.00
View on Etsy
Small Business Petty Cash Tracker

Log petty cash in and out, record top-ups, and check counted cash against the expected balance.

$7.50 $3.00
View on Etsy
Small Business Cash Flow Spreadsheet

A 13 week cash flow forecast that flags tight weeks before they arrive.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00