In this scenario, the invoice is posted using the currency exchange rate configured in Microsoft Dynamics 365 Business Central on the invoice posting date. Exchange rates are maintained and updated to reflect market fluctuations. When the payment is posted, the bank uses the same exchange rate that was applied when the invoice was posted. Under normal circumstances, no realized currency exchange gain or loss would be expected. However, Business Central recalculates the invoice value using the exchange rate configured on the payment posting date rather than the original invoice exchange rate. If the exchange rate in Business Central has changed since the invoice was posted, Business Central calculates and posts a realized currency exchange gain or loss, even though the bank applied the same exchange rate to both the invoice and the payment.
In this example, the company uses GBP as its local currency, and the vendor is configured to use EUR as its transaction currency.
Following Chart of Account will be used in the example:
G/L Account | Description | Income/Balance |
|---|---|---|
10380 | Currency Gains | Income statement |
41100 | Currency Losses | Income statement |
64140 | Goods for resale | Balance Sheet |
78100 | GBP Bank account | Balance Sheet |
82200 | Vendor Foreign | Balance Sheet |
Currencies:
Currency | Starting date | Exchange Rate Amount | Relational | Realised Gains Acc. | Realised Losses Acc. |
|---|---|---|---|---|---|
EUR | 01/08/2026 | 1 | 0.85 | 10380 | 41100 |
EUR | 15/08/2026 | 1 | 0.90 | 10380 | 41100 |
The vendor invoice is:
Invoice amount: EUR 1.176,47
Invoice date : 04/08/2026
Exchange rate on the invoice date: GBP 0,85 per EUR
Invoice value in LCY: GBP 1.000,00
The original posting is :
Description | G/L Account | Debit GBP | Credit GBP |
|---|---|---|---|
Goods for resale | 64140 | 1.000,00 | |
Vendor Foreign | 82200 | 1.000,00 | |
Total | 1.000,00 | 1.000,00 |
The Vendor Ledger Entry contains both:
Currency amount: EUR 1.176,47
Amount (LCY): GBP 1.000,00
The GBP bank statement contains :
Transaction date : 31/08/2026
Transaction amount (LCY): GBP 1.000,00
Currency Code: EUR (This is an AMC specific field, not standard BC)
Bank payment (FCY): EUR 1.176,47 (This is an AMC specific field, not standard BC)
Because the bank account is in local currency GBP, Business Central creates an LCY payment,
not an EUR payment.
The two AMC specific fields tell Business Central which currency the bank actually transferred and how much.
The reconciliation line is matched to the open vendor invoice. The invoice has an open amount of EUR 1.176,47, which is exactly the foreign currency amount reported by the bank, so the payment settles the invoice in full.
The bank withdrew GBP 1.000, which is exactly the amount the invoice was booked at. At first sight no difference exists.
But the exchange rate configured in Business Central has changed since the invoice was posted, and that creates two differences that offset each other
The payment posting starts as:
Description | Debit GBP | Credit GBP |
|---|---|---|
Vendor payment | 1.000,00 | |
Realized exchange loss | 58,82 | |
Realized exchange gain | 58,82 | |
GBP Bank account | 1.000,00 |
On the payment date, the rate configured in Business Central is no longer 0,85 but 0,90.
1 EUR = 0.90 GBPBusiness Central therefore values the EUR 1.176,47 reported by the bank at:
EUR 1.176,47 × 0.90 = GBP 1.058,82The invoice was booked at GBP 1.000, so according to Business Central the debt has become GBP 58,82 more expensive while it was open.
GBP 1.058,82 - GBP 1.000 = GBP 58,82The bank, however, converted at 0,85:
GBP 1.000,00 ÷ EUR 1.176,47 = 0,85Which is the same rate as the invoice and withdrew only GBP 1.000,00
Two differences arise in the same posting:
Business Central revalued the debt to the payment-date rate before closing it: the debt grows from 1.000,00 to 1.058,82, and the increase of GBP 58,82 is posted as realized exchange loss on 41100.
Technically, Business Central calculates the loss per application line. The invoice is settled by two lines, the main payment of GBP 1.000,00 and the gain line of GBP 58,82, and each line carries its own share of the loss, based on how many EUR of the invoice it settles.
Main payment:
The GBP 1.000,00 is converted at the payment-date rate to find out how many EUR settles:
GBP 1.000,00 ÷ 0,90 = EUR 1.111,11 Those EUR 1.111,11 were booked at 0,85 but settled at 0,90, so the loss on this part is the rate increase of 0,05 GBP per EUR
EUR 1.111,11 × 0,05 = GBP 55,56Gain line:
The remaining part of the invoice is settled by the gain of GBP 58,82, which covers:
GBP 58,82 ÷ 0,90 = EUR 65,36 The loss on this part is:
EUR 65,36 × 0,05 = GBP 3,26 Total:
Together the two lines settle the full invoice:
EUR 1.111,11 + EUR 65,36 = EUR 1.176,47The total loss is:
GBP 55,56 + GBP 3,26 = GBP 58,82 The 58,82 matches the revaluation of the debt.
Business Central now values the payment at 1.058,82, but the bank only withdrew 1.000,00. AMC Banking creates a separate reconciliation line for the difference of GBP 58,82 and applies it
to G/L account 10380 — the last 58,82 of the revalued debt is cleared without money, because the bank converted cheaper than Business Central's table.
The loss (58,82 on 41100) and the gain (58,82 on 10380) offset each other. Net effect on the income statement: zero — the company paid exactly what was booked.
Account | G/L Account | Debit GBP | Credit GBP | Meaning |
|---|---|---|---|---|
Vendors Foreign | 82200 | 3,26 | Debt revalued up to the 0,90 rate. (part 2 of the loss) | |
Vendors Foreign | 82200 | 58,82 | Last 58,82 of the revalued debt cleared, covered by the gain. | |
Vendors Foreign | 82200 | 55,56 | Debt revalued up to the 0,90 rate. (part 1 of the loss) | |
Vendors Foreign | 82200 | 1.000,00 | Debt cleared by the actual payment. | |
GBP bank account | 78100 | 58,82 | Cancels out the 58,82 credit below. | |
GBP bank account | 78100 | 58,82 | Cancels out the 58,82 debit above. | |
GBP bank account | 78100 | 1.000,00 | The payment leaving the bank. | |
Realized exchange loss | 41100 | 3,26 | Loss part 2: The EUR debt became more expensive while it was open | |
Realized exchange loss | 41100 | 55,56 | Loss part 1: The EUR debt became more expensive while it was open | |
Realized exchange gain | 10380 | 58,82 | Gain: The bank converted at 0,85, which is cheaper than the 0,90 configured in Business Central. |
Before closing the invoice, Business Central revalued the debt to the payment-date rate: the debt grows by 58,82, from 1.000,00 to 1.058,82 (credit 55,56 + 3,26 on the vendor account), and the increase is expensed as a realized loss (debit 55,56 + 3,26 on 41100).
The bank then withdrew GBP 1.000,00 (credit on the bank account), which writes down 1.000,00 of the revalued debt of 1.058,82 (debit on the vendor account). However, 58,82 is still missing before the debt is fully cleared and the vendor has received the full EUR 1.176,47, so nothing more is owed. The journal therefore posts a further 58,82 as if it were paid from the bank (credit) and writes down the remaining 58,82 of the vendor debt (debit). But the bank only withdrew 1.000,00, so the 58,82 is immediately posted back to the bank account (debit), with the Realized exchange gain account as the counterpart (credit 58,82). The two 58,82 bank lines cancel each other out.
Account | G/L Account | Calculation | Net | Matches |
|---|---|---|---|---|
GBP bank account | 78100 | -1.000,00 - 58,82 + 58,82 | -1.000,00 | The bank statement |
Vendors Foreign | 82200 | +1.000,00 + 58,82 - 55,56 - 3,26 | +1.000,00 | The booked invoice - fully cleared |
Realized exchange loss | 41100 | +55,56 + 3,26 | +58,82 | BC's rate table: The debt became more expensive |
Realized exchange gain | 10380 | -58,82 | The bank converted cheaper than BC's table | |
Income statement net | +58,82 - 58,82 | 0 | The company paid exactly the booked amount |