Every figure in Vault's reports is shown in your workspace currency. You choose it when you create the workspace, and it can't be changed afterwards. This article explains which exchange rate is used to convert transactions and account balances held in other currencies.
In short: a transaction uses the rate of its own date, and a balance uses the rate of the day it is shown for. Today's balance uses the latest available rate.
Where the rates come from
Vault uses daily reference rates from market data providers, for ordinary currencies and for cryptocurrencies. A day's rate is its end-of-day value, so it only exists once the day is over. There is never a rate for today yet, which means the latest available rate is usually yesterday's.
This is not your bank's rate. If your bank converted money at its own rate, the difference shows up in Cashflow as an exchange rate difference — see below.
Transactions: the rate of the transaction's date
Each transaction is converted into your workspace currency at the rate for its own date, and that amount is stored with the transaction. It never changes afterwards — not even if the rate for that day is later revised.
So P&L, money in and out in Cashflow, and transaction widgets always show the same amount for the same transaction, whenever you open the report.
If there is no rate for the transaction's currency on its date, the transaction can't be saved: Vault asks you to choose another date or currency.
A transaction in a different currency from its account
When you enter a payment in dollars on a euro account, the form asks for a conversion rate and shows the amount in the account's currency. The rate is filled in for you with the latest available one, and you can change it to the rate your bank actually used. The transaction is stored in the account's currency, at the amount you confirmed.
Sometimes a bank sends a transaction in a different currency from the account, without an amount in the account's currency. For that account's past balances, it is converted into the account's currency at the rate of its own date.
Balances: the rate of the day the balance is shown for
An account's balance is kept in its own currency. It is converted into your workspace currency when you look at it:
Balance | Rate |
Today, and the projection for future days | The latest available rate |
At the end of a past day | That day's rate. If there is no rate for that day, the nearest earlier one |
The rule is the same everywhere a balance appears: the dashboard and its chart, account widgets, the payment calendar, and the balance rows in Cashflow.
That is why a balance in your workspace currency can change with no transactions at all: a euro account holding 1,000 € is worth however many dollars that day's rate makes it.
Revaluation of balances in Cashflow
In Cashflow, the opening and closing balance of each column are converted at the rate of their own day. The change in value of balances held in other currencies that comes only from the rate is shown in the Revaluation of balances row, under Other balance changes. It is neither income nor expense, so it does not appear in P&L.
For each account it equals: closing balance at the closing rate − opening balance at the opening rate − the period's transactions in your workspace currency.
Example 1: no transactions. A workspace in dollars, a euro account holding 1,000 €. The rate is 1.10 at the start of the month and 1.15 at the end.
Cashflow row | Amount |
Opening balance (1,000 € × 1.10) | $1,100 |
Net cash flow | $0 |
Revaluation of balances | +$50 |
Closing balance (1,000 € × 1.15) | $1,150 |
Example 2: with money coming in. The same account, but 100 € arrives on the 15th at a rate of 1.12 — that transaction is stored as $112. At the end of the month the account holds 1,100 €, and the rate is 1.15.
Cashflow row | Amount |
Opening balance (1,000 € × 1.10) | $1,100 |
Money in | $112 |
Revaluation of balances (1,265 − 1,100 − 112) | +$53 |
Closing balance (1,100 € × 1.15) | $1,265 |
The money in stays at $112 — the rate of its own day, as in P&L. Everything the rate movement added, both on the opening balance and on those 100 € after the 15th, goes into the revaluation.
If all your accounts are in your workspace currency, there is no revaluation and this row is always zero.
A transfer between accounts in different currencies
Each side of a transfer keeps its own amount in its own currency and is converted at the rate of the transfer's date. If your bank converted at a different rate, the two sides don't match in your workspace currency. That difference is the Exchange rate difference on transfers row, under Other balance changes.
Example. You transferred 500 € from a euro account to a dollar account, and the bank credited $560. The rate that day was 1.14.
Euro side: −500 € × 1.14 = −$570.
Dollar side: +$560.
Exchange rate difference on transfers: −$10.
The transfer itself is neither income nor expense: it is not in net cash flow and not in P&L.
The payment calendar and balance charts
Past days in the calendar and on the chart show the balance at that day's rate. So if you hold accounts in other currencies, the difference between two neighbouring days may not equal that day's money in minus money out: it also includes the change in the rate. The calendar has no separate revaluation row.
Example. A euro account holding 1,000 €, no transactions on 3 or 4 March. The rate is 1.10 on 3 March and 1.12 on 4 March. The calendar shows a balance of $1,100 on 3 March and $1,120 on 4 March. Nothing came in or went out on 4 March, yet the balance grew by $20.
The projection for future days starts from today's balance at the latest rate — there are no future rates.
When there is no rate
This usually happens with a cryptocurrency on days before its rate history begins, or when the provider hasn't delivered the last few days yet.
A past day with no rate. The account is left out of the balance for those days — it is not counted as zero, and no other day's rate is used. A note names the currency, the accounts and the first date that has a rate.
A transaction that can't be converted into its account's currency. That account is left out of past balances altogether, and a note names it.
No rate on a period boundary in Cashflow. The account is left out of the opening and closing balances, and its transactions are shown in a separate row, Transactions on accounts without a balance, so the column still adds up.
The latest rate is stale. If it is older than the usual yesterday, a note names the currency and the date of the rate Vault uses.
No rate at all. The account's balance today is unknown: it is left out of totals, and a note names it.
P&L is not affected by the rate
P&L is made only of transactions, and each transaction has a stored amount at the rate of its own date. So there is no revaluation in P&L, and a rate change after the transaction doesn't change its amount.
For more about the reports, see P&L and Cashflow and Payment calendar. Which date each report uses, and how the actual period spreads amounts in P&L, is explained in How Vault counts.
