sheetsmith

Templates › Plans and occasions

Holiday & Trip Budget

Made for people planning a big trip.

Plan every trip cost by category, compare estimates against what you actually paid, map the trip day by day, and see how much of the travel pot is left. The summary carries a chart that redraws itself as you type.

Tabs
4
Columns
26
Fill themselves in
22

£7one payment, yours to keep

  • Opens in Excel, Google Sheets and Numbers
  • Delivered straight away
  • No macros, nothing to install
  • Change it free before you buy

Payment is handled by Stripe. Your card details go to them and never to us. Sales are final, which is why every tab, column and calculation is shown on this page first.

The workbook's summary and the table behind it
A row typed into the real file. Every figure that changes is the spreadsheet's own arithmetic.
The summary page, every figure calculated from the tables
The chart, drawn from the totals in the table beside it
What is inside: the tabs, the columns and what fills itself in
Where you type, and the shaded columns that work themselves out
The guide sheet that opens first and explains the file
Everything included in the download

Everything inside, before you pay

This is the whole design: every tab, every column and how each calculated one is worked out. White cells are yours to fill in; the shaded ones work themselves out and are locked so a formula cannot be overwritten by accident. There is room for 480 rows.

Budget Items

One row per thing you are paying for, with the estimate and the real figure side by side. Room for 300 rows.

ColumnTypeWorked out as
Itemtext
Categorychoice (list)
Booking Statuschoice (list)
Pay Bydate
Estimated Costcurrency
Actual Paidcurrency
DifferencecurrencyIF(ISBLANK([actual]), "", ROUND([actual]-[estimated], 2))
Difference %percentIF(ISBLANK([actual]), "", IFERROR(([actual]-[estimated])/[estimated], 0))
Still To PaycurrencyIF(ISBLANK([estimated]), "", IF(ISBLANK([actual]), [estimated], MAX([estimated]-[actual], 0)))
Notestext

Itinerary

The trip day by day, with the spending money you expect to need each day. Room for 120 rows.

ColumnTypeWorked out as
Daynumber
Datedate
Wheretext
Plan For The Daytext
Staying Attext
Main Transportchoice (list)
Estimated Day Spendcurrency
Actual Day Spendcurrency
Day DifferencecurrencyIF(ISBLANK([actual_day_spend]), "", ROUND([actual_day_spend]-[est_day_spend], 2))
Days From TodaynumberIF(ISBLANK([date]), "", [date]-TODAY())
Notestext

Travel Pot

Money set aside for the trip. Everything paid in here is what the spending comes out of. Room for 60 rows.

ColumnType
Sourcetext
Date Addeddate
Amount Incurrency
Methodchoice (list)
Notestext

Trip Summary

The headline numbers: what the trip is estimated to cost, what has gone out already and what is left in the pot.

MeasureWorked out as
Total In The PotSUM([Travel Pot!amount])
Total Estimated CostSUM([Budget Items!estimated]) + SUM([Itinerary!est_day_spend])
Total Spent So FarSUM([Budget Items!actual]) + SUM([Itinerary!actual_day_spend])
Left In The PotSUM([Travel Pot!amount]) - (SUM([Budget Items!actual]) + SUM([Itinerary!actual_day_spend]))
Still To Pay On EstimatesSUM([Budget Items!outstanding]) + MAX(SUM([Itinerary!est_day_spend]) - SUM([Itinerary!actual_day_spend]), 0)
Pot Against Full EstimateSUM([Travel Pot!amount]) - (SUM([Budget Items!estimated]) + SUM([Itinerary!est_day_spend]))
Share Of Estimate SpentIFERROR((SUM([Budget Items!actual]) + SUM([Itinerary!actual_day_spend])) / (SUM([Budget Items!estimated]) + SUM([Itinerary!est_day_spend])), 0)
Over Or Under On Paid ItemsSUM([Budget Items!variance]) + SUM([Itinerary!day_variance])
Items Not Booked YetCOUNTIF([Budget Items!booking_status], "Not Booked")
Items Fully PaidCOUNTIF([Budget Items!booking_status], "Paid")
Spent On FlightsSUMIF([Budget Items!category], "Flights", [Budget Items!actual])
Spent On AccommodationSUMIF([Budget Items!category], "Accommodation", [Budget Items!actual])
First Day Of The TripIF(COUNT([Itinerary!date])=0, "", MIN([Itinerary!date]))
Last Day Of The TripIF(COUNT([Itinerary!date])=0, "", MAX([Itinerary!date]))
Days PlannedCOUNT([Itinerary!date])
Days Until DepartureIF(COUNT([Itinerary!date])=0, 0, MIN([Itinerary!date]) - TODAY())
Average Estimated Spend Per DayIFERROR(SUM([Itinerary!est_day_spend]) / COUNT([Itinerary!date]), 0)