Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Savings goal open in Sheets, in the light themeSavings goal open in Sheets, in the dark theme

What is in it

A target and a date, each amount put by, how much is left to save, and what that comes to each month until the date. The figures are examples to type over.

Savings goal
What for[A deposit, a holiday, money for a rainy day]
Target3000
By2027-06-30
Saved so far=SUM(B13:B60)
Still to save=MAX(0,B3-B6)
Reached=IF(B3=0,"",ROUND(B6/B3*100,0)&"%")
Whole months left=IF(B4<=TODAY(),0,DATEDIF(TODAY(),B4,"m"))
To save each month=IF(B9=0,B7,ROUND(B7/B9,2))
DateAmountNote
2026-11-01250First amount put by
2026-11-28150

Worked out for you

These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.

Saved so far
=SUM(B13:B60)
Still to save
=MAX(0,B3-B6)
Reached
=IF(B3=0,"",ROUND(B6/B3*100,0)&"%")
Whole months left
=IF(B4<=TODAY(),0,DATEDIF(TODAY(),B4,"m"))
To save each month
=IF(B9=0,B7,ROUND(B7/B9,2))

Filling it in

  • Set the date first, then the target. “£3,000 by June” can be planned; “save more” cannot.
  • Add every amount on the day you move it. The monthly figure updates and tells you whether you are ahead.
  • Keep the savings somewhere separate from the account you spend from.

More templates

All 32 templates