Small Business Inventory Tracker, Google Sheets Template with Low Stock Alerts (Digital Download)

Know what's in stock, what to reorder and what your stock is worth. Add your items once, log every delivery and sale, and this Google Sheets Inventory Tracker keeps every item's stock on hand up to date, warns you when it's low, and shows it all on a Dashboard.

━━━ WHAT YOU GET ━━━
- A START-HERE PDF with two "Make a copy" buttons:
– Ready-to-use copy for your own items
– Sample copy filled with a made-up small shop, so you can see how it works
- A step-by-step PDF guide (setup, every tab, FAQ, troubleshooting)

━━━ WHAT'S INSIDE ━━━
DASHBOARD – your stock at a glance
- Stock value at cost and at retail, and units on hand
- A Needs reordering list, out of stock first, then low stock
- Your latest stock movements and a chart of received against used over 6 months

ITEMS – up to 500 items
- SKU, name, category, unit cost, sell price, starting quantity and reorder point
- What you've received, sold or used, what's on hand, its value and its Status (OK, Low stock or Out of stock) are worked out for you

STOCK MOVES – up to 3,000 movements
- Log a delivery (In), a sale or use (Out) or a stock count correction (Adjust)
- Pick the SKU from a dropdown; the item name fills in

START HERE – a 3-step setup checklist and a color guide

━━━ PERFECT FOR ━━━
Small shops, makers and craft sellers, workshops, salons, cafes, home businesses and anyone with stock to count.

━━━ HOW IT WORKS ━━━
1. Buy and download the START-HERE PDF
2. Click a button while signed in to Google, then "Make a copy"
3. Open your copy, add your items, then log your stock moves

━━━ GOOD TO KNOW ━━━
- Google Sheets only: you need a free Google account. This is not an Excel file.
- Works in any browser on a computer, tablet or phone. Setup is easiest on a computer.
- Nothing to install, no add-ons, no scripts.
- Quantities are whole numbers. It doesn't scan barcodes or track locations, batches or suppliers.
- Prices show in dollars; the guide shows how to switch currency.
- Screenshots show the sample copy with made-up data.

━━━ LICENSE ━━━
For use by one person or one business. Please don't resell, share or redistribute the template or its links. Digital download: no physical item will be shipped. Because it's a digital file, returns aren't accepted, but if something isn't working, message me and I'll help.