Inventory Tracker with Reorder Alerts Spreadsheet

**Know what you actually have on the shelf, and get told what to reorder before you run out.**

Stock is not a number you type in and hope. In this file it is calculated from every movement in and out, so the number on screen is the number on the shelf.

**INSIDE THE FILE — 6 TABS**

- Products — 60 products with cost, retail price, reorder point, lead time and supplier

- Movements — 200 rows of stock in, stock sold, and anything lost or gifted

- Stock — live on-hand quantity per product, with a status flag on every line: OK, Getting low, Reorder now, Out of stock

- Reorder — your shopping list, priced up, with the date you need it by

- Dashboard — stock value at cost and at retail, by category

- Start here — plain-English instructions

**WHY THIS ONE**

- A reorder point per product, because a cheap component and an expensive one do not need the same buffer

- Lead time in days, so the reorder list tells you the date to order by, not just what is low

- Values your stock twice: what you paid for it, and what it is worth if it all sells

- Handles losses and gifts, so breakages do not silently corrupt your count

**WHO IT IS FOR**

Handmade sellers, small manufacturers, resellers, market traders, anyone holding materials or finished stock and tired of counting boxes twice.

**WHAT YOU GET**

- 1 x XLSX file (opens in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice Calc)

- A "Start here" tab written in plain English

- Every cell pre-filled with a worked example, so you can see how it behaves before you touch it

**HOW IT WORKS**

Cream cells are the ones you type in. Grey cells work themselves out. That is the whole rule.

No macros. No pivot tables. No add-ons. Everything is built from ordinary formulas and dropdowns, which is why it behaves the same way in Excel and in Google Sheets. Nothing to enable, nothing to trust, nothing that breaks on the other side.

**TO USE IT IN GOOGLE SHEETS**

Google Drive > New > File upload > right-click the file > Open with > Google Sheets. That is it. No add-on, no permissions request.

**DELIVERY**

Instant download. Etsy emails you the file the moment payment clears. Nothing is posted to you.

**LICENCE**

Use it in your own business as much as you like, on as many devices as you like. Please do not resell, redistribute or share the file itself.

**A NOTE ON THE EXAMPLE DATA**

The file arrives filled in with example numbers so nothing looks empty and you can see every formula working. Type straight over them with your own.

Questions before you buy? Message me — I answer the same day.