Home/Spreadsheets/Small Business/Reseller Sourcing ROI and Aged Inventory Spreadsheet
Reseller Sourcing ROI and Aged Inventory Spreadsheet
A reseller spreadsheet that scores the sourcing trip, not just the item: tag every piece to the run that bought it and each trip earns a live profit per hour while unsold stock ages against a line you set. It opens in Microsoft Excel, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- 40 sourcing trips with spend, miles and hours in, and cash cost, items sold, net proceeds and profit per hour back
- 100 inventory rows with fees and shipping netted out, net profit, ROI on cost and days held
- 0-30 / 31-60 / 61-90 / 90+ age buckets that recalculate every time you open the file
- A red STALE flag past a day count you set
- Cash tied up in unsold stock shown as a dollar figure by age
- Opens in Excel
$13.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
What it does
- 40 sourcing trips with spend, miles and hours in, and cash cost, items sold, net proceeds and profit per hour back
- 100 inventory rows with fees and shipping netted out, net profit, ROI on cost and days held
- 0-30 / 31-60 / 61-90 / 90+ age buckets that recalculate every time you open the file
- A red STALE flag past a day count you set
- Cash tied up in unsold stock shown as a dollar figure by age
- Sourcing hours priced at your own rate; worked example with 8 trips and 27 items
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Sourcing Trips
- Inventory
Works in
- Microsoft Excel 2016 or newer, Windows or Mac
- Built and checked in Excel only
- No macros, no add-ins, no external links
Honest scope
This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.
Others in Small Business
- RFI and Submittal LogAn RFI and submittal log for construction administration that ages every open item from…$12.99View →
- Photography Job Profit CalculatorA job costing calculator for photographers that counts the editing, the admin and the…$14.99View →
- Cleaning Business Planner SpreadsheetA cleaning business spreadsheet for Excel: know which jobs to take, what each one earns…$24.99View →
- Coffee Shop Cash Flow ModelModel your coffee shop's cash flow before you open or expand, in one Excel file. Set…$13.99View →
