Reseller Spreadsheet: eBay, Poshmark & Mercari Profit Tracker

Selling on four apps makes it hard to know what you actually keep: eBay takes 13.6% plus a per-order fee, Poshmark takes 20% (or 2.95 under 15), Mercari 10%, Depop 3.3% + 0.45, Whatnot 8% plus processing. This tracker works out every platform's fee per sale from editable presets, pulls each item's cost from your inventory by SKU, and shows net profit, ROI and days to sell. It flags stale stock at 30, 60 and 90 days, logs your sourcing miles, and checks each platform's 1099-K against your own records before tax season.

What you get:

• Sales tab: pick the SKU and platform, type price, shipping and label cost; fees, net profit, ROI % and days to sell calculate for you
• Fee presets for eBay (13.6% + 0.40/order), Poshmark (20% or 2.95 flat under 15), Mercari (10%), Depop (3.3% + 0.45) and Whatnot (8% + 2.9% + 0.30), all editable; Promoted / Boost % and a per-sale fee override
• Inventory tab: SKU, purchase date, source (thrift, garage sale, retail arbitrage, estate sale), cost and storage location; status Listed / Sold / Donated is automatic
• Days in stock with Watch (30+), Slow (60+) and Stale (90+) flags, plus a Dashboard list of your oldest unsold items
• Dashboard: revenue, fees, net profit, ROI, items sold, average days to sell, inventory value at cost, tax set-aside; month-by-month table and charts
• Profit by platform and by sourcing place, so you know where to sell and where to shop
• 1099-K check: each platform's reported gross vs your recorded sales, with Matches / Form higher / Form lower
• Mileage log for sourcing trips at the 2026 IRS rates (72.5 cents before 1 July, 76 cents from 1 July) plus an Expenses tab

Included files:

• Reseller Profit and Inventory Tracker.xlsx (blank, fee presets filled in)
• Reseller Profit and Inventory Tracker - SAMPLE.xlsx (a full year of demo flips so you can see every chart working)
• 'Start here' instructions tab inside each file

Works in: Microsoft Excel 2019, 2021, Microsoft 365 (Windows and Mac), Google Sheets (free), LibreOffice. One .xlsx file for both Excel and Google Sheets; no separate versions to mix up.

After purchase you get an instant download link by email (Payhip). This is a DIGITAL DOWNLOAD. Nothing physical will be shipped.

Refunds: because this is an instantly downloadable file, sales are final, but if the file doesn't open or a formula misbehaves, email me and I will fix it or refund you.

Designed, built and tested by me. I used AI tools to help write formulas and copy; every formula was recalculated and checked against hand calculations before listing.

This is a planning and record-keeping tool, not legal, tax or accounting advice.