Real Travel Budget: The Spreadsheet by Destination with the Hidden Costs That Blow Everything Up

Flight, hotel, and food account for 60% of the actual travel expense. The other 40% hide in Venice's tourism tax, baggage per leg, European hotel VAT, paid Wi-Fi, mandatory tipping in the US, Schengen insurance, and roaming. Here's the complete spreadsheet, by region, in three scenarios.

por Curadoria Voyspark May 15, 2026 16 min Curadoria Voyspark

Budgeting a trip only by flight and hotel leaves you with 30 to 40% less money than needed. Extra baggage charged per leg, city tourism tax, mandatory Schengen insurance, embedded VAT in European hotels, 18% tipping in the US, roaming, hotel Wi-Fi, and ATM exchange rates form a parallel budget. See the spreadsheet by category, by region, and in three scenarios: backpacker, mid-range, and luxury.

16 min de leitura

The first budget spreadsheet everyone makes has four lines: flight, hotel, food, tours. Add, multiply by day, done. Then comes the real trip, and the card comes back with 30% more.

It's not that the person overspent. It's that the spreadsheet was incomplete.

There's a set of invisible costs that don't appear in any simulator, any "how much I spent in X" YouTube video, and almost no blog report. They are not optional — they are structural. They are in the airline's rule, the city's law, the hotel's contract, the local culture. Those who don't budget for them, pay for them anyway. Just by surprise.

This article breaks down each category, each value range by region, and concludes with a model spreadsheet with three traveler scenarios: backpacker, mid-range, and luxury. The idea is that after this, your next trip will have a realistic, not optimistic, final number.


Why the "normal" budget fails

Most people budget in visible categories: flight, hotel, food, attractions. These categories have a displayed price — Google Flights, Booking, TripAdvisor. You add them up and feel in control.

The problem is that these four lines, on average for an international trip of 7 to 14 days, represent 60 to 70% of the total expense. The other 30 to 40% are scattered across items that no one adds up when deciding if the trip is feasible.

When the budget blows up, the traveler blames "shopping." Rarely is it. It's the sum of 15 small categories that no one was watching.

The method here is to reverse: list all the invisible categories first, assign an average value by region, and only then close with flight and hotel.


The 11 categories of invisible costs

1. Checked baggage — charged per leg

This is the champion of blown budgets. The person buys the "cheap" ticket and discovers at check-in that the bag costs more than the ticket itself.

The rule no one reads: checked baggage is charged per operated leg, not per trip.

  • Direct flight São Paulo-Lisbon: pay once. Return pays another. Total: 2 charges.
  • Flight São Paulo-Lisbon-Madrid (connection): may pay on both legs of the outbound + two on the return. Total: 4 charges.
  • European low-cost (Ryanair, Wizz, EasyJet): if bought at the airport counter, costs €55-75 per leg. Buying online in advance drops to €30-45.

Value range per leg:

Airline type Average price (1st 23kg bag)
Full-service airline (Latam, Tap, Lufthansa) on international route US$ 0-70 included or separate
Full-service airline on domestic US route US$ 35-45
European low-cost (online) €30-45
European low-cost (counter) €55-75
Asian low-cost (AirAsia, Scoot) US$ 25-50

Realistic calculation: a 14-day trip through Europe with 3 intermediate low-cost flights pays baggage 6 times. At €40 per leg, that's €240 (~US$ 260) just for luggage.

2. City tourism tax

Exists in more than 40 European cities and destinations like Bali, Dubai, and some Japanese cities. Charged by the hotel, passed on to the city hall.

Does not appear on Booking until the final screen. Does not go on the reservation card — you pay in cash at check-out.

Typical values (per person, per night):

City Value Note
Venice €5-10 Rises in high season
Barcelona €4 + €4 (regional) Increased in 2025
Rome €3-7 Varies by hotel stars
Paris €1-5 By stars
Berlin 5% of hotel value
Amsterdam 12.5% of hotel Europe's most expensive
Lisbon €4 Increased from €2 in 2024
Porto €3
Kyoto ¥200/night
Bali (Indonesia) IDR 150,000 (~US$ 10) Charged once upon arrival
Dubai AED 7-20 By stars

Realistic calculation: couple, 5 nights in Venice in July = €100 in tax. Five nights in Amsterdam in a €250 hotel = €156 just in tax.

3. VAT embedded in European hotel

Unlike Brazil, in Europe the hotel VAT (between 6 and 25%) may appear at check-out, not in the advertised price. Booking started correcting in 2024, but direct bookings in small hotels, hostels, and B&Bs still show "net rate."

Always confirm: "total amount including all taxes."

Hotel VAT ranges:

Country Hotel VAT
Portugal 6%
Spain 10%
France 10%
Italy 10%
Germany 7%
United Kingdom 20%
Netherlands 9%
Switzerland 3.8%

In London, a £150/night booking turns into £180. Those who budgeted £150 were 20% off.

4. Schengen health insurance (and equivalents)

Mandatory by law to enter the Schengen area. Minimum coverage of €30,000 for medical expenses and repatriation. Without insurance, the embassy denies the visa. For Brazilians who do not need a visa (tourism up to 90 days), the airline may still ask at boarding, and border police may ask upon arrival.

Average price for 10 days:

Type Price
Basic Schengen (€30k) US$ 30-50
Schengen + baggage + cancellation US$ 60-100
USA / Canada (US$ 100k coverage) US$ 50-90
Asia / Oceania US$ 40-80
Annual multi-trip (unlimited days per trip, up to 60 days each) US$ 350-600

For those traveling 3+ times a year, annual pays for itself.

5. Visas and electronic authorizations

Even "visa-free" destinations charge electronic authorization.

Destination Document Cost
United States ESTA (if with Global Entry) or B1/B2 visa US$ 21 (ESTA) / US$ 185 (B1/B2)
United Kingdom ETA £16
European Union (Schengen) ETIAS (effective 2026) €7
Australia ETA A$ 22
Canada eTA C$ 7
Schengen with visa required Visa C €80
Japan Not needed (up to 90 days) 0
Thailand Not needed (up to 60 days) 0
India e-Visa US$ 25

Couple going to the US + UK pre-Brexit fees: 2 ESTAs + 2 ETAs = US$ 42 + £32 = ~US$ 80. Small, but it counts.

6. Tipping — the "invisible salary" in many destinations

Tipping varies more than any other category. In some countries, it's 15-22% of the restaurant bill. In others, it offends if you tip.

Region Restaurant Hotel baggage Room/day Uber/taxi
USA 18-22% US$ 1-2 per bag US$ 3-5 15-20%
Canada 15-20% C$ 2 per bag C$ 3 10-15%
Latin America (Argentina, Mexico, Peru) 10% US$ 1 US$ 1 Round up
Western Europe Included or 5-10% €1 €1 Round up
United Kingdom 12.5% (service charge) £1 £1 Round up
Japan ZERO. Offends. 0 0 0
South Korea Zero 0 0 0
China Zero 0 0 0
Southeast Asia (Thailand, Vietnam) 5-10% in tourist places, zero locally THB 20 THB 20 Round up
Australia Not mandatory (10% in fine dining) 0 0 Round up
Dubai / Emirates 10% (often already in service) AED 5 AED 5 Round up

Realistic calculation for the USA: couple, 14 days, with 2 meals out per day spending an average of US$ 80/meal = US$ 80 × 28 × 20% = US$ 448 just in restaurant tips. Add baggage, housekeeping, Uber: US$ 600-700 in tips on the trip.

7. International ATM exchange

Covered in detail at /iof-spread-cartao-internacional-2026. Summary:

  • Hidden spread from the issuing bank: 1-4%
  • Hidden spread from the network (Visa/Master): 1-2%
  • Fixed fee from the foreign ATM: US$ 3-7
  • Fee from the Brazilian bank per withdrawal: R$ 12-25
  • International credit card IOF: 3.38% (dropping 0.38pp/year until 2028)

On a trip with 4 withdrawals of US$ 200 at an American ATM and US$ 1,500 in card purchases, the invisible exchange cost is around US$ 80-130.

8. Lost or delayed baggage

Happens in 0.7% of international flights according to IATA 2024. Sounds low. Those affected spend US$ 200-500 on emergency purchases (clothing, hygiene, charger) while the bag doesn't show up.

Airline reimburses only if you provide a receipt for what you bought and show it was strictly necessary. Takes 30-90 days.

Good travel insurance includes advance for delayed baggage (US$ 100-200 in the first 12-24h). Worth checking.

9. Impulse buys in duty-free

Card data (Mastercard reports 2023-2024): Brazilian travelers spend an average of US$ 180 in duty-free on departure or return, unplanned. Perfume, whiskey, chocolate, electronics.

Not "wrong" — just not budgeted. And it counts towards the US$ 1,000 baggage excess allowance when returning to Brazil (see /cota-bagagem-internacional-edbv-imposto-50-porcento).

Trick: enter duty-free with a closed list and timed (20 minutes max). Those who enter "to take a look" and have 2h of connection leave with 3x more.

10. Paid hotel Wi-Fi and roaming

4-5 star hotels in Tokyo, Singapore, Dubai, and part of Europe charge for Wi-Fi. Range: €10-25 per day. 3-star hotels generally offer it for free.

Roaming from the Brazilian carrier: Vivo/Claro/TIM packages cost R$ 30-50/day with data cap (usually 500MB).

International eSIM (Airalo, Holafly, Saily): US$ 10-25 for the entire trip (5-20GB). Activates in 5 minutes on the app, even before boarding.

For a 10-day trip, eSIM easily saves R$ 250-400 compared to roaming.

11. Airport-city transport

Forgotten item. In some cities, it's trivial (metro for €5). In others, US$ 80 just for a taxi.

City Airport → Center
New York (JFK) US$ 70-90 taxi / US$ 11 AirTrain+subway
Los Angeles (LAX) US$ 50-70 Uber / US$ 9.75 FlyAway bus
London (LHR) £25 Heathrow Express / £5.50 subway (Piccadilly)
Paris (CDG) €56 flat taxi / €10.30 RER B
Tokyo (NRT) ¥3,200 Narita Express (~US$ 22)
São Paulo (GRU) R$ 50-70 Uber / R$ 50 Connect bus
Rome (FCO) €50 flat taxi / €14 Leonardo Express

Couple taking a taxi from JFK and back = US$ 160. Couple using AirTrain = US$ 22. Difference of US$ 138 in a single trip.


The model spreadsheet: three scenarios by region

I've put everything into a mental spreadsheet you can replicate. The rows are the expense categories. The columns are regions. The values are daily per person in USD (except where marked), in three scenarios.

Backpacker Scenario: hostel, public transport, hostel kitchen + street food, 1 paid attraction per day. Mid-Range Scenario: 3-star hotel, transport mix, mid-range restaurants, 2 attractions per day. Luxury Scenario: 4-5 star hotel, taxi/Uber, top restaurants, private tours.

EUROPE (per day, per person, in US$)

Category Backpacker Mid-Range Luxury
Accommodation 35-50 110-160 300-600
Food + drink 25-40 60-90 150-300
Local transport 8-12 15-25 50-100
Attractions + tours 15-25 40-70 100-250
City tourism tax 2-5 4-10 6-15
Wi-Fi / eSIM (prorated) 1-2 1-2 1-2
Tip 2-4 5-10 15-30
Invisible exchange (prorated) 1-2 2-4 5-10
Contingency (10%) 9 24 65
DAILY TOTAL 98-149 261-395 692-1372
Unique additions
Flight (round trip GRU-EU) 700-1100 1000-1500 2500-6000 (business)
14-day insurance 40 70 120
ETIAS (from 2026) 8 8 8
Baggage (4 legs) 0 (backpack) 80-160 0 (included class)

UNITED STATES (per day, per person, in US$)

Category Backpacker Mid-Range Luxury
Accommodation 50-70 150-220 400-800
Food + drink 35-50 80-120 200-400
Local transport 15-25 30-50 80-150
Attractions + tours 20-35 50-80 120-300
Tip (18-20% of food + baggage + room) 10-15 20-30 45-90
Wi-Fi / eSIM 1-2 1-2 1-2
Invisible exchange 2-3 3-5 6-12
Contingency (10%) 13 33 85
DAILY TOTAL 146-213 367-540 937-1839
Unique additions
Flight (GRU-USA round trip) 700-1100 1100-1700 3500-8000 (business)
14-day insurance 50 90 150
ESTA 21 21 21
Baggage (internal US airlines) 70-140 140 0

ASIA (Thailand, Vietnam, Indonesia — per day, per person, in US$)

Category Backpacker Mid-Range Luxury
Accommodation 12-20 50-80 150-400
Food + drink 8-15 25-40 80-200
Local transport 3-6 10-15 30-80
Attractions + tours 10-20 30-50 80-200
Tourism tax (Bali) 1 (prorated) 1 1
Tip (Southeast Asia) 1-2 3-5 8-15
Wi-Fi / eSIM 1 1 1
Invisible exchange 1-2 2-3 4-8
Contingency (10%) 4 12 36
DAILY TOTAL 41-71 134-207 390-941
Unique additions
Flight (GRU-Asia round trip) 1100-1500 1400-2000 3500-9000 (business)
14-day insurance 40 75 130
Visa (if applicable) 0-30 0-30 0-30

BRAZIL (domestic trip — per day, per person, in R$)

Category Backpacker Mid-Range Luxury
Accommodation 80-120 280-450 800-2000
Food + drink 60-90 150-220 400-900
Local transport 20-40 60-100 200-400
Attractions + tours 30-60 100-180 300-700
Tourism tax (some cities, e.g., Bombinhas) 0-5 0-5 0-5
Tip (10%) 6-9 15-22 40-90
Contingency (10%) 20 60 175
DAILY TOTAL 216-324 665-1037 1915-4270
National round trip flight 600-1000 900-1600 2500-5000 (first)

How to apply the spreadsheet in 4 steps

1. Define the real duration, including flight days.

A São Paulo-Tokyo flight leaves one day and arrives the day after tomorrow. You're "traveling" 16 days, not 14, and paying for 14 hotel nights + 2 days of food on the flight/airport.

2. Choose the scenario honestly.

Those who call themselves "mid-range" but only eat at Michelin stars are luxury. Those who sleep in shared Airbnb are backpackers. Mixing scenarios (luxury in hotel, backpacker in food) works but requires separating the lines.

3. Add unique additions before the daily.

Flight + insurance + visa + checked baggage are "existence costs" of the trip. They don't depend on how many days you stay. Put it upfront.

4. Add 10-15% as a contingency reserve.

It's not a psychological margin — it's statistical. 10-15% covers: medication, plan change due to rain, extra hotel day due to canceled flight, small medical emergency. Those who don't use it, return with a surplus. Those who use it, are grateful.

Receba uma viagem por semana.

Newsletter editorial Voyspark — long-forms, dicas e descobertas que não cabem no Instagram. 1x por semana, sem ads.

Sem spam. Cancela em 1 clique.

Closed example: 14 days in Europe, mid-range scenario, couple

  • Round trip flight GRU-Lisbon, 2 people: US$ 2,400
  • 14-day insurance × 2: US$ 140
  • ETIAS × 2 (2026+): US$ 16
  • Checked baggage (included in Latam business → 0; on internal low cost 2 legs × €40 × 2 people): US$ 175
  • Accommodation 14 nights in 3-star: US$ 130/night × 14 = US$ 1,820 (for the couple together)
  • Food + drink: US$ 70/day × 2 × 14 = US$ 1,960
  • Local transport: US$ 20/day × 2 × 14 = US$ 560
  • Attractions: US$ 55/day × 2 × 14 = US$ 1,540
  • Tourism tax (visited cities, ~€5 average × 14 × 2): US$ 150
  • Wi-Fi / eSIM: US$ 30
  • Tips: US$ 7/day × 2 × 14 = US$ 196
  • Invisible exchange (prorated): US$ 100
  • Contingency 10%: US$ 910

TOTAL: US$ 10,017

Those who budgeted only flight + hotel + food = US$ 6,180. US$ 3,837 would come on the card without prior notice.

Those who budgeted with the complete spreadsheet returned home with a contingency surplus = US$ 910 less. But returned whole.


Slow travel reduces invisible costs

Short trips concentrate invisible costs. Baggage, tips, airport transport, arrival tax, fixed insurance, ESIM: all these are departure and arrival costs, not daily costs.

Those who travel 30 days to the same destination pay once for insurance, baggage, flight, visa, eSIM. Spread over 30 days, it becomes cheap.

The complete math of when a long trip becomes cheaper than a short one is at /slow-travel-matematica-30-dias. Summary: from 18-21 days in the same destination, the daily cost drops below the daily cost of a 7-day trip.


Common mistakes that blow the budget

1. Budgeting in "destination currency" and ignoring IOF.

Lisbon costs €100/night. On the card, it becomes R$ 620 with IOF and spread. Those who budgeted R$ 580 (exchange rate of the day) already started 7% behind.

2. Not checking baggage policy before buying low cost.

Ryanair advertises flights at €19. Checked baggage €55. Real flight €74 one way = €148 round trip. Then it's no longer cheaper than EasyJet at €60 with luggage included.

3. Forgetting airport-city transport on both sides.

In GRU → Lisbon, pay Uber in SP and Uber in Lisbon. Easily adds up to R$ 250-400. Go by metro/Aerobus in Lisbon and it drops to R$ 30. R$ 200-370 saved.

4. Not budgeting pre-trip.

Plug adapter, new backpack, new shoes, raincoat, vaccine, pre-boarding test, glasses exchange. On average US$ 100-300 before even stepping on the plane.

5. Confusing "hotel price" with "stay price."

€100/night + 10% VAT + €5 city tax + €15 parking = €128/night. 30% more than advertised.

6. Not tracking exchange in the statement.

Those who only look at the final balance in real lose the notion of which operation was expensive. Tools like Wise, Nomad, and Avenue provide a statement in the original currency — makes auditing easier.


How to create your spreadsheet in 15 minutes

  1. Open a spreadsheet (Google Sheets or Excel).
  2. Rows: Flight, Insurance, Visa, Baggage, Accommodation, Food, Local Transport, Attractions, Tourism Tax, Wi-Fi, Tip, Invisible Exchange, Contingency.
  3. Columns: Days × unit value × people.
  4. Add a "Scenario" column (backpacker / mid-range / luxury).
  5. Add a "Total" row.
  6. Paste the values from the regional table in this article in the corresponding column.
  7. Adjust the scenario to your reality.
  8. Multiply by days and people.

The 13-line spreadsheet will immediately show where the budget might break — and where you can tighten without ruining the trip.


Practical summary

The budget of an international trip is not flight + hotel + food. It's a system of 13 lines, where 3 to 4 invisible categories add up to 30% of the total.

Those who budget with the 4 traditional lines underestimate by 30 to 40%. Those who budget with the 13 arrive at the destination with a margin.

The margin is what separates a good trip from a trip with a tight chest every day checking the balance. It's not about spending more. It's about knowing beforehand how much the trip really costs.

Flights with included baggage, hotels with VAT already in the price, eSIM instead of roaming, annual insurance instead of trip-by-trip, ATM with Wise/Nomad instead of the traditional bank. Each of these decisions reduces the invisible category.

The difference, in the end, is sleeping peacefully.

Gostou? Salve ou compartilhe.

Pontos-chave

"Invisible costs" represent **20 to 35% of the total budget** for an international trip — almost never appear in the first simulation.

**Checked baggage costs per leg**, not per trip. With connections, you pay twice. On European low-cost airlines, up to **€60 per leg** if bought at the counter.

**City tourism tax** exists in **40+ European cities**: Venice €5-10/night, Barcelona €4, Paris €1-5, Rome €3-7, Berlin 5% of the hotel.

Perguntas frequentes

Around US$ 7,500 to US$ 8,500 all-in: flight (~US$ 2,400), insurance (US$ 140), accommodation (~US$ 1,300), food (~US$ 1,400), local transport (~US$ 400), attractions (~US$ 1,100), tourism tax (~US$ 110), tips and Wi-Fi (~US$ 170), baggage in low-cost connections (~US$ 175), invisible exchange (~US$ 80), contingency 10% (~US$ 720).

Conversa

Faça login pra deixar seu insight

Conversa séria, sem trolls. Comentários moderados, vínculo ao seu perfil Voyspark.

Entrar pra comentar

Carregando…

Sobre o autor

Curadoria Voyspark

2 anos no editorial Voyspark

Time editorial da Voyspark — escritores, repórteres, fotógrafos e fixers em Lisboa, Tóquio, Nova York, Cidade do México e Marrakech. Coletivo. Sem voz corporativa. Cada peça com checagem cruzada por um editor regional e um chef ou curador local.

Especialidades

slow-travelfoodiesustentabilidadecultureworkationfamily

Continue a leitura

Travel Hacking · 14 min

Investing dollars for a future trip (12-24 months): currency fund, ETF, Wise or stablecoin — what earns and what just gets in the way

You have 50,000 reais for a trip in 2027 and want to lock the exchange rate without leaving the money idle? There are six viable paths in Brazil in 2026 — XP/BB/Itaú currency fund, DOLB11 ETF, BDR of US ETF, Wise USD, Nomad/Avenue, and USDC/USDT stablecoin on Brazilian exchanges. Each has different tax treatment, different liquidity, and a hidden risk that only shows up at redemption. This guide compares all six with a final table and says which fits which profile.

Travel Hacking · 13 min

Splitting group travel expenses: Splitwise, Tricount or a spreadsheet (tested)

Splitwise is the global standard but throttles multi-currency on the free tier. Tricount is European and wins on simple UX. Settle Up has the best settlement algorithm. Google Sheets wins when the group has a nerd. Notion is where projects go to die. We did the math with six friends in Tokyo, ¥ + US$ + EUR, and there's a right tool for each kind of group.

Travel Hacking · 14 min

Airport exchange vs city center vs bank: who charges less (real test in 5 cities, May/26)

Every Brazilian repeats the same line: "never exchange money at the airport." The line is almost right, but not an absolute rule. In May/26 we ran the real test: we simulated exchanging USD 500 (or the EUR equivalent) at airport, city center, and bank across five cities. We show the effective spread at each point, the difference in reais, and the one rule that matters: exchanging beforehand in Brazil is almost always the best deal — and when you can't, there's a correct order of preference at the destination.

Voyspark AI