Track Net Worth in Multiple Currencies
Expats and international investors face a unique problem: your net worth changes even when you do nothing. Here's how to track it accurately.
If all your money is in one country and one currency, tracking your net worth is straightforward: add up your accounts, subtract your debts, done. But for the growing number of people with assets spread across countries — expats, remote workers, immigrants, international investors — the picture is far more complex.
A Canadian living in Germany with USD index funds, a EUR savings account, and a property in India valued in INR will see their net worth fluctuate every single day just from exchange rate movements — even if they do absolutely nothing.
Why multi-currency net worth is genuinely tricky
The silent portfolio mover
In 2022, the USD strengthened roughly 15% against the EUR. A European holding US stocks saw their USD portfolio gain in USD terms — but those gains partially or fully disappeared when converted back to EUR. Without multi-currency tracking, you would not see this happening in real time.
The three core problems with multi-currency net worth tracking are:
- 1
Exchange rates change constantly
A fixed rate from last month is meaningless today. You need live or near-live exchange rates to see an accurate current net worth.
- 2
You need a single base currency to compare
Your net worth must be expressed in one currency to be useful. But which currency? Ideally the currency you spend in day to day, or the currency of the country you plan to retire in.
- 3
Each asset must track its own currency
A property in India is worth X lakhs. An ETF in the US is worth Y dollars. A savings account in Germany is worth Z euros. Each must be recorded in its native currency and converted at the current rate.
Why spreadsheets fail for multi-currency tracking
Spreadsheets are the go-to tool for many people starting to track net worth. They work well enough when everything is in one currency. With multiple currencies, they break down quickly:
- ✕Exchange rates must be updated manually — most people do this monthly at best, or forget entirely
- ✕GOOGLEFINANCE() in Google Sheets is often delayed or unreliable for less common currency pairs
- ✕There is no audit trail — you cannot see what your net worth was at a specific past date and which exchange rates applied
- ✕One formula error cascades across all calculations silently
What to look for in a multi-currency net worth tracker
Live exchange rates
The app should fetch exchange rates automatically — at minimum daily. Look for transparency about which rate source is used.
Per-asset currency setting
Each asset and liability should have its own currency. A mortgage in GBP and a stock portfolio in USD should both be entered in their native currency and converted automatically.
Configurable base currency
You choose one currency as your "home" currency. All totals are shown in this currency. You should be able to change this if you move countries.
Historical snapshots in original currency
Snapshots should record the original currency values and the exchange rate used, not just the converted number. This lets you separate actual portfolio growth from exchange rate movements.
At least 20 currencies supported
Major pairs (USD, EUR, GBP, JPY, CAD, AUD) are table stakes. Look for support for INR, SGD, CHF, HKD, and other currencies common for expats and international investors.
Setting up your multi-currency net worth tracker
Here is a practical setup sequence that works regardless of which tool you use:
- 1
Choose your base currency
Pick the currency you live in today, or the one you plan to retire in. This is the currency where you will watch the total trend over time.
- 2
Group assets by currency first
Before entering anything, list all your assets and which currency each is denominated in. This forces clarity before you type a single number.
- 3
Enter each asset in its native currency
A US brokerage account gets entered in USD, even if your base currency is EUR. The tracker converts it. Never manually convert before entering — that bakes in a stale rate.
- 4
Take a snapshot immediately after setup
Record your starting net worth. This becomes the baseline everything is measured against. Without a starting snapshot, you cannot measure growth.
- 5
Update balances monthly, not rates
Your job is to update the balance numbers. The tracker handles rates. Log in once a month, update each account balance, take a new snapshot.
The key insight: separate real growth from currency noise
Once your tracker is running, the most important analysis you can do is separate genuine portfolio growth from exchange rate effects. If your net worth in USD went up $10,000 last month but the USD strengthened 3% against your base currency EUR, some of that gain is exchange rate movement, not real wealth creation.
The best multi-currency trackers let you look at each asset in its native currency trend separately from the overall converted total. This tells you whether your investments are actually growing, or whether a currency tailwind is masking a flat or declining portfolio.