Track Travel Expenses in Multiple Currencies in Google Sheets
Short answer: write each expense down in the currency you actually paid, with the currency in its own column. Total each currency separately with SUMIF.1 Convert to one currency only when you need a single number — and then use the rate that matches what you actually paid.
This works for a family trip, a work trip, or a trip that is a bit of both.
1. Set up the sheet: one row per receipt, currency in its own column
A layout that holds up on any trip:
| Date | Vendor | Category | Amount | Currency | Receipt |
|---|---|---|---|---|---|
| 2026-11-03 | Bakery | Meals | 1,280 | JPY | (link) |
| 2026-11-04 | Museum | Activities | 18.00 | EUR | (link) |
Two habits make the rest easy:
- Amount is just the number (
1280, not¥1,280), so formulas can add it. - Currency is a three-letter code (
JPY,EUR,KRW,USD), always spelled the same way, so formulas can group by it.
2. Total each currency on its own
SUMIF adds the cells in one column where another column matches a value. Its form is SUMIF(range, criterion, [sum_range]).1 With currency in column E and amount in column D:
=SUMIF(E:E, "JPY", D:D)
=SUMIF(E:E, "EUR", D:D)
Put each currency on its own line in a small summary table and you can see, for example, how many yen and how many euros you spent — exactly as you paid them, with no exchange rate mixed in yet.
Why not convert every row right away? Because a rate you look up today may not match the amount your card or bank actually charged. Keeping the original amount and date means you can always redo the conversion with the right number.
3. When you need one number: pick the rate on purpose
| You need… | Use |
|---|---|
| What the trip really cost you | The amounts on your card or bank statement — that is what you were charged. |
| A quick estimate today | A current rate in Sheets: Google's help points to the GOOGLEFINANCE function for converting currencies.2 |
| An estimate for a past date | GOOGLEFINANCE can also return data for a start date.3 |
Two cautions from Google's own help: real-time prices are delayed by up to 20 minutes, and the data is provided for information only, not for trading or advice.3 Fine for a budget; not a substitute for your statement.
4. If the trip is for your business
For a U.S. tax return, the IRS says amounts must be reported in U.S. dollars.4 For most people whose working currency is the dollar, the IRS says to use the exchange rate prevailing when you pay or receive the item, and notes that rates can generally be found from banks and U.S. embassies.4
That is one more reason to keep the original amount, currency and date on every row: they are exactly what you need to convert correctly later. This is general information, not tax advice — ask your tax professional about your situation.
For more on what the IRS expects a receipt to show and how long to keep it, see how long self-employed people should keep receipts. To hand a finished sheet to an accountant, see how to organize receipts for your accountant in Google Sheets.
Quick checklist
- One row per receipt; amount as a plain number; currency as a 3-letter code.
SUMIFper currency for trip totals.- Convert only when you need one number, with the rate that matches what you paid (your statement), and the date.
- Business trip: report in U.S. dollars using the rate when you paid.
Where Slipmo fits
Typing every receipt is the slow part. Slipmo reads a receipt photo — including the currency printed on it — and adds a row to a Google Sheet you already use, matching your own column headers.5 Its statistics keep a separate total for each currency, so yen, euros and won stay apart, and nothing is converted.5
More from Slipmo: Scanning receipts into Google Sheets on an iPhone and What to keep from your receipts when you are self-employed, all in the guides. To see how it works, visit the Slipmo home page.
Google Sheets is a trademark of Google LLC. Slipmo is not affiliated with or endorsed by Google. This article is general information and is not tax or financial advice.
References
- Google. "SUMIF." Google Docs Editors Help. https://support.google.com/docs/answer/3093583 (accessed 2026-11-16). ↩
- Google. "TO_DOLLARS." Google Docs Editors Help (note: "use the GoogleFinance function to convert currencies"). https://support.google.com/docs/answer/3094241 (accessed 2026-11-16). ↩
- Google. "GOOGLEFINANCE." Google Docs Editors Help. https://support.google.com/docs/answer/3093281 (accessed 2026-11-16). ↩
- Internal Revenue Service. "Foreign currency and currency exchange rates." IRS.gov. https://www.irs.gov/individuals/international-taxpayers/foreign-currency-and-currency-exchange-rates (accessed 2026-11-16). ↩
- Slipmo. "What Slipmo reads from a receipt" and "See where the money went." https://www.slipmo.com/ (accessed 2026-11-16). ↩