Introduction
Reselling streetwear and accessories bought through agents is a growing side hustle. The buyers who succeed treat it like a business, not a hobby. That means tracking every cost down to the cent, monitoring inventory levels, calculating profit margins in real time, and knowing exactly which items sell fastest. A standard LoveGoBuy spreadsheet tracks purchases. A reseller-grade LoveGoBuy spreadsheet tracks a business. This guide shows you the exact column structure, formulas, and workflow differences that separate casual buyers from profitable resellers. If you have ever wondered whether an item is worth flipping, this sheet will tell you before you click buy.
Want to skip the setup and start tracking immediately? Our free templates have everything pre-configured.
View the Ultimate GuideThe Reseller Column Set
Resellers need every standard tracking column plus five additional fields. Field one: Cost Basis. This is your true landed cost including item price, domestic shipping, agent fee, international shipping, and any packaging or labeling fees. Field two: Resale Platform. eBay, Grailed, Depop, Instagram, or local marketplace. Different platforms have different fee structures. Field three: Listing Price. What you actually list the item for, not what you hope to get. Field four: Platform Fee. eBay takes thirteen percent. Grailed takes nine percent. Your sheet should calculate this automatically based on the platform. Field five: Net Profit. A formula that subtracts Cost Basis and Platform Fee from Listing Price. This is the number that matters. If Net Profit is negative before you list, you know immediately that the flip is not viable.
Inventory Velocity Tracking
Speed matters in resale. An item that sits for six months ties up capital and warehouse space. Add a Days Listed column and a Sold Date column. Calculate Days to Sale by subtracting the listing date from the sold date. After twenty sales, sort by Days to Sale and identify patterns. Maybe Nike tech fleeces sell in eight days while vintage jackets take forty-five. Maybe your local marketplace moves items faster than eBay despite lower prices. This data tells you what to buy next and what to stop buying. A reseller who ignores velocity data is guessing. A reseller who tracks it is optimizing.
Tax-Ready Reporting
Reselling income is taxable in most jurisdictions. Your LoveGoBuy spreadsheet should make tax season effortless, not painful. Add a Tax Year column and a Sold Price column separate from Listing Price. When an item sells, record the actual sold price including any discounts you gave. Create a Tax Summary tab that uses SUMIF to total Cost Basis, Sold Price, Platform Fees, and Net Profit for any tax year you select. Export this tab as a CSV and hand it to your accountant. No scrambling through PayPal history or screenshot folders. Your spreadsheet becomes your official business ledger.
Reseller Metrics Dashboard
Scaling from Side Hustle to Business
When your monthly orders exceed fifty, your sheet needs structural changes. Move from a single Active Orders tab to monthly tabs like Jan 2026, Feb 2026. This prevents any one tab from becoming unwieldy. Create a master Inventory tab that pulls current stock from every monthly tab using QUERY. Create a Purchased vs Sold summary that flags slow movers automatically. Share view-only access with a partner or virtual assistant who handles listing while you handle buying. The LoveGoBuy spreadsheet that handled ten orders breaks at five hundred unless you plan for scale. Build the structure for the business you want, not the business you have today.
Conclusion
Reselling is a numbers game, and a LoveGoBuy spreadsheet built for resellers is your scorecard. Cost Basis prevents losing flips. Net Profit shows true earnings before you celebrate. Inventory Velocity guides your next purchase. Tax reporting keeps you legal and stress-free. Build these five reseller columns into your sheet today, track your first ten sales religiously, and within three months you will have data that most resellers never collect. For buyers who are not reselling yet but want to understand cost tracking fundamentals, our guide on what to track with a LoveGoBuy spreadsheet covers the essential fifteen fields every buyer needs.
Comparison Table
| Metric | Formula / Method | Update Frequency | Why It Matters |
|---|
| Cost Basis | Sum of all purchase costs | Per order | True item cost for profit calc |
| Net Profit | Listing Price - Cost Basis - Platform Fee | On sale | Actual money you keep |
| Days to Sale | Sold Date - Listed Date | On sale | Capital turnover speed |
| Inventory Value | Sum of Cost Basis for unsold items | Weekly | Tied-up capital snapshot |
| Sell-Through Rate | Sold count / Listed count | Monthly | Business health indicator |
| Platform Fee | Percentage of Listing Price | On listing | Accurate profit forecasting |
Pro Tips
- Log Cost Basis immediately after paying international shipping, before memory fades.
- Update Sold Date within one hour of receiving payment to keep velocity data accurate.
- Use a separate Purchases tab for items not yet listed to avoid cluttering active inventory.
- Reconcile your sheet monthly against PayPal or bank statements to catch missed sales.
- Archive sold items quarterly to keep the active view fast and focused.
Master Your Orders
The LoveGoBuy spreadsheet system works for beginners and power users alike. Start with the ultimate guide.
Frequently Asked Questions
Do I need a separate sheet for tax reporting?
No. A dedicated Tax Summary tab inside your main LoveGoBuy spreadsheet is sufficient for most small resellers. Export it as CSV at year-end.
How do I track items I haven't listed yet?
Use a Purchases tab for unlisted inventory. Move rows to the Inventory tab only when you photograph and list them.
What if I sell at a loss?
Log the actual sold price. Negative Net Profit is valuable data. It tells you which categories or sizes to stop buying.
Can I use the same sheet for personal and resale purchases?
Yes, but add a Type column with values Personal and Resale. Use SUMIF in your Budget tab to separate the two for tax purposes.