AllChinaBuy Spreadsheet for Resellers: Inventory and Profit Tracking
A complete reseller-focused allchinabuy spreadsheet system for tracking inventory, calculating margins, and managing hundreds of SKUs per month.
Get the Reseller TemplateReselling internationally is a numbers game. With margins often between fifteen and thirty percent, every dollar of cost control matters. A standard allchinabuy spreadsheet tracks orders. A reseller spreadsheet tracks inventory, profit margins, sell-through rates, and return ratios across hundreds of items. This article builds the complete reseller toolkit from the ground up, adding the columns, formulas, and dashboards that turn a hobby into a data-driven business.
Reseller Column Structure
Start with the standard twelve-column order tracker, then add six reseller-specific fields: SKU, Category, Expected Resale Price, Actual Resale Price, Days to Sell, and Return Status. The SKU column links your buy-side tracker to whatever platform you sell on — eBay, Grailed, Depop, or your own store.
Expected Resale Price should be entered at purchase time, before emotional attachment or market shifts distort your judgment. Compare it to Actual Resale Price after the item sells to calculate a forecasting accuracy score. If you consistently overestimate, tighten your margin assumptions.
Profit Margin Dashboard
Build a dedicated Profit tab that pulls data from the Orders tab using SUMIF and AVERAGEIF. Calculate total cost per SKU category, total revenue from sales, net profit, and profit margin percentage. Add a chart showing monthly profit trends so you can spot seasonal patterns.
The most important metric is profit per square foot of storage space. Some items have high margins but take three months to sell, tying up capital and storage. Other items have lower margins but sell in days. The spreadsheet reveals which strategy actually wins for your niche.
| Metric | Formula | Why It Matters |
|---|---|---|
| Profit Margin | =(Resale-TotalCost)/TotalCost | Shows true return on each item |
| Days to Sell | =SaleDate-ReceivedDate | Capital turnover speed |
| Return Rate | =Returns/Sales | Quality indicator per seller |
| Sell-Through % | =Sold/Received | Inventory efficiency |
| Storage ROI | =Profit/StorageDays | Capital efficiency metric |
Inventory Aging System
Add an Inventory Status column with values: In Stock, Listed, Pending Sale, Sold, Returned, and Dead Stock. Use conditional formatting to turn Dead Stock items red after ninety days in inventory. These items need markdown pricing, bundle deals, or donation to clear space.
Calculate a monthly carrying cost per item based on your storage and insurance costs divided by total inventory count. Add this to the total cost before calculating final profit. Many resellers discover they are barely breaking even after accounting for storage.
Seller Performance for Resellers
Resellers depend on supplier consistency more than casual buyers. Build a Seller Scorecard tab that tracks defect rate, delivery speed variance, communication response time, and price stability. A seller who delivers in ten days consistently is worth more than a seller who averages twelve days with occasional thirty-day outliers.
Use this scorecard when negotiating bulk discounts. Sellers with strong performance scores get larger orders, which unlocks wholesale pricing tiers that further improve your margins.
Pro Tips
- 1Track both Expected and Actual resale prices. The gap between them is your forecasting skill score.
- 2Dead stock is not a failure; it is data. Analyze which categories and sizes become dead stock most often and stop buying them.
- 3Never skip the Return Status field. Return reasons reveal quality patterns that prevent future losses.
