Travel and vehicles

Trip budget vs actual template: see where you overspent

A trip budget vs actual template with budget, actual, difference and a one-line reason per category, shown on a made-up trip.

Editorial illustration for Trip budget vs actual template: see where you overspent

A trip budget vs actual sheet has five columns: category, budget, actual, difference and a one-line reason. After the trip you subtract budget from actual for each category, total the column and read the reasons. The table below is a made-up trip where food and shopping ran over, stay and activities came in under, and the overall result hides what really happened.

What does the template look like?

Copy these headers into row 1 of a sheet: Category, Budget, Actual, Difference, Difference as a share of budget, Reason. Fill the budget column before you leave and the actual column after you return, from your records.

CategoryBudget (₹)Actual (₹)Difference (₹)Reason
Flights and trains24,00024,0000Booked early, no change
Stay28,00025,200-2,800Cheaper last night
Food16,00021,500+5,500Two restaurant dinners not planned
Local transport6,0007,200+1,200Cabs after a late return
Activities8,0006,500-1,500Skipped one paid tour
Shopping5,0009,400+4,400Gifts, and a jacket
Miscellaneous3,0002,100-900Fewer tips than planned
Total90,00095,900+5,900Over by a small margin

Which formulas do I need?

  • Difference in D2: =C2-B2. A positive number means you spent more than planned, and a negative one means you spent less.
  • Difference as a share of budget in E2: =D2/B2, formatted as a percentage.
  • Totals in row 9: =SUM(B2:B8) and =SUM(C2:C8), with the difference total in D9 as =C9-B9.
  • A quick check: the differences in D2 to D8 should add up to D9. Here, 0 - 2,800 + 5,500 + 1,200 - 1,500 + 4,400 - 900 is 5,900, matching 95,900 minus 90,000.

What does the overall result hide?

The trip went ₹5,900 over, which is 5,900 divided by 90,000, about 6.6 per cent. That sounds mild. Look at the lines and the picture changes: food was over by 5,500 on a 16,000 budget, about 34 per cent, and shopping by 4,400 on a 5,000 budget, about 88 per cent. The stay and activities savings of 4,300 masked most of it. Reading only the total would tell you the budget was nearly right when two categories were badly off.

How do I write a useful reason?

One line, in plain words, naming the cause and not the amount. Cabs after a late return explains more than cabs over budget. A good reason helps when you plan the next trip: it separates things you could have predicted, such as dinners out, from one-offs, such as a missed train.

What about costs that were not in the budget at all?

Add a row called Not budgeted for anything that has no category in your plan, such as a pharmacy visit, a lost-luggage purchase or a visa photo. Leave its budget as zero, so the difference column shows the full amount. A recurring Not budgeted line of a few thousand rupees is a sign that your categories are missing something, and it is cheaper to add that category next time than to keep being surprised by it.

What should I do with the result?

  1. Mark each over or under line as planned-for next time, one-off or a flaw in the budget.
  2. Fix the flaws: if food was over because dinners were not budgeted, add them next time.
  3. Leave one-offs alone, but note them.
  4. Keep the sheet. After two or three trips, the same categories will keep appearing at the top.

Can a tracker fill the actual column for me?

It can help. If your trip spending is already categorised, a report grouped by category over the trip dates gives you the actual column without retyping. In SpendixAI, reports can be filtered and grouped and downloaded as CSV, so the actual column can be pasted straight into the template. The budget and reasons stay yours to write.

SPENDIXAI JOURNAL

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

Explore your reports