ACBuy Spreadsheet Step-by-Step Guide: From Blank Sheet to Pro Tracker
Starting with a blank spreadsheet can feel intimidating. This step-by-step guide walks you through building a fully functional ACBuy spreadsheet from scratch — no prior experience required. By the end, you will have a professional tracker that handles orders, budgets, and shipping with automated precision.
Step 1: Choose Your Platform
Google Sheets is the recommended starting point. It is free, cloud-synced, and works on every device. Excel Online is a close second. Avoid desktop-only Excel if you plan to share your ACBuy spreadsheet with group members or access it from your phone.
Create a new workbook and name it clearly: 'ACBuy Tracker 2026.' This simple naming convention makes your file searchable in your drive when you have dozens of documents.
Step 2: Build the Master Tab
The Master Tab is your single source of truth. Freeze Row 1 (View → Freeze → 1 Row) so headers remain visible as you scroll. This small detail saves hours of confusion once you pass 50 orders.
Add these exact column headers in Row 1: Order ID, Date Added, Product Name, Product Link, Agent/Store, Size/Variant, Price (Local), Price (USD), Shipping Estimate, Weight (kg), Status, Tracking Number, QC Photos, Notes.
Format the header row with a subtle background color (#F2EDE6) and bold text. Visual hierarchy matters when you are staring at rows of data late at night.
Step 3: Add Data Validation
Data validation is the secret weapon of every great ACBuy spreadsheet. It prevents typos that destroy your filters and formulas later. Select the Status column, then go to Data → Data Validation → List of Items.
Enter exactly these options: Pending, Paid, Shipped, In Transit, Received, Resold, Returned. Do not allow free-text entry. A single typo like 'Recieved' will break every status-based calculation in your sheet.
Apply similar dropdowns to the Agent/Store column. Common entries: WeGoBuy, SuperBuy, Pandabuy, CSSBuy, SugarGoo. Add your own as needed, but keep the list tight.
Step 4: Create the Dashboard Tab
A Dashboard Tab transforms raw data into actionable insight. Create a second tab named 'Dashboard.' In cell A1, type 'Total Orders.' In B1, enter =COUNTA(Master!A:A)-1 to count every order row.
Add these summary cells: Total Spent (SUMIF on Price USD), Pending Orders (COUNTIF Status = 'Pending'), Shipped Orders (COUNTIF Status = 'Shipped'), Estimated Shipping Total (SUMIF Shipping Estimate where Status ≠ 'Received').
Use conditional formatting on the Dashboard to turn 'Pending Orders' yellow when it exceeds 5 and red when it exceeds 10. These visual triggers keep your workload visible without scrolling through rows.
Step 5: Apply Conditional Formatting to Master
Select the entire Master Tab (click the top-left corner). Go to Format → Conditional Formatting. Add a rule: if Status contains 'Pending' and Date Added is more than 14 days ago, highlight the entire row in light yellow.
Add a second rule: if Status is 'Shipped' and Tracking Number is empty, highlight in light red. This catches the most common oversight — paying for shipping and forgetting to log the tracking number.
Add a third rule: if Price (USD) is greater than your monthly budget cell (set this in Dashboard), highlight in soft orange. This prevents budget overruns before they happen.
Step 6: Link Everything Together
Your ACBuy spreadsheet now has two tabs talking to each other. Add a third tab called 'Archive.' When an order reaches 'Received' status for 30 days, cut and paste it to Archive. This keeps your Master Tab fast and responsive.
In Dashboard, update the Total Orders formula to subtract Archive rows if you want true active-order counts. Use =COUNTA(Master!A:A)-1-COUNTA(Archive!A:A)+1.
Finally, protect your formula cells (Tools → Protect Sheet → Restrict Who Can Edit). Lock every cell that contains a formula, leaving only your data-entry columns editable. This prevents accidental breakage.
| Step | Action | Time Required | Skill Level | Impact |
|---|---|---|---|---|
| 1 | Choose platform | 2 min | Beginner | Foundation |
| 2 | Build Master Tab | 10 min | Beginner | High |
| 3 | Add validation | 5 min | Beginner | Very High |
| 4 | Dashboard Tab | 15 min | Intermediate | High |
| 5 | Conditional formatting | 10 min | Intermediate | Medium |
| 6 | Link + protect | 8 min | Intermediate | Medium |
Skip the Setup — Grab a Pre-Built Template
If this feels overwhelming, our curated templates come with every formula, validation rule, and formatting preset already configured. Copy, customize, and start tracking in under 5 minutes.
Browse TemplatesFrequently Asked Questions
Q: How long does the full setup take?
From blank sheet to functional tracker: 45-60 minutes for a beginner. With our template: under 5 minutes. The time pays for itself within the first week of use.
Q: Can I use Excel instead of Google Sheets?
Absolutely. Excel supports every feature mentioned here except real-time collaboration. If you work alone and prefer desktop software, Excel is excellent. For teams, Google Sheets wins.
Q: What if I mess up a formula?
Ctrl+Z (Undo) is your best friend. For bigger accidents, both Google Sheets and Excel have version history. In Sheets: File → Version History. In Excel: File → Info → Manage Workbook.
Q: Do I need to know math to build this?
Not at all. The formulas in this guide use basic functions: SUM, COUNTA, SUMIF, COUNTIF. They are explained in plain English and copy-paste ready. No algebra required.
Q: Should I share my spreadsheet with my agent?
Never share your full spreadsheet. It contains pricing, personal notes, and potentially your home address. If an agent needs order details, export a sanitized CSV with only product links and order IDs.
Ready to Start Tracking Smarter?
Grab a template and start your ACBuy spreadsheet in under 10 minutes.