Reseller Inventory Tracker in Google Sheets: eBay, Poshmark & Etsy Flipping Spreadsheet (2026)
Most resellers think they're profitable until they build a real tracker. Platform fees alone eat 12–20% of every sale before shipping. A Google Sheets reseller tracker shows you actual profit per flip — so you stop congratulating yourself on sale price and start focusing on margin.
Table of Contents
- Why Resellers Need a Real Tracker (Not a Notes App)
- Platform Fee Reference: eBay, Poshmark, Mercari, Depop, Etsy
- The Inventory Tab: Every Column You Need
- The Sold Items Log: Recording Completed Sales
- Profit Formulas That Account for Every Cost
- Inventory Aging: Know What's Been Sitting Too Long
- Dashboard: Monthly Profit, ROI, and Category Analysis
- Taxes for Resellers: What You Owe and What You Can Deduct
- 6 Reseller Tracking Mistakes That Shrink Your Profits
- Want the Full Template Pre-Built?
Why Resellers Need a Real Tracker (Not a Notes App)
The typical new reseller workflow: buy things at thrift stores, list on eBay or Poshmark, money shows up in the account, feel successful. What's missing is the math.
Take a pair of Levi's you bought at Goodwill for $6. You list on Poshmark for $35. It sells. But before you get paid, Poshmark takes 20% ($7). You shipped for $6 using Poshmark's label. Your actual profit: $35 − $6 (cost) − $7 (fee) − $6 (shipping) = $16. Not $29. Not $35. $16.
Now how long did the item sit? How many items are you sourcing per week? What's your average ROI by category? Which sourcing locations are your best performers? Without a tracker, you're flying blind. You feel busy. You might not be profitable.
The one number that matters: Net Profit Per Item = Sale Price − Sourcing Cost − Platform Fee − Shipping − Packaging Supplies. If you can't calculate this for every item, you don't have a business — you have a hobby with paperwork.
Platform Fee Reference: eBay, Poshmark, Mercari, Depop, Etsy (2026)
Fees change. Below are the 2026 rates for the major reselling platforms. Build these into your spreadsheet as named constants so you can update them in one place when they change.
| Platform | Selling Fee | Payment Processing | Total Effective Rate |
|---|---|---|---|
| eBay | ~13.25% (varies by category) | Included in eBay's rate | ~13–15% |
| Poshmark | 20% on items ≥$15; flat $2.95 on items <$15 | Included | 20% on most items |
| Mercari | 10% selling fee | 2.9% + $0.30 per transaction | ~13% |
| Depop | 10% selling fee | 2.9% + $0.30 (PayPal) | ~13% |
| Etsy | 6.5% transaction fee + $0.20 listing fee | 3% + $0.25 payment processing | ~10% + $0.45 |
| Facebook Marketplace | 5% per shipment (or flat $0.40 on sales <$8) | Included | 5% |
⚠️ Promoted listings add costs too. If you run promoted listings on eBay or Etsy ads, that's an additional 2–15% off your proceeds. Track promoted sales separately from organic so you know your true ad-driven profit margin.
The Inventory Tab: Every Column You Need
Your active inventory tab tracks every item you currently have listed or in queue. One row per item. When it sells, the row moves to your Sold Items Log — not deleted.
| Column | What to Enter | Notes |
|---|---|---|
| Item ID / SKU | Your internal reference number | Sticker or label on item; makes finding it fast |
| Item Description | Brand + Item + Size/Condition | Match to your listing title for easy lookup |
| Category | Clothing / Electronics / Books / Shoes / etc. | Category dashboard shows which niches are profitable |
| Sourcing Location | Goodwill / Estate Sale / Wholesale / etc. | Track which sources yield best ROI |
| Date Sourced | Date you acquired the item | Used in aging formula |
| Sourcing Cost ($) | What you paid, including any sourcing trip allocation | Be honest here — it affects your true profit |
| Platform Listed | eBay / Poshmark / Mercari / Multi | Use dropdown list for consistency |
| Date Listed | When you first listed it | Paired with Date Sourced for aging |
| List Price ($) | Current asking price | What you'd make before fees if sold today |
| Status | Listed / Draft / Sold / Donated / Trashed | Conditional formatting: green = listed, red = sold, yellow = draft |
| Days on Market | =TODAY()-Date Listed (auto) | Triggers aging alert at 30, 60, 90 days |
The Sold Items Log: Recording Completed Sales
When an item sells, move it (or copy it) to the Sold Items Log and add the sale details. This tab is your income record and your profit report. Never delete rows — you need them at tax time.
Additional Columns for Sold Items
- Date Sold — when the sale completed
- Sale Price ($) — what the buyer paid
- Platform — where it sold (may differ from where listed)
- Platform Fee ($) — calculated formula based on platform fee %
- Shipping Cost ($) — your actual cost (not what buyer paid)
- Packaging Cost ($) — boxes, bubble wrap, tape allocation
- Other Costs ($) — promoted listing fees, photography, etc.
- Net Profit ($) — auto-calculated (see formulas below)
- ROI (%) — Net Profit ÷ Sourcing Cost
- Days to Sell — Date Sold − Date Listed
Tip: Keep your Inventory and Sold Log on separate tabs, but use the same row structure. When something sells, copy the inventory row to Sold Log and add the sale columns. This preserves your sourcing data alongside the sale outcome without complex formulas across tabs.
Profit Formulas That Account for Every Cost
These are the core formulas. Assume your Sold Log has: Sale Price in column G, Platform in column H, Sourcing Cost in column F, Shipping Cost in column I, Packaging in column J.
Platform Fee (Dynamic by Platform)
Net Profit Per Item
ROI Per Item (%)
Monthly Net Profit (Dashboard Summary)
Total Inventory Value at Cost
Inventory Aging: Know What's Been Sitting Too Long
Aged inventory is capital sitting in your closet earning nothing. The best resellers run tight inventory turns — sell fast, recycle capital into new sourcing. Track aging to know when to reprice, relist, or donate.
Days on Market Formula
Aging Category (for Conditional Formatting)
Apply conditional formatting to the Days on Market column:
- Green (0–29 days): Fresh — hold price
- Yellow (30–59 days): Aging — consider small price reduction
- Orange (60–89 days): Stale — drop 20%, relist on different platform
- Red (90+ days): Clear it — deep discount, bundle deal, or donate
💡 The 90-Day Rule
If an item hasn't sold in 90 days at any price, you misread demand. The sourcing cost is already spent — donate it, take the small tax deduction, and put that closet space toward faster-turning inventory. Sunk cost fallacy is real in reselling.
Dashboard: Monthly Profit, ROI, and Category Analysis
Your dashboard tab is where the business story emerges. At a glance you should be able to answer: Am I actually profitable this month? Which categories have the best ROI? Which platform is performing best?
Dashboard Metrics to Include
Monthly Dashboard
- Total sales revenue (this month, YTD)
- Total platform fees paid (this month, YTD)
- Total shipping costs (this month, YTD)
- Total net profit (this month, YTD)
- Items sold (this month, YTD)
- Average profit per item
- Average ROI % by category
- Best-performing category (highest total profit)
- Current inventory value (at cost)
- Items aging 60+ days (count — action required)
- Average days to sell
- Platform breakdown: revenue split across eBay/Poshmark/etc.
Category ROI Analysis
Create a small summary table for category performance. This tells you where to spend your sourcing time:
| Category | Items Sold | Total Revenue | Total Profit | Avg ROI % |
|---|---|---|---|---|
| Clothing — Women's | =COUNTIF(Category, "Women's") | =SUMIF(Category, "Women's", SalePrice) | =SUMIF(Category, "Women's", NetProfit) | =TotalProfit/TotalCost |
| Electronics | … | … | … | … |
| Shoes | … | … | … | … |
Sort by Avg ROI % descending. Double down on your top two categories. Stop sourcing your bottom two until you figure out why they underperform — is it your sourcing cost, your pricing, or just a weak market on your chosen platforms?
Taxes for Resellers: What You Owe and What You Can Deduct
If your reselling is a business (not just occasional personal item sales), the IRS treats it as self-employment income. The rules are actually reasonable — you can deduct a lot — but you need records.
What's Taxable
Your taxable income = Net profit (revenue minus allowable deductions), not gross sales. The 1099-K forms you receive from platforms report gross sales, not profit. You'll need your expense records to reduce that number to what's actually taxable.
Deductible Expenses for Resellers
| Expense | Deductible? | Notes |
|---|---|---|
| Sourcing costs (thrift purchases, estate sales) | Yes — Cost of Goods Sold | What you paid for items you sold |
| Platform fees | Yes — Business expense | eBay fees, Poshmark commissions, etc. |
| Shipping costs | Yes | Postage, labels, carrier fees |
| Packaging supplies | Yes | Boxes, bubble wrap, tape, poly mailers |
| Mileage to sourcing locations | Yes — at IRS mileage rate | 2026 rate: check IRS.gov; log every trip |
| Photography equipment/lighting | Yes | Phones used for business can be partially deducted |
| Steamer, cleaning supplies for items | Yes | Prep supplies are business expenses |
| Storage unit rental | Yes | If used exclusively for inventory |
| Spreadsheet/software subscriptions | Yes | Tracking tools are business expenses |
⚠️ The 1099-K trap: Platforms report your gross sales to the IRS. If you received $12,000 in eBay payments but only made $2,800 in profit after all costs, you're not taxed on $12,000 — but you need your expense records to prove it. Your Google Sheets tracker is your proof.
Need a Done-for-You Financial Tracker?
SheetStackStudio's Google Sheets templates are built for self-employed sellers and side hustlers. Instant download — no setup required.
Browse Templates on Etsy →6 Reseller Tracking Mistakes That Shrink Your Profits
1. Using Sale Price as "Profit"
The most common reseller error. A $40 sale is not $40 profit. After a 20% Poshmark fee ($8), $7 shipping, and $6 sourcing cost, you made $19. Celebrate the real number, not the gross number.
2. Not Tracking Sourcing Trip Mileage
The IRS mileage deduction (67+ cents/mile as of recent years) adds up fast for active resellers. A 20-mile round trip to your favorite thrift store, twice a week, is 2,000+ deductible miles a year. That's a $1,300+ deduction you're skipping. Add a Mileage Log tab to your spreadsheet.
3. Ignoring Items That Don't Sell
Donations are deductible at fair market value (what similar items sell for at thrift stores — typically 30% of original retail). Log every donation in your tracker with an estimated FMV. At year end, that's real tax deductions you'd otherwise miss.
4. Mixing Personal Sales with Business Sales
Selling your old couch is not business income. Buying 12 pairs of jeans to resell is. Mix them in one eBay account with no tracking and you'll overpay taxes. Create a separate "personal disposal" section in your sold log to distinguish the two.
5. Not Tracking Per-Platform Performance
Many resellers list everywhere and assume it's all equal. It's not. Some categories do far better on Poshmark than Mercari. Some brands sell faster on Depop. Without platform-level data in your tracker, you're guessing instead of allocating your listing time intelligently.
6. Starting the Tracker Mid-Year
If you started reselling in January and don't build your tracker until October, you're reconstructing 9 months of data. Most platform dashboards show historical sales, but sourcing costs are gone if you didn't log them. Start the tracker on Day 1 — even a bare-bones version beats a perfect tracker started late.
Want the Full Template Pre-Built?
Building this from scratch takes 4–6 hours if you're comfortable with Google Sheets. The result is a custom tracker fitted exactly to your platforms and sourcing categories. Use the structure above and the formulas provided — they cover everything a reseller needs.
If you'd rather start tracking today, browse SheetStackStudio's digital templates on Etsy. Templates built for self-employed sellers — with pre-built tabs, formulas, and an instructions guide. Instant download to your Google Drive.
💡 The Bottom Line
Reselling is a real business — treat it like one. Track every item from source to sale, log every cost, and review your category ROI monthly. The resellers who scale are the ones who know their numbers. A Google Sheets tracker costs nothing and gives you everything you need to run a tight operation.