For eBay, Poshmark, Whatnot and Mercari sellers
The apps tell you your gross. This tells you your profit.
Your actual profit is scattered across four platforms’ fees, a pile of shipping labels, and a shelf of unsold inventory. That is fine in month one. It is a problem by tax time.
Generic templates do not help, because reselling is its own animal: cost of goods matters per item, an item can sit for months before it sells, and every platform takes a different cut. This spreadsheet is built around that.
Works in Excel and Google Sheets. No macros, no add-ins, no account with us.
| Jan | Feb | Mar | |
|---|---|---|---|
| Gross sales | $419.00 | $404.00 | $314.00 |
| Platform fees | $46.95 | $55.30 | $35.70 |
| Shipping cost | $44.70 | $41.95 | $39.80 |
| Cost of goods sold | $125.49 | $112.95 | $95.99 |
| Expenses | $66.84 | $139.69 | $77.04 |
| Net profit | $135.02 | $54.11 | $65.47 |
Cash tied up in unsold inventory$53.99
Dead pile write-offs$5.00
Quarterly tax set-aside at 25%$63.65
What’s inside
Six tabs, two copies of the file, one guide.
Tabs, built for how reselling works
- Sales log. One row per sale, any platform. Enter the price and fees; it pulls the item’s cost automatically and shows the true net on every flip.
- Inventory & COGS. Every item you buy, what you paid, and its status: not listed, listed, sold, or dead. An item’s cost hits profit in the month it sells.
- Expenses. Categories a reseller recognizes: sourcing trips, shipping supplies, storage, subscriptions, crosslisting software, mileage.
- Quarterly tax set-aside. Pick a percentage; it computes the amount to move to savings each quarter, with the usual US due dates beside it.
- Dashboard. The tab above. Monthly gross, fees, cost of goods, expenses, net profit, and your dead pile, filled in automatically.
- Year-end checklist. Ten steps in January and your books are ready to hand to a tax preparer.
Copies of the file
One loaded with three months of realistic sample data so you can see every formula working, and a blank one for your real numbers.
Plain-language guide
A weekly ten-minute routine. Ten minutes, once a week, is the honest total time cost.
What this is not
It is not tax advice, and it does not talk to your platforms; you type your sales in weekly, which for most sellers is faster than fixing what an auto-importer got wrong. It is not accounting software with a monthly fee. And it will not make you profitable; it will just stop you from guessing whether you are.
$19
one-time purchase
Buy it, open the sample-data copy, and watch your first entry flow through to the dashboard today. 30-day refund, no questions asked.
Format: two .xlsx files plus a setup guide. Every formula was built with cross-compatible functions and tested to survive a Google Sheets import. Yours forever, free updates if a platform change ever breaks something.
Made by Saltworks, a small product studio.