A rental property management system web app on Google Apps Script: owners, units, leases, the monthly rent run, late fees, deposits, maintenance, owner statements and 20 reports, with live demo login details.
Blog
Google Sheets ARRAYFORMULA: Stop Dragging Formulas Down (Free Sheet)
Use one Google Sheets ARRAYFORMULA to fill a whole Total column, new rows included, and stop dragging formulas down. Free practice sheet + 44-second video.
Marketing KPI Dashboard in Google Sheets: Build a ROAS Scorecard with Formulas (Free)
Free marketing KPI dashboard in Google Sheets: filters, six KPI cards, a ROAS scorecard with Scale, Watch or Cut badges, a trend chart and a QUERY top 5.
Subscription Box Management System Web App
A Google Apps Script web app for subscription box companies: subscribers, plans, box curation, stock, shipping, renewals, dunning and churn, with a live demo for every role login.
School Dashboard in Google Sheets: Build an App-Style Dashboard with Formulas (Free)
Free school dashboard in Google Sheets: build a clickable menu, KPI cards, attendance heat map, SORTN top 3 and a month dropdown with formulas only.
Google Sheets Checkbox: Cross Out Done Tasks and Show % Done (Free Sheet)
Add a Google Sheets checkbox to a task list, cross out finished rows with a custom formula rule, and show % done with one COUNTIF. Free practice sheet.
Financial Auditing Dashboard in Google Sheets
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.
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.