ACBuy Spreadsheet
for Resellers
A reseller-specific breakdown of how to track inventory, manage multiple platforms, and maximize profit margins using a purpose-built spreadsheet system.
Why Resellers Need Different Tracking
Generic business spreadsheets assume a simple buy-sell cycle. Reselling is messier. You buy from overseas agents, wait for international shipping, inspect for quality, list on multiple platforms with different fees, handle returns, and sometimes sit on inventory for months. A generic sheet breaks under that complexity. A reseller-specific acbuy spreadsheet bends with it.
Multi-Platform Fee Management
Every platform charges differently. eBay takes insertion fees plus final value fees. StockX takes a fixed percentage. Grailed takes a lower cut but has a different audience. Your spreadsheet needs a Config tab that stores each platform fee structure, and your profit formula needs to reference the correct fee based on the platform column.
- Store platform fees as named variables in the Config tab.
- Use VLOOKUP or SWITCH formulas to pull the correct fee per platform.
- Update fees immediately when platforms change their pricing.
- Track net profit per platform to find your most profitable channels.
Inventory Velocity and Cash Flow
Resellers tie up cash in inventory. The longer an item sits unsold, the more it costs in opportunity and sometimes storage. Track Days to Sell for every item. Calculate average velocity by category. If Jerseys take forty days and Shoes take twelve, allocate more buying budget to Shoes until you find faster-moving Jersey suppliers.
Return and Defect Tracking
Returns are inevitable. Defects happen. Track them meticulously. A column for Return Reason tells you whether the problem is supplier quality, listing inaccuracy, or buyer remorse. Supplier Defect Rate tells you which agents need replacing. This data protects your margins and your reputation.
Reseller-Specific Columns
- Platform (eBay, StockX, Grailed, etc.)
- Days to Sell (Received date to Sold date)
- Return Reason (Quality, Sizing, Description, Other)
- Supplier Defect Rate (percentage per agent)
- Net Profit After Returns (true bottom line)
| Platform | Fee Structure | Best For | Tracking Complexity |
|---|---|---|---|
| eBay | Insertion + FVF | Volume & variety | High |
| StockX | Fixed percentage | Authenticated sales | Low |
| Grailed | Low percentage | Fashion audience | Medium |
| Depop | Fixed percentage | Youth market | Medium |
| Own Store | Payment processing only | Brand building | High |
Related Guides
Frequently Asked Questions
How do I track consignment inventory?
Add a Consignment Owner column. Split profit between you and the owner with a formula. Track whose inventory is whose so payouts are accurate.
Should I track shipping supplies cost?
Yes, if you ship more than fifty orders per month. Add a Shipping Supplies column or include it in your average shipping cost formula for simplicity.
How do I handle international buyers?
Track currency conversion in a separate column. Some platforms handle this automatically; others require you to note the exchange rate on the sale date.
More ACBuy Spreadsheet Guides
Best ACBuy Spreadsheet for Beginners
Discover the perfect starting spreadsheet to track your orders, manage inventory, and grow your reselling business without the steep learning curve.
Step-by-Step ACBuy Spreadsheet Guide
Master the complete workflow from first order entry to automated profit calculation with our detailed walkthrough and pro tips.
Free vs Paid ACBuy Spreadsheet Templates
Compare the features, automation levels, and tracking capabilities between free starter templates and premium professional spreadsheet systems.