AllChinaBuy Spreadsheet for Resellers: Profit Tracking Guide

Reselling replica sneakers and streetwear requires the same discipline as any retail business. Without accurate cost tracking, you are flying blind on profit margins, tax obligations, and inventory turnover. This guide shows how experienced resellers structure their allchinabuy spreadsheet to manage dozens of items, multiple platforms, and complex shipping math.

Why Resellers Need a Different Spreadsheet Structure

Casual buyers track items they plan to keep. Resellers track items they plan to sell, which means additional columns for platform fees, shipping to customers, estimated sale price, and net profit. A reseller sheet also needs inventory status columns: In Transit, In Hand, Listed, Sold, and Shipped to Buyer. These extra data points transform a simple tracker into a business management tool.

Essential Reseller Columns

Beyond the standard tracking columns, add these reseller-specific fields to your allchinabuy spreadsheet.

1. Estimated Resale Price — Based on current market demand and comparable listings
2. Platform Fee — Usually 10-15% for major marketplaces
3. Shipping to Buyer — Domestic shipping cost estimate
4. Net Profit = Sale Price - Item Cost - Platform Fee - Shipping - Freight Share
5. ROI Percentage = Net Profit / Total Cost * 100
6. Days Listed — Tracks how long an item sits before selling
7. Platform — Where you plan to list: eBay, Instagram, local, etc.

Shipping Math for Resellers

Resellers must calculate freight cost per item, not per haul. If your total freight is $60 for a 5kg haul containing four items, allocate cost by weight or value. Heavier items like boots bear more freight share than light items like t-shirts. Record this allocation in your spreadsheet so each item shows its true cost basis.

Margin Targets by Category

Not every item is worth reselling. Use your spreadsheet to enforce minimum margin rules. Shoes typically need 40% ROI to cover platform fees and freight. Accessories can profit at 25% because they are lighter and cheaper to ship. T-shirts and hoodies fall in the middle at 30-35%. Filter your prospective purchases by ROI before ordering.

Inventory Turnover Tracking

Dead inventory kills reseller profits. Create a Days Listed column and set conditional formatting to highlight items unsold after 30 days in yellow and 60 days in red. When an item hits red, either drop the price, switch platforms, or bundle it with a faster seller. Your spreadsheet should tell you which items are assets and which are liabilities.

Tax and Record Keeping

Resellers in most jurisdictions must report income. Your allchinabuy spreadsheet doubles as a tax record if you add columns for Sale Date, Sale Price, Platform, and Buyer Location. Export this data quarterly for your accountant or tax software. Good records prevent audits and maximize deductible expenses like freight and platform fees.

Frequently Asked Questions

Treat It Like a Business

Reselling is fun, but it is still commerce. The resellers who last are the ones who track every dollar, review their data monthly, and adjust strategies based on numbers rather than hype. Use your allchinabuy spreadsheet as the backbone of a disciplined operation, and the profits will follow.