Sneaker Reselling Profit Calculator Spreadsheet
Here's a confession: I lost money on my first 15 pairs. Not because I bought bad shoes — because I had no idea what my actual costs were. I was doing mental math that conveniently forgot about processing fees, shipping supplies, and the $3.75 I spent on packing tape per pair. By the time I actually built a spreadsheet and ran the numbers, I realized I'd been operating at a 2% margin for three months.
This guide gives you the exact profit calculation framework I use today, a free template structure you can replicate in Google Sheets or Excel, and real examples showing how costs stack up at different price points. No guessing. No "feels about right." Just numbers.
The One Formula Every Reseller Needs
Here's the equation that should live in your head — or better yet, in your spreadsheet:
Net Profit = Sale Price − Purchase Cost − Platform Fees − Shipping − Supplies − Taxes
Looks simple. But every one of those variables has sub-variables that most resellers ignore until it's too late. Let's break each down.
Cost Component #1: Purchase Cost (Your "All-In" Number)
This isn't just what you paid for the shoes. It's everything required to get them into your possession:
| Cost Element | Typical Range | Notes |
|---|---|---|
| Retail price | $100–$250 | What you paid Nike/SNKRS/Foot Locker |
| Sales tax on purchase | 0%–10% | $200 shoe + 8% tax = $16. Ask yourself: did I include this? |
| Shipping to you (if any) | $0–$25 | Most retailers offer free shipping over $50 |
| Bot/proxy/raffle costs | $0–$50+/pair | Bot subscription ÷ pairs copped. Don't ignore this |
| Gas/parking (in-store cops) | $3–$10 | Adds up on raffle pickup days |
So a $180 retail Jordan 1 isn't $180. In most states, with 8% sales tax, it's $194.40. That's your actual purchase cost. Start your profit math from $194.40, not $180. That $14.40 difference? That's the margin most new resellers accidentally give away.
Cost Component #2: Platform Fees (The Silent Killer)
Every platform takes a cut. The percentages look small. They're not.
| Platform | Fee Components | Typical Effective Rate | On $200 Sale |
|---|---|---|---|
| StockX (Level 1) | 9% transaction + 3% processing | 12% | −$24.00 |
| GOAT (90+ rating) | 9.5% + $0–$5 shipping + 2.9% cashout | ~15.2% | −$30.40 |
| eBay (no store, $150+) | 8% FVF, no per-order fee | 8% | −$16.00 |
| eBay ($100–$149) | 13.6% FVF + $0.40 | ~14% | −$27.60 |
| Local (Facebook, etc.) | 0% | 0% | $0.00 |
That $24–$30 difference between platforms? On 50 pairs a month, that's $1,200–$1,500 in fee savings — just by choosing the right listing platform. Factor this into your platform comparison decision before you ever list.
Cost Component #3: Shipping & Supplies (Death by a Thousand Paper Cuts)
| Supply Item | Cost Per Unit | Notes |
|---|---|---|
| Shipping box (12×10×6) | $1.25–$2.50 | Buy in bulk (100+). Single boxes at Office Depot = $4 each |
| Packing tape | $0.15–$0.30/pair | 36-pack on Amazon ≈ $18 = $0.50/roll, ~3 pairs per roll |
| Bubble wrap / packing paper | $0.50–$1.00 | Needed to protect the shoe box inside the shipping box |
| Shipping label printer toner | $0.02–$0.05/label | Thermal printer (Rollo/Zebra) eliminates ink cost |
| Tissue paper / thank-you card | $0.10–$0.50 | Optional but recommended for eBay direct sales |
Total supplies per pair: $2.00–$4.00. On 100 pairs a month, that's $200–$400 just in packaging materials. The resellers who buy boxes one at a time from Staples are hemorrhaging money they don't realize they're spending.
Buy boxes in bulk from Uline, Grainger, or theboxery.com. 100 boxes at $1.50 each beats $4 each at retail by $250. On the first order alone, you've paid for a thermal label printer.
Real Profit Calculations: Three Scenarios
Let's run the numbers on three realistic scenarios so you can see where the money actually goes:
Scenario A: Budget GR — Nike Dunk Low ($120 Sale, eBay)
| Line Item | Amount |
|---|---|
| Sale price | +$120.00 |
| Retail price + tax ($110 + 8%) | −$118.80 |
| eBay FVF (13.6% — under $150, no store) | −$16.32 |
| eBay per-order fee | −$0.40 |
| Supplies (box, tape, wrap) | −$2.50 |
| Shipping label to auth center | $0.00 (buyer paid) |
| Net Profit | −$18.02 |
This is a loss. A pair most beginners think they're making "about $10" on is actually a $18 loss after all costs. This is why GR Dunks at retail are a trap — the spread between retail and resale is too thin to absorb the fee structure. This pair needed to sell at $140+ to break even.
Scenario B: Mid-Tier Hype — Jordan 1 High ($220 Sale, eBay)
| Line Item | Amount |
|---|---|
| Sale price | +$220.00 |
| Retail price + tax ($180 + 8%) | −$194.40 |
| eBay FVF (8% — over $150, no store) | −$17.60 |
| Per-order fee (waived) | $0.00 |
| Supplies | −$2.50 |
| Net Profit | +$5.50 |
Only $5.50 profit on a pair that's selling $40 over retail. This is the reality check most new resellers need. The spread has to be meaningful to actually make money once the platform takes its cut. Rule of thumb: if your sale price isn't at least 15% above your all-in purchase cost, you're breaking even at best.
Scenario C: Real Hype — Travis Scott Release ($550 Sale, StockX)
| Line Item | Amount |
|---|---|
| Sale price | +$550.00 |
| Retail + tax ($200 + 8%) | −$216.00 |
| StockX fee (9% transaction, Level 1) | −$49.50 |
| StockX processing (3%) | −$16.50 |
| Shipping (prepaid StockX label) | $0.00 |
| Supplies | −$2.50 |
| Net Profit | +$265.50 |
| Profit Margin | 48.3% |
This is what a good flip looks like. The spread is large enough that even after StockX's 12% total fee, you're walking away with $265 profit — a 48% margin. One pair like this offsets ten losing or breakeven GR trades.
Building Your Spreadsheet: Column by Column
Here's the exact column structure I use. Build this in Google Sheets or Excel — it takes 15 minutes and will save you thousands in unforced errors:
| Column | Formula / Input Type | Example |
|---|---|---|
| A: Date Purchased | Manual input | 7/4/2026 |
| B: Shoe Name | Manual input | Air Jordan 1 High OG "Chicago" |
| C: Size | Manual input | 10.5 |
| D: SKU | Manual input | DZ5485-612 |
| E: Retail Price (pre-tax) | Manual input | $180.00 |
| F: Sales Tax Rate | Manual input (e.g., 0.08) | 8% |
| G: Total Purchase Cost | =E*(1+F) | $194.40 |
| H: Sale Date | Manual input | 7/18/2026 |
| I: Platform | Dropdown: StockX/GOAT/eBay/Local | eBay |
| J: Sale Price | Manual input | $250.00 |
| K: Platform Fee Rate | VLOOKUP from rate table | 8% |
| L: Platform Fee ($) | =J*K | $20.00 |
| M: Processing/Cashout Fee | Manual or VLOOKUP | $0.00 |
| N: Supplies Cost | Fixed $2.50 (or calculated) | $2.50 |
| O: Other Costs | Manual input (gas, bot fee, etc) | $5.00 |
| P: Net Profit | =J−G−L−M−N−O | $28.10 |
| Q: Profit Margin (%) | =P/J | 11.2% |
| R: Days to Sell | =H−A | 14 |
Pro tip: Add a "Platform Fee Table" on a separate sheet with current rates for StockX (by level), GOAT (by rating tier), and eBay (by price threshold). Use VLOOKUP or INDEX/MATCH in column K to pull the right rate automatically. When fees change — and they will — you update one table, not 500 rows.
Advanced Tracking: The Metrics That Matter
A basic profit spreadsheet tells you whether you made money. An advanced one tells you whether your business model is sustainable. Add these metrics:
1. Return on Investment (ROI) per pair
Formula: Net Profit ÷ Total Purchase Cost. A $28 profit on a $194 purchase is 14.4% ROI. Compare this against what your capital could earn elsewhere (stock market: ~8% annually). If your flipping ROI isn't beating the S&P 500, your time and risk aren't being compensated.
2. Annualized ROI
Formula: ROI × (365 ÷ Days to Sell). A 14.4% return in 14 days annualizes to 375%. That's the power of fast flipping. A 50% return on a pair that takes 6 months to sell annualizes to only 100%. Speed matters.
3. Platform Profit per Sale
Average your net profit by platform. You might discover, as I did, that eBay pairs average $42 profit while StockX pairs average $38 despite higher sale prices on StockX. Knowing this lets you optimize listing priorities.
4. Inventory Aging
Add conditional formatting: green if Days to Sell < 30, yellow if 30–60, red if 60+. Pairs sitting 90+ days are tying up capital that could be redeployed. Consider cutting prices on anything in the red zone.
Common Profit Calculation Mistakes
Mistake #1: Ignoring sales tax on the purchase. That $180 shoe costs $194.40 in an 8% tax state. A small error repeated 100 times = $1,440 in phantom profit.
Mistake #2: Counting the full sale price as revenue. Offers, promotions, and shipping discounts all reduce your actual take. An eBay pair listed at $250 might sell for $225 after the buyer's offer is accepted. Your spreadsheet should use the actual sale price, not the listing price.
Mistake #3: Forgetting about returns. Plan for a 2–3% return rate on eBay. That means 2–3 out of every 100 pairs come back. Factor this into your annual projections.
Mistake #4: Not tracking cash-out timing. StockX pays out within 2–3 business days of authentication. GOAT holds your money until you manually cash out (with that 2.9% fee). eBay Managed Payments usually hit your bank in 2–4 days but can take longer for new accounts. Float matters when you're cash-flow dependent.
Mistake #5: Pretending bot costs don't exist. If you pay $300/month for a bot subscription and cop 15 pairs that month, that's $20 per pair. Not nothing. Group buys and server costs add more. Track them.
Related Reading
- StockX vs GOAT vs eBay: Which Platform Makes You the Most Money?
- How to Price Sneakers for Resale (with Pricing Formula)
- Sneaker Reselling Tax Guide (US Edition) — how profits impact your tax return
Frequently Asked Questions
What's a good profit margin target for sneaker reselling?
Aim for 15% net margin minimum. Below 10%, you're one return or price drop away from losing money. Above 30% is excellent but usually requires either retail wins (SNKRS, Confirmed) or early investment in pairs that appreciate significantly. The realistic sweet spot for consistent, volume-based reselling is 12–20% net after all costs.
Should I include my time in the profit calculation?
At minimum, track your hours and calculate your effective hourly rate. If you're spending 20 hours a week to make $400 profit, that's $20/hour — below minimum wage in some states. Include everything: driving to pickups, listing, packing, shipping runs, customer service. Many resellers realize their "side hustle" pays them less per hour than a part-time job at a shoe store — where they'd get an employee discount on the same shoes.
How do I account for pairs that don't sell?
Create a separate "Dead Stock" tab in your spreadsheet. After 90 days without a sale, move the pair there. Mark it at current market value (conservative estimate — use the low ask on StockX). This gives you a realistic picture of your tied-up capital. If dead stock exceeds 20% of your total inventory value, you're buying wrong. Pairs that sit forever are either the wrong size, the wrong colorway, or purchased at the wrong time in the hype cycle.
What's the minimum sale price needed to make a retail-purchased sneaker profitable?
The breakeven formula: Sale Price = (Retail + Tax + Supplies) ÷ (1 − Fee Rate). For a $180 retail shoe with 8% tax on eBay ($150+ category, 8% fee): ($180 + $14.40 + $2.50) ÷ (1 − 0.08) = $196.90 ÷ 0.92 = $214.02. That's your breakeven. Anything below $214 on a $180 retail Jordan is a loss. If you're selling for $210, you're actually losing ~$3.70 per pair.
Can I use the same spreadsheet for local sales and consignment?
Yes — just add rows for the different cost structures. Local sales (Facebook Marketplace, OfferUp, in-person meets) have zero platform fees but add transportation costs and time. Consignment shops (Round Two, Urban Necessities, local stores) typically take 15–25% commission but handle everything — listing, authentication, shipping. Your spreadsheet should include a "Channel" column that pulls the right fee structure so you can compare profitability across all selling methods.
Last updated: July 2026. Platform fees current as of this date. Want the actual spreadsheet template? Drop us a line and we'll send you the Google Sheets link.
