Skip to main content

Currency Rates Import for Microsoft Dynamics 365 Business Central

This guide explains how to set up automatic currency rate synchronization in Business Central using certified services, open data providers, and cryptocurrency exchanges. Designed for financial managers and administrators who need reliable exchange rates for accounting and reporting, including support for cryptocurrency transactions.

| ✅ What's Inside

| | --- | |

Assisted Setup wizard walkthrough

| |

List of supported rate providers (fiat and crypto)

| |

Configuration of filters and authentication

| |

Cryptocurrency mapping and setup

| |

Job Queue scheduling

| |

Manual override and preview options

| |

Transformation rule: "NEXTDATE" explained

|

To facilitate automatic import of foreign currency rates, Microsoft Dynamics 365 Business Central offers Currency Exchange Rate Services. You can specify multiple sources for currency rates import, with filter on which currency to import from what source.

Some European countries have national currencies, and their National Banks publish foreign currency rates. Other currency rate sources need to provide authentication. To import this data into Business Central, additional configuration may be required.

Supported Services:

Fiat Currency Services​

  • European Central Bank

  • Sveriges Riksbank (National Bank of Sweden)

  • Bank of England (National Bank of the United Kingdom)

  • Danmarks Nationalbank (National Bank of Denmark)

  • Open Exchange Rates - open source for exchange rate data

Cryptocurrency Services (NEW)​

  • CoinGecko - Free cryptocurrency exchange rates with 19,000+ coins

  • CoinMarketCap - Professional crypto exchange rates (API key required)

  • CryptoCompare - Real-time cryptocurrency data (API key optional)

All cryptocurrency services support:

  • Multiple cryptocurrencies (Bitcoin, Ethereum, Litecoin, etc.)

  • Conversion to any fiat base currency (EUR, USD, etc.)

  • Automatic or manual asset mapping

  • Real-time exchange rate updates