---
title: "Real Travel Budget: The Spreadsheet by Destination with the Hidden Costs That Blow Everything Up"
excerpt: "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."
description: "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."
slug: "real-travel-budget-spreadsheet-hidden-costs"
locale: "en"
canonical: "https://voyspark.com/en/journal/real-travel-budget-spreadsheet-hidden-costs"
author: "Curadoria Voyspark"
published_at: "Fri May 15 2026 03:32:13 GMT+0000 (Coordinated Universal Time)"
updated_at: "Wed Jun 03 2026 15:30:14 GMT+0000 (Coordinated Universal Time)"
vertical: "hacking"
reading_time_minutes: 16
word_count: 3100
hero_image: "https://s3.voyspark.com/voyspark-images/articles/orcamento-viagem-real-planilha-gastos-invisiveis/hero.jpg"
tags:
  - "orcamento"
  - "planilha"
  - "gastos-invisiveis"
  - "viagem"
---

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

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 JFK-London: pay once. Return pays another. **Total: 2 charges.**
- Flight JFK-London-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 your home bank per international withdrawal**: $3-7
- **Dynamic currency conversion (DCC) markup if you accept paying in USD abroad**: 3-5%

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): U.S. travelers spend an average of **$180** in duty-free on departure or return, unplanned. Perfume, whiskey, chocolate, electronics.

Not "wrong" — just **not budgeted**. And it counts towards the $800 personal exemption when returning to the U.S. via CBP.

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 your U.S. carrier**: Verizon/AT&T/T-Mobile international day passes cost **$10-12/day** with data cap (usually 500MB high-speed).

**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 **$50-80** 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) |
| Miami (MIA) | $30-45 Uber / $2.65 Metrobus 150 |
| 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 (JFK-Asia round trip, USD) | 850-1200 | 1200-1800 | 3500-9000 (business) |
| 14-day insurance | 40 | 75 | 130 |
| Visa (if applicable) | 0-30 | 0-30 | 0-30 |

#### USA (domestic trip — per day, per person, in USD)

| Category | Backpacker | Mid-Range | Luxury |
|---|---|---|---|
| Accommodation | 45-80 | 160-260 | 450-1200 |
| Food + drink | 30-50 | 80-130 | 220-500 |
| Local transport | 10-25 | 35-60 | 110-250 |
| Attractions + tours | 15-35 | 60-110 | 180-450 |
| **Tourism tax/resort fee (some cities)** | 0-3 | 5-15 | 20-50 |
| **Tip (18-22%)** | 8-12 | 25-40 | 70-150 |
| **Contingency** (10%) | 12 | 40 | 110 |
| **DAILY TOTAL** | **120-218** | **405-655** | **1160-2710** |
| **Domestic round trip flight** | 180-320 | 320-550 | 800-2200 (first) |

---

### How to apply the spreadsheet in 4 steps

**1. Define the real duration, including flight days.**

A JFK-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.

---

### 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 conversion markups.**

London costs £150/night. On the card, it becomes $195 with FX spread and a 3% foreign transaction fee. Those who budgeted $180 (mid-market rate of the day) already started 8% 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 JFK → Paris, pay Uber in NYC and taxi at CDG. Easily adds up to $130-180. Take AirTrain+subway in NYC and RER B in Paris and it drops to $25. **$100-150 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.