📦 Reseller & Small Business Inventory Tracker — Google Sheets

The most common reason resellers fail to scale is not sourcing or sales — it's the complete absence of a system. Items are priced by gut feel. Platform fees are forgotten until the payout arrives. COGS are never tracked. Tax season arrives and the numbers simply don't exist. The business is making money but nobody knows how much.

This tracker solves every one of those problems. Ten professional tabs give you a complete operating system — a 500-row inventory with days-listed auto-tracking, a 400-row sales log with platform fees auto-deducted and true profit per sale, a 12-month income statement, a pricing calculator showing the minimum price for your target margin on all 10 platforms simultaneously, a quarterly tax summary ready for Schedule C, and a full platform comparison so you know exactly which channels are worth your time.

---

📦 WHAT'S INSIDE — 10 Professional Tabs

1. 📊 Dashboard — Live Business Overview

Three KPI rows covering 21 live metrics — all auto-populated from every other tab. Inventory snapshot (stock count, total value, retail value, potential profit, margin %, active items, low stock alerts). Sales snapshot (total revenue, COGS, fees, net profit, margin %, this-month revenue). Sourcing snapshot (purchases, total spent, estimated ROI %, total expenses, tax deductible, quarterly run rate). Plus full platform performance table and quarterly tax snapshot.

2. 📦 Inventory — 500-Row Stock Tracker

Every item you own in one place. SKU, description, platform listed, cost price, list price, quantity, category, condition, date sourced, days listed (auto-calculated from today), status, and notes. Summary bar tracks 12 live metrics including total COGS, retail value, potential profit, margin %, items active/draft/sold, and best category. Days Listed auto-calculates continuously — you always know which items have been sitting too long.

3. 💰 Sales Log — 400-Row Transaction Journal

Every sale with date, item, platform, sale price, COGS, platform fee, shipping cost, net profit (auto-calculated), margin % (auto-calculated), units sold, and notes. Platform fee + shipping + COGS all deducted automatically — the profit number is always your real, actual net. Summary tracks total revenue, COGS, fees, net profit, average profit per sale, best month, and this-month revenue.

4. 🛒 Purchase Log — 300-Row Sourcing Tracker

Every buying trip logged with date, item, brand, source/supplier, cost paid, quantity, estimated resale price, estimated profit (auto-calculated), estimated ROI % (auto-calculated), condition, and status. Summary tracks total spent, total resale estimate, estimated profit, estimated ROI %, average cost per item, best source, items resold vs still in stock, and this-month spend.

5. 📈 Monthly P&L — 12-Month Income Statement

Complete profit and loss across all 12 months with annual totals. Sections: Revenue (gross sales, returns, net revenue), COGS (item costs, sourcing fees, supplies, total COGS), Platform Fees (eBay, Etsy, Amazon, PayPal, other, total fees), Operating Expenses (storage, shipping, software, advertising, vehicle, other, total expenses). Profit summary: gross profit, operating profit, net profit, net margin % — all auto-calculated.

6. 🏪 Platform Sales — Per-Channel Comparison

Auto-pulls from the Sales Log to show units sold, gross revenue, platform fees, COGS, shipping, net profit, margin %, average sale price, and fee rate % for all 10 platforms plus a grand total row. The tab that tells you definitively which platform earns most after fees — no manual entry required.

7. 💸 Expenses — 200-Row Full Expense Tracker

Every business cost with date, description, vendor, payment method, category, amount, receipt number, and tax-deductible flag. 14 pre-labelled categories: storage, shipping supplies, advertising, software, vehicle, home office, platform fees, insurance, equipment, professional services, meals, travel, education, and other. Summary tracks total expenses, tax-deductible total, non-deductible, this-month, this-quarter, top category, average expense, and annual run rate.

8. 📋 Pricing Calculator — Break-Even & Target Margin

Enter cost, shipping, packing, overhead, and target margin once. Get break-even price AND target margin price for all 10 platforms instantly — platform fee rates pre-loaded and editable. A second section lets you test any asking price and see your net profit and margin on every platform simultaneously. Never guess a price again.

9. 📊 Tax Summary — Schedule C Prep

Quarterly income, COGS, platform fees, expenses, gross profit, net profit, and margin % — pulled from Monthly P&L and summarised by quarter and full year. Quarterly estimated tax tracker with tax rate %, estimated tax due, amount paid, and balance remaining. Built for US Schedule C and international self-assessment. Every number you need at tax time in one place.

✅ HIGHLIGHTS

- ✔ 500-row inventory with days-listed auto-calculation from date sourced

- ✔ 400-row sales log — true net profit per sale auto-calculated

- ✔ Platform fees auto-deducted on every transaction in the Sales Log

- ✔ 12-month income statement — revenue, COGS, fees, expenses, net profit

- ✔ Platform Sales tab pulls live from Sales Log — no double entry

- ✔ Pricing Calculator — break-even & target margin for all 10 platforms at once

- ✔ Quarterly Tax Summary — Schedule C ready, all year

- ✔ 300-row Purchase Log with estimated ROI per sourcing run

- ✔ 200-row Expense Tracker with tax-deductible flag per item

- ✔ 2,389 pre-built formulas — zero errors, LibreOffice verified

- ✔ 10 platforms — eBay, Etsy, Amazon, Poshmark, Mercari, Depop, Facebook Marketplace, Vinted, Shopify, Direct

- ✔ Works on free Google Sheets and Excel

- ✔ Instant download — set up in 10 minutes

🏪 PLATFORMS SUPPORTED

| Platform | Pre-Loaded Fee % | Notes |

|----------|-----------------|-------|

| eBay | 12.92% | Standard final value fee |

| Etsy | 6.95% | Transaction fee |

| Amazon | 15.00% | Typical referral fee |

| Poshmark | 20.00% | Sales over $15 |

| Mercari | 10.00% | Standard rate |

| Depop | 10.00% | Standard rate |

| Facebook Marketplace | 5.00% | With checkout |

| Vinted | 5.00% | Buyer protection fee |

| Shopify / Own Store | 2.90% | Payment processing |

| Direct / Cash | 0.00% | No platform fees |

All fee rates are editable in the Pricing Calculator tab.

👤 PERFECT FOR

- eBay resellers flipping thrift store and clearance finds

- Etsy sellers managing handmade or vintage inventory

- Amazon FBA and FBM sellers tracking per-unit profitability

- Poshmark and Depop closet sellers scaling their business

- Multi-platform resellers selling across 3+ channels simultaneously

- Small retail businesses tracking stock, sales, and expenses

- Car boot, market stall, and pop-up traders

- Anyone who buys items to resell and needs to know their actual profit

⚡ INSTANT DOWNLOAD