How to Use ACBuy Spreadsheet Step-by-Step
Most resellers know they need an acbuy spreadsheet, but few actually know how to unlock its full potential. This step-by-step tutorial walks you through every tab, formula, and feature so you can track orders like a pro within the next hour. Whether you are using Google Sheets or Excel, the workflow is nearly identical.
Understanding the Dashboard Tab
The Dashboard is your command center. It pulls data automatically from your Orders tab and displays real-time metrics. When you first open the acbuy spreadsheet, start here to understand what the system is already calculating for you.
- Total Spend Counter — Automatically sums every product cost, agent fee, and shipping charge you have entered. Updates in real time.
- Profit Margin Overview — Shows average gross margin, highest-margin items, and lowest-margin alerts so you can spot problems instantly.
- Pending Orders Tracker — Counts items stuck in each status: Ordered, In Warehouse, Shipped, or Delivered. Never lose track again.
- Inventory Value — Calculates the total resale value of delivered items based on your listed selling prices.
Filling Out Your First Order Row
The Orders tab is where the magic happens. Every row is one product. Here is exactly what goes into each column and why it matters for your acbuy spreadsheet accuracy.
Order ID (Column A)
Use a simple format like ORD-001. This becomes your reference key everywhere else in the sheet.
Product Name (Column B)
Be specific. Instead of 'Hoodie', write 'Nike Tech Fleece Hoodie Black Size L'. Searchability matters when you have 200 items.
Purchase Price CNY (Column C)
Enter the exact price shown on the ACBuy product page. Do not estimate. The currency conversion formula handles the rest.
Agent Fee (Column D)
Usually 5-10%. If your agent charges a flat rate, overwrite the formula and enter the fixed number.
Domestic Shipping CNY (Column E)
This is shipping from the seller to the agent warehouse. Often overlooked but adds up fast.
International Shipping (Column F)
Enter the estimated or actual cost to ship from agent to your door. Update this when you get the real invoice.
Status (Column G)
Pick from the dropdown: Ordered, Warehouse Received, Shipped, Delivered. Color coding triggers automatically.
Want the template with all formulas pre-filled?
Download the complete acbuy spreadsheet with every formula and dropdown already configured.
Automating Currency Conversion
One of the biggest headaches in ACBuy buying is currency math. Our acbuy spreadsheet handles this automatically with a live-rate hookup or a manual fallback.
In the Settings tab, enter the current CNY-to-USD rate. The Orders tab multiplies every CNY cost by this rate to show your true cost in your home currency. Pro tip: update the rate weekly. A 0.05 shift in exchange can swing your total cost by hundreds of dollars on large orders.
Using the Profit Calculator
The profit section is what separates hobbyists from professionals. After entering your landed cost, add your target selling price in Column H. The sheet instantly calculates gross profit, net profit after fees, and margin percentage.
If your margin drops below 20%, the cell turns amber. Below 10%, it turns red. This visual alert system helps you catch bad buys before you even list them for sale. That is the power of a real acbuy spreadsheet built for resellers.
Common Formula Errors and How to Fix Them
#REF! errors in Dashboard
This means a formula is referencing a deleted row. Restore the row or update the formula range in the Dashboard tab.
Currency showing as #####
Column is too narrow. Double-click the column border to auto-fit.
Dropdown not working
You probably copied the sheet without the validation rules. Re-copy the template fresh from the source.
Totals showing zero
Check that you are entering numbers, not text. Leading spaces or apostrophes force text mode.
FAQ
Can I customize the column names?
Yes, but be careful. Renaming columns will break Dashboard formulas. Duplicate the sheet first, then experiment.
Does it work offline?
Excel version works fully offline. Google Sheets requires periodic connectivity but caches recent changes.
Can I add custom product photos?
Yes. Insert image cells in a new column. It will not break any formulas if placed to the right of existing data.
How do I share this with my team?
Google Sheets: click Share and set permissions. Excel: upload to OneDrive or Dropbox for live collaboration.
Conclusion
Learning how to use an acbuy spreadsheet properly is a one-time investment that pays off every single day. The first setup takes 30 minutes. After that, adding a new order takes under 60 seconds. The visibility you gain into costs, margins, and inventory flow is the difference between guessing and growing.
Start with the template, fill five rows today, and review the Dashboard tomorrow morning. You will immediately see why experienced resellers never operate without one.
Ready to Master ACBuy Spreadsheet?
Download the full template and start tracking like a pro today.