Inventory Tracker | Google Sheets Template
Know exactly what is on your shelves. This Google Sheets inventory tracker keeps your products, stock levels, deliveries, sales and suppliers in one place, and the dashboard shows your stock value, revenue, profit and what needs reordering, automatically.
WHAT'S INSIDE (7 tabs)
- START HERE: quick setup steps and tips
- Dashboard: products, stock value at cost and retail, units sold, revenue, gross profit, low and out-of-stock counts, top sellers, stock value by category and a reorder list
- Products: your catalogue with margin %, a live stock level bar, stock value and In stock / Low stock / Out of stock status
- Stock Movements: every delivery, sale and adjustment, with product name, cost and sale value filled in for you
- Sales Summary: month by month units sold, revenue, cost of goods, gross profit, margin and stock purchased
- Suppliers: supplier contacts, lead times, number of products and stock value per supplier
- Setup: business name, currency, year and your own product categories
HOW IT WORKS
1. After purchase, download the PDF from the link in your confirmation email.
2. Click the link. Google asks you to make a copy, which is saved to your own Google Drive.
3. Add your products and starting stock on the Products tab, then log each delivery and sale. Stock levels and the dashboard update automatically.
GOOD TO KNOW
- Two versions included: one with sample data to explore and a blank one ready for your own numbers
- Great for handmade shops, small online stores, market sellers and home businesses
- Works in Google Sheets on computer, tablet and phone. A free Google account is needed. Not made for Excel or Numbers
- Cells that calculate show a gentle warning if you try to edit them, so formulas are not deleted by accident
- This is a digital product. No physical item will be shipped
- For personal use only. Please do not share or resell
- Because this is a digital download, returns are not accepted. If you have any problem, email me and I will be happy to help