Sinking Funds Tracker Spreadsheet, Sinking Funds Dashboard, Monthly Savings Planner, Savings Goal Tracker, Google Sheets & Excel, 30 Funds

Sinking funds tracker spreadsheet for the big costs you know are coming: car insurance, Christmas, holidays, repairs, school costs. Add up to 30 funds with a target and a date, and the sheet tells you how much to put aside each month for each one.

WHAT'S INSIDE
- Start Here: three steps, one color rule (yellow cells are where you type) and quick answers
- Setup: currency symbol, year, an optional report date and editable fund groups
- Funds (up to 30): target, target date and anything already saved; the sheet works out the balance, still needed, months left, needed per month, a progress bar and a status (Funded, On track, Behind, Due now)
- Optional "my monthly amount" per fund, with the month the fund will be full at that amount
- Transactions: one list for every deposit and withdrawal (1,000 rows), with a check column that flags mistakes
- Yearly Overview: money into each fund in each month, with totals for deposits and withdrawals
- Dashboard: total saved, total of all targets, overall progress, needed per month, funds funded, the next five target dates and 2 charts

HOW IT WORKS
1. Add your funds: what you're saving for, how much and by when.
2. Log as you go: each deposit and each withdrawal. Balances update themselves.
3. Follow the plan: put aside the monthly amount and watch each bar fill up.

GOOD TO KNOW
- The monthly amount is rounded up to the cent, so following it gets you to the target on time.
- Progress bars are built from text, so they also show in Google Sheets.
- Every formula was tested in LibreOffice with a filled sample year and uses only functions Excel and Google Sheets share. No macros.

FILE FORMAT
You receive one ZIP file containing:
- Sinking_Funds_Tracker.xlsx (blank, ready to use)
- Sinking_Funds_Tracker_Example.xlsx (filled with an invented family's year)
- Quick_Start_Guide.pdf (4 pages)
- Google_Sheets_Links.pdf (click to make your own copy in Google Sheets)
Works in Excel 2010 or later, Excel for Mac, Google Sheets and LibreOffice. Any currency. Apple Numbers can open the file but is not supported.

Digital download, nothing is shipped.

Because this is a digital file, returns and exchanges aren't accepted. If something isn't working, message me and I'll help put it right.

Not financial advice. The workbook helps you plan and track your own savings.

Designed by WrenWorks with AI assistance.