CNShopper Spreadsheet for Resellers: Profit Tracking System
May 10, 2026 · 9 min read
Reselling streetwear and sneakers is a numbers game. The difference between a profitable reseller and a struggling one often comes down to one tool: a cnshopper spreadsheetbuilt for resale. This guide shows resellers how to track cost per unit, selling price, platform fees, shipping to customers, days in inventory, and net profit — all in one streamlined sheet that turns order chaos into a clear profit dashboard.
Source inventory to resell? Browse our latest drops.
Browse OOCBuyWhy Resellers Need a Different Spreadsheet
A basic order tracker tells you what you bought and when it arrives. A reseller-focused cnshopper spreadsheet answers harder questions: What is my true profit margin after all fees? Which items sit in inventory too long? Which supplier gives me the best margin? Which platform moves inventory fastest?
Without these answers, you are guessing. Guessing leads to overstocking low-margin items, underpricing winners, and tying up cash in inventory that moves slower than expected. A cnshopper spreadsheet designed for reselling replaces guessing with data.
The Reseller Column Setup
Start with the standard tracking columns, then add these reseller-specific fields:
- Cost per Unit: Your purchase price including shipping to you
- List Price: The price you first list the item at
- Sold Price: The actual price the customer pays
- Platform: eBay, Grailed, StockX, Instagram, etc.
- Platform Fee %: Usually 10–15 percent depending on platform
- Shipping to Customer: Cost you pay to ship the sold item
- Net Profit: Formula: Sold Price - Cost per Unit - Platform Fee - Shipping to Customer
- Profit Margin %: Formula: Net Profit / Sold Price
- Days in Inventory: Formula: Sold Date - Received Date
- Inventory Status: In Stock, Listed, Sold, Returned, Defective
Profit Tracking Formulas
These three formulas are the mathematical core of your reseller cnshopper spreadsheet:
- Net Profit: =Sold_Price - Cost_per_Unit - (Sold_Price * Platform_Fee_pct) - Shipping_to_Customer
- Margin %: =Net_Profit / Sold_Price (format as percentage)
- Days in Inventory: =IF(Sold_Date="", TODAY(), Sold_Date) - Received_Date
Wrap these in ARRAYFORMULA so they auto-fill for every new row. Your cnshopper spreadsheet now calculates profit in real time as you enter sales data.
Platform Fee Comparison
| Platform | Fee Structure | Avg Fee % | Payment Hold |
|---|---|---|---|
| eBay | Final value + insertion | 12.9% + $0.30 | None (PayPal may hold) |
| Grailed | Final value fee | 9% | None |
| StockX | Transaction fee | 9.5% + 3% processing | Until authentication |
| Depop | Final value fee | 10% | None |
| Instagram / DM | Payment processor only | 2.9% + $0.30 | None |
New to Reselling?
Start with our beginner guide to build your first tracking sheet before adding reseller columns.
Beginner GuideDashboard Tabs for Resellers
A single master tab becomes overwhelming at volume. Create these dedicated tabs in your reseller cnshopper spreadsheet:
- Inventory: Items received but not yet sold. Sort by days in inventory to spot dead stock.
- Active Listings: Items listed for sale with platform, list price, and views.
- Sales History: Completed sales with actual sold price, fees, net profit, and customer.
- Supplier Performance: Average margin, defect rate, and lead time per supplier.
- Monthly P&L: Summary of revenue, costs, fees, and net profit by month.
Dead Stock Alerts
Inventory that sits unsold for 60+ days ties up cash and usually needs a price cut. Use conditional formatting to highlight items in inventory longer than 30 days (yellow), 60 days (orange), and 90 days (red). This visual system pushes you to reprice, bundle, or discount before stock becomes a total loss.
FAQ
Should I track unsold items differently than sold ones?
Yes. Keep a separate "Inventory" tab for unsold items with a column for "Days in Inventory." Move rows to "Sales History" only when sold. This prevents your active view from getting cluttered.
How do I handle returns in my sheet?
Add a "Returned" status. When an item comes back, change the status, add a note with the reason, and subtract the sale from your monthly P&L. Do not delete the original sale row.
Can I track multiple platforms in one sheet?
Absolutely. The "Platform" column lets you filter sales by where they happened. Use a pivot table to compare performance across platforms monthly.
What margin should I aim for?
After all fees and shipping, a sustainable reseller margin is 25–40 percent. Below 20 percent leaves no room for returns, defects, or price drops. Your cnshopper spreadsheet reveals your true margin, not your guessed one.
Turn Data Into Profit
Reselling without a cnshopper spreadsheet is gambling. Reselling with one is a business. You know your true costs, your real margins, your slow movers, and your star suppliers. Every decision stops being a guess and starts being a data-driven move. Build your reseller sheet today and watch your margins improve within your first month.
For the complete tracking foundation, see our cnshopper spreadsheet ultimate guide. Source your next batch of inventory at OOCBuy.