ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Multi-Currency Travel Expense Tracker
3
Log spending from your phone in any currency — see totals, budgets and who owes whom, live.
4
5
SET UP IN 3 STEPS
6
1Open Setup: choose your home currency, trip dates and total budget (category budgets are optional).
7
2Still in Setup: add everyone travelling (up to 8) and the countries you will visit.
8
3Open the form link below on your phone and add it to your home screen. Log each expense as you go.
9
10
YOUR FORM LINK
11
Log an expense
https://docs.google.com/forms/d/e/1FAIpQLSdx1lXDvQbdxSDABOiFEqc0RPDOiGQIXyZBeevMrH3CKtzy9A/viewform
12
Edit the formOpen the form editor
13
14
COLOUR KEY
15
Yellow cells — you type here.
16
Grey cells — automatic (formulas or the script). They are protected so nothing breaks.
17
Coloured cards — live dashboard numbers.
18
19
GO TO
20
Setup →Trip dates, home currency, budget, travellers, categories, countries, theme.
21
Expenses →Every entry (one row per stay night). You can also type rows here by hand.
22
Stays →One row per hotel/apartment. Each is split into one Expenses row per night.
23
Transport →Flights, trains, buses, ferries.
24
FX Rates →Live, cached and manual exchange rates.
25
Dashboard →Trip overview with filters, map and charts.
26
Country View →One country at a time, in home or local currency.
27
Split & Settle →Who paid what, fair shares and who pays whom.
28
Budget vs Actual →Budgets by category and spending by country.
29
30
QUESTIONS
31
Where do exchange rates come from?Google Finance, live. The last good rate is saved every 6 hours in case Google has a gap. To use the exact rate your card charged, type it in FX Rates → Manual override. Rates are today's rate, not the rate on the day of each expense.
32
A rate says "Missing"Google has no rate for that currency right now. Type one in FX Rates → Manual override.
33
Can I type expenses here instead of the form?Yes. Add a row in Expenses (yellow columns). The ID, split check and shares fill in automatically. For a stay, add it in Stays and use Travel Tracker menu → Process manual stays & transport.
34
How do I change a stay?Edit the row in Stays, delete its night rows in Expenses (same ID with -01, -02…), then Travel Tracker menu → Process manual stays & transport.
35
I see "Authorisation required"Open Extensions → Apps Script, run buildAll once more and approve. Your data is kept.
36
How do I make a copy?File → Make a copy. In the copy, use Travel Tracker menu → Re-run setup to create its own form and automations (they are not copied).
37
How do I edit a formula?Grey cells are protected. Data → Protect sheets and ranges → click the sheet → Except certain cells / Remove. Re-running setup protects them again.
38
I changed the home currencyEverything switches by itself: totals, labels, live rates, and your budgets are converted at today’s rate. Old backup rates are cleared so they are never mixed up.
39
40
41
42
43
44
45
ACTIVITY LOGNewest first. Problems with form entries show up here.
46
26 Sep 2026 23:05Home currency back to USD: budgets restored exactly as typed.
47
9/26/2026Home currency EUR: budgets = your USD budgets × 0.8779 (Google Finance).
48
9/26/2026Home currency back to USD: budgets restored exactly as typed.
49
9/26/2026Home currency CAD: budgets = your USD budgets × 1.4146 (Google Finance).
50
9/26/2026Home currency CAD: budgets = your USD budgets × 1.4146 (Google Finance).
51
9/26/2026Home currency GBP: budgets = your USD budgets × 0.7547 (Google Finance).
52
9/26/2026Sample trip loaded: 168 Expenses rows, 8 stays, 6 transport legs.
53
9/26/2026Setup complete (tabs, form, triggers, theme "Midnight").
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100