How to Manage Money in Multiple Currencies

If you earn in one currency and spend in another, the hardest question is deceptively simple: how much do I actually have? A dollar invoice, a euro rent, and a shekel savings account do not add up on their own, and the exchange rate moves under you while you try. This is a guide to keeping a clear picture across currencies without turning it into a second job.

Why multiple currencies break the usual tracking

Most money tools quietly assume everything is in one currency. The moment it is not, small problems pile up. Your balances live in different units, so no single screen shows your real net worth. Every conversion happens at a different rate on a different day, so last month's numbers do not match this month's. And a chunk of your money is always mid-air, invoiced but not paid, converted but not landed, which a plain balance never captures.

This hits a specific group hard: freelancers with foreign clients, remote workers paid from abroad, people living in one country and saving in another, and anyone who travels for long stretches. The stress is not that you are short of money, it is that you can never quite tell where you stand.

The usual approaches, and where they fall short

Convert everything in your head. Fine for a coffee, useless for a month. You end up guessing at a rate you half remember, and the guess is always a little optimistic.

One account per currency, checked separately. Accurate per account, but the number you care about, your total in one currency, is never on screen. You are back to mental math across apps.

A currency-converter app. Great for the rate right now, silent about your actual position. It tells you what 1,000 dollars is worth today, not what you will have across everything on the 20th after rent clears.

The better move: keep each currency real, convert only to view

The mistake most people make is converting every transaction to their home currency as they enter it. Do not. A euro expense is a euro expense, record it in euros. Keep every amount in the currency it actually happened in, so your per-currency balances stay exactly right and no rounding creeps in.

Then convert only when you want the combined view. Pick one home currency, apply today's rate across all the others, and read a single total. Because the underlying records are untouched, you can re-read that total at tomorrow's rate without rewriting anything. This is the same running-balance idea behind a cash flow forecast, extended so the timeline spans currencies and rolls up to one number on demand.

The one thing to get right: which rate, and when

Be deliberate about exchange rates or your totals will drift. Two rules keep it honest. First, for money that has already moved, use the rate you actually got, the one your bank or provider applied, not the mid-market rate, since the spread is real money. Second, for money still ahead of you, a future invoice or an upcoming bill, use today's rate as a working estimate and accept it will shift.

The practical upshot is to treat converted totals as a snapshot, not a fixed fact. Your euros are worth one number today and a slightly different one next week, and that is normal. What you want is a total that is honest about today, not one that pretends the rate is frozen.

Do it in a spreadsheet first

You can build this before committing to any tool. Use columns for Date, Description, Currency, Money In, Money Out, and a Running Balance per currency. Keep each currency's balance separate so nothing gets mixed. Then add a small summary block: one cell per currency for its balance, a rate next to each, and a final cell that multiplies and sums them into your home-currency total. Change the rates, and the total updates.

If you would rather not build the formulas from scratch, we made a free cash flow template with the running balance ready to go: download the free template (works in Google Sheets and Excel). Duplicate the sheet per currency, or add a Currency column, and bolt a conversion summary on top.

When you want it to maintain itself

The spreadsheet works, but the upkeep across currencies is where it gets tiring: pulling fresh rates, keeping a balance per currency, and recomputing the combined total every time. That is the gap we built TinyCashflow to fill. It is a spreadsheet-style money manager where each currency keeps its own real balance, everything sits on one timeline, and it rolls up to a single total in your home currency on any future date, with crypto handled the same way if you hold any. It works without connecting your banks and syncs across your phone and desktop, which matters when your accounts are in different countries.

Frequently asked questions

How do I see my total across different currencies?

Keep each currency's balance separate and accurate, then convert each to one home currency at today's rate and sum them. That combined figure, not any single account, is your real total for the day.

Should I record expenses in the original currency or convert as I go?

Record in the original currency. Converting every entry bakes in a rate that will be wrong later. Keep the real amounts and convert only when you want the combined view, so you can always re-read the total at a current rate.

Which exchange rate should I use?

For money already moved, the rate you actually received. For money still ahead of you, today's rate as an estimate, understanding it will change. Treat the combined total as a snapshot of today, not a fixed number.

This is general information for educational purposes only and is not financial advice.