How to Auto-Sync the NBC Exchange Rate into Odoo
RielSync Team · 7 min read · Updated August 31, 2026
In short
Odoo tracks multi-currency rates but does not keep them current. RielSync records the National Bank of Cambodia's published rate each evening and writes it directly into Odoo's currency table, so nobody has to look it up and enter it by hand.
Odoo supports multi-currency out of the box: set a company currency, add others, and every invoice, bill, and report can convert between them using exchange rates stored in the system. What Odoo does not do is keep those rates current. That stays a daily task for whoever updates the books.
The manual route in Odoo
Odoo's currency rates live under Accounting → Configuration → Currencies. Some setups pull rates from a generic third-party service on a schedule. Businesses in Cambodia need to match the National Bank of Cambodia's official published rate specifically, because that is the rate expected for local accounting and tax purposes, and a generic feed will not give them that. So the rate gets looked up on NBC's site and entered by hand, one currency and one day at a time.
What goes wrong with manual entry
- 01A missed day: a stale rate applies to a full day of transactions.
- 02A transcription error: usually surfaces at reconciliation, not at entry.
- 03A late update: invoices already went out against the previous day's number.
Individually these are minor. Together they produce books that do not match what NBC actually published.
Automating it instead
RielSync connects directly to Odoo's API. It records NBC's published rate, checks it against recent history to catch anything that looks like an error rather than a real move, and writes it into Odoo's currency rate table (res.currency.rate). That is the same field you would otherwise update by hand. There is no app to install inside Odoo and no change to how your invoices or reports work. The rate is simply already there and already correct.
Beyond Odoo
The same sync also covers SambaPOS, QuickBooks Online, Zoho Books, and SAP Business One, with custom integrations available for other platforms with an API. See how it works or pricing to get started.
FAQ
Does this replace Odoo's built-in currency rate feature?
No. It writes into the same currency rate table Odoo already has. There is no app to install and nothing changes about how invoices or reports work.
What happens on a day NBC doesn't publish a rate?
Nothing is written, and the previous rate is never reused in its place. Weekends and public holidays show as a gap, not a stale value carried forward.
Does it work with anything besides Odoo?
Yes. SambaPOS, QuickBooks Online, Zoho Books, and SAP Business One are also supported out of the box, with custom integrations available for other platforms with an API.