Multi-currency is the ability of an accounting or ERP system to record, convert and report transactions in more than one currency.
Finance · Reviewed by Ray Rasouli
Ask about multi-currency
Plain answers, with your setup in mind.
Ask anything about multi-currency. For example, how it works in your current tools.
A scripted guide for now. It does not store what you type.
A Canadian distributor that buys from US suppliers and sells to customers in Canada and Europe deals in at least three currencies. Multi-currency support lets it issue invoices and pay bills in each currency while keeping its books in Canadian dollars.
The system stores the original amount, the exchange rate used, and the converted amount. When a bill is paid at a different rate than when it was recorded, the difference is booked as a foreign exchange gain or loss. At month end, open balances in foreign currencies are usually revalued at the current rate.
Done right, multi-currency gives an honest view of what each sale and purchase is really worth.
In practice
Exchange rates are entered by hand.
Typed rates go stale or contain errors, and different staff use different sources.
Gains and losses are not separated.
When currency swings are buried in cost of goods or revenue, managers cannot tell product margin from currency luck.
Foreign bank accounts are not revalued.
A US dollar account left at an old rate makes the balance sheet wrong every month.
Integrations drop the currency code.
An online store sends a US dollar order to the ERP as Canadian dollars, and the invoice is wrong from the start.
A realized gain or loss happens when a foreign invoice is actually paid. An unrealized one comes from revaluing open balances at month end and may change before payment.
The main currency of the economic environment a business operates in, usually the currency its books are kept in. Other currencies are converted into it.
A 30-minute discovery call with Ray, then a clear list of what to fix first. No obligation.
With Ray Rasouli. No obligation.