Modulis › Templates › Reseller Profit Tracker
Reseller · Spreadsheet template
Reseller Profit Tracker
How much did I keep on that sale?
Log an item when you buy it, set it to Sold when it goes, and the file shows what you actually kept, after platform fees, shipping and packaging. Profit by platform, cash tied up in old stock, and lots split across items, on the first screen.
Not sure yet? Try the free resale profit calculator first. Same logic, fewer rows.
The first screen
This is the dashboard of the file, with the sample data it ships with. Replace the sample with your numbers and every tile updates.
A real example
Six sales across five platforms, and a box of two jackets bought as one lot. These are the sample numbers shipped in the file.
- An office chair, bought at $30, cleaned up for $5, sold at $40 on Facebook Marketplace. After the $2 fee, $3 left. A 7.5% margin, and most sellers would never have noticed
- A Nike Air Max 90, bought at $12, sold at $68 on eBay: $46.56 net after the 13% fee, shipping and packaging
- $79.50 tied up in 4 items that have not moved in 90 days, including a wool blazer at 155 days
- A box of two jackets bought for $45: the tracker assigns $22.50 to each, so the first sale from the box is not counted as a loss
The number most resellers never see
Most resellers know what they sold for. Few know what they kept, and almost nobody knows how much cash is sitting in items that stopped selling. The dashboard shows both: net profit after every fee, and the value of everything older than 90 days. That second number is the one that tells you what to discount.
Lots are the other blind spot. Buy a bundle for one price and the first item you sell looks like a loss, everything after looks like pure profit. Add the lot once, write its ID on each item, and the cost is split automatically.
What's inside
The tabs of the file, in the order you meet them. You only ever type in one or two of them.
What you get
One spreadsheet and one guide, delivered right after checkout.
- Up to 200 items, one line each
- Net profit after every fee and shipping cost, per sale
- 10 platforms with editable fee rates, profit by platform
- Lot cost split across items
- Dead stock alert: cash tied up in items unsold for over 90 days
- Average days to sell and return on cost
- Any currency, sample data included, formulas locked in Excel and marked in Google Sheets
- Files
- 1 spreadsheet (.xlsx) + 1 Quick Start Guide (.pdf)
- Works in
- Excel, Google Sheets, LibreOffice, Numbers
- Currency
- Any, you type the symbol once
- Skills
- None needed, no formulas to write
- Delivery
- Instant download, no account, no subscription
- Support
- Write to us and we fix it
Questions people ask
Which platforms are included?
What if I have more than 200 items?
How do lots work?
Reseller Profit Tracker
How much did I keep on that sale? One file, and the answer is on the first screen.