Build an inventory tracker in Google Sheets step by step: a stock log with dropdowns, XLOOKUP item names, Stock In and Stock Out with SUMIFS, current stock and value, reorder alerts with colors and KPI cards. Free practice file.
Blog
Warehouse Inventory Management System Web App
A warehouse inventory management system web app on Google Apps Script: stock by bin, batch and expiry, FEFO pick and dispatch, cycle counts, barcode labels, 25 reports and 7 roles, with live demo login details.
How to Make a To Do List in Google Sheets with Checkboxes (Free Template)
Build a Google Sheets to do list template step by step: checkboxes, Category and Priority dropdowns, automatic Overdue and Due Soon status, Days Left, KPI cards and a progress bar. Free template included.
Boiler Maintenance KPI Scorecard in Google Sheets
Boiler Maintenance KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.
Electronics Retail Dashboard in Google Sheets
A six-tab Electronics Retail Dashboard in Google Sheets: 16 KPI cards, 15 slicers and 18 pivot-driven charts over 500 sample orders, 8 categories, 10 brands and 4 channels.
Windshield Repair and Replacement KPI Scorecard in Google Sheets
A 10-KPI traffic-light scorecard for windshield repair and auto glass shops in Google Sheets: service mix, install quality, claims and revenue KPIs, a KPI Trend page, setup steps and the known issues to fix first.
Generator Service KPI Scorecard in Google Sheets
Generator Service KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.
Junk Removal Services KPI Scorecard in Google Sheets
Junk Removal Services KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.
Moving Company KPI Dashboard in Google Sheets
A Google Sheets KPI dashboard for moving companies: 12 KPIs in six groups, MTD and YTD against target and prior year, traffic lights, a KPI Trend page and group analysis.
SaaS MRR & Churn Tracker in Google Sheets
A one-page SaaS MRR and Churn Tracker in Google Sheets: live Total Active MRR, Active Customers and Churn Rate cards, four charts, and a 16-column account log with automatic LTV, ARPU per seat, Health Score and Risk.