An audit dashboard in Google Sheets with 4 KPI cards, 15 slicers and 18 charts over 500 sample engagements from 6 offices, 8 partners and 8 industries.
Blog
Loan Tracker Google Sheets: Build a Loan & EMI Tracker with Overdue Alerts (Free)
Free loan tracker Google Sheets template: build a loan and EMI tracker with PMT, FV, EDATE, SPARKLINE repaid bars and Overdue / Due Soon / On Track badges.
Loan & EMI Management System Web App: Run Your Whole Loan Book in Google Sheets
A loan and EMI management system web app on Google Apps Script: borrowers, KYC, EMI schedules, payments, late fees, aging and collections, with a live 6-role demo.
Budget Dashboard Google Sheets: Build a Monthly Budget vs Actual Tracker (Free)
Free budget dashboard Google Sheets template: build a monthly budget vs actual tracker with XLOOKUP, SUMIFS and EOMONTH, ARRAYFORMULA, SPARKLINE progress bars and Over / Watch / OK badges.
Dairy Dashboard in Google Sheets: Sales, Plants and Quality
A dairy dashboard in Google Sheets with 4 KPI cards, 15 slicers and 17 charts over 500 sample orders from 6 plants, 8 products and 12 customers.
Restaurant Reservation Template in Google Sheets: Build a Table Reservation Tracker (Free)
Free restaurant reservation template in Google Sheets: build a table reservation tracker with dropdowns, one XLOOKUP for section and seats, an IF seat check, a COUNTIFS double-booking check and summary cards.
Food Bank Management System Web App
A food bank management system web app on Google Apps Script: donations, lots by best-by date, partner agency orders with FEFO picking, households, volunteers, 28 reports and 7 roles, with live demo login details.
How to Build a Bakery Order Tracker in Google Sheets (Free Template)
Build a bakery order tracker in Google Sheets step by step: item and status dropdowns, XLOOKUP prices, ARRAYFORMULA totals and balances, overdue pickup alerts, a SUMIFS bake list and summary cards. Free cake order template.
Training Matrix Template in Google Sheets: Employee Training Tracker
A training matrix template in Google Sheets: log every training once, get automatic expiry dates, days left and Valid / Due Soon / Expired status, plus an employee x course matrix that builds itself.
Toy & Games Industry Dashboard in Google Sheets
A six-page Toy & Games Industry Dashboard in Google Sheets: 4 KPI cards, 15 slicers and 16 charts over 500 sample orders, 10 categories, 8 brands and 4 channels.