Reseller Inventory Spreadsheet, eBay & Poshmark Profit Tracker (Excel, Google Sheets)
This reseller inventory spreadsheet and profit tracker shows what every flip really made, after platform fees, shipping and what you paid for it. Built for resellers on eBay, Poshmark, Mercari, Depop, Vinted, Facebook Marketplace, Whatnot and more. Works in Excel and Google Sheets.
Who it is for: resellers and thrift flippers selling on eBay, Poshmark, Mercari, Depop, Vinted, Facebook Marketplace or Whatnot.
What it does
- One row per item: what you paid, where you found it, when you listed it and when it sold.
- Platform fees calculated for you for each sale (eBay, Poshmark, Mercari, Depop, Vinted, Facebook Marketplace, Whatnot, Etsy, Grailed, local sales). Every fee rate is editable, and you can add your own platforms.
- Net profit, ROI and days to sell for every item. Status updates itself: Unlisted, Listed, Stale or Sold.
- Bought a box, a bin haul or a pallet? Add the lot once and its cost is split across its items, evenly or by what each item is worth. See when each lot has paid for itself.
- Dashboard: sales, fees, shipping, cost of items, expenses and NET PROFIT for every month, with charts.
- Which platform pays you best: sales, fees, profit and average days to sell for each one.
- Unsold stock: how long each item has waited, plus a list of the oldest items to list, relist or discount.
- Your best categories and your best sources (thrift stores, bins, estate sales…), ranked by profit.
- Expenses and mileage for sourcing trips.
- Tax summary in US Schedule C style: gross receipts, cost of goods sold with start and end inventory, expenses and mileage.
What's included
- 1 spreadsheet (.xlsx) with 10 tabs: Start Here, Dashboard, Inventory, Lots, Expenses, Mileage, Tax Summary, Platforms, Settings, Lists
- Quick-Start Guide (PDF)
- A sample shop with about 200 items, so you can see how everything works before you add your own
Works with
- Microsoft Excel 2010 or newer (Windows and Mac), Excel for the web, and Google Sheets
- Any currency
- Capacity: 2,000 items, 200 lots, 1,000 expenses and 1,000 trips per file
How it works
- Download the files instantly after purchase
- Check the platform fees and add your items as you buy them
- Fill in the sale details when an item sells. Fees, profit and the dashboard update by themselves.
Quick answers
- Who is this for? It is made for resellers and thrift flippers selling on eBay, Poshmark, Mercari, Depop, Vinted, Facebook Marketplace or Whatnot.
- Does it work out platform fees? Yes. Fees are calculated for each sale for eBay, Poshmark, Mercari, Depop, Vinted, Facebook Marketplace, Whatnot, Etsy and Grailed. Every rate is editable.
- I buy in lots or bin hauls - does that work? Yes. Add the lot once and its cost is split across its items, evenly or by estimated value. You can see when each lot has paid for itself.
- Does it help with taxes? Yes. A Schedule C style summary shows gross receipts, cost of goods sold with start and end inventory, expenses and mileage.
- Is there a monthly fee? No. It is a one-time purchase and an instant download, with no subscription. It works in Excel and Google Sheets, in any currency.
Please note
- This is a digital download. No physical item will be shipped.
- Platform fees change often. The included rates are US starting values, so check your platforms' current fees and edit them.
- This template helps with record keeping. It is not tax, legal or accounting advice.
- For use in your own business. Please don't resell or share the file.
- Not affiliated with or endorsed by eBay, Poshmark, Mercari, Depop, Vinted, Facebook, Whatnot, Etsy or Grailed.
- Designed by me with the help of AI tools. Every formula was tested in Microsoft Excel and Google Sheets.
Questions? Send me a message. I'm happy to help you get set up.
Questions people ask
Does it work out platform fees?
Yes. Fees are calculated for each sale for eBay, Poshmark, Mercari, Depop, Vinted, Facebook Marketplace, Whatnot, Etsy and Grailed. Every rate is editable.
I buy in lots or bin hauls - does that work?
Yes. Add the lot once and its cost is split across its items, evenly or by estimated value. You can see when each lot has paid for itself.
Does it help with taxes?
Yes. A Schedule C style summary shows gross receipts, cost of goods sold with start and end inventory, expenses and mileage.
Does it work in Excel and Google Sheets?
Yes. It works in Microsoft Excel 2010 or newer (Windows and Mac), Excel for the web and Google Sheets.
Is there a monthly fee?
No. It is a one-time purchase and an instant digital download. There is no subscription.
Does it work in my currency?
Yes. It works with any currency.
What if I find an error?
Message us on Etsy. You can choose another spreadsheet from our shop, free of charge (any except our Pro editions), and we will fix the error for everyone.
Get the Reseller Inventory & Profit Tracker on Etsy