In this scenario, the invoice is posted using the fixed currency exchange rate configured in Microsoft Dynamics 365 Business Central. When the payment is made, the bank applies a lower exchange rate to convert the foreign currency amount into the local currency. As a result, the local currency amount of the payment is lower than the local currency amount of the invoice. During the payment reconciliation process, AMC Banking recognizes the difference as a realized currency exchange gain and automatically creates new Payment Reconciliation lines for the realized exchange gain. When the reconciliation is posted, Business Central posts the corresponding currency exchange difference.
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 |
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 995,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 has, however, withdrawn GBP 995,00, while the invoice was booked at GBP 1.000,00. The two local currency amounts do not agree, and the difference must be accounted for before the reconciliation can be posted.
The payment posting starts as:
Description | Debit GBP | Credit GBP |
|---|---|---|
Vendor payment | 1.000,00 | |
Realized exchange gain | 5,00 | |
GBP Bank account | 995,00 |
Because exchange rates are not updated in this scenario, the rate on the payment date is the same as the rate on the invoice date:
1 EUR = 0.85 GBPBusiness Central therefore values the EUR 1.176,47 reported by the bank at:
EUR 1.176,47 × 0.85 = GBP 1.000,00This is exactly the amount at which the invoice was booked, so the payment settles the invoice in full and leaves nothing outstanding.
The bank, however, withdrew GBP 995,00. The exchange rate applied by the bank was therefore:
GBP 995,00 ÷ EUR 1.176,47 = 0,8458Which is lower than the 0,85 configured in Business Central.
Business Central values the payment at GBP 1.000,00, while the bank withdrew GBP 995,00. The difference is:
GBP 1.000,00 - GBP 995,00 = 5,00 GBPThat is the realized exchange gain. Because the bank applied a lower exchange rate than the configured in Business Central, less currency left the bank account than the invoice was booked at.
During the payment reconciliation process, AMC Banking creates a separate reconciliation line for the GBP 5,00 and applies it to G/L account 10380, the account configured as Realized Gains Acc. on the currency. The original line of GBP 995,00 settles GBP 995,00 of the invoice, and the gain line settles the remaining GBP 5,00 - the debt of GBP 1.000,00 is cleared in full, while only GBP 995,00 left the bank.
Account | G/L Account | Debit GBP | Credit GBP | Meaning |
|---|---|---|---|---|
Vendors Foreign | 82200 | 5,00 | Last 5,00 of the debt cleared, covered by the gain. | |
Vendors Foreign | 82200 | 995,00 | Debt cleared by the actual payment | |
GBP bank account | 78100 | 5,00 | Cancels out the 5,00 credit below. | |
GBP bank account | 78100 | 5,00 | Cancels out the 5,00 debit above. | |
GBP bank account | 78100 | 995,00 | The payment leaving the bank | |
Realized exchange gain | 10380 | 5,00 | 5,00 gain because a debt of 1.000,00 was settled with 995,00, because the bank converted at a lower rate than Business Central. |
The bank withdrew GBP 995,00 (credit on the bank account), and the 995,00 was used to write down the vendor debt of GBP 1.000,00 (debit on the vendor account).
However, 5,00 is still missing before the debt is fully cleared — the vendor has received the full EUR 1.176,47, so nothing more is owed. The journal therefore posts a further 5,00 as if it were paid from the bank (credit) and writes down the remaining 5,00 of the vendor debt (debit).
But the bank only withdrew 995,00, so the 5,00 is immediately posted back to the bank account (debit), with the Realized exchange gain account as the counterpart (credit 5,00). The two 5,00 bank lines cancel each other out, leaving the bank with a net movement of 995,00 — exactly what the bank withdrew — while the last 5,00 of the debt was effectively covered by the exchange gain: a debt of GBP 1.000,00 was settled with only GBP 995,00 of real money, and the 5,00 saved is recognized as income.