Build a quote and estimate template in Google Sheets: dropdowns, XLOOKUP, tax on materials only, a profit check and a print-ready PDF. Free practice file.
Blog
10 Google Sheets Formulas for Work: Build One Real Sales Report (Free Practice File)
10 Google Sheets formulas for work on one real sales report: SPLIT, XLOOKUP, IFS, NETWORKDAYS, TEXT, UNIQUE, SUMIFS, AVERAGEIFS, COUNTIFS and SORTN. Free practice file.
Business Expense Tracker in Google Sheets: Free Template with Monthly Summary and Chart
Build a business expense tracker in Google Sheets: category dropdown, one SUMIFS monthly summary, budget status colours, KPI cards and a spend vs budget chart. Free template.
Asset Tracking System Web App
An asset tracking system web app on Google Apps Script: asset register with QR code tags, check-out and check-in, work orders, maintenance plans, depreciation, physical audits, 17 reports and 7 roles, with live demo login details.
Task Management Tracker in Google Sheets 2026: Build a Project Task Tracker Step by Step
Build a task management tracker in Google Sheets 2026 step by step: owner dropdowns, tick boxes, SPARKLINE progress bars, automatic overdue status and a live dashboard.
Purchase Order and Vendor Management System Web App
A purchase order and vendor management system web app on Google Apps Script: requisitions, approvals by amount, receiving, three-way match, payments, budgets, 14 reports and 7 roles, with live demo login details.
9 Google Sheets Tricks for Business Reports: Build a Weekly Sales Report That Updates Itself (Free)
Nine Google Sheets tricks for business reports: dropdown chips, ARRAYFORMULA, QUERY, SPARKLINE, FILTER, a slicer and a live title. Free practice file.
Invoice Template in Google Sheets: Auto Invoice Number, Customer Dropdown & Sales Tax (Free)
Free invoice template in Google Sheets: automatic invoice number, customer dropdown with XLOOKUP, item prices, sales tax on taxable lines only and a status box that turns green when paid.
Manufacturing OEE Dashboard in Google Sheets: Track Downtime, Scrap and OEE
A Google Sheets OEE dashboard that shows availability, performance, quality, downtime Pareto, MTBF, MTTR and scrap cost by plant, line and shift.
Reseller Profit Tracker in Google Sheets and Excel
A reseller profit tracker for Google Sheets and Excel that works out platform fees, net profit, ROI and days to sell on every eBay, Poshmark, Etsy, Mercari and Amazon item.