Why mixing currency and investment gains distorts your net worth

A net worth tracker that shows one total in one currency feels clean, but that single number often bundles two very different things: what your investments actually earned, and what happened to the exchange rate between your assets and your reporting currency. When those effects are blended, a good year for markets can look mediocre because the currency moved against you, or a flat portfolio can look impressive because the currency moved in your favour. Worse, a tracker that converts past values at today’s exchange rate can rewrite your own history. ^[S2] Behaviorally, confusing currency swings with investment gains or losses is a recognised trap that can skew decisions. ^[S2]

The goal of separating the two is not accounting perfection. It is to answer two distinct questions with two distinct numbers: how did my portfolio perform in the currencies it is actually invested in, and how did my reporting currency move relative to those currencies? Once those are separated, both the performance picture and the decision-making get clearer.

Define the reporting currency and the asset currency

Every separation exercise starts with two definitions. The reporting currency is the currency you use for your net worth statement — typically the one you spend, owe debt in, or plan your life around. The asset currency is the currency in which an asset is denominated and, importantly, in which its price is quoted. A US-listed stock is priced in US dollars even if you live in Europe and track your net worth in euros.

Write these down explicitly in your tracker. Ambiguity here is the root of most confusion. For each holding, record:

• The asset currency (what the price is quoted in).
• The reporting currency (what your net worth statement uses).
• The exchange rate used, and its date or source.
• Whether the asset’s own price return is tracked separately from the currency conversion.

A useful discipline is to store asset values in their native currency first, then apply a conversion layer. If your tracker forces you to enter only the converted figure, you have already lost the ability to separate the two effects.

Split the return into price return and currency return

The cleanest way to think about this is a simple decomposition. The change in the reporting-currency value of a foreign asset comes from two sources: the change in the asset’s own price (in its native currency), and the change in the exchange rate between the asset currency and your reporting currency. In practical terms:

This is the same logic that appears in institutional reporting, where investment gains and currency translation effects are disclosed separately rather than merged. For example, MAS reported investment gains of $31.4 billion for a fiscal year, partially offset by a negative currency translation effect of $3.4 billion. ^[S1] The point is not the size of those figures but the structure: the investment result and the currency effect are presented as distinct lines so readers can see both.

Practically, you can approximate this in a spreadsheet or tracker by keeping, for each foreign holding, the native-currency value and the FX rate at each snapshot. Your price return is the change in native-currency value; your currency return is the change in the FX rate applied to the prior native-currency value. The sum reconciles to the change in the reporting-currency value, up to rounding and any contributions or withdrawals you made during the period.

Handle cash flows, contributions, and withdrawals carefully

Separation gets harder when money moves in or out, because a contribution made at one exchange rate and a withdrawal made at another can look like a gain or loss if you are careless. Three rules keep this manageable:

• Timestamp every cash flow in both currencies. Record the amount in the asset currency and the reporting-currency equivalent at the rate on the transaction date.
• Exclude flows from return calculations. A contribution is not investment gain. A withdrawal is not investment loss. If your tracker blends them, your separated figures will be wrong in both directions.
• Use a consistent FX source and be explicit about timing. Mid-market rates at a fixed daily time, or a published reference rate, are defensible choices. Mixing sources mid-year introduces noise that looks like currency gain.

If you hold assets in several currencies, consider tracking each currency sleeve separately. A euro-denominated sleeve and a dollar-denominated sleeve each have their own price return and their own currency return against your reporting currency. Aggregating them too early hides exactly the information you are trying to preserve.

Keep a historical FX log instead of retroactively converting

One of the most common tracker mistakes is applying today’s exchange rate to past values. On the surface it simplifies reporting, but when the current rate is retroactively applied to past values, the record becomes distorted. ^[S2] The distortion is subtle: a past net worth figure that was accurate at the time suddenly changes every time the currency moves, which makes trend analysis meaningless.

The fix is a historical FX log. For each snapshot date, store the rate you actually used. Then:

• Past figures stay fixed and comparable over time.
• Currency gains and losses show up in the period they occurred, not retroactively.
• You can restate history deliberately, if you choose to, rather than accidentally.

A log also makes reconciliation easier. When your reporting-currency net worth changes, you can attribute the change to price return, currency return, and net contributions, and check that the three add up. If they do not, you have a data problem worth finding.

A practical workflow and a note on tool limitations

A workable routine looks like this. At each snapshot, record native-currency values for every holding, the FX rate for each currency pair, and any cash flows with their dates. Compute price return per holding in native currency, compute currency return from the FX log, and reconcile the two to the change in reporting-currency value. Report the two numbers side by side rather than as one blended total.

Be realistic about tooling. Many portfolio trackers default to showing everything in a single currency, which simplifies reporting but makes separation harder. ^[S2] Some tools allow native-currency views or manual FX rates; others do not. Where a tool cannot separate the effects, a parallel spreadsheet that stores native values and rates is a reasonable workaround. Details of specific features and defaults change between tools and over time, so check current documentation rather than assuming a capability persists.

Finally, treat the separated figures as decision inputs, not scorekeeping. If your reporting-currency net worth rose mainly because of currency movement, that is useful to know before you conclude your investment strategy is working. Separating the two does not eliminate currency risk — it simply stops that risk from hiding inside a number labelled “investment gain.”