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.
Templates
Google-Sheets-Templates
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.
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.
Domain & Website Portfolio Tracker in Google Sheets
The Domain and Website Portfolio Tracker in Google Sheets keeps every domain cost, revenue, visitor count, renewal date and ROI on one shareable page.
Commission & Custom Order Tracker in Google Sheets
A one-page Google Sheets tracker for commissioned and custom orders: 16 columns per job, a Total Order Value KPI card, four live charts, and automatic commission, profit, margin and due-date columns.
IT Asset Management System Web App
IT Asset Management System Web App built on Google Apps Script: asset register, check-out and check-in, licence seats, contracts, tickets and depreciation across 25 screens and 7 roles, with a live demo.
Music Class Calendar in Google Sheets
A ready-to-use music class calendar in Google Sheets with annual, monthly and daily views, one Events register and 100 sample lessons for music schools and teachers.
Student Counselling Calendar in Google Sheets
A five-tab Google Sheets calendar for scheduling counselling sessions, workshops and parent meetings, with annual, monthly and daily views and 100 sample events. Scheduling only – no student identifiers, no case notes.
Investment Portfolio Tracking System Web App
Investment Portfolio Tracking System Web App: a role-based Google Apps Script system with FIFO holdings, XIRR, time-weighted returns, rebalancing, client statements and 19 reports, with a live demo.