Instant downloadSpreadsheet Templates
Reseller Inventory and Profit Excel Template
Every flip has a story: where you found it, what you paid and what it finally sold for. This reseller inventory spreadsheet turns those facts into platform fees, net profit, ROI and days to sell, right on the item's own line, with a status of In stock, Listed or Sold that follows from the dates you enter.
The sourcing report shows which thrift stores, estate sales or auction lots actually pay off, by profit, ROI and speed of sale, and a sales summary tracks each month. Add up to six selling platforms with their percentage and fixed fees, and keep mailers, storage and other costs in the expense log. When a new year starts, unsold stock carries over, so you keep logging in the same file.
The tax summary brings together quarterly profit, a suggested set-aside and your inventory value at year end, and the mileage log covers sourcing runs. You get a blank workbook, a sample with a fictional year and a quick-start guide, for Microsoft Excel 2010 or newer on Windows and Mac.
Details
- Microsoft Excel 2010 or newer (Windows and Mac), .xlsx file
- 9 tabs: 1,000-item inventory log with automatic SKUs
- Up to 6 platforms, each with its own fee % and fixed fee
- Sourcing report for up to 15 sourcing locations
- No macros or add-ins: standard formulas only
- Blank workbook, sample workbook and quick-start guide (PDF)
- Instant download, available worldwide
- No physical item is shipped
- Your files appear under Purchases in your Etsy account, and Etsy emails you a download link
- Digital downloads can't be returned or exchanged
Tip Before you sort the inventory list, turn the automatic SKUs into fixed values with Paste Values, so each item keeps its number.
