The best acbuy spreadsheet is not the one with the most columns. It is the one with the right columns. This guide identifies the essential metrics every reseller should track, explains why each matters, and shows you how to keep your sheet lean without losing critical data.
Tracking too much creates busywork. Tracking too little creates blind spots. The sweet spot lives in the eight core columns below, plus two optional upgrades when your workflow demands them.
The Eight Core Columns
These columns cover every essential workflow for resellers sourcing through ACBuy. If you are just starting, build these first. Add anything else only after these eight are automatic habits.
Unique identifier for every purchase. Essential for support tickets, supplier disputes, and tax records.
When you placed the order. The foundation for delivery time analysis and monthly profit reports.
What you bought. Use full names, not abbreviations. Future you will not remember what SKU-X47 means.
The price of one item before quantity or shipping. The baseline for every profit calculation.
How many units. Multiplied by unit cost to get total product cost before shipping.
Unit Cost times Quantity plus Shipping. The real money leaving your account.
What you expect to sell each unit for. Required for profit margin calculation.
Ordered, Shipped, Delivered, or Cancelled. Tells you what needs attention right now.
The Profit Formula That Changes Everything
Profit is not Selling Price minus Unit Cost. That ignores quantity, shipping, and fees. The correct formula for your Profit column is: =(SellingPrice - TotalCost) * Quantity. This single formula reveals your true margin on every order, including the impact of bulk quantity and freight costs.
If you also pay platform fees or payment processing charges, add a Fees column and update the formula to: =(SellingPrice - TotalCost - Fees) * Quantity. Precision matters. Small fee omissions compound across hundreds of orders into significant profit misestimation.
Want a template with these exact columns pre-built?
Get Core Column TemplatesOptional Columns That Add Power
Once the eight core columns are habits, consider adding these based on your specific workflow needs. Do not add them all at once. Introduce one column, use it for two weeks, then decide if it earns its place.
Track freight separately from product cost. Essential for logistics optimization and dispute resolution.
Group orders by vendor to compare reliability, speed, and pricing over time.
Paste the carrier tracking ID. Cross-reference with delivery status for customer service.
Platform commissions, payment processing, and packaging costs. Omitting fees inflates profit by 5-15%.
Product type like Shoes, Hoodies, or Accessories. Enables pivot table analysis of best-performing categories.
Free text for special instructions, customer requests, or supplier warnings. Use sparingly to avoid clutter.
Core vs Optional Columns
| Column | Type | Priority | Impact |
|---|---|---|---|
| Order ID | Core | Essential | Tracking & disputes |
| Date | Core | Essential | Reporting & speed analysis |
| Product Name | Core | Essential | Identification |
| Unit Cost | Core | Essential | Profit baseline |
| Quantity | Core | Essential | Bulk calculations |
| Total Cost | Core | Essential | Real spend |
| Selling Price | Core | Essential | Revenue forecast |
| Status | Core | Essential | Workflow priority |
| Shipping | Optional | Important | Logistics insight |
| Supplier | Optional | Important | Vendor comparison |
| Tracking | Optional | Useful | Customer service |
| Fees | Optional | Important | Accurate profit |
| Category | Optional | Useful | Category analytics |
| Notes | Optional | Low | Context only |
Keeping It Lean
- Never track a metric you do not act on. If you record customer birthdays but never send offers, delete the column.
- Use abbreviations in headers sparingly. Future team members should understand every column without asking you.
- Freeze the header row so it stays visible while scrolling. This simple feature eliminates the need to scroll back to check column names.
- Set data validation on Status to prevent typos. Delivered and delivered are different values in a spreadsheet.
- Review your column list quarterly. Delete anything unused for sixty days. Lean sheets are fast sheets.
Build Your Tracker
- → Step-by-Step Guide: Set up these columns in 10 minutes
- → Template Library: Pre-built trackers with all core columns
- → Organizing Orders: Sort and filter by the columns you choose
- → Advanced Tips: Formulas that make these columns calculate automatically
Ready to Start Tracking?
Get the free template and have your first order logged in under ten minutes.
