Reselling demands a completely different litbuy spreadsheet structure than casual buying. Every purchase is inventory. Every sale is revenue. The gap between them is your profit, and tracking that gap accurately determines whether your resale business thrives or fails. This guide builds a reseller-specific spreadsheet that calculates profit, tracks inventory status, and reveals which products actually make money.
The Reseller Column Structure
A reseller litbuy spreadsheet needs twelve columns minimum: Date Purchased, Item, Category, Source, Purchase Price, Shipping In, Total Cost, Platform, Sale Price, Shipping Out, Platform Fees, and Net Profit. This structure captures every dollar flowing through your business.
The Total Cost column sums Purchase Price and Shipping In. The Net Profit column subtracts Total Cost, Shipping Out, and Platform Fees from Sale Price. With these formulas in place, every row instantly shows whether that flip made or lost money.
Inventory Status Tracking
Add a Status column with these exact options: Ordered, In Hand, Listed, Sold, Shipped, Returned. This six-stage pipeline tells you exactly where every item sits in your workflow. Without it, items get buried in closets while you forget to list them, or sold items sit unshipped because you thought they were already gone.
Use conditional formatting so each status has its own color. Ordered shows yellow. In Hand shows blue. Listed shows green. Sold shows purple. One glance at your sheet reveals your workflow health. Too much yellow means delayed deliveries. Too much blue means listing procrastination. Too much green means pricing issues.
Source Inventory to Resell
Find premium products at wholesale-friendly prices on our main store.
Visit oocbuy.comProfit Margin by Category
| Category | Avg Purchase | Avg Sale | Avg Margin | Recommendation |
|---|---|---|---|---|
| Limited Sneakers | $180 | $340 | 89% | High priority |
| Streetwear Hoodies | $85 | $155 | 82% | High priority |
| Vintage Jackets | $60 | $140 | 133% | Explore more |
| Accessories | $25 | $55 | 120% | Volume play |
| Basic T-Shirts | $20 | $35 | 75% | Low priority |
Days to Sell Metric
Add a Days to Sell column that calculates how long each item sat in inventory. The formula subtracts Date Purchased from Date Sold. Over time, this metric reveals which categories move fast and which sit idle. Fast-turning inventory deserves more capital allocation. Slow inventory either needs better sourcing or should be eliminated from your model.
Create a pivot table from your data showing average Days to Sell by Category. If sneakers average twelve days and jackets average forty-five days, you now have objective evidence to focus on sneakers. Gut feelings are unreliable. Pivot tables do not lie.
Tax Preparation Columns
Resellers face tax obligations that casual buyers do not. Add a Tax Year column and a Receipt Link column. When tax season arrives, filter by Tax Year, export the relevant rows, and hand your accountant clean data. The Receipt Link column stores URLs to digital receipts stored in Google Drive or Dropbox. No more shoebox of paper receipts. No more panic in March.
FAQ
Should I track unsold inventory differently?
Yes. Use a separate "Inventory Value" column showing purchase price of unsold items. This is your current asset value.
How do I handle returns in the sheet?
Change status to "Returned" and add a Returns column tracking the refund amount. Net Profit adjusts automatically if your formula includes it.
Can this scale to hundreds of items?
Yes. Google Sheets handles tens of thousands of rows. For extreme volume, consider upgrading to a database like Airtable.
Conclusion
A reseller-specific litbuy spreadsheet is the difference between a hobby and a business. Track every cost, every stage, and every profit dollar. Let the data guide your sourcing decisions instead of guessing. Build this sheet once, use it forever, and watch your margins improve with every row.