A Controller reviewing quarter-end numbers finds a currency realized-gain-loss variance that doesn't reconcile to anything obvious. Tracing it back takes hours, and the eventual answer is almost anticlimactic: an exchange rate that hadn't been updated in six weeks, quietly applied to every transaction in that currency during that window. No single transaction looked wrong. The accumulated drift across dozens of transactions did.
How Exchange Rates Actually Work in Business Central
Business Central maintains exchange rates by currency and effective date, and every transaction in a foreign currency uses the rate in effect on that transaction's posting date. This works cleanly when rates are updated regularly and accurately. It produces exactly the kind of quiet, compounding drift described above when they aren't.
Where This Typically Breaks
Manual Rate Updates That Fall Behind
Companies without an automated rate feed rely on someone manually entering updated exchange rates on a regular cadence — and this is exactly the kind of recurring administrative task that quietly slips when the person responsible gets busy with something more urgent. A rate that's a few days stale rarely matters much. A rate that's six weeks stale, applied across every transaction in that window, becomes a real, hard-to-trace variance.
Unrealized vs. Realized Gain/Loss Confusion
Open items in a foreign currency — an invoice not yet paid — carry unrealized gain or loss based on rate movement since the transaction was posted, distinct from realized gain or loss booked once the item actually settles. Companies that don't clearly understand or properly configure this distinction end up with currency variance postings that don't map cleanly to what actually happened, making genuine reconciliation difficult even when the underlying rates were accurate.
Rounding and Currency-Specific Configuration
Each currency in Business Central carries its own rounding precision and invoice rounding configuration, and inconsistent setup across currencies — reasonable for one currency, wrong for another with different typical transaction sizes — creates small, compounding discrepancies that are individually trivial but collectively confusing at reconciliation time.
What a Reliable Setup Actually Requires
For any business with meaningful multi-currency volume, an automated or at minimum tightly disciplined manual process for updating exchange rates matters more than almost any other single configuration choice in this area. Beyond that, a clear, correctly configured distinction between unrealized and realized gain/loss, and currency-specific rounding settings reviewed deliberately rather than left at default, round out a setup that won't produce mystery variances at quarter-end.
Where to Start
Check directly how current your exchange rates actually are right now, and how they're normally updated — automated feed, or someone remembering to do it manually. If it's the latter, that's worth tightening into a defined, owned process before the next quarter-end variance investigation, rather than after.