ACBuy Spreadsheet for Resellers: Scaling from Side Hustle to Real Income
Reselling is a numbers game, and most resellers lose because they do not track the numbers. An ACBuy spreadsheet built for resale transforms guesswork into precision. From sourcing cost to platform fees to net margin, this guide shows resellers how to build a tracker that reveals which products actually make money — and which silently drain profits.
The Reseller's Profit Formula
Net Profit = Resale Price - Product Cost - Agent Fees - Domestic Shipping - International Shipping - Platform Fees - Packaging - Time Cost. Most resellers calculate only the first two terms and wonder why their bank account does not grow.
Your ACBuy spreadsheet must capture every cost. Create a dedicated 'Reseller Dashboard' tab with these exact columns: Product, Source Cost (product + agent + domestic), Shipping (international actual), Platform Fee (% of resale price), Packaging, Net Profit, Margin %, ROI Days (from purchase to sale), and Platform (StockX, eBay, GOAT, Grailed).
Critical rule: Record source cost immediately upon purchase. Waiting until items arrive introduces recall bias. You will forget agent fees, underestimate domestic shipping, and inflate your perceived margin by 15-30%.
Margin Thresholds: When to Buy, When to Pass
Not every item that sells for more than you paid is a good buy. Platform fees, shipping volatility, and time-to-sale all erode apparent profit. Resellers need clear margin thresholds in their ACBuy spreadsheet to avoid emotional buying.
Set minimum margins by platform. StockX takes 9.5% + transaction fees. eBay takes 13.25% + promoted listing costs if you use them. GOAT takes 9.5% + $5 seller fee. Grailed takes 9%. Your ACBuy spreadsheet should auto-calculate platform-specific net margin using a lookup table.
Use conditional formatting to highlight rows where Net Margin % falls below your threshold. For sneakers, we recommend 25% minimum. For apparel, 35% minimum (apparel moves slower). For accessories, 40% minimum (niche market, higher risk).
When a row turns red, you do not buy. No exceptions. This mechanical discipline separates profitable resellers from hobbyists who subsidize their 'business' with their day job.
Inventory Velocity Tracking
Capital tied up in slow inventory is capital not buying fast inventory. Add a 'Days Listed' column to your ACBuy spreadsheet. When status changes to 'Received,' start the clock. When it changes to 'Resold,' record the days.
Calculate average velocity by category. Sneakers average 12 days. Hoodies average 28 days. Jackets average 45 days. If your ACBuy spreadsheet shows hoodies consistently taking 60+ days, stop buying hoodies regardless of margin. Slow inventory kills cash flow.
Advanced: add a 'Capital Efficiency Score' column. Formula: (Net Profit / Source Cost) / Days to Sale * 365. This annualized ROI metric reveals which items deliver the best return on your tied-up capital. A 40% margin item that sells in 60 days has lower capital efficiency than a 25% margin item that sells in 10 days.
Tax Season Without Tears
Tax authorities do not care about your margins. They care about revenue minus documented costs. A sloppy ACBuy spreadsheet means overpaying taxes, underreporting deductions, or worse — an audit triggered by inconsistent records.
Add these tax columns: Purchase Date (for cost basis), Sale Date (for revenue recognition), Platform Invoice Number, and Shipping Receipt Link. Link to digital receipts stored in a dedicated Google Drive folder.
Quarterly, export your ACBuy spreadsheet as CSV and hand it to your accountant. With proper columns, they can calculate cost of goods sold, shipping deductions, platform fee deductions, and home office percentage without asking you a single question.
Resellers who treat their ACBuy spreadsheet as a financial record from day one save 5-10 hours during tax season and typically claim $500-2,000 more in legitimate deductions than those who reconstruct records from memory.
Scaling from 10 to 100 Orders Monthly
At 10 orders per month, a simple ACBuy spreadsheet is sufficient. At 100, you need systems. The transition point is usually 30 orders — when manual updates consume more than 2 hours daily.
First, split into two workbooks: 'Operations' (active orders, QC photos, tracking) and 'Finance' (costs, margins, taxes, analytics). Link them with IMPORTRANGE. This prevents the bloat that makes large sheets unusable.
Second, automate status updates. Use Zapier to watch your email for agent shipping confirmations and update Status automatically via webhook to Google Sheets. This alone saves 30 minutes daily at volume.
Third, batch your workflow. Dedicate Monday to QC review and listing, Wednesday to shipping logistics, Friday to financial reconciliation. Batching prevents context-switching overhead and keeps your ACBuy spreadsheet updated in structured sprints rather than chaotic ad-hoc entries.
| Platform | Fee % | Avg Sale Days | Min Margin | Capital Efficiency |
|---|---|---|---|---|
| StockX | 9.5% + txn | 8-14 | 25% | Very High |
| GOAT | 9.5% + $5 | 10-18 | 25% | Very High |
| eBay | 13.25% | 15-30 | 30% | Medium |
| Grailed | 9% | 20-45 | 30% | Medium |
| Depop | 10% | 25-60 | 35% | Low |
| Direct (IG/Discord) | 0-3% | 7-21 | 20% | High |
Reseller Templates with Profit Tracking Built In
Our reseller-specific ACBuy spreadsheet templates include platform-specific fee calculators, margin thresholds, inventory velocity tracking, and tax-ready columns. Start tracking like a business, not a hobby.
Get Reseller TemplatePro Tips
Record costs immediately
Log every fee at purchase. Waiting guarantees underestimation and phantom profits.
Track days-to-sale
Velocity matters more than margin. A fast 20% beats a slow 40% every time.
Archive sold items monthly
Keep active sheets lean. Move completed sales to a dedicated 'Sold' workbook for tax and analytics.
Set hard margin rules
Red rows below threshold = do not buy. Discipline beats intuition in resale.
Frequently Asked Questions
Q: What is the minimum viable margin for reselling?
20% for direct sales, 25% for StockX/GOAT, 30% for eBay/Grailed, 35% for slow-moving apparel. These floors account for platform fees, shipping volatility, and the occasional return or price drop.
Q: Should I track every item or only resale items?
Only items you intend to resell. Tracking personal purchases in the same sheet creates tax confusion and data noise. Maintain separate workbooks for personal and business buying.
Q: How do I handle returns as a reseller?
Create a 'Returns' tab with original Order ID, return reason, refund amount, and net loss. Analyze quarterly. If a specific category or seller generates >10% returns, stop sourcing from them regardless of margin.
Q: Can I use these techniques for dropshipping instead of agent buying?
Most principles translate, but cost structures differ. Dropshipping has no international shipping or agent fees, but lower margins. Adjust your threshold formulas accordingly. The core discipline — track every cost, enforce margin rules, measure velocity — applies universally.
Ready to Start Tracking Smarter?
Grab a template and start your ACBuy spreadsheet in under 10 minutes.