AMC Banking 365 BC - Accounting Example 5 | Scribe

AMC Banking 365 BC - Accounting Example 5

  • today
  • AmcbankingAmcbanking

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 received, the bank applies a higher exchange rate than the exchange rate configured in Business Central on the payment posting date. As a result, the payment amount calculated by the bank differs from the amount calculated by Business Central during payment application. 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

EUR

15/08/2026

1

0.90

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 1.100,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.100, while the invoice was booked at GBP 1.000,00 .

Two things have happened at the same time: the exchange rate configured in Business Central has changed since the invoice was posted, and the bank has converted at a rate that is higher then the updated Business Central rate. This creates two differences, and both is loss.

The payment posting starts as:

Description

Debit GBP

Credit GBP

Vendor payment

1.000,00


Realized exchange loss

58,82


Realized exchange loss

41,18


GBP Bank account


1.100,00

3. Conversion at the payment-date exchange rate

On the payment date, the rate configured in Business Central is no longer 0,85, but 0,90.

1 EUR = 0.90 GBP

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

EUR 1.176,47 × 0.90 = GBP 1.058,82

The 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,82

The bank, however, converted at an even higher rate:

GBP 1.100,00 ÷ EUR 1.176,47 = 0,935

Which is higher than the 0,90 configured in Business Central

4. The exchange difference

Two differences arise in the same posting:

a) The realized loss (Business Central's rate table).

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.

Business Central converts the payment of GBP 1.058,82 at the payment-date rate to find out how many EUR it settles:

GBP 1.058,82 ÷ 0,90 = EUR 1.176,47

The payment alone settles the entire invoice, so no gain line is needed and the whole loss is posted in one entry:

EUR 1.176,47 × 0,05 = GBP 58,82

Those EUR 1.176,47 were booked at 0,85 but settled at 0,90, so the loss is the rate increase of 0,05 GBP per EUR.


b) The realized loss (The bank's rate).

Business Central values the payment at 1.058,82, but the bank withdrew 1.100,00.
AMC Banking creates a separate reconciliation line for the difference and applies it to G/L account 41100:

GBP 1.100,00 - GBP 1.058,82 = GBP 41,18

Total loss:

GBP 58,82 + GBP 41,18 = GBP 100,00

This is exactly the difference between what the invoice was booked at (GBP 1.000,00) and what the bank actually withdrew (GBP 1.100,00).


5. Resulting G/L entries

Account

G/L Account

Debit GBP

Credit GBP

Meaning

Vendors Foreign

82200


58,82

Debt revalued up to the 0,90 rate.

Vendors Foreign

82200

1058,82


Debt cleared by the payment—the full revalued amount

GBP bank account

78100


41,18

The extra 41,18 the bank also withdrew (the AMC loss line's bank side)

GBP bank account

78100


1058,82

The main payment leaving the bank


Realized exchange loss

41100

41,18


Loss: The bank converted at 0,935 — higher than the 0,90 configured in Business Central

Realized exchange loss

41100

58,82


Loss: The EUR debt became more expensive while it was open

Further explanation of the G/L entries table:

Before closing the invoice, Business Central revalues the debt to the payment-date rate: the debt grows by 58,82, from 1.000,00 to 1.058,82 (credit on the vendor account), and the increase is expensed as a realized loss (debit 58,82 on 41100). No money moves on these lines — this is Business Central's rate table speaking.

The bank then withdrew GBP 1.100,00. Of this, 1.058,82 settles the revalued debt (credit on the bank account, debit on the vendor account) — the vendor is now fully paid; they have received the full EUR 1.176,47. The remaining 41,18 was withdrawn because the bank converted at a higher rate than Business Central's table. AMC Banking posts it directly as a realized loss: credit 41,18 on the bank account and debit 41,18 on 41100.

6. Net Check

Account

G/L Account

Calculation

Net

Matches

GBP bank account

78100

-1.058,82 - 41,18

-1.100,00

The bank statement

Vendors Foreign

82200

+1.058,82 - 58,82

+1.000,00

The booked invoice - fully cleared

Realized exchange loss

41100

+58,82 + 41,18

+100,00

The company paid more than booked

Income statement net




- 100

Loss: 58,82 from the rate change, 41,18 form the bank conversion