Travel budget planner with currency conversion template

	A	B	C
1	Travel budget planner
2	Example data — replace the blue input cells with your own.
3
4	Trip details
5	Trip	Example trip to Mexico City	Fictional example. All amounts are converted to USD.
6	Start date	Apr 10, 2027
7	End date	Apr 19, 2027
8	Travelers	2
9	Days (start to end, inclusive)	10
10	Nights	9
11
12	Totals (USD)
13	Total budget	$4,200
14	Spent so far (logged expenses)	$3,271	From the Expenses tab
15	Remaining	$929
16	Share of budget used	78%

	A	B	C	D	E	F	G	H
1	Travel budget by category (USD)
2	Budget amounts are typed in USD. Spent amounts come from the Expenses tab, converted with the rates on the Rates tab.
3
4	Category	Budget (USD)	Spent (USD)	Remaining (USD)	Used	Budget per day	Budget per person	Spent per person
5	Flights	$900	$812	$88	90%	$90	$450	$406
6	Accommodation	$1,800	$1,724	$76	96%	$180	$900	$862
7	Local transport	$250	$136	$114	54%	$25	$125	$68
8	Food and drink	$450	$143	$307	32%	$45	$225	$71
9	Activities and tickets	$300	$164	$136	55%	$30	$150	$82
10	Shopping and souvenirs	$250	$178	$72	71%	$25	$125	$89
11	Insurance and fees	$150	$97	$54	64%	$15	$75	$48
12	Other	$100	$17	$83	17%	$10	$50	$8
13	Total	$4,200	$3,271	$929	78%	$420	$2,100	$1,635
14
15	Checks
16	Logged USD matches the category totals	OK

	A	B	C	D	E	F	G
1	Expense log in local currency
2	Enter each expense in the currency you paid. The rate is looked up on the Rates tab and the amount is converted to USD.
3
4	Date	Category	Description	Currency	Amount (in currency)	Units per USD	Amount (USD)
5	Feb 3, 2027	Flights	Round-trip flights for two	USD	812.40	1.00	$812.40
6	Feb 10, 2027	Accommodation	Apartment deposit	MXN	6,000.00	17.40	$344.83
7	Apr 10, 2027	Accommodation	Apartment balance, 9 nights	MXN	24,000.00	17.40	$1,379.31
8	Apr 10, 2027	Local transport	Airport transfer	MXN	900.00	17.40	$51.72
9	Apr 11, 2027	Local transport	Ride-hailing	MXN	320.00	17.40	$18.39
10	Apr 11, 2027	Food and drink	Breakfast and lunch at a market	MXN	650.00	17.40	$37.36
11	Apr 12, 2027	Food and drink	Dinner for two	MXN	1,450.00	17.40	$83.33
12	Apr 13, 2027	Activities and tickets	Museum entry for two	MXN	460.00	17.40	$26.44
13	Apr 14, 2027	Activities and tickets	Guided day trip	MXN	2,400.00	17.40	$137.93
14	Apr 15, 2027	Shopping and souvenirs	Ceramics and textiles	MXN	3,100.00	17.40	$178.16
15	Apr 16, 2027	Insurance and fees	Trip cancellation insurance	USD	96.50	1.00	$96.50
16	Apr 17, 2027	Food and drink	Coffee and pastries	MXN	380.00	17.40	$21.84

	A	B	C	D
1	Currency rates (example values)
2	Example rates for illustration only. Replace them with the rates you plan to use before you travel.
3
4	Currency code	Currency	Units per 1 USD	Note
5	USD	US dollar (base currency)	1.00	Base currency
6	EUR	Euro	0.92	Example rate
7	GBP	Pound sterling	0.79	Example rate
8	MXN	Mexican peso	17.40	Example rate
9	CAD	Canadian dollar	1.37	Example rate
10	JPY	Japanese yen	152.00	Example rate
11	AUD	Australian dollar	1.52	Example rate
12	CHF	Swiss franc	0.88	Example rate
13
14
15
16	Units per 1 USD: how many units of the currency one US dollar buys. Amount in USD = amount in currency divided by this number.

	A
1	Travel budget planner with currency conversion
2	Notes: what this workbook does, how to use it and the method behind it.
3
4	What it does
5	Budgets a trip by category in USD and logs each expense in the currency you paid. A lookup table converts every expense to USD, and the budget tab shows spending per day and per person.
6
7	How to use it
8	1. On the Trip tab, enter the trip name, start and end dates and the number of travelers.
9	2. On the Rates tab, check the example rates and replace them with the rates you plan to use. Add any new currency in an empty row.
10	3. Type each budget amount in USD on the Budget tab.
11	4. Log each expense on the Expenses tab with its date, category, description, currency and amount in that currency.
12	5. Read remaining budget, budget per day and per person, and the share of budget used on the Trip and Budget tabs.
13
14	Formulas and method
15	Units per USD: an amount in USD equals the amount in the currency divided by the rate.
16	Rate lookup: VLOOKUP on the currency code, exact match, in the Rates table. An unknown code shows Not in Rates and the expense is left out of totals until fixed.

What does this template do?

A trip budget that works in US dollars while expenses are paid in other currencies. Set the trip dates and the number of travelers on the Trip tab. The Budget tab holds the budget for each category in USD, with spending, the remaining amount, the share used, and budget and spending per day and per person.

The Expenses tab is a log in the currency you actually paid. A VLOOKUP on the Rates table converts each amount to USD, and the Budget tab totals the converted amounts by category with SUMIF. Two checks confirm that every expense has a known currency and that the category totals match the log.

The Rates tab holds example exchange rates for illustration only, so update them before you budget with real figures. The example trip, its expenses and its amounts are fictional.

What’s inside

Expenses logged in the currency paid and converted to USD
VLOOKUP conversion from a rate table with room for new currencies
Budget per day and per person, and spending per day and per person
Accommodation budget per night from the length of the trip
Checks for unknown currencies and for category names that do not match

Which tabs does the workbook have?

Tab	What it holds
Trip	Trip details, totals in USD, and per-day and per-person figures.
Budget	Budget and spending by category in USD, with per-day and per-person amounts and checks.
Expenses	Expense log in the currency paid, with the rate looked up and the USD amount.
Rates	Currency table with the units per US dollar. Example values, labeled as such.
Notes	Purpose, steps, formulas used, assumptions and limits.

What formulas does this template use?

This template holds 189 formulas in 389 cells across 5 tabs, so 49% of its cells calculate. They use 10 distinct functions; the longest formula is 93 characters and 100 of them read from another tab.

Function	Uses	What it does
`IF`	224	one result when a test is true, another when false
`IFERROR`	60	swaps an error for a fallback value
`ISNUMBER`	60	true for a number
`OR`	60	true when any test is true
`VLOOKUP`	60	looks a value up in a column
`SUMIF`	8	adds values meeting one condition
`SUM`	4	adds numbers
`ABS`	1	absolute value
`COUNT`	1	counts numeric cells
`COUNTA`	1	counts non-empty cells

Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.

How do you use it?

On the Trip tab, enter the trip name, start date, end date and number of travelers.
On the Rates tab, replace the example rates with the rates you plan to use, and add any new currency.
On the Budget tab, type the budget for each category in USD.
On the Expenses tab, log each expense with its date, category, currency and amount.
Read the remaining budget, budget per day and per person, and the share used on the Trip and Budget tabs.

What is it good for?

Budgeting a trip that spends in more than one currency
Checking daily spending against a set daily budget
Splitting trip costs per person for a group
Comparing actual spending with the plan while traveling

Questions about this sheet

Where do the exchange rates come from?

You type them on the Rates tab. The example rates are fictional and fixed, so enter the rate you expect to use and check it before you travel.

What happens if a currency is missing?

The expense shows Not in Rates and is left out of the USD totals. A check on the Budget tab flags it. Add the currency to an empty row on the Rates tab.

Are card fees and exchange spreads included?

No, unless you log them as expenses. Enter a fee in USD in the Insurance and fees category, or on its own line.

How is the per-person figure calculated?

It divides the total by the number of travelers on the Trip tab, and assumes that costs are shared evenly.