Small Business Inventory Tracker | Stock Management, Reorder Alerts (Excel Google Sheets) | Product Stock Control, SKU and Reorder Point

SMALL BUSINESS INVENTORY & STOCK MANAGEMENT TRACKER
Know exactly what you have, what it's worth, and what to reorder — without paying for inventory software. Enter each product once and your SKU flows into a stock-movement log, a purchase-order tracker, a sales log and a supplier directory, all wired to one dashboard that values your whole inventory and flags every item running low. One editable workbook instead of guesswork, sticky notes and a bookkeeping sheet you've bent into a stock tracker.

🎁 FREE BONUS INCLUDED — Reorder Alerts + Stock Value (a $18 value): flags what to reorder and totals the value of everything in stock. Yours free with this template.

Most 'inventory templates' are a plain grid you total by hand. This one does the math. Set a reorder point per product and every SKU auto-flags REORDER NOW in amber and OUT OF STOCK in red the moment it drops. Log a stock-in or a stock-out and on-hand quantities recalculate instantly. Every unit is valued at cost AND at retail, so you can see your inventory investment and its selling potential side by side, plus the gross profit locked in your shelves.

Type your products once and just run your business — the dashboard shows total value at cost and retail, potential profit, units on hand, low-stock and out-of-stock counts, dead-stock flags, open purchase orders and inventory value by category, all at a glance.

✅ WHAT'S INCLUDED
• 1 x Excel (.xlsx) file — works in Excel, Google Sheets and Apple Numbers
• 8 ready-built tabs with all formulas already written and tested
• Product master with automatic margin, on-hand, valuation and stock-status
• Live reorder-point alerts — REORDER NOW / OUT OF STOCK / OK, colour-coded
• Dual valuation: every SKU valued at cost AND at retail, totalled for you
• Stock-movement log — every stock-in and stock-out updates on-hand instantly
• Purchase-order tracker with line totals and placed-to-received status
• Sales / usage log with automatic revenue and gross-profit calculation
• Dead-stock flag — spot products sitting on the shelf that never sell
• Supplier directory with contacts, lead times and minimum orders
• Inventory value by category, built automatically on the dashboard
• SKU-driven dropdowns and multi-location support built in
• 24 sample products loaded in as an example — type over them or clear them
• Plain-English 'Start Here' guide
• Free customization — message me and I'll tailor it to your business

📊 THE 8 TABS
1. Start Here — how it all works, step by step.
2. Dashboard — total value at cost and retail, alerts, and value by category.
3. Product Master — one row per SKU; the hub that feeds every other tab.
4. Stock Movements — log every stock-in and stock-out; on-hand updates itself.
5. Purchase Orders — what's ordered, when it's due and whether it's arrived.
6. Sales / Usage Log — revenue, profit and automatic stock drawdown.
7. Supplier Directory — contacts, lead times and minimum orders.
8. Settings — categories, storage locations and suppliers feed the dropdowns.

⭐ WHY IT WORKS
• IT WATCHES YOUR STOCK — set a reorder point and every SKU flags itself REORDER NOW or OUT OF STOCK against its on-hand quantity, and the dashboard counts them for you.
• IT VALUES EVERYTHING TWICE — see your inventory at cost and at retail side by side, plus the potential gross profit sitting on your shelves.
• ON-HAND IS ALWAYS CURRENT — log a movement or a sale and quantities recalculate instantly; no manual counting or totalling.
• ONE SKU, EVERY TAB — type each product once and it flows into movements, orders, sales and the supplier list.
• NOTHING GETS FORGOTTEN — low stock, out-of-stock, dead stock and open purchase orders all count themselves on the dashboard.

💻 HOW IT WORKS
1. Download the .xlsx file straight after purchase
2. Open it in Excel, or upload to Google Sheets (File ▸ Import ▸ Replace spreadsheet)
3. List your categories, locations and suppliers on Settings, then add your products on the Product Master tab
4. Log movements, orders and sales — the dashboard does the rest

📱 COMPATIBILITY
Works in Microsoft Excel, Google Sheets and Apple Numbers, on desktop, tablet and phone. No app to install, no subscription, no account to create. Nothing is password-locked — it's your file, restructure it however you like.

⚠️ PLEASE NOTE
This is a DIGITAL DOWNLOAD. No physical item will be shipped. Because of the nature of digital files, all sales are final — but if anything isn't working, message me and I'll sort it out.

💬 QUESTIONS?
Message me any time. I built this and I'm happy to customise the fields, categories or tabs for your shop, boutique or warehouse.

📗 HOW TO OPEN IN GOOGLE SHEETS (free & easy):
This is one file that works in BOTH Excel and Google Sheets — there's no separate file to find, you just import the download once:
1. Go to sheets.google.com and open a blank spreadsheet
2. Click File ▸ Import ▸ Upload
3. Drag in the .xlsx file you downloaded from this order
4. Choose "Replace spreadsheet" and click Import data
All tabs load as a full Google Sheet saved in your Drive — edit it on any device. (Prefer Excel? Just double-click the file to open.)

© ReadySheetGo. For personal business use only. Please don't resell or redistribute.

———————————————
VIDEO TUTORIAL INCLUDED
This template comes with a step-by-step video walkthrough to help you get set up in minutes. Your tutorial link is included with the instant download.