One big number is hard to save towards and easy to raid. Break the holiday into a price per day, split that day into parts, and track each part's own savings bar. A ten-day trip at €210 a day is €2,100 in total, but seeing '€600 of €840 for lodging' tells you far more about where you stand than a single total.
How do you price a trip per day?
Start with the number of days and add parts that behave differently. Flights and lodging are fixed and usually must be paid in advance, while food and activities can be adjusted on the trip. Here is a made-up ten-day plan.
| Part | Total | Per day | Share of trip |
|---|---|---|---|
| Transport there and back | €640 | €64 | 30% |
| Lodging | €840 | €84 | 40% |
| Food | €420 | €42 | 20% |
| Activities and extras | €200 | €20 | 10% |
| Whole trip | €2,100 | €210 | 100% |
The per-day column is the total divided by ten, and the shares are rounded: 640 out of 2,100 is 30.5 per cent, shown as 30. The detail matters less than the discipline of having four buckets rather than one.
Why track each part separately?
Because the parts come due at different times. Transport and lodging must be paid months ahead, so those two buckets must be full first. Food and activities can fill last, since they are spent on the trip. If your progress report shows each bucket, you can see that transport is full and food is empty and know that the timeline is on track even though the total looks half done.
In what order should you fill the buckets?
- Fill transport and lodging first, in the months before the booking date.
- Fill food next.
- Fill activities and extras in the final months.
- Keep a small extra amount for surprises and add it to whichever bucket you spend from.
With €175 a month for twelve months you reach €2,100. Transport and lodging together come to €1,480, so if you book in month eight, a payment of about €185 a month for those two parts alone would be ready in time. Choose the sequence to suit your booking date.
What does the tracking sheet need?
- One row per bucket with target, saved so far and percentage
- A total row that adds the saved column and divides by the full target
- A log below with date, bucket, amount in or out and a short note
- A cell for the date you will book, so a quick look shows months remaining
The percentage per bucket is saved divided by target. A cell with =C2/B2 in a row where B2 is the target and C2 is the amount saved does the job. For the total, =SUM(C2:C5)/SUM(B2:B5). In some European regional settings the formula separator is a semicolon rather than a comma, so use whichever your sheet accepts.
What if you travel with others?
Agree who pays for which part. If one person books flights and the other lodging, each keeps a bucket and both read the shared sheet. When you book, record the actual price and compare it with the estimate: a difference of €50 on lodging goes into the next version of the plan.
Before you start
Decide your booking date, price each part with a visit to a booking site or a quote and give yourself one small cushion. SpendixAI is built around India and rupees, so it is not aimed at euro plans, but if you ever plan a rupee trip, its savings goals keep contributions separate from spending.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

