Excel-based inventory and sales tracking system built and used daily by an active reseller.
This is the exact master inventory workbook I use daily to run my own resale business. It was built to replace scattered spreadsheets, notes, and guesswork with a single, structured system that tracks inventory, sales, expenses, and profit from purchase to payout.
No subscriptions.
No apps.
No cloud lock-in.
Your data stays on your computer, in Excel.
This system is designed around how resellers actually operate — sourcing, listing, storing, selling, shipping, reconciling fees, and knowing real profit without backtracking or duplicate entry.
What This System Tracks
✔ Full inventory with SKU, category, cost, quantity, and storage location
✔ Detailed sales logging with platform fees, shipping, adjustments, and net profit
✔ Category, platform, and performance analytics dashboards
✔ Accurate COGS, margins, and ROI — no estimates
✔ Monthly, quarterly, and annual reporting
✔ Cash flow visibility
✔ Expense tracking and business mileage
✔ Unsold inventory tracking (donations, write-offs, damaged items)
✔ Shipping supply inventory management
✔ Structured workflow that reduces missed entries and errors
If you can type in Excel, you can run this system.
Included Sheets & Tools
• Master Inventory Sheet (core operational control)
• Monthly Sales Sheets (January–December)
• Sales Performance Analytics Dashboards
• COGS & ROI Analytics Dashboard
• Monthly, Quarterly & Annual Reports
• Profit & Loss by Venue
• Cash Flow Reports
• Expense & Mileage Tracking
• Shipping Supply Inventory
• Unsold Inventory Tracking
• Admin Sheet with dropdown controls
• Automated sold-item handling
• Date picker calendar
• Built-in workflow buttons (no copy/paste chaos)
• Full written user guide (PDF + Word)
• Support through December 31
Everything is pre-built, tested, and ready to use immediately.
Delivery & Compatibility
• Delivered on a physical USB drive with documentation
• Compatible with Excel 2019, 2021, 2024, Office 365 and later
Note: This is a software workbook only. Microsoft Excel / Office is not included.
Who This Is For
This system is built for resellers who:
manage real inventory volume
sell across one or multiple platforms
want accurate numbers without monthly software fees
This is not a basic spreadsheet or starter template.
It is a full resale tracking system designed for ongoing, daily business use.
When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.