A Sinking Fund Tracker in Google Sheets: Spreading Irregular Expenses into Monthly Set-Asides
How to build a Google Sheets tracker that spreads lumpy annual expenses into monthly set-aside amounts, with formulas for funding percentage and countdown.
Google-Sheets
Sheet
Updated
A Client Retainer Tracker in Google Sheets: Banked Hours, Rollover Caps, and Overage Billing
Build a Google Sheets retainer tracker that calculates hours used, rolls over unused hours up to a cap, and bills overage automatically.
An Invoice Aging and Late Fee Calculator in Google Sheets
Build an aging bucket system and automatic late fee formula for overdue invoices in Google Sheets, using DATEDIF, nested IFS, and SUMIFS.
A 13-Week Cash Flow Forecast in Google Sheets: Weekly Buckets and a Running Balance
Build a rolling 13-week cash flow forecast in Google Sheets using SUMIFS to bucket transactions by week and a running balance formula.
A Subscription Tracker in Google Sheets: Auto-Renewing Dates and a Normalized Monthly Cost Formula
Build a subscription and recurring expense tracker in Google Sheets that calculates renewal dates automatically and normalizes annual, quarterly, and monthly charges into one comparable figure.
A Debt Payoff Calculator in Google Sheets: Snowball vs. Avalanche with a Rolling Extra-Payment Formula
Build a Google Sheets calculator that ranks debts by snowball or avalanche order and rolls freed-up minimum payments into the next target automatically.
Freelance Invoice and Expense Tracker: A Two-Tab Spreadsheet That Scales
A Google Sheets template for freelancers: an invoice log with automatic overdue flags, and an expense tab that rolls up by category and quarter for tax prep.
Building a Loan Amortization Schedule in Google Sheets
How to build a full month-by-month amortization schedule in Sheets using PMT, IPMT, and PPMT, plus a running balance that hits exactly zero at term end.
Building a Break-Even Calculator in Google Sheets: Contribution Margin and a What-If Table
How to build a break-even calculator in Google Sheets using contribution margin formulas, plus an ARRAYFORMULA sensitivity table for price and cost changes.
A Simple ROI Calculator in Google Sheets: NPV, IRR, and Payback Period
How to build a small ROI calculator in Google Sheets using NPV, IRR, XIRR, and a payback period formula, with the mechanics of each explained.
A 50/30/20 Budget Tracker in Google Sheets, Formula by Formula
How to build a self-updating 50/30/20 budget tracker in Google Sheets: category tagging, SUMIF rollups, and a progress bar that doesn't need manual updates.