360 Visibility
  • Dynamics 365
    Business Central Services
    • Business Central Implementation
    • Dynamics GP to Business Central Migration
    • Dynamics NAV to Business Central Upgrade
    • Business Central Integrations
    Complimentary Systems Assessment
    Quick Links
    • Business Central Demo Videos
    • Business Central Apps
    • Business Central Contactless Banking Bundle
    • Business Central Blogs
    • ERP Evaluation Guide
    • Business Central Partner Toronto Ontario
    Customer Stories
    dk household brands partners with 360 Visibility to implement Dynamics 365 Business Central

    DK Household Brands implements Business Central with full EDI, WMS, and Shipping integration.

    Read the story
    Dynamics 365 Solutions
    • Dynamics 365 Business Central
    • Dynamics 365 Sales
    • Dynamics 365 Contact Center
    • Dynamics GP
    • Dynamics NAV
  • Cloud
    Azure Cloud Services
    • Azure Cloud Managed Services
    • Azure Infrastructure Modernization and Migration
    • Azure Virtual Desktop
    • Azure Cloud Cost Optimization
    Cloud Infrastructure Assessment
    Quick Links
    • Cloud Blog
    • Cloud Migration Guide
    • Cloud Cost Optimization Playbook
    Customer Stories

    How Azure cloud turned physical hardware bottlenecks into a secure, limitless engine for software growth.

    Read the story
    Cloud Solutions
    • Azure Cloud
    • Power Platform
  • Microsoft 365
    Microsoft 365 Services
    • Microsoft 365 Implementation
    • Microsoft 365 Support Services
    • Microsoft 365 Security Assessment
    • Microsoft 365 Backup and Disaster Recovery
    Complimentary Microsoft License Audit
    Cybersecurity Services
    • Device Management & Security
    • Ransomware & Endpoint Security
    • Purview Data Loss Prevention
    • Purview Insider Risk Management
    • Purview Information Protection
    • Entra ID Identity and Access Management (IAM)
    • Entra ID Backup and Recovery
    Customer Stories
    pain specialists of america works with 360 Visibility to enhance security and control over Azure

    How reclaiming IT control from their MSP slashed Pain Specialists of America's security incidents by 30%.

    Read the story
    Microsoft 365 Solutions
    • Microsoft 365
    • Microsoft Teams Phone
    • Microsoft Places
    • Outlook Email Signature Management
  • Copilot & AI
    Microsoft Copilot & AI Services
    • Copilot AI Leadership Circle
    • Copilot AI Agent Business Impact Assessment
    Complimentary AI Readiness Snapshot
    Quick Links
    • Microsoft 365 Copilot Offer
    • Microsoft 365 Copilot Implementation Guide
    • Copilot and AI Blog
    Customer Stories

    Financial Services Firms' Custom AI Agent for Case Management automates bulk document analysis, saving 35+ hours daily.

    Read the story
    Copilot & AI Solutions
    • Microsoft Copilot
    • Microsoft SharePoint
  • Advisory Services
    • Clarity CSP Portal
    • Business Impact Assessment
    • IT Governance
    • Microsoft License Optimization
    • Quarterly Business Review
  • Industries
    • Wholesale Distribution
    • Financial Services
    • Nonprofit
    • Professional Services
    • Software
    • Hospitality
  • Resources
    • Blog
    • Case Studies
    • Documentation
    • Support
  • About
    • Why Work With Us
    • Partner
    • Careers
✕
No results See all results
Contact Us
Clarity
360 Visibility
burger-bar

Home / Blog / Business Intelligence / Business Central Multi Currency: How It Works and What to Set Up

Business Central Multi Currency: How It Works and What to Set Up

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 […]

Barbara Allen
Barbara Allen

Published: Nov 13, 2026 •

Table of Contents
  1. How does Business Central multi currency work?
  2. What to set up first
  3. Realized and unrealized gains and losses
  4. The month-end routine
  5. Where Business Central multi currency saves time
  6. Where companies get stuck
  7. Is it worth it for a few foreign transactions?
  8. Questions to answer before you configure
  9. Next step

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

TypeWhen it arisesHow it is handled
RealizedAn invoice is paid or applied at a different rate than when it was postedPosted automatically when the payment is applied
UnrealizedAn open receivable, payable or bank balance is revalued at period endCalculated 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.

business central multi currency

The month-end routine

  1. Update exchange rates to the period-end date.
  2. Run Adjust Exchange Rates for customers, vendors and bank accounts.
  3. Review the postings to gain and loss accounts and the audit trail.
  4. Reconcile foreign currency bank accounts.
  5. 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.

Barbara Allen

Barbara Allen

Barb is our Vice President of Client Solutions. She is tasked with building and maintaining relationships with key accounts and implementing strategies that align with their business goals. She has worked in various industries holding several key leadership positions. Barb also successfully implemented ERP systems such as Microsoft Dynamics for organizations of all sizes - from start-ups companies with two users, to Fortune 500 companies with over 1,400 users.

See all my posts

Related Posts

  • Microsoft Dynamics 365 Business Central
  • Financial Services

Nov 13, 2026

Business Central vs Dynamics 365 Finance and Supply Chain Management: Which Fits a Mid-Market Business?

Finance is working around system limits. Operations keeps its own spreadsheets. Reporting takes longer each quarter. Sooner or later the question comes up: is our ERP […]

Keep reading
  • Financial Services
  • Microsoft Dynamics 365 Business Central

Nov 13, 2026

Business Central Reporting: Executive Dashboards That Leaders Use

By the time the leadership team reviews the monthly numbers, someone has exported them, reworked them in Excel, built the charts and emailed a file that […]

Keep reading
  • Financial Services
  • Microsoft Dynamics 365 Business Central
  • Microsoft Dynamics GP

Nov 13, 2026

Dynamics GP End of Life: Your Business Central Migration Timeline

When is Dynamics GP end of life? Microsoft’s lifecycle page lists two dates: December 31, 2029 for the end of mainstream support (product enhancements, regulatory updates […]

Keep reading
360 Visibility

360 Visibility is a Microsoft Cloud Solution Provider (CSP) holding Microsoft Solutions Partner designations in Security, Cloud & AI Platforms, and AI Business Solutions.

With over 20 years of experience across Microsoft 365, Dynamics 365, Azure, and Copilot, we help organizations modernize operations, strengthen security, and adopt AI with confidence.

microsoft solutions partner, dynamics 365 business central implementation partner, dynamics 365 sales implementation partner
microsoft solutions partner, microsoft 365 security, defender, entra id, cloud security, microsoft purview
microsoft solutions partner, microsoft 365, office 365, sharepoint, teams phone system
microsoft solutions partner, azure cloud, cloud migration, it governance, technology advisory
microsoft solutions partner badge for digital app and innovation azure
Dynamics 365 Services
  • Dynamics 365 Business Central Partner
  • Dynamics 365 Business Central Implementation
  • Dynamics GP to Business Central Migration
  • Dynamics NAV to Business Central Upgrade
  • Dynamics 365 Sales Implementation
Copilot AI Services
  • Copilot AI Agent Business Impact Assessment
  • Copilot AI Leadership Circle
  • Microsoft 365 Copilot Readiness Assessment
  • Microsoft Copilot AI
Business Advisory Services
  • Business Impact Assessment
  • Quarterly Business Review
Azure Cloud Services
  • Azure Cloud Implementation Partner
  • Managed Azure Services Provider
  • Azure Infrastructure Modernization and Migration
  • Azure Virtual Desktop
  • IT Governance
  • Azure Cloud Cost Optimization
Cloud Security Services
  • Microsoft 365 Security Assessment
  • Backup and Disaster Recovery
  • Data Loss Prevention
  • Insider Risk Management
  • Identity and Access Management
  • Information Protection
  • Entra ID Backup
Company & Resources
  • Blog
  • About 360 Visibility
  • Careers
  • Case Studies
  • Documentation
  • Contact Us
Legal & Technical
  • Terms and Conditions
  • Data Security and Data Privacy
  • Privacy Policy
  • Support
  • Clarity CSP Portal

See Clearly. Act Faster.

Copyright © 2026 360 Visibility Inc. All Rights Reserved

✕
✕
✕
No results See all results
  • Dynamics 365
    • Business Central Services
    • Business Central Implementation
    • Dynamics GP to Business Central Migration
    • Dynamics NAV to Business Central Upgrade
    • Business Central Integrations
    • Quick Links
    • Dynamics 365 Business Central Demo Videos
    • Business Central Apps
    • Contactless Banking Bundle for Dynamics 365 Business Central
    • Business Central Blog
    • ERP Evaluation Guide
    • Dynamics 365 Solutions
    • Dynamics 365 Business Central
    • Dynamics 365 Sales
    • Dynamics 365 Contact Center
    • Microsoft Dynamics GP
    • Microsoft Dynamics NAV
  • Cloud
    • Azure Cloud Services
    • Azure Cloud Managed Services
    • Azure Infrastructure Modernization and Migration
    • Azure Cloud Cost Optimization
    • Azure Virtual Desktop
    • Quick Links
    • Cloud Blog
    • Cloud Migration Guide
    • Cloud Cost Optimization Playbook
    • Cloud Solutions
    • Azure Cloud
    • Power Platform
  • Microsoft 365
    • Microsoft 365 Services
    • Microsoft 365 Implementation
    • Microsoft 365 Support Services
    • Microsoft 365 Security Assessment
    • Microsoft 365 Backup and Disaster Recovery
    • Cybersecurity Services
    • Purview Data Loss Prevention
    • Purview Insider Risk Management
    • Purview Information Protection
    • Entra ID Identity and Access Management (IAM)
    • Entra ID Backup and Recovery
    • Microsoft 365 Solutions
    • Microsoft 365
    • Microsoft Teams Phone
    • Microsoft Places
    • Outlook Email Signature Management
  • Copilot & AI
    • Microsoft Copilot and AI Services
    • Copilot AI Leadership Circle
    • Copilot AI Agent Business Impact Assessment
    • Microsoft 365 Copilot AI Readiness Assessment
    • Quick Links
    • Microsoft 365 Copilot Offer
    • Microsoft 365 Copilot Implementation Guide
    • Copilot and AI Blog
    • Copilot and AI Solutions
    • Microsoft Copilot
    • Microsoft SharePoint
  • Advisory Services
    • Clarity CSP Portal
    • Business Impact Assessment
    • IT Governance
    • Microsoft License Optimization
    • Quarterly Business Review
  • Industries
    • Wholesale Distribution
    • Financial Services
    • Nonprofit
    • Professional Services
    • Software
    • Hospitality
  • Resources
    • Blog
    • Case Studies
    • Documentation
    • Support
  • About
    • About Us
    • Why Work With Us
    • Partner
    • Careers
Contact Us
Clarity
Chat with Claire