Running a resale business without a structured AllChinaBuy spreadsheet is like driving without a dashboard. You might reach your destination, but you have no idea how fast you are going, how much fuel you have left, or whether you took the best route. This guide builds a reseller-specific spreadsheet system that tracks inventory, calculates profit margins, monitors sell-through rates, and predicts cash flow needs. Whether you flip sneakers on Instagram or run a full storefront, these spreadsheets become the backbone of your operation.
Profit-Centric Column Design
Reseller spreadsheets need financial columns that personal buyers ignore. Cost Price captures your landed cost including item price, agent fees, shipping, and customs duties. Sale Price records what you actually sold the item for, not what you listed it at. Platform Fee subtracts marketplace commissions like PayPal or stockx fees. Net Profit calculates the true bottom line after every expense.
Margin Percentage divides Net Profit by Sale Price to show efficiency. An item with $50 profit on $200 sale is less efficient than $40 profit on $100 sale because the margin is lower. Tracking margin percentage helps you identify which product categories deliver the best return on investment.
Inventory Status Tracking
Resellers need a Status dropdown with more granularity than personal buyers. Use Purchased, In Transit, Arrived, Listed, Sold, and Shipped to Buyers. Each status change triggers a different action in your workflow. Arrived items need photos taken. Listed items need price monitoring. Sold items need shipping labels printed.
Create a summary dashboard that counts items in each status and values them at cost price. This live inventory valuation tells you exactly how much capital is tied up at any moment. When cash flow gets tight, the dashboard shows whether you have too much money sitting in transit or in unsold stock.
Cash Flow and Reorder Forecasting
Smart resellers track average sell-through time per category. If shoes take fourteen days to sell but hoodies take thirty, your spreadsheet reveals this pattern. Use that data to time reorders so new inventory arrives just as old inventory sells through.
Add a Reorder Alert column that flags items where your current stock is below a threshold you define. When Supreme tees drop below three units, the cell turns red and you know to restock. This prevents stockouts on hot items without overinvesting in slow movers.
| Metric | Formula | Frequency | Decision |
|---|---|---|---|
| Net Profit | Sale - All Costs | Per sale | Keep or drop item |
| Margin % | Profit / Sale | Monthly | Focus categories |
| Inventory Value | SUM cost of unsold | Weekly | Cash flow |
| Sell-Through Days | AVG arrival to sale | Monthly | Reorder timing |
Find the best deals now
Browse thousands of streetwear items on our main store.
AllChinaBuy SpreadsheetRelated Resources
Frequently Asked Questions
One master sheet with a Platform column is usually enough. Export platform-specific reports using QUERY functions.
Related Articles
Start Your AllChinaBuy Spreadsheet Journey
Get free templates, expert guides, and transform how you manage every order.