Excel-based inventory and sales tracking system built by an active reseller.
This version is a streamlined edition of the system I use to run my own resale business. It provides a clean, structured way to track inventory, sales, expenses, and profit without subscriptions, apps, or cloud software.
Your data stays on your computer, in Excel.
This system is designed for resellers who want control and visibility without overcomplication — ideal for steady sellers who don’t need advanced analytics or automation.
What This System Tracks
✔ Inventory with SKU, category, cost, quantity, and storage location
✔ Sales with fees, shipping, adjustments, and net profit
✔ Monthly sales tracking (January–December)
✔ Expense and cash flow tracking
✔ Profit & loss visibility without estimates
✔ Unsold inventory tracking (donations, write-offs, damaged items)
✔ Simple, consistent workflow that reduces missed entries
If you can type in Excel, you can use this system.
Included Sheets & Tools
• Master Inventory Sheet
• 12 Monthly Sales Sheets
• Profit & Loss / Shipping Log
• Expenses & Cash Flow Tracking
• Unsold Inventory Tracker
• Admin Sheet with dropdown controls
• Automated sold-item handling
• Date picker calendar
• Full written user guide (PDF + Word)
• Support through December 31
Everything is pre-built, tested, and ready to use immediately.
What This Version Does Not Include
This edition does not include:
Advanced analytics dashboards
ROI / category performance reporting
Multi-period analytics views
Premium automation tools
Those features are reserved for the Premium version.
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 Version Is For
This system is best suited for:
Small to mid-volume resellers
Sellers upgrading from scattered spreadsheets
Anyone who wants clean records without paying monthly app fees
This is not a basic template.
It is a practical resale tracking system built for day-to-day 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.