One row per movement, one goal per name. Log every payday transfer, every bit of interest and every withdrawal, and the running total for each goal is one filter away. Import it into The Income Tracker and each goal gets a projected finish date.
Opens in Excel, Google Sheets, Numbers and LibreOffice. It is a plain CSV, so nothing is locked, tracked or macro-enabled.
What is in the template
Date
Description
Category
Money in
Money out
Goal
2026-09-01
Opening balance, emergency fund
Savings
1250.00
Emergency fund (target 3000)
2026-09-01
Opening balance, holiday
Savings
320.00
Holiday (target 1200)
2026-09-25
Payday transfer
Savings
200.00
Emergency fund (target 3000)
2026-09-25
Payday transfer
Savings
100.00
Holiday (target 1200)
2026-09-30
Interest
Interest
4.85
Emergency fund (target 3000)
2026-10-12
Boiler repair, paid from fund
Savings
180.00
Emergency fund (target 3000)
Columns explained:
Date: When the money moved.
Description: Payday transfer, interest, or what a withdrawal paid for.
Category: Savings for transfers and withdrawals, Interest for interest. Keeping interest separate shows how much the account is earning.
Money in / Money out: Money in for deposits and interest, money out for withdrawals.
Goal: The goal name with its target in brackets, so filtering by goal gives the balance and the gap.
How to use it
Download the CSV and add an opening balance row for each goal you already have.
Each payday, add a transfer row per goal. Set up standing orders and the rows write themselves from your statement.
Add interest when it is paid and withdrawals when you use the money.
Filter by goal and sum Money in minus Money out for the balance. Or import into The Income Tracker, where goals show a balance and a projected completion date.
Name the goals, and the order
An emergency fund first, then the specific goals. MoneyHelper's guideline is three to six months of essential outgoings for emergencies, and the emergency fund calculator on this site turns that into a monthly amount. Once it is there, the rest is choice: holiday, car, deposit, Christmas.
Log the withdrawals too
Savings you spend are still savings that did their job. Logging the boiler repair against the emergency fund shows the fund working, and shows how much needs rebuilding. That is more motivating than a balance that only ever goes up until it suddenly does not.
The Income TrackerSkip the spreadsheet. Import your bank CSV and the totals do themselves.