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.

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 116 central banks and 4 tax authorities.

Guides

What every 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.

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.