A vacation fund stays alive when you can see it move, and a milestone chart makes it move in four clear steps. Set a dollar target, mark 25, 50, 75 and 100 per cent, and decide in advance what happens to any extra money that arrives, such as a bonus or a payment for a side job. For a C$4,500 trip those milestones are C$1,125, C$2,250, C$3,375 and C$4,500.
How do the milestones work?
Four lines in a sheet, each with a target amount, the date you expect to reach it and a note on what it unlocks. They break a fifteen-month goal into stretches of under four months.
| Milestone | Amount saved | Expected by | What it means |
|---|---|---|---|
| 25% | C$1,125 | Month 4 | Pick the destination and dates |
| 50% | C$2,250 | Month 8 | Compare flight prices |
| 75% | C$3,375 | Month 12 | Book flights and lodging |
| 100% | C$4,500 | Month 15 | Fund the daily spending |
C$4,500 over fifteen months is C$300 a month, so month four holds C$1,200, a little past the first milestone, and month eight holds C$2,400. The sheet should show this overshoot, not hide it.
What is the windfall rule?
A windfall is money you did not plan on: a work bonus, a gift, the sale of something you no longer use or a one-off payment from a side job. Without a rule it dissolves into groceries. A common rule is to split it: half to the vacation fund and half to you. Say a C$800 bonus arrives in month three. Under the half rule C$400 goes to the fund, which lifts the balance from C$900 to C$1,300 and moves the 25 per cent milestone forward a month.
Write the rule on the sheet's front page in one line. Having it in advance removes the debate when the money arrives.
How do you make progress visible?
- A progress bar made with a conditional format on one cell
- A single row at the top that shows percentage saved and months to go
- A monthly screenshot or note kept in the same folder as the sheet, so you can look back
- A short line in your calendar on the first of each month: update the balance
For the percentage, divide the balance by the target. If the balance is in B2 and the target in B1, =B2/B1 gives the share, and formatting as percentage shows 25% when B2 equals 1125.
What if you fall behind?
Compare the balance with the milestone date every month. If month four arrives and you hold C$1,000 instead of C$1,200, the gap is C$200. You can add C$25 a month for eight months, delay the first milestone by a month or lift the windfall share to two thirds for the next payment. All are valid; the failure is not noticing.
What do you do when the trip itself changes?
Plans shift: a partner's leave moves, a flight price jumps or you decide on a shorter stay. When it happens, re-price the trip in the same parts you used at the start and compare the new total with the old target. If the new target is C$4,200 and you already hold C$2,400, the remaining gap is C$1,800. Divide that by the months left and set the new transfer. Update the milestone rows rather than deleting them, and add a short note with the date and the reason. A sheet that records its own changes is far easier to trust than one that was quietly rewritten.
Your set-up list
- Choose the destination range and price the trip in rough parts.
- Fix the target and the date you want to book.
- Create four milestone rows with dates.
- Write the windfall rule on the first line of the sheet.
- Set a monthly update reminder.
A footnote: SpendixAI, which is built around India and rupees, has savings goals that sit apart from expense records, but it is not a tool for Canadian dollars, so use the sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

