ERP & Accounting Integrations for Official Exchange Rates

Step-by-step guides for loading central-bank and tax-authority exchange rates into Dynamics 365 Business Central, Xero, QuickBooks Online, SAP and Odoo from the AllRatesToday API.

By Madhushan, Founder & Lead Developer

Accounting systems ship with a market-rate feed. That is the wrong number wherever a regulation names the publisher: VAT returns that must use the central bank's reference rate, customs entries at the tax authority's monthly table, statutory accounts closed at the official month-end rate. These guides show how to replace or override the built-in feed with the rate the named institution actually published, pulled from one endpoint that covers 122 central banks and 4 tax authorities.

Not a developer? The finance-team overview explains which rate each regulation wants and how the Business plan includes integration support.

Guides

Dynamics 365 Business CentralPoint the built-in Currency Exchange Rate Service at the XML feed. No code. XeroXero fixes its own organisation rates; set the official rate per invoice through the Accounting API. QuickBooks OnlinePush a custom rate per currency per day with the ExchangeRate entity. SAP S/4HANA and ECCLoad TCURR through BAPI_EXCHRATE_CREATEMULTIPLE or the market-data file import. OdooCreate res.currency.rate rows over XML-RPC, with the inversion Odoo expects.

What every ERP guide has in common

One table per bank per publication date. The response carries the bank's own rate_date. Book the rate under that date, not the date you fetched it.
Direction is the bank's, unmodified. The ECB quotes foreign currency per 1 EUR; the Reserve Bank of India quotes INR per 1 USD. Each guide shows which field to invert for that system's convention.
Pairs the bank did not print are flagged. Ask for source and target and a cross rate through the home currency comes back with "derived": true and the method. Keep that flag in your audit trail.
Weekends and holidays return the rate in force. The most recent published table, which is what the compliance rules require you to apply.
Formats. JSON by default; format=xml, format=csv and format=xlsx on the same URL. File downloads on the bank pages need a paid plan; the API formats do not.

Storefronts and spreadsheets

These use live market rates rather than official tables.

ShopifyEstimated local prices, a product-page converter, and a nightly market-price sync through the Admin API. ExcelPower Query from CSV, one-cell FILTERXML formulas, official rates, VBA and Google Sheets.

No-code alternatives

If the system you use is not listed, the Excel and CSV downloads give you a dated file per bank for a manual month-end load, the Google Sheets guide covers spreadsheet-driven workflows, and the open data repository publishes every bank's table as daily JSON and CSV files with no key at all.

Get a free key

Free to evaluate, no card. Every central-bank endpoint is on the free tier.

Create an account