Inventory Tracker
Keep a running stock log instead of retyping a spreadsheet. Enter opening stock, then record deliveries, sales and physical counts by date: quantities on hand, reorder alerts and the value of your stock update as you go.
- Free
- No sign-up
- Runs in your browser
Someone shared this result with you. It was made with Inventory Tracker, free on VISU, no sign-up.
Your stock list stays in this page. Nothing is saved automatically or synced: download the private backup and import it next time to continue the log.
Items
Opening stock is the quantity on hand before the first movement. Use up to two decimals, without thousands separators.
Stock movements
Movements are applied in date order. A count replaces the quantity on hand and records the difference.
Up to 200 items and 1,000 movements. Quantities up to 1,000,000 and unit costs up to 100,000. CSV opens in Excel or Google Sheets; it is not an .xlsx file.
Your document
Add an item with a SKU and a name to see stock levels.
What makes it work
A log, not a snapshot
Every quantity comes from the opening stock plus dated movements, so you can see why a number changed instead of overwriting it.
Counts correct the books
A physical count replaces the calculated quantity and keeps the difference, which shows shrinkage, breakage or unrecorded sales.
Alerts from your minimum
You set the minimum for each item. Anything at or below it is listed first with how much is missing, before you place the next order.
Inventory Tracker in VISU
Open this tool in VISU to create and save new work to your account. Your work on this page won't transfer.
Open this tool in VISUHow to use it
- Add each item with a SKU, name, unit, opening stock, minimum level and unit cost.
- Record movements by date: stock in for deliveries, stock out for sales or use, and physical count when you count the shelf.
- Review the reorder alerts for items at or below their minimum, and the total stock value.
- Download the stock levels or the movement log as CSV for Excel or Google Sheets, print, and keep the private backup to continue next time.
Examples
Coffee shop mugs
40 mugs, plus 12 delivered, minus 25 and 20 sold, leaves 7. With a minimum of 10, the mug is flagged as low and 3 short.
Monthly tea count
The log expects 5.5 kg but the shelf has 4.25 kg. The count sets stock to 4.25 kg and records a -1.25 kg difference.
Questions
Can I open the export in Excel or Google Sheets?
Yes. The CSV files open in Excel, Google Sheets or Numbers. The tool does not create .xlsx files. Cells that start with =, +, - or @ are prefixed so they are not run as formulas.
What is the difference between a physical count and stock in or out?
Stock in and stock out add or subtract a quantity. A count states what is actually on the shelf: it replaces the calculated balance and records the difference.
When does an item get a reorder alert?
When its quantity on hand is at or below the minimum level you entered, or at zero. The tool does not calculate a reorder point from lead time and demand; the Reorder Point Calculator does that.
Why was a stock out refused?
A movement cannot take more than the quantity on hand on that date. Check the dates and the order of deliveries, or record a count if the shelf has more than the log.
Is the stock value an accounting valuation?
No. It is the quantity on hand multiplied by the unit cost you entered. It does not apply FIFO, average cost, taxes or depreciation.
