Getting started

Holiday budget versus actual: checking your trip against the statements

Compare a holiday budget with what your card statements show in Australian dollars, category by category, and see where the overspend came from.

Editorial illustration for Holiday budget versus actual: checking your trip against the statements

A holiday you budgeted for can still run over, and the card statements tell you exactly where. Put your planned figures in one column, the statement totals in the next, and subtract. In a few minutes you will know which categories ran over, which ran under, and whether the overall gap is a one-off or a habit to plan for next time.

How do I get the actual figures?

  1. Download the statements for each card and account that paid for the holiday.
  2. Paste them into one sheet with Date in A, Description in B, Amount in C and Category in D.
  3. Label each holiday row with a category from your budget, using the same names you planned with.
  4. In a second area list the categories and use =SUMIFS($C$2:$C$300,$D$2:$D$300,F2) beside each name in column F.

Using the same category names in the budget and the sheet is what makes the comparison work. If your budget said Food but your sheet says Meals, the formula will return zero and look like you spent nothing.

What does the comparison look like?

CategoryBudgetActualDifference
FlightsA$2,400.00A$2,468.00+A$68.00
AccommodationA$1,800.00A$1,742.50-A$57.50
FoodA$900.00A$1,096.20+A$196.20
ActivitiesA$600.00A$515.00-A$85.00
TransportA$300.00A$281.40-A$18.60
Everything elseA$200.00A$342.75+A$142.75
TotalA$6,200.00A$6,445.85+A$245.85

Positive differences are overspends. Three categories ran over by A$406.95 between them, and three came in under by A$161.10, leaving a net overspend of A$245.85. Food and Everything else are the story, and they are exactly the categories that are hardest to estimate beforehand.

Why did Food and Everything else run over?

They are made of many small rows. Flights and accommodation are one or two large, known payments, so they are easy to predict. Meals, coffee, snacks, souvenirs and transport top-ups come in dozens of small taps that nobody adds up in advance. A rough rule for next time is to budget the lumpy items from quotes and the small items from your own past trips, using this sheet.

What should I change next time?

  • Raise the food line by the overspend you saw, or decide in advance to cap it.
  • Hold a separate small amount for things you cannot name, rather than hiding it inside other categories.
  • Book the large items first and budget around them.
  • Keep the actuals column. After two trips you have a range to plan from.

How do I budget the next holiday from this one?

Use the actual column as your starting point. Take the overall difference, A$245.85 here, as a guide to how much cushion the next budget needs. Divide the total actual by the number of days and the number of people to get a rough daily figure per person, then multiply by the length and size of the next trip. It will not be exact, since prices and plans change, but it beats starting from a blank page and a guess.

Do I include things I bought for home?

Souvenirs and gifts bought on the trip belong in the trip total, since you would not have bought them at home. A new suitcase or a pair of walking shoes bought a month before you left is a judgement call. If you bought it only because of the trip, tag it as such. If it replaced something you would have replaced anyway, leave it out. Whichever way you decide, write one line in the sheet saying what you chose, so a later comparison with another holiday uses the same rule.

Also think about what you would have spent at home in the same days. Groceries you did not buy while away are a saving, but they are not part of the cost of the trip, so do not subtract them. Keep the trip figure as the money that left because of the holiday, and treat any comparison with normal life as a separate calculation.

Wrapping up

Save the sheet with the trip name and the date. Next time, copy it, clear the actuals and replace the budget column with what you learned. The planning gets better with every holiday, and the statements do all the remembering for you.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports