A Canadian distributor buys in U.S. dollars, sells in Canadian dollars and invoices a few European customers in euros. Every month someone asks why the books do not match the bank. Business Central multi currency handles this, but only if the setup is right and the month-end routine is followed.
How does Business Central multi currency work?
Business Central keeps your books in a local currency (LCY), which is the currency you report in. You then assign currencies to customers, vendors and bank accounts so documents can be created in the transaction currency. Each posting is converted to LCY using the exchange rate for that date, and the system records both the foreign amount and the LCY amount.
What to set up first
- Currencies and exchange rates. Add each currency with its rates and effective dates. You can enter rates manually, import them or use an exchange rate service. Check which option fits your process and who maintains it.
- Default currency on customers and vendors, so documents open in the right currency
- Gain and loss accounts. Realized and unrealized gains and losses post to accounts you define. Set them before you post anything.
- Bank accounts in the currencies you actually hold, with their own balances
- Additional reporting currency (ACY). If you need a second reporting currency, for example for a U.S. parent, set it up before go-live, since changing it later is difficult.
Realized and unrealized gains and losses
| Type | When it arises | How it is handled |
| Realized | An invoice is paid or applied at a different rate than when it was posted | Posted automatically when the payment is applied |
| Unrealized | An open receivable, payable or bank balance is revalued at period end | Calculated by the Adjust Exchange Rates batch job |
Realized gains and losses happen as you apply payments. Unrealized ones do not appear unless you run the adjustment.
The month-end routine
- Update exchange rates to the period-end date.
- Run Adjust Exchange Rates for customers, vendors and bank accounts.
- Review the postings to gain and loss accounts and the audit trail.
- Reconcile foreign currency bank accounts.
- Run reports in LCY and, if you use it, ACY.
Missing step 2 is the most common reason receivable, payable and bank balances look wrong in LCY at month-end.
Where Business Central multi currency saves time
- Documents in the customer’s or supplier’s currency without manual conversion
- Foreign currency bank accounts tracked in their own currency and reconciled normally
- Consistent statements in LCY, with ACY where needed
- A visible audit trail of how each gain or loss was calculated
Where companies get stuck
- Exchange rates not updated, or updated by different people on different dates
- Gain and loss accounts not set up before posting
- Changing the currency on a customer or vendor with open entries
- Running adjustments inconsistently, so a period includes them and the next does not
- Consolidating multiple entities with different currencies without a plan
If you have several legal entities, plan the consolidation approach and Business Central multi currency setup together.
Is it worth it for a few foreign transactions?
Yes, in most cases. Even a handful of foreign currency invoices a month is enough to create reconciliation work, and the risk of error grows with each manual conversion. Companies that buy from overseas suppliers, hold foreign currency accounts or run subsidiaries get the most benefit.
Questions to answer before you configure
- Which currency is LCY, and do we need an ACY?
- Who maintains exchange rates, how often and from which source?
- Which accounts receive realized and unrealized gains and losses?
- How do we treat foreign currency bank accounts at period end?
- Do we have entities in other currencies that need consolidating?
Next step
If you are planning a Business Central implementation or fixing a Business Central multi currency setup that does not reconcile, a Business Impact Assessment from 360 Visibility reviews your currencies, entities and month-end process and recommends how to configure them.