Small Business Inventory & Order Tracker – Excel E-Commerce Dashboard
E-COMMERCE INVENTORY & ORDER CONTROL SYSTEM
Control your products, stock, supplier purchases, sales, COGS, gross profit and reorder decisions from one connected Microsoft Excel workbook.
Designed for small business owners, Shopify sellers, Etsy sellers, handmade brands, product-based businesses, resellers and side hustlers who want a structured operational dashboard without adding another monthly software subscription.
WHAT'S INCLUDED
- Clean Microsoft Excel workbook
- DEMO workbook with realistic example data
- PDF Quick Start & Instructions Guide
- 10 connected Excel sheets
- Product master catalogue with live stock calculation
- Order and sales tracker
- Automatic unit cost, COGS, gross profit and margin calculations
- Purchase order tracker
- Supplier directory with lead time and MOQ
- Stock adjustment log for returns, damage and corrections
- Automatic low-stock / out-of-stock status
- Reorder planner with suggested order quantity and spend
- Live e-commerce dashboard with KPIs and charts
LIVE STOCK LOGIC
Current Stock = Opening Stock + Qty Received - Qty Fulfilled + Stock Adjustments
Orders reduce stock only when their status is set to Fulfilled.
COMPATIBILITY
Designed for Microsoft Excel. A current desktop version of Microsoft Excel is recommended. Google Sheets compatibility is not claimed for this edition.
EUR EDITION
This edition uses euro (€) number formatting.
DIGITAL PRODUCT
This is a digital download. No physical item will be shipped.
TERMS & DISCLAIMER
For the purchaser's own personal or internal business use. The original workbook may not be resold, redistributed, shared, sublicensed, given away or uploaded as a competing digital product. © Exile Digital Store.
This spreadsheet is an inventory, sales, pricing and business-organization tool only. It does not provide accounting, tax, legal, investment or financial advice.