Home/Spreadsheets/Small Business Tools/Sourcing ROI and Aged Inventory Analyzer
Sourcing ROI and Aged Inventory Analyzer
A reseller analyzer that scores each sourcing trip on profit per hour and prices the cash sitting in unsold stock by age. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Profit per hour on every sourcing run
- Cash tied up, by age bucket
- STALE flag past a line you set
- Days held, recalculated on open
- Fees and shipping netted out first
- Opens in Excel and in Google Sheets
$19.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
What it does
- Profit per hour on every sourcing run
- Cash tied up, by age bucket
- STALE flag past a line you set
- Days held, recalculated on open
- Fees and shipping netted out first
- 40 trips and 100 items
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Inventory
- Getting Started
- Sourcing Trips
- Setup
Works in
- Microsoft Excel 2016 or later, Windows and Mac
- Google Sheets — upload to Drive and open
- No macros, no add-ins, no subscription
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 Tools
- Craft Show Vendor KitA craft show vendor kit that answers the only question that matters after a market…$10.99View →
- PTA and PTO Treasurer SpreadsheetA treasurer's ledger for any parent group with a bank account: one register row per…$18.00View →
- RFI and Submittal LogAn RFI and submittal log for construction administration that ages every open item from…$16.99View →
- Home Inventory TrackerAfter a fire or a burglary the insurer asks for a list. People who have one get paid…$11.00View →
