Profit Calculator Spreadsheet for Resellers, eBay Poshmark Mercari Depop Fee and Sales Tracker, Excel Google Sheets, Digital Download
Excel and Google Sheets tool. Not a printable, not party decor.
Know whether an item is worth buying before you buy it. This spreadsheet works back from your resale price to the most you can pay, then tracks the item through to the money in your account.
MOST RESELLER SHEETS ARE RECORD KEEPERS
They tell you what you already spent and what already sold. Useful, but the money was gone before the sheet said anything.
This one starts one step earlier. Enter what the seller is asking and what you expect to resell for, and it gives you a maximum buy price and a BUY, THIN or PASS verdict. Pay more than that number and the item loses money no matter how well it sells.
FIVE TABS
- PLATFORMS: your fee rates, set once, read by everything else
- SOURCING: should I buy this? Max buy price, projected ROI, BUY / THIN / PASS
- INVENTORY: what you own, what it cost, how long you have held it, ageing alerts
- SALES: what sold, what the platform took, what you actually kept
- DASHBOARD: cash tied up, net profit, average ROI, average days to sell, profit by platform
WORKS ON ANY PLATFORM
eBay, Poshmark, Mercari, Depop, Vinted, Etsy, Facebook Marketplace, local sales, and any platform not on that list.
You enter your own fee rates rather than trusting mine. That is deliberate. Platforms change their fees, and a spreadsheet quietly using last year's rate is worse than one that asks. Copy your rates from your own payout statement once and this file stays correct through every fee change.
AGEING STOCK, NOT JUST PROFIT
Anything unsold past your own threshold is flagged. A cheap buy that sits for a year is not a good buy, and the dashboard shows you exactly how much cash is stuck in stock that is not moving.
WHAT YOU GET
- 1 Excel file (.xlsx) with 5 tabs
- Works in Excel on Windows and Mac, and in Google Sheets. No add-ins, macros, or subscriptions required.
- Sample rows included. Clear them and enter your own.
- Blank rows are ignored by every total and every average
HOW IT IS SET UP
Blue text on yellow cells are yours to edit. Formula cells are locked so you cannot break them by accident, with no password if you want to change the structure.
DELIVERY AND REFUNDS
Digital download only. No physical item will be shipped. Your file is available immediately after payment. Because files are delivered instantly, all sales are final.
If something does not work the way you expected, message me. I will fix it and send you the updated file.
ALSO IN THIS SHOP
This file is built for buying and reselling finished items. If you import from factories instead, see the China Sourcing Profit Calculator, which adds duty, freight and Amazon fees to the same kind of decision.
---
Built with AI assistance, then tested and corrected by me. Every formula in this file was recalculated and stress-tested before it shipped, including blank-sheet and partial-data scenarios.