What is included
- Item records and a stock-movement log calculate on-hand quantities, stock value and status.
- Restock views combine reorder settings, estimated costs and supplier lead times.
- Individual item cards show movement history and six-month summaries.
- Includes Google Sheets and sample/blank Excel files; printable supplier purchase-order tooling is a Sheets feature.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- Product identifiers and units used for counts
- A starting stock count
- The products and quantities you need to review for reordering
A practical way to use your records
Use consistent product names or identifiers before entering the first count. Maintain the stock record when goods move and reconcile it with a physical count at a regular interval. Review the reorder list in the context of outstanding orders and expected demand.
A worked example
Fictional example: a small shop reconciles stock for one product before making a reorder decision.
- Opening quantity
- 30 units
- Received quantity
- 12 units
- Units sold
- 25 units
- Damaged units recorded
- 2 units
- Record receipts, sales and damage as distinct movements for the same item.
- Compare the implied closing stock with a physical count before reviewing the item's chosen reorder level.
Result: The movements imply 15 units remaining: 30 + 12 − 25 − 2. A reorder decision still depends on the shop's own lead times and stock policy; a discrepancy between records and count should remain visible for investigation.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Small Business Inventory Tracker Spreadsheet for Google Sheets and Excel
Additional previews from this product's Etsy listing. Open any image for a larger view.
Questions about this product
Is a reorder list included?
Yes. Stock tracking, an inventory sheet and a reorder list are included.
Is this the bill-of-materials spreadsheet for makers?
No. The maker inventory and product-cost Excel spreadsheet is a separate product. Compare it if materials and manufacturing costs are your main focus.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
