Reselling fashion is a numbers game. Buy low, sell high, track everything. The rizzitgo spreadsheet built for resellers goes far beyond simple order logging. It is a complete business intelligence system that tracks inventory, calculates margins, monitors cash flow, and identifies your most profitable categories. If you are serious about resale, you need a serious tracker.
The Reseller Column Structure
Resellers need more columns than casual buyers. Here is the proven structure used by full-time fashion resellers to manage hundreds of items per month:
- 1A: Date Purchased — when you acquired the item
- 2B: Item Name — brand, model, colorway
- 3C: Category — shoes, hoodies, jerseys, etc.
- 4D: Purchase Price — your cost including shipping
- 5E: Platform Fees — listing fees, payment processing
- 6F: Shipping to Buyer — your cost to ship sold items
- 7G: Total Cost — formula: =D2+E2+F2
- 8H: Listed Price — what you ask on the resale platform
- 9I: Sold Price — what you actually received
- 10J: Net Profit — formula: =I2-G2
- 11K: Profit Margin — formula: =J2/G2
- 12L: Days to Sell — how long from listing to sale
- 13M: Buyer Platform — StockX, GOAT, eBay, Grailed
- 14N: Status — Available, Listed, Sold, Returned
- 15O: Storage Location — bin number, shelf, warehouse zone
Understanding Your True Cost
Most beginner resellers underestimate their costs. They see an $80 purchase and a $120 sale and think they made $40. They forgot the $12 shipping to buy, the $15 platform fee, the $8 shipping to sell, and the $3 packaging. True profit is $22 — nearly half of what they assumed. The rizzitgo spreadsheet captures every cost center so you know your real margins.
Inventory Management
When you have 50+ items in stock, physical organization is as important as digital tracking. Use the Storage Location column to map where each item lives. Create a simple coding system: A1-B2 means Shelf A, Bin 1, Box B, Item 2. When an item sells, you find it in seconds instead of tearing through piles of inventory.
Cash Flow Forecasting
Reselling ties up capital. Money sits in inventory for weeks or months before returning as profit. Use your rizzitgo spreadsheet to calculate average days to sell per category. Multiply by your average cost per item. This tells you exactly how much working capital you need to maintain your inventory levels without going broke.
| Metric | Formula | Why It Matters |
|---|---|---|
| Net Profit | =Sold Price - Total Cost | Your actual take-home per item |
| Profit Margin % | =Net Profit / Total Cost | Compares profitability across different price points |
| Inventory Value | =SUMIF(Status,"Available",Total Cost) | Working capital tied up in stock |
| Avg Days to Sell | =AVERAGE(Days to Sell) | Cash flow cycle length |
| ROI | =SUM(Net Profit) / SUM(Total Cost) | Overall business return rate |
Category Performance Analysis
Not all categories perform equally. Use pivot tables to compare profit margins, days to sell, and sell-through rates across shoes, hoodies, jerseys, and accessories. You might discover that jackets have lower volume but higher margins, while t-shirts sell fast but barely break even. These insights guide smarter buying decisions.
Tax Season Preparation
Reselling income is taxable in most jurisdictions. Your rizzitgo spreadsheet becomes your primary tax record. Export annual summaries showing total revenue, total costs, net profit, and inventory value. When tax season arrives, you are prepared instead of panicking. Consult a tax professional, but bring organized data to the conversation.
Source Inventory for Resale
Find underpriced items on OOCBuy with strong resale potential.
Browse OOCBuy NowConclusion
The difference between a hobby reseller and a profitable business is data discipline. The rizzitgo spreadsheet gives you that discipline without expensive software. Track every cost, measure every margin, and let the numbers guide your growth. Fashion resale is competitive. Organized resellers win.
Frequently Asked Questions
Do I need a business license to resell?
Laws vary by location. Many jurisdictions require a license once resale becomes a regular income source. Research your local requirements.
How many items should I track?
Track every item you intend to resell, plus any personal purchases over $50. Complete records are your best defense in disputes and audits.
Can I use this for other products besides fashion?
Absolutely. The column structure works for electronics, collectibles, or any resale category. Adapt the category names to match your niche.
What if an item never sells?
Log it as a learning. Analyze why: wrong category, overpriced, poor timing? Failed inventory teaches more than successful sales.