Inventory Spreadsheet for Small Business – Stock Tracker with Reorder Alerts, Sales & Profit (Excel + Google Sheets)

Never sell out of your best seller again — and know what every sale really earns.

Stop counting stock on sticky notes or paying $30+/month for inventory software. This spreadsheet updates your stock from your purchases and sales, tells you what to reorder and how many, and shows your profit per sale and per month.

🎉 Launch offer: -30% with code STOCK30 (until November 30).

What it does for you

- ✅ Stock updates itself from your Purchases, Sales and Adjustments logs.

- ✅ Reorder alerts: every product shows OK / REORDER / OUT OF STOCK (color-coded).

- ✅ Automatic reorder list with suggested quantity and estimated cost — ready to send to your supplier.

- ✅ Real profit: revenue, cost of goods (COGS) and profit on every sale, discounts included.

- ✅ Dashboard: stock value, revenue & profit by month (chart), revenue by sales channel (online, markets, wholesale…).

Who it's for

Handmade makers (candles, soap, jewelry, apparel), online shops, boutiques, market & craft-fair sellers, resellers — up to 300 products.

What's included

- 1 spreadsheet (.xlsx): Start Here · Dashboard · Products (300 SKUs) · Purchases · Sales · Adjustments · Reorder List

- Drop-down lists for SKUs, categories, channels and reasons · 1,000 rows per log

- Works in Excel (2010+), Google Sheets (free) and LibreOffice · sample data + step-by-step guide

- One-time purchase, no subscription · instant download

FAQ

Do I need Excel? No, it works in free Google Sheets (instructions included).

Can I track products sold on several platforms? Yes, each sale has a channel; the dashboard splits revenue by channel.

Does it handle variants (sizes, colors)? Give each variant its own SKU line.

Is it accounting software? No — it's a stock & profit tracker. Share the totals with your accountant.

Want to try first? Get the free Inventory Reorder Checker (25 products): https://payhip.com/b/ohBc0

Management tool, not accounting or tax advice. Licensed for use in your own business, no resale.