Small Business Inventory & Sales Tracker (Excel & Google Sheets)

Running a small shop or online store? This tracker shows what you have in stock, what is selling, and how much profit you make, without writing a single formula.

What's inside:

- Dashboard: total sales, profit, margin, stock value, items to reorder, and a monthly sales vs profit chart

- Products: current stock updates automatically from your purchases and sales

- Low-stock alerts: products at or below your reorder level turn red

- Purchases and Sales: pick the product from a dropdown; name, totals and profit fill in automatically

- Start Here guide with simple instructions

- Example data included so you can see how it works, then replace it with your own

Details:

- Works in Microsoft Excel and Google Sheets

- Room for 200 products, 1,000 purchases and 2,000 sales

- Formulas are protected so they can't be broken by accident

- Any currency (set your symbol in Settings)

Who it's for: small retail shops, hardware and supply stores, online sellers, and anyone who buys and sells physical products.

Licence: for use by one business. Please don't share or resell the file.

Made by a business owner who uses this kind of tracking every day in a hardware and building-materials trading business.

Questions? Message me through this shop and I'll help.