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.
What Makes This Guide Different
Most tutorials throw screenshots at you and call it a day. This acbuy spreadsheet guide follows a real beginner named Marcus who processed his first thirty orders using our system. Every step reflects what actually confused him, what slowed him down, and what made his workflow faster once he got it right.
We will cover setup, daily usage, batch entry, formula troubleshooting, and the exact weekly review routine that keeps your data clean. By the end, you will have a working system, not just a folder of unused templates.
Phase One: Environment Setup
Before touching a single order, configure your environment so every formula works without manual fixes later.
- 1Create a dedicated Google account or folder just for reselling data.
- 2Set your primary currency in the Config sheet (USD, EUR, GBP, etc.).
- 3Enter your platform fee percentages (eBay 13%, StockX 12%, etc.).
- 4Add your common shipping costs per region in the reference table.
- 5Choose a color scheme and stick to it across all tabs.
Phase Two: Daily Order Entry
Consistency beats speed. Spending two extra minutes per order saves thirty minutes later when you need accurate profit reports.
- 1Paste the supplier product link in the Source column.
- 2Enter the item name, SKU if available, and purchase price.
- 3Select the status from the dropdown: Ordered, In Transit, Received, Listed, Sold.
- 4Add the target platform and estimated sale price.
- 5Let the sheet auto-calculate profit, margin, and ROI.
Phase Three: Weekly Review and Cleanup
Every Sunday, spend twenty minutes reviewing your sheet. Update statuses that changed during the week. Delete test rows you accidentally left behind. Check the profit summary tab for any negative-margin items that sneaked through.
Weekly Checklist
- Update all order statuses from supplier tracking emails.
- Reconcile sold items with platform payout confirmations.
- Flag items sitting at Received for more than two weeks.
- Review profit summary for anomalies or negative margins.
- Archive completed orders older than three months to a separate sheet.
Phase Four: Batch Import for Power Users
Once you are comfortable with manual entry, batch importing from CSV exports accelerates everything. Copy the supplier order list, paste it into the Import tab, map the columns once, and watch fifty orders populate in seconds.
| Phase | Time | Frequency | Goal | Result |
|---|---|---|---|---|
| Environment Setup | 20 min | Once | Configure formulas | Auto-calculating profit |
| Order Entry | 2 min/order | Daily | Capture data | Live inventory status |
| Weekly Review | 20 min | Sunday | Clean & reconcile | Accurate reports |
| Batch Import | 5 min/batch | As needed | Scale entry speed | 50+ orders at once |
Related Guides
Frequently Asked Questions
How do I handle multiple currencies?
Use the Config sheet to set a primary currency. Enter prices in whatever currency you paid, and add a conversion rate column. The formula multiplies automatically.
Can I use this on a phone or tablet?
Google Sheets mobile app handles basic updates well. For initial setup and batch imports, a laptop is strongly recommended.
What if a formula breaks?
Most formula errors come from accidentally deleting a header row or inserting a column where formulas expect data. The guide includes a troubleshooting tab with common fixes.
How do I track partial shipments?
Split the order into multiple rows, one per shipment, and link them with a parent order ID in a dedicated column.
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.
Free vs Paid ACBuy Spreadsheet Templates
Compare the features, automation levels, and tracking capabilities between free starter templates and premium professional spreadsheet systems.
Build Your Own ACBuy Spreadsheet
Learn how to design and build a custom tracking system from scratch, tailored to your exact workflow and business model.