Reselling is a numbers game disguised as a fashion hobby. The buyers who win are not the ones with the best taste. They are the ones who know their numbers. A purpose-built basetao spreadsheet for resellers tracks cost, margin, velocity, and category performance in one view. This guide shows exactly how to build that view.
Why Standard Tracking Fails for Resellers
A basic basetao spreadsheet tells you what you bought and when it shipped. It does not tell you if you made money. Resellers need three additional data layers: acquisition cost versus sale price, time-to-sell per category, and true net profit after all fees.
Without these layers, you are guessing. Guessing leads to buying inventory that sits. Sitting inventory ties up capital. Tied-up capital prevents you from buying the items that actually sell. The cycle repeats until your reseller operation becomes an expensive closet.
The Reseller Column Stack
Add these reseller-specific columns to your main orders sheet. They sit alongside your standard tracking columns, creating a unified command center.
| Column | What to Enter | Why It Matters |
|---|---|---|
| Target Sale Price | Your planned listing price in local currency | Forces pre-purchase profit calculation |
| Platform | Where you plan to sell: eBay, Grailed, Depop, etc. | Different platforms have different fee structures |
| Platform Fee % | Decimal: 0.10 for 10 percent, 0.125 for 12.5 percent | Drives accurate net profit formulas |
| Actual Sale Price | What it really sold for | Reveals if your target pricing was accurate |
| Days to Sell | Sale date minus arrival date | Shows which categories move fast |
| Net Profit | Formula: Sale minus all costs and fees | The only number that truly matters |
| ROI % | Formula: Net Profit / Total Acquisition Cost | Compare efficiency across items and categories |
The Profit Formula That Actually Works
Here is the exact formula for your Net Profit column. It accounts for every dollar that leaves your pocket and every dollar that returns.
=ActualSale - (TotalAcquisitionCost + (ActualSale*PlatformFeePct) + LocalShippingCost)Where TotalAcquisitionCost includes item price, agent fee, international shipping to you, and any domestic forwarding. LocalShippingCost is what you pay to ship to the buyer. Every hidden fee lives in this formula. Nothing is forgotten.
Category Performance Dashboard
Create a second sheet tab named "Reseller Dashboard." Use QUERY or pivot tables to auto-generate these metrics from your main data:
- Total inventory value — sum of all unsold items still in hand
- Average days to sell — by category (Shoes, Hoodies, Accessories)
- Win rate — percentage of items that sold above acquisition cost
- Best category by ROI — which product type returns the most profit per dollar invested
- Worst performing items — filter for negative net profit to avoid repeating mistakes
Review this dashboard weekly before placing new orders. A basetao spreadsheet for resellers is not just a record. It is a decision engine. The dashboard tells you what to buy more of and what to stop buying entirely.
Reseller Buying Discipline
Before you buy any item for resale, fill the Target Sale Price, Platform, and Platform Fee columns. Run the Net Profit formula. If the number is negative or below your minimum acceptable margin, do not buy. This single habit separates profitable resellers from hobbyists who accumulate debt. Emotion drives the purchase. The spreadsheet drives the decision. Trust the sheet.
Inventory Cash Flow Warning
Track unsold inventory value as a running total. If that number exceeds three months of your typical selling volume, you are over-inventorying. Stop buying. Focus on selling what you have. A basetao spreadsheet with a clear inventory value prevents the most common reseller failure: buying faster than selling.
Reseller Performance by Category
| Category | Avg Days to Sell | Typical ROI | Best For |
|---|---|---|---|
| Shoes | 14-21 days | 35-55% | High-volume, fast turnover |
| Hoodies/Sweaters | 21-35 days | 25-40% | Seasonal demand spikes |
| Jackets | 30-60 days | 40-70% | Higher margin, slower move |
| Accessories | 10-20 days | 20-35% | Impulse buys, easy shipping |
| Jerseys | 7-14 days | 30-50% | Event-driven, time-sensitive |
These ranges reflect informal reseller community averages and vary by platform, season, and regional demand. Your personal basetao spreadsheet will generate exact numbers for your specific operation within sixty days of consistent tracking.
FAQ
Should I track unsold inventory separately?
Yes. Add an "Inventory Status" column with values: In Transit, In Hand, Listed, Sold, Returned. Filter by "In Hand" and "Listed" to see your current inventory value instantly.
How do I handle returns in the spreadsheet?
Create a new row for the return with negative sale price and note the original order row number. This keeps your profit calculations accurate without deleting history.
Can I use this for tax reporting?
The data is helpful but not legally sufficient alone. Export annual summaries from your sheet and pair them with actual bank and platform statements. Use the spreadsheet as supporting documentation, not primary proof.
What is the minimum ROI to justify reselling an item?
After all fees and shipping, most experienced resellers will not touch an item below 20 percent net ROI. Below that, the time, risk, and capital tie-up rarely pay off.
Ready to Start Tracking Smarter?
Free templates, no signup required. Just open, copy, and start tracking.