Sinking Funds Planner Excel — A fund for every future bill: target, saved so far, monthly set-aside, and the date each fund is full. Built for anyone who wants the whole picture on one page: what the goal is, what is…
About this template
Sinking Funds Planner Excel — A fund for every future bill: target, saved so far, monthly set-aside, and the date each fund is full. Built for anyone who wants the whole picture on one page: what the goal is, what is actually there, and which line is quietly falling behind — without accounting software or a subscription app. If one line is underfunded, this workbook shows it while there is still time to fix it.
$39
Excel & Google Sheets template — instant download on Etsy
Funds Planner — Every sinking fund: target, saved so far, remaining, percent saved, monthly set-aside, and months to goal — remaining, percent, and months by formula.
Contribution Log — Every contribution January-October: date, fund, description, amount, and account, with a running total and each entry's share of the total by formula.
Monthly Plan — Month by month: planned deposits, actual deposits pulled from the log by formula, the difference, and cumulative planned vs actual.
Category Summary — Funds grouped by category: how many funds, total target, total saved, remaining, and percent saved — all by formula from sheet 1.
Dashboard — Total target, total saved, remaining, percent funded, monthly set-asides, log totals, and the strongest and weakest funds.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Sinking Funds Planner Excel
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
The included example shows: Target 19,700; current 7,980; remaining 11,720; 40.5 percent complete overall.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.