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, so the bank withdraws exactly the amount the invoice was booked at. Under normal circumstances, no realized currency exchange gain or loss would be expected. However, the exchange rate configured in Business Central has dropped since the invoice was posted, so Business Central posts a realized exchange gain based on its own rate table, and AMC Banking recognizes a realized exchange loss because the bank converted more expensively than Business Central's rate table. The two differences are equal and offset each other — the net effect on the income statement is zero, because the company paid exactly what was booked. This example is the mirror of example 4, where the rate in Business Central had gone up instead of down.
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.80 | 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 | 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,00, 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 | |
Total | 1.058,82 | 1.058,82 |
On the payment date, the rate configured in Business Central is no longer 0,85, but 0,80.
1 EUR = 0.80 GBPBusiness Central therefore values the EUR 1.176,47 reported by the bank at:
EUR 1.176,47 × 0.80 = GBP 941,18The invoice was booked at GBP 1.000, so according to Business Central the debt has become GBP 58,82 cheaper while it was open.
GBP 1.000,00 - GBP 941,18 = GBP 58,82The bank, however, converted at a higher rate:
GBP 1000,00 ÷ EUR 1.176,47 = 0,85Which is the same rate as the invoice, so the bank withdrew GBP 58,82 more than Business Central's valuation of the payment.
GBP 1.000,00 - GBP 941,18 = GBP 58,82Two differences arise in the same posting:
The payment at Business Central's valuation of GBP 941,18 settles the entire invoice of EUR 1.176,47 in a single application line:
GBP 941,18 ÷ 0,80 = EUR 1.176,47Those EUR 1.176,47 were booked at 0,85 but settled at 0,80, so the gain is the rate decrease of 0,05 GBP per EUR:
EUR 1.176,47 × 0,05 = GBP 58,82The booked debt of 1.000,00 is cleared in one entry, and the difference between the booked debt and the payment is posted as a realized exchange gain on 10380.
Business Central values the payment at 941,18, but the bank 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 41100 — the extra GBP 58,82 left the bank account without settling any debt, because the bank converted more expensively than Business Central's table.
The gain (58,82 on 10380) and the loss (58,82 on 41100) 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 | 1.000 | The booked debt is cleared in full | |
GBP bank account | 78100 | 58,82 | The extra amount the bank withdrew because it converted at 0,85. | |
GBP bank account | 78100 | 941,18 | The part of the payment that settles the debt at Business Central's valuation | |
Realized exchange loss | 41100 | 58,82 | Loss: The bank converted at 0,85, which is more expensive than the 0,80 configured in Business Central. | |
Realized exchange gain | 10380 | 58,82 | Gain: The EUR debt became cheaper while it was open (BC's rate table). |
The booked debt of 1.000,00 is cleared in a single entry (debit on the vendor account). The payment at Business Central's valuation, 941,18, leaves the bank account (credit), and the difference of 58,82 between the booked debt and the payment is posted directly as a realized exchange gain (credit on 10380).
The bank, however, withdrew GBP 1.000,00 in total. The remaining 58,82 (credit on the bank account) settled no debt — it is the extra cost of the bank's conversion at 0,85 — and is expensed directly as a realized loss (debit 58,82 on 41100).
Account | G/L Account | Calculation | Net | Matches |
|---|---|---|---|---|
GBP bank account | 78100 | -941,18 - 58,82 | -1.000,00 | The bank statement |
Vendors Foreign | 82200 | +1.000,00 | +1.000,00 | The booked invoice - fully cleared |
Realized exchange loss | 41100 | +58,82 | The bank converted more expensively than BC's table | |
Realized exchange gain | 10380 | -58,82 | BC's rate table: the debt became cheaper while it was open | |
Income statement net | +58,82 - 58,82 | 0 | The company paid exactly the booked amount |