Most investors with a single-country portfolio never need to think about currency. Their income, expenses, valuations and loan balances all live in the same currency and consolidation is trivial — it is just addition. But the moment a second currency enters the picture, that simplicity is gone. To see a true portfolio-level view, every figure needs to be expressed in a common unit.
The challenge is not just converting numbers — it is converting them consistently, at meaningful points in time, in a way that reflects actual economic reality rather than producing numbers that look tidy but obscure what is actually happening.
What needs to be consolidated
Rental income and expenses
Each property generates income and incurs costs in its local currency. To see portfolio-level net income, these need to be converted at a consistent exchange rate — either the rate on the date each transaction occurred, or a periodic average rate. Using today's rate to convert historical transactions produces a misleading number.
Property valuations
A property's market value is stated in the local currency. To compare values across a multi-country portfolio, all valuations need to be converted to the base currency at a defined rate. The rate used matters: applying today's rate to a valuation that is twelve months old conflates property value change with currency movement.
Outstanding loan balances
Mortgages denominated in foreign currencies need to be expressed in the base currency to calculate true equity. A loan balance can appear to grow or shrink in base currency terms purely due to exchange rate movement, independent of any repayments made.
Equity
Net equity across a multi-currency portfolio is only meaningful when both the value and the debt components are expressed in the same currency. An equity number that mixes currencies is arithmetically incorrect.
Returns and yield
Yield calculations divide income by value — if income is in one currency and value is in another, the result is meaningless. Everything in the calculation needs to be in the same currency before performance metrics can be computed.
Choosing a base currency
The base currency is the currency in which you consolidate everything — the lens through which you view your portfolio. For most investors, this is naturally their home currency: the currency in which they live, spend and plan. It is also the currency most relevant for assessing whether the portfolio is generating real wealth in terms that matter to them.
Some investors choose a different base currency — USD is common for internationally diversified portfolios because of its role as a global reference currency. The choice matters less than consistency: using one base currency and applying it everywhere is what makes the consolidated view coherent.
The exchange rate problem
The most common mistake in multi-currency consolidation is applying a single current exchange rate to all historical figures. This seems reasonable — it is simple and produces a tidy snapshot — but it distorts performance. If a currency has moved significantly, using today's rate on last year's income makes the income look different from what it actually was when received.
A more rigorous approach records the exchange rate at the time each transaction occurred — so historical income and expenses reflect the rate at the time, not today's rate. Current-period figures (valuations, outstanding balances) use current rates. This approach makes currency effects visible and separable from underlying property performance.
Why spreadsheets struggle with this
Spreadsheets can handle multi-currency consolidation in theory — you can add exchange rate columns and conversion formulas. In practice, they tend to break down because maintaining a consistent exchange rate history across multiple sheets, currencies and time periods is a manual, error-prone process. Investors typically end up with a mix of approaches — some transactions converted at the time of entry, others at whatever rate was current when the spreadsheet was last updated — producing a number that looks like portfolio performance but is not.
The moment you have more than one overseas property, the maintenance burden of a correct multi-currency spreadsheet model typically exceeds what most investors are willing to sustain.
What good consolidation looks like
- Each property holds its own local currency for income, expenses, valuations and loan balances.
- Transactions are recorded with their original currency amounts, not pre-converted.
- Exchange rates are applied at the transaction date for historical income and expenses.
- Current valuations and loan balances are converted at current rates.
- Portfolio totals — equity, net income, yield, IRR — are computed in the base currency after consistent conversion.
- The base currency is defined once and applied everywhere, not changed between views.
How Akweno solves this
Akweno is built around multi-currency from the ground up. Each property stores its local currency — income, expenses, valuations and loan balances are all recorded in the original currency. A single portfolio reporting currency is set at the account level, and Akweno consolidates everything using live exchange rates so the portfolio dashboard always reflects true, currency-adjusted performance.