AMC Banking 365 BC - Accounting Example 3 | Scribe

AMC Banking 365 BC - Accounting Example 3

  • today
  • AmcbankingAmcbanking

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
Exch. Rate Amount

Realised

Gains Acc.

Realised

Losses Acc.

EUR

01/08/2026

1

0.85

10380

41100

1. Original vendor invoice

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

2. Payment reconciliation line

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

3. Conversion at the payment-date exchange rate

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 GBP

Business Central therefore values the EUR 1.176,47 reported by the bank at:

EUR 1.176,47 × 0.85 = GBP 1.000,00

This 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,8458

Which is lower than the 0,85 configured in Business Central.

4. The exchange difference

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 GBP

That 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.

5. Resulting G/L entries

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.


Further explanation of the G/L entries table:

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.