How to track travel expenses, and where the spreadsheet gets painful

By Trabee · · 6 min read

The simplest way to track travel expenses is to write down every expense on the day you spend it, in the currency you paid, along with what it was, how you paid and who paid. Then, when your card statement arrives, check your notes against it.

That’s it. Any notebook, notes app or spreadsheet can do it. Where people get stuck is everything after: converting currencies, splitting costs, and figuring out why the bank charged a different amount from the one they wrote down. This guide covers the basics, how to set up a spreadsheet if you like spreadsheets, and the spots where it tends to get painful.

What to write down for every expense

Five things are enough:

  1. Date, so you can match it to your statement later.
  2. Amount and currency, exactly as you paid. “€48”, not “about $52”. You can convert later; you can’t recover the original amount once it’s rounded into dollars.
  3. How you paid: cash, or which card.
  4. What it was: food, transport, lodging, activities, shopping. Broad categories are fine. Too many categories and you’ll stop logging.
  5. Who paid, if you’re traveling with other people.

Include what you paid before the trip, too: flights, hotels, the rental car deposit. Otherwise the total you end up with is only part of what the trip cost.

Setting up a travel budget spreadsheet

If you’d rather build your own, a simple layout works for both a road trip and a trip abroad:

DateItemCategoryAmountCurrencyPaid withPaid byAmount in USD
Jun 3Train to FlorenceTransport29.90EURCardMe
Jun 3LunchFood42.00EURCashAndrew

Fill in the first seven columns as you go. The last one is where things get harder.

Where the spreadsheet gets painful

Converting currencies

Google Sheets has a function, GOOGLEFINANCE, that can pull exchange rates into a cell. It helps, with some catches straight from Google’s own help page: quotes “may be delayed up to 20 minutes”, the information is “solely for informational purposes”, and historical data for a past date comes back as a small table with headers rather than a single number, so you need extra formulas to use it in a running total.

And even a perfect formula gives you the market rate, not the rate your bank used.

Your card charge won’t match your notes

This is the one that surprises people. Two things make the dollar amount on your statement differ from what you calculated:

  • Foreign transaction fees. Many cards add a fee on purchases in a foreign currency or outside the U.S., typically 1% to 3% of the amount. Some cards charge none, so it’s worth checking yours before you go.
  • The exchange rate date. The rate is set when the transaction is processed, not when you tapped your card. As Bank of America puts it, “the processing date may differ from the date of the transaction.”

So your spreadsheet can be right and still not match. The only number that’s truly final is the one on your statement.

”Pay in dollars or in euros?”

Card machines and ATMs abroad sometimes offer to charge you in U.S. dollars on the spot. That’s called dynamic currency conversion, and Visa notes the offer includes an exchange rate and additional fees, and that it’s your choice to accept or decline. The FDIC’s travel tips suggest letting your own bank do the conversion and choosing the local currency. It also keeps your notes simple: the amount on the receipt is the amount you log.

Splitting costs

“Excel formula to split expenses” is a common search for a reason. One person paying for the group is easy to record and fiddly to settle: you need each person’s share of each expense, then a running balance of who owes whom. It’s doable, but it’s the kind of formula that breaks the moment someone adds a row in the wrong place.

Cash

Cash you exchanged at one rate and spent over a week doesn’t fit neatly into a “today’s rate” column. The honest fix is to record cash at the rate you actually got when you exchanged it.

Check it against your statement

When you get home, go through your card statement line by line against your notes. It’s how you catch a double charge or something you didn’t buy. The FTC recommends making it a habit to review your credit card statements, and if you find a billing error on a credit card, the CFPB explains that you need to send a written notice to the card company within 60 days after the charge appeared on your statement.

Then update your notes with the actual dollar amounts. Now your trip total is real.

Do you still need to tell your bank you’re traveling?

It depends on the bank. Chase, Capital One and American Express all say on their own sites that you don’t need to notify them before you travel, and recommend keeping your phone number and email up to date instead (Chase, Capital One, American Express). Other banks may still want a heads-up, so check yours, and turn on transaction alerts either way.

Easy logging, and still a spreadsheet at the end

We make an app for exactly this. With Trabee Pocket, you log on your phone as you go, and the painful parts are handled for you:

  • Currencies: you enter the amount in the currency you paid, and the converted amount appears beside it. Rates update once a day and are saved on your phone, so it works with no signal (exchange rates).
  • Receipts: snap a photo and AI fills in the amount, currency, date, place and category (receipt AI).
  • Your statement: enter the actual card charge for an expense, or enter a statement total and the app spreads it across your card expenses, so every total matches what you really paid (matching card charges).
  • Cash: put exchanged cash in a budget pocket at the rate you got, and everything paid from it uses that rate. Budget pockets are a Premium feature (budget pockets).
  • Before the trip: expenses dated before your trip starts go into their own “Pre” list, so flights and deposits count too (pre-trip expenses).
  • Splitting: pick who paid and who was in on each expense, and it works out who owes whom. Settle-up is a Premium feature, and only the trip’s creator can add expenses (settle-up).

And if you like having a spreadsheet, you still get one, already organized. Export the trip to Excel and you get an expenses sheet and a statistics sheet; CSV gives you every expense with date, time, category, amount, currency, converted amount, exchange rate, payment method, notes and who was in on it, ready for Google Sheets. There’s a PDF report too, with or without photos. Exports are a Premium feature (exporting).

Either way, the habit is what matters.

Summary

  • Log every expense the day you spend it, in the currency you paid
  • Record date, amount and currency, payment method, category and who paid
  • Include what you paid before the trip
  • Expect card charges to differ from your notes: fees and the processing-date rate
  • Choose the local currency when a card machine offers dollars
  • When the statement arrives, check it line by line and update your totals

← More from the blog

Trabee Pocket

Downloaded over 1.2 million times

Join travelers around the world already managing their trip expenses with Trabee Pocket.
Download it for free today.

Scan to download

Trabee Pocket Download QR Code