The acbuy spreadsheet is not just a personal shopping tool. For resellers, it is a complete business management system. It tracks inventory, calculates profit, manages customers, and generates reports that help you grow your business.
In this reseller-focused guide, we will show you how to configure the acbuy spreadsheet for business use. We will cover profit tracking, inventory management, customer lists, and the automation that makes reselling at scale possible.
The Reseller Mindset
Reselling requires a different approach than personal shopping. Every purchase is an investment. Every sale is a return. The acbuy spreadsheet helps you treat your buying like a business from day one.
The core difference is that you need to track two prices: what you paid and what you sell for. The gap between them is your profit. But profit is more than just the selling price minus the cost. You need to factor in shipping to customers, packaging, payment fees, and returns.
The acbuy spreadsheet reseller template includes all these columns. It calculates net profit, which is the real amount you keep after all expenses. This is the number that matters for your business decisions.
| Column | Purpose | Formula |
|---|---|---|
| Product Name | Identify item | Manual |
| Cost | What you paid | Manual |
| Shipping In | Shipping to you | Manual |
| Shipping Out | Shipping to buyer | Manual |
| Fees | Platform fees | Manual |
| Total Cost | All expenses | =Cost+Shipping In+Fees |
| Sale Price | What you sold for | Manual |
| Net Profit | Real profit | =Sale-Total Cost |
| Profit Margin | ROI percentage | =(Net Profit/Total Cost)*100 |
Inventory Management System
Inventory management is about knowing what you have, where it is, and when it will sell. The acbuy spreadsheet handles this with a simple but effective status system.
The basic status flow is: Ordered -> In Transit -> In Stock -> Listed -> Sold -> Shipped. Each status represents a real stage in your business process. By tracking each item through these stages, you always know your exact inventory position.
Add an inventory count column that shows how many of each item you have in stock. If you buy 5 identical hoodies, track each one individually. This helps you know exactly which items are available when a customer asks.
Track by Individual Item
Do not group identical items. Track each piece individually. This gives you precise inventory accuracy.
Set Days to Sell Target
Add a column for your target sell date. If an item is unsold after 30 days, consider discounting it.
Record Customer Names
Add a Customer column for sold items. This builds a customer database you can use for repeat marketing.
Log Return Status
Track returns separately. A return changes the status from Sold back to In Stock. Record the reason for analytics.
Profit and Loss Reporting
Profit tracking is the lifeblood of your reselling business. The acbuy spreadsheet makes it automatic. Every time you update a sale price, the profit and margin update instantly.
Create a monthly P&L summary. At the end of each month, calculate total revenue, total cost, total profit, and average profit margin. This tells you if your business is growing or shrinking.
Track profitability by category. Use a pivot table to show profit per category. You might discover that shoes give you 40% margins while hoodies give 25%. This data tells you where to focus your buying efforts.
Scaling Your Business
When your business grows, the acbuy spreadsheet grows with you. The basic template handles up to 200 orders. The bulk version handles up to 500. For larger operations, you can connect multiple sheets or upgrade to a database.
For resellers with 100+ orders per month, consider using a database connected to Google Sheets. Airtable is a popular choice. The acbuy spreadsheet data structure transfers easily to Airtable. This gives you the power of a database with the familiarity of a spreadsheet.
The automation scripts become essential at scale. Manual updates for 100+ orders are impossible. Auto-tracking, auto-email, and auto-archive scripts handle the routine work so you can focus on buying and selling.
Frequently Asked Questions
Is the reseller template different from the basic one?
Yes, the reseller template includes profit tracking, inventory management, and customer columns. It is designed for business use, not personal shopping.
How many orders can I track as a reseller?
The basic template handles 200 orders. The bulk version handles 500. For more, you can create a new sheet per month or use a database integration.
Can I use the spreadsheet for taxes?
Yes, but you should export your data to a proper accounting system for tax filing. The spreadsheet is great for tracking, but accountants prefer structured reports.
What is the most important metric for resellers?
Net Profit Margin is the most important. It tells you the real percentage you keep after all expenses. Aim for 30-50% margins.