AllChinaBuy Spreadsheet for Resellers

How resellers use the allchinabuy spreadsheet to maximize profit, track inventory, and scale their fashion resale business efficiently.

Updated May 20268 min read

Ready to start tracking your hauls?

Start Now

Reselling fashion from China is a numbers game. Your ability to track costs, calculate margins, and manage inventory determines whether you turn a profit or bleed money on every haul. The allchinabuy spreadsheet is the tool that separates hobbyists from professionals. This guide shows resellers exactly how to build a sheet that drives real business results.

The Reseller Mindset

Every purchase is an investment. You are not buying clothes for yourself. You are buying inventory for your customers. That means every dollar counts, every delay matters, and every mistake eats into your margin. A spreadsheet transforms gut feelings into data-driven decisions.

Essential Reseller Columns

Resellers need more than basic tracking. Your sheet should function as a lightweight enterprise resource planning tool. Here are the columns that matter most.

ColumnPurposePriority
Item NameIdentify product for reorderingCritical
Total Landed CostTrue cost including all shippingCritical
Selling PriceYour listed price on platformsCritical
Platform FeeeBay, Depop, Grailed commissionCritical
Net ProfitWhat you actually keepCritical
Margin %Profit as percentage of revenueHigh
Days to SellInventory velocity trackerHigh
Restock FlagYes/No based on margin & speedMedium

Margin Math That Matters

Most resellers calculate profit incorrectly. They subtract item cost from selling price and call it a day. The real calculation includes agent fees, domestic shipping, international shipping, packaging, platform commission, payment processing, and returns allowance. Your allchinabuy spreadsheet should capture every single one of these.

Net Profit = SellingPrice - TotalLandedCost - PlatformFee - PaymentFee - (SellingPrice * ReturnRate)

Inventory Velocity Tracking

A 50% margin means nothing if the item takes 8 months to sell. Track the date you list each item and the date it sells. Calculate days-on-market. After 90 days, consider dropping the price or discontinuing that product. High margin plus fast turnover equals a winning product. High margin plus slow turnover ties up your cash.

Category Winners and Losers

Not every category performs equally. Use your spreadsheet to compare margins across product types. Shoes might have higher upfront costs but sell faster. T-shirts might have thin margins but move in volume. Jackets might have great margins but only sell in winter. Data reveals what intuition misses.

Scaling From Side Hustle to Business

When you are buying 5 items a month, manual tracking is fine. At 50 items, it breaks. At 200 items, it is impossible. The spreadsheet scales with you. Add tabs for each supplier, each season, or each selling platform. Use QUERY functions to build summary dashboards. Create templates for repeat orders so you are not rebuilding the wheel every haul.

Get the Reseller Template

Our pre-built reseller sheet includes all the columns, formulas, and dashboard views described above. Plug in your numbers and start making data-driven decisions today.

Download Reseller Template

Handling Returns and Disputes

Returns are part of the reseller game. Add a Return Amount column and a Return Reason column. Track which suppliers generate the most returns. Over time, this data tells you who to avoid and who to double down on. One bad supplier can erase the profit from five good ones.

Frequently Asked Questions

What margin should I aim for?

Minimum 30% after all fees. Aim for 40-50% on most items. Luxury or rare pieces can justify lower margins if turnover is fast.

How do I track unsold inventory?

Use a Status column with values like Listed, Sold, Returned, and Archived. Filter by Listed to see your current inventory at any time.

Should I track every item individually?

Yes. Even identical items can have different landed costs due to exchange rate fluctuations or shipping batch differences. Individual tracking keeps your profit data accurate.

Final Thoughts for Resellers

The resellers who win are the ones who treat their spreadsheet like a business dashboard, not a shopping list. Every row is a profit opportunity. Every column is a decision input. Build your allchinabuy spreadsheet with discipline, update it with consistency, and let the data guide your growth.

Get the AllChinaBuy Spreadsheet

Join thousands of resellers tracking their fashion hauls smarter. Download free templates and start optimizing your workflow today.