Resellers need more than basic tracking. Learn how to build a sugargoo spreadsheet that handles inventory, profit margins, and business analytics.
Sugargoo Spreadsheet Team
Published on Sugargoo Spreadsheet Courses
Reselling is a business, and businesses need data. A basic sugargoo spreadsheet tracks what you buy. A reseller spreadsheet tracks what you buy, what you sell, what you profit, and how your business grows over time. This guide is for buyers who treat reselling seriously.
The difference between a hobby reseller and a professional is often their tracking system. Professionals know their numbers. They know average profit margin by category. They know which sellers deliver the fastest. They know their monthly revenue, cost, and net profit. All of this lives in a well-designed spreadsheet.
This guide assumes you already understand basic spreadsheet functions. We will focus on reseller-specific features: profit tracking, inventory management, customer orders, and business analytics.
Every reseller needs a profit column. The formula is simple: (Resale Price - Total Cost) / Total Cost * 100. This gives you profit margin as a percentage. A 30% margin means you earn $30 profit on every $100 spent.
Add a minimum margin threshold. Use conditional formatting to highlight items below your target. If your minimum acceptable margin is 25%, make anything below that red. This prevents you from buying low-margin items that waste your time.
Track margin by category. Some categories have higher margins than others. Sneakers might average 35% while accessories average 20%. This data helps you focus on the most profitable categories.
Resellers need to track items from purchase through sale. Add a Status column with these values: Ordered, In Stock, Listed, Sold, Shipped. This shows your inventory pipeline at a glance.
Create an inventory summary sheet. Use COUNTIF to count items in each status. In Stock = available inventory. Listed = items waiting for buyers. Sold = items awaiting shipment. This dashboard tells you your business health instantly.
Add a "Days in Inventory" column. Calculate it as TODAY() minus Arrival Date. Items sitting for more than 60 days might need price adjustments. Items selling within 7 days might need higher prices. This data optimizes your pricing strategy.
When you sell items, you need to track customer orders separately. Create a "Sales" sheet with columns: Sale Date, Item Name, Customer, Sale Price, Shipping Charged, Platform Fee, Net Revenue, and Status.
Platform fees vary. eBay takes 13%, Grailed takes 9%, StockX takes 12%. Add a Platform column and use a formula to calculate fees automatically. =SalePrice * VLOOKUP(Platform, FeeTable, 2, FALSE) pulls the correct fee from a reference table.
Link sales to your inventory. When an item sells, update its status in the inventory sheet. This prevents double-selling. You can also use a formula to check if an item is available before listing it.
Create a dashboard sheet that summarizes your entire business. Monthly Revenue: =SUMIF(Sales!A:A, "2026-05", Sales!D:D). Monthly Cost: =SUMIF(Inventory!A:A, "2026-05", Inventory!H:H). Net Profit: Revenue - Cost.
Add charts using Google Sheets chart tools. A line chart showing monthly profit over time reveals trends. A pie chart showing revenue by category helps you focus. A bar chart showing profit by seller identifies your best suppliers.
Calculate key metrics. Return on Investment: =TotalProfit / TotalCost * 100. Inventory Turnover: =ItemsSold / AverageInventory. These metrics help you compare your business to industry benchmarks.
Resellers must track expenses for tax purposes. Add expense categories: Shipping, Packaging, Platform Fees, Photography, Storage, and Returns. Record every expense with a date, amount, and category.
Create a quarterly summary. Use SUMIF to total expenses by category for each quarter. This makes tax filing much easier. Your accountant will thank you for organized data.
Save receipts in Google Drive and link them in your spreadsheet. In a "Receipt" column, paste the Drive link. If audited, you have instant access to documentation. This habit protects you legally.
| Metric | Formula | Frequency | Why It Matters |
|---|---|---|---|
| Profit Margin | (Sale-Cost)/Cost*100 | Per item | Measures efficiency |
| ROI | TotalProfit/TotalCost*100 | Monthly | Business performance |
| Inventory Turnover | Sold/AvgStock | Monthly | Cash flow speed |
| Avg Days in Stock | Days in inventory | Weekly | Pricing indicator |
| Platform Fees | Sale*FeeRate | Per sale | Cost accuracy |
| Net Revenue | Sale-Fee-Shipping | Per sale | True earnings |
| Monthly Profit | Revenue-Costs | Monthly | Business health |
Yes, or at least a separate sheet within the same workbook. Mixing inventory and sales data in one sheet becomes confusing.
Add a "Returns" sheet. Record returned items with original sale price, refund amount, and reason. This data helps you identify problematic items.
Yes, add a Platform column. Use it for filtering and fee calculations. eBay, Grailed, StockX, and direct sales can all live in one sheet.
Research sold listings on your platform. Average the last ten sold prices for similar items. Record this as your target resale price in the spreadsheet.
If reselling is a significant income source, yes. Add a time column. Calculate hourly profit. If you earn less than minimum wage, reconsider your approach.