Inventory and Reorder Tracker Spreadsheet for Small Business
$15.99
Running out of your best seller is the worst way to find out you needed to reorder. This tracker keeps a running count from what you log.
Share
What's inside
- One row per SKU with cost, sale price, reorder point, target stock and opening quantity
- On hand updates from Stock In, Sales Out and Adjustments
- Every SKU is marked OK, Low or Out, in color
- Reorder Summary lists Low and Out items, with a suggested order quantity and estimated cost
- Profit by Item shows units sold, revenue, cost of goods, fees, shipping, gross profit and margin
- Dashboard of SKUs tracked, stock value, items at reorder point, and monthly gross profit
Who it's for
- Handmade makers and craft fair sellers who keep their own stock
- Small retail and online shops that want to reorder before they run out
- Anyone tracking stock value and profit per item in Excel or Google Sheets
Details
Excel and Google Sheets inventory tracker for small businesses: on-hand stock, reorder alerts, stock value, and profit per item.
Log what comes in and what goes out. The workbook works out what's on hand, what it's worth, and which items actually make you money. Each item at its reorder point, or within the low-stock buffer you set, shows up on one list, with a suggested order quantity and an estimated cost. Digital download, nothing ships. One .xlsx file. Works in Excel or Google Sheets on any device. No macros, no add-ons.
Sample data (25 items, 3 months) is included so you can see how it works. Start Here shows you how to clear it. Formula cells are locked, so you won't overwrite them by accident. Tabs: Dashboard, Reorder Summary, Profit by Item, Start Here, Setup, Products, Stock In, Sales Out, Adjustments.
Limits: up to 200 SKUs, 500 stock deliveries, 1,000 sales lines and 300 adjustments. Reorder Summary shows up to 100 items. Setup holds 8 categories and 20 suppliers. You type or paste your sales in. It doesn't connect to any shop or store account. Single location totals. Each item can carry one optional location label, but stock isn't counted by location.
This workbook is an organizational tool, not tax, legal, accounting or financial advice.
Before you buy
This workbook is an organizational tool, not tax, legal, or accounting advice. For filing, talk to a tax professional.
Excel and Google Sheets. No macros. Paid spreadsheet products include a blank file and a filled example, plus a Start Here tab in plain English.
Licensed for one business per purchase.
