Reselling Demands a Different Spreadsheet
Personal buyers track what they bought. Resellers track what they bought, what they paid, what they sold it for, where they sold it, how long it sat in inventory, and whether the margin was worth the effort. A standard sheet cannot handle that complexity. A litbuy spreadsheet for resellers is built from the ground up for buying low and selling high. This guide is the complete playbook for anyone turning oocbuy finds into resale profits.
The Reseller's Core Columns
Before you log a single item, your sheet needs these columns. Skipping any of them will create blind spots that cost money:
- Item ID — Unique code for every piece of inventory.
- Item Name — Searchable name you and buyers recognize.
- Category — Shoes, hoodies, accessories, etc.
- Purchase Date — When you paid the supplier.
- Cost Basis — Item price + shipping + agent fees + conversion cost.
- Sale Platform — eBay, Grailed, Depop, Instagram, local, etc.
- List Price — The asking price before negotiation.
- Sold Price — Final price after fees and discounts.
- Platform Fee % — eBay takes ~13%, Grailed ~9%. Log it.
- Net Profit — Sold Price minus Cost Basis minus Platform Fees.
- Profit % — Net Profit divided by Cost Basis.
- Days to Sell — From listed date to sold date.
- Inventory Status — In Stock, Listed, Sold, Returned, Damaged.
- Storage Location — Bin A3, Shelf 2, etc. Critical at scale.
Step-by-Step: Building a Reseller Sheet
Step 1 — Create Three Main Tabs
Tab one: Inventory (all unsold items). Tab two: Sold (completed transactions with profit). Tab three: Dashboard (summary charts and KPIs).
Step 2 — Log Cost Basis Accurately
Many resellers fail because they underestimate true cost. If you paid $50 for a hoodie, $15 for shipping, and $3 for PayPal fees, your cost basis is $68, not $50. Every hidden fee erodes your margin. Be brutally honest in this column.
Step 3 — Track Platform Fees Separately
Different platforms eat different percentages. A $100 sale on eBay nets ~$87 after fees. The same $100 sale on a local cash deal nets $100. Your sheet must reflect this so you know where to push inventory.
Step 4 — Calculate True Net Profit
Use the formula: =Sold_Price - Cost_Basis - (Sold_Price * Platform_Fee_Percent). This is your real take-home. If the result is negative, you learned an expensive lesson. If it is positive but under 20%, question whether the item was worth the capital and time.
Step 5 — Monitor Days to Sell
Capital tied up in slow inventory is capital not working elsewhere. Use =TODAY() - List_Date to auto-calculate days on market. Flag anything over sixty days. Either drop the price, move to a different platform, or consider donating for tax write-off.
Step 6 — Grade Your Inventory
Add a Grade column: A (sells in under 14 days), B (14–45 days), C (45–90 days), D (over 90 days). Over time, your buying habits should shift toward Grade A categories and away from Grade D traps.
Reseller Spreadsheet vs. Personal Tracker
| Feature | Personal Tracker | Reseller Tracker |
|---|---|---|
| Primary goal | Stay organized | Maximize profit |
| Key metric | Total spend | Net profit per item |
| Columns needed | 8–10 | 14+ |
| Formula complexity | Basic SUM | Margin, ROI, days-to-sell |
| Tabs | 1–2 | 4+ (Inventory, Sold, Dashboard, Tax) |
| Time invested | 5 min/week | 30 min/week |
| Tax implications | None | Full ledger required |
Tips for Scaling Your Resale Operation
- Batch similar items. Photograph, list, and ship in batches. Context switching between sneakers and jewelry kills efficiency.
- Use consistent photography. Same background, same lighting, same angles. Buyers trust consistency.
- Track return rates by category. If 30% of your jackets return but 5% of your caps return, stop buying jackets.
- Set minimum margin rules. Never list an item unless projected profit is at least 25%. Discipline separates hobbyists from earners.
Conclusion
A litbuy spreadsheet for resellers is not optional. It is the difference between guessing and knowing, between hobby income and real business. Build the three-tab system above, log every cost honestly, and review your dashboard weekly. The numbers will teach you more than any YouTube video ever could.
Want to start tracking today? Download our reseller-ready template and log your first five items.