Hubbuycn Spreadsheet for Resellers
Resellers face unique challenges that casual buyers never encounter: multi-platform sales, inventory turnover, fee calculations, and margin pressure across hundreds of SKUs. A standard tracker is not enough. This hubbuycn spreadsheet for resellers guide covers specialized columns, formulas, and workflows built specifically for resale operations.
Whether you flip on StockX, GOAT, eBay, or local marketplaces, the core principle is the same: every penny must be tracked, every fee must be accounted for, and every decision must be data-driven.
Our Reseller Pro Dashboard template includes every column and formula mentioned in this guide.
Get Reseller TemplateEssential Reseller Columns
- SKU / Product Code: Your internal inventory code. Essential when you carry multiple sizes or colorways of the same model.
- Platform: StockX, GOAT, eBay, Grailed, local. Each platform has different fee structures, and you need to track performance per channel.
- Platform Fee %: Enter the commission rate (e.g., 12.5% for StockX). Use this in profit calculations rather than flat fee estimates.
- Listing Price: What you actually list the item for, not what you hope to get.
- Net Revenue: Formula = Listing Price * (1 - Platform Fee %). This is the real money you receive before shipping the item to the buyer.
- Total Cost: Product cost + inbound shipping + any agent fees. This is your true breakeven point.
- Net Profit: Formula = Net Revenue - Total Cost - Outbound Shipping. The only metric that tells you if a deal is actually profitable.
- Days to Sell: Track how long each item sits in inventory. Slow movers drain capital and storage space.
- ROI %: Formula = Net Profit / Total Cost. Expressed as a percentage, this normalizes profitability across items with different price points.
- Inventory Status: In Stock, Listed, Sold, Shipped, Returned. More granular than basic order tracking.
Platform Fee Comparison
| Platform | Fee % | Payout Speed | Best For | Notes |
|---|---|---|---|---|
| StockX | 12.5% | 1-2 days | Sneakers | Level-based discounts available |
| GOAT | 9.5% + $5 | 2-3 days | Sneakers | Consignment or instant options |
| eBay | 13.25% | 1 day | Variety | Store subscriptions reduce fees |
| Grailed | 9% | 2-3 days | Streetwear | PayPal fees additional |
| Local | 0% | Instant | Cash deals | Meet in safe public locations |
Inventory Turnover Analysis
The most successful resellers do not just track individual deals; they analyze portfolio performance. Calculate your average Days to Sell per category. If Shoes take 45 days but Accessories sell in 12, you know where to allocate capital.
Track your monthly ROI by platform. You might discover that eBay yields lower per-item margins but higher volume, while StockX has better margins but slower turnover. These insights shape purchasing decisions and prevent over-investment in slow categories.
Reseller Workflow Tips
- Weekly P&L Review: Every Sunday, review net profit by platform and category. Kill underperforming categories ruthlessly. Double down on winners.
- Capital Allocation Tracker: Maintain a running total of cash tied up in unsold inventory. Never let unsold inventory exceed 60% of your available capital.
- Seasonal Adjustment: Track sell-through rates by month. Hoodies sell better in fall. Sneakers spike before holidays. Use this to time your bulk purchases.
- Return Rate Monitor: If a platform or category shows rising return rates, investigate immediately. Returns destroy margins faster than any fee structure.
Reseller FAQ
Should I track unsold inventory differently than sold items?
Yes. Use separate tabs: "Inventory" for unsold items and "Sales" for completed transactions. The Inventory tab focuses on days-held and capital-tied-up. The Sales tab focuses on actual profit and ROI realization.
How do I handle items that never sell?
Set a "Max Hold Days" rule (e.g., 90 days). When an item exceeds this threshold, either discount it for quick liquidation or donate it for a tax deduction. Dead inventory is a cash trap.
Should I include storage costs in my profit formula?
Only if you pay for external storage. Home-based resellers typically absorb storage costs into overhead. If you rent warehouse space, add a per-item storage cost column based on square footage used.
How do I track multi-item bundles?
Enter the bundle as a single line item with a "Bundle" category. In the Notes column, list the individual items and their estimated split values. For tax purposes, keep a separate detailed breakdown in an external document.
Continue Your Learning
Ready to Start Tracking?
Download our free hubbuycn spreadsheet templates and start organizing your orders smarter today.