Inventory Tracker Spreadsheet Small Business, Etsy Seller Stock Sales Profit Tracker Google Sheets, Low Stock Reorder Alert Template

Seller's description

What it is
An inventory, sales and profit tracker for small shops: stock in and out, sales, reorder alerts, monthly reports, and top and slow sellers — with profit shown after Etsy fees, not just gross profit.

Who it is for
Etsy sellers, handmade shops, resellers and small retailers who need to know what is in stock, what is selling, and what actually makes money after fees.

Exactly what is included
- Excel (.xlsx) file, importable into Google Sheets — the buyer guide explains the File > Import steps. This version has no live native Google Sheets copy link.
- Excel (.xlsx) file in a ZIP, with a buyer guide
- Item and variant (size/colour) tracking — one row per SKU
- Stock-in, stock-out, sales and transfer logs (sales in the Sales Log reduce stock automatically; do not also add a stock-out row for a sale)
- Other business expenses log (packaging, supplies, stall fees) — reduces overall profit, not assigned to one SKU
- Reorder alerts and cash needed to reorder (low-stock SKUs reordered up to twice their reorder level — a planning assumption stated in the guide)
- Monthly report, top-seller view, and a per-SKU profit table to spot slow sellers (low or zero units sold)
- Etsy-fee-aware profit per SKU (fees use editable inputs in Settings; the $0.20 listing fee is not counted per sale — see the guide)
- Start Here tab and worked example
- Capacity stated honestly in the guide: up to 100 SKUs/variants, 500 inventory rows, 500 sales rows, 200 expense rows

Formats and compatibility
Excel (.xlsx), importable into Google Sheets (free Google account required; the buyer guide explains File > Import). No macros. No Etsy shop sync — you enter sales and stock manually or paste your own records.

How it works after purchase
1. Buy the listing and download instantly from Etsy.
2. Open the included buyer guide first — it tells you which file to open and which cells to type in.
3. Follow the Start Here steps, enter your own information, and use the built-in dashboard or checklist. Calculated cells are marked so you do not overwrite formulas.
4. Save your own copy. Your master download stays unchanged if you need to start again.

What it is NOT
It is not an Etsy shop integration, it does not sync stock automatically, and it does not guarantee sales. Capacity limits in the guide must be respected for large shops. It is not tax or financial advice — verify figures with a qualified professional.

Bundle / upsell suggestion
Bundle with the Etsy-Shop Profit + Fees + Pricing Tracker, and upsell an Etsy-fee-aware profit version.

FAQ
Q: Does it sync with my Etsy shop?
A: No. You enter sales and stock data. That keeps it simple and avoids broken syncs.

Q: Does it show profit after Etsy fees?
A: Yes. That is the key difference from a gross-profit-only sheet — fees are an editable input so profit per SKU is realistic.

Q: Can I track variants?
A: Yes, size and colour variants are included as separate SKUs, but check the capacity limits in the guide for very large catalogues (up to 100 SKUs/variants).

Q: Does this work in Google Sheets and Excel?
A: Yes. You get an Excel (.xlsx) file that also imports into Google Sheets (the guide explains import). This version has no live native Google Sheets copy link.