How to Track Reseller Inventory in a Spreadsheet (Columns, Formulas & Stale Stock)
Most flippers lose money in two quiet ways: they forget what they paid for things, and they let items sit listed for months. One simple spreadsheet fixes both. Here is how to set it up.
The columns you need
- SKU or item number (write the same code on the bag or bin so you can find it fast)
- Item description
- Date bought and where (thrift store, garage sale, estate sale)
- Cost, what you paid including tax
- Date listed and platform (eBay, Poshmark, Mercari, Facebook)
- Asking price
- Date sold, sold price, platform fees, shipping you paid
- Profit and days to sell (formulas, below)
The formulas that do the work
Say cost is in column E, sold price in J, fees in K and shipping in L, with the date listed in G and the date sold in I.
- Profit:
=IF(J2="","",J2-K2-L2-E2) - Days listed (unsold):
=IF(I2="",TODAY()-G2,"") - Days to sell:
=IF(I2="","",I2-G2) - Return on cost:
=IF(J2="","",(J2-K2-L2-E2)/E2)
Not sure what the fees will be? Our free eBay fee calculator and Poshmark and Mercari fee calculator give you the number to type in.
Spot stale stock every week
- Sort or filter unsold items by days listed, longest first.
- Anything past 60 days gets a price drop, better photos, or a cross-list to another platform.
- Anything past 120 days gets bundled, sent to a lot sale, or donated so the space and cash are freed up.
- Look at your best days to sell and return on cost by store. Source more where those numbers are strongest.
Worked example
| Bought (Goodwill jacket) | $8.00 |
| Sold on eBay | $54.00 |
| eBay fees (about 13.6% plus $0.40) | − $7.74 |
| Shipping label | − $9.10 |
| Profit | $29.16 |
| Return on cost | 364% |
Do that on every row and you will see which items are worth your time and which ones only look good on paper. For the full fee formula, read how to calculate real eBay profit after fees, or try the free reseller profit calculator.
Want your shelves to match your sheet? See how to organize reseller inventory at home with bins and SKU codes.
Want this done for you?
The Flip Profit Tracker has these columns, fee math for eBay, Poshmark and Mercari, days-listed tracking and a monthly dashboard already built, for Excel or Google Sheets.
Get the Flip Profit Tracker ($9.99) or try one row free first →