AMC Banking 365 BC - Accounting Example 2 | Scribe

AMC Banking 365 BC - Accounting Example 2

  • 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 received, the bank has applied a higher exchange rate to convert the foreign currency amount into the local currency. As a result, the local currency amount of the payment is higher than the local currency amount of the invoice. During the payment reconciliation process, AMC Banking recognizes the difference as a realized currency exchange loss and automatically creates new Payment Reconciliation lines for the realized exchange loss. 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

G/L Account

Debit GBP

Credit GBP

Goods for resale

64140

1.000,00


Vendor Foreign

82100


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 1.005,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 1.005,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 loss

5,00


GBP Bank account


1.005,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 1.005,00. The exchange rate applied by the bank was therefore:

GBP 1.005,00 ÷ EUR 1.176,47 = 0,8543

Which is higher 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 1.005,00. The difference is:

GBP 1.005,00 - GBP 1.000,00 = 5,00 GBP

That is the realized exchange loss. Because the bank applied a higher exchange rate than the configured in Business Central, more 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 41100, the account configured as Realized Losses Acc. on the currency. The original line is reduced to the GBP 1.000,00 that settles the invoice, so that the two lines together equal the GBP 1.005,00 withdrawn by the bank

5. Resulting G/L entries


G/L Account

Debit GBP

Credit GBP

Meaning

Vendor Foreign

82200

1.000,00


The booked debt is cleared - invoice fully applied

Realized exchange loss

41100

5,00


The conversion cost 5,00 more than booked.

GBP bank account

78100


5,00

The extra 5,00 the bank also withdrew

GBP bank account

78100


1000,00

The payment leaving the bank