Small Business Inventory Tracker (Excel + Google Sheets)
DIGITAL SPREADSHEET: nothing is shipped.
Know what you have, what's selling and what to restock. For makers, resellers, market vendors and small shops with up to 300 products.
AI disclosure: this item was created with the use of AI. LB3 Trackers designed it with AI assistance; AI tools helped write the formulas, layouts and instructions.
What's inside:
- Products: SKU, cost, price, reorder point and starting stock, with automatic units in and out, on hand, stock value at cost, margin per unit and %, and an OK / Reorder / Out status
- Stock In log (2,000 rows) and Stock Out log (3,000 rows); the product name fills in from the SKU
- Dashboard: totals, a reorder and out-of-stock list, and units by channel with a chart
- Editable channel list (online shop, market, wholesale...)
You get a SAMPLE file (a made-up candle shop) and a BLANK file. Works in Excel, Google Sheets, LibreOffice and Numbers. No macros.
Record-keeping only; not accounting or tax advice.
Instant download: after payment you get a download link right away.
Questions or a problem with the file? Message us through the store contact page. If the file doesn't work for you, we'll fix it or refund you.
License: own-business use. Please don't resell or share the file.