- Home
- Stock and Inventory Tracker
Stock and Inventory Tracker
- €14,95
Stock and Inventory Tracker
- €14,95
General information only. This workbook is a record-keeping tool. It is not accounting, tax, legal or financial advice.
The problem. You run out of the things that sell, you over-order the things that do not, and you cannot say what your stock is worth.
What this does. You keep a list of your products and add one line each time stock comes in or goes out. The workbook works out how much of each product you hold, what it is worth, what to reorder and how many days it will last.
What you can do with it
- See on-hand quantity for every product, worked out from your movements.
- Get a reorder list: everything at or below its reorder level, with a suggested order quantity, estimated cost and days of stock left.
- See your stock value, the number of products at or below reorder level, how many are out of stock, and stock value by category.
- See top sellers by units, and slow movers: stock that has not sold for a number of days you choose.
- Count the shelves on a stocktake sheet, see short and over with the value of each difference, and copy the differences into your movements.
- Keep adding movements: on-hand and sales totals read whole columns, so the list has no row limit.
How it works
- Enter your business name, currency symbol and product categories once.
- Add your products, then one line per stock movement.
- Work down the reorder list, count the shelves now and then, and check the dashboard each week.
How stock value is worked out. Units on hand multiplied by the latest unit cost you entered on a Received line. It is not FIFO and not an average cost. Negative stock is shown in red and counts as zero value.
Who it is for. Small retailers, online sellers, market stallholders and cafes that want to stop running out and stop over-ordering.
Who it is not for. Businesses that need a till or shop integration, batch or serial numbers, best-before tracking or recipes. This is a spreadsheet tracker: it does not connect to anything and does not order for you.
What you need. Microsoft Excel 2016 or later (Windows or Mac). No macros, no add-ins, no subscription and no AI.
Good to know
- Works with any currency: you set the symbol.
- 500 product rows and 3,000 movement lines are prepared. The movement totals read whole columns; the check and cost helper columns are extended by dragging down, and the dashboard warns you if you have gone past them.
- Posting stocktake differences is a copy and paste step you do yourself. There are no macros.
- Nothing is locked or password protected.
Enter your email to receive a one-time alert if this product's price decreases.
Customers also buy
Recently Viewed
© 2026 TeleWorld Online




