Online Tutorial for Data Analysis and Automation
A complete guide to the Inventory Tracker in Google Sheets: the Dashboard with four KPIs and slicers, the Inventory, Movements, Suppliers, Reorder, Search and Instructions tabs, how to load your own items and when a spreadsheet is the right inventory tool.
Track stock IN, stock OUT and transfers across four warehouses in Google Sheets, with closing stock and stock value for any date. See each tab, a worked example and the formula logic.
Track stock in and out, see closing balances for any date and get reorder alerts with a free four-tab inventory management system in Google Sheets, with the formulas explained.