AMC Banking 365 BC - Accounting Example 8 | Scribe

AMC Banking 365 BC - Accounting Example 8

  • 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. Since the invoice was posted, the exchange rate configured in Business Central has dropped, but when the payment is posted, the bank converts at a rate that is higher than the rate configured in Business Central on the payment posting date. Two differences arise: Business Central posts a realized exchange gain, because according to its rate table the debt became cheaper while it was open, and AMC Banking recognizes a realized exchange loss, because the bank converted more expensively than Business Central's rate table. The loss is larger than the gain — the company paid more than the booked amount, and the income statement shows the real extra cost.

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

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.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 withdrew GBP 1.005,00, 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 dropped since the invoice was posted (a gain), and the bank has converted at a rate that is higher than the updated Business Central rate (a loss). The loss is larger than the gain.

The payment posting starts as:

Description

Debit GBP

Credit GBP

Vendor payment

1.000,00


Realized exchange loss

63,82


Realized exchange gain


58,82

GBP Bank account


1.005,00

Total

1.063,82

1.063,82

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,80.

1 EUR = 0.80 GBP

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

EUR 1.176,47 × 0.80 = GBP 941,18

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

The bank, however, converted at a higher rate:

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

Which is higher than both the invoice rate of 0,85 and the 0,80 configured in Business Central, so the bank withdrew GBP 63,82 more than Business Central's valuation of the payment.

GBP 1.005,00 - GBP 941,18 = GBP 63,82

4. The exchange difference

Two differences arise in the same posting:

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

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,47

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

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

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

Business Central values the payment at 941,18, but the bank withdrew 1.005,00. AMC Banking creates a separate reconciliation line for the difference of GBP 63,82 and applies it to G/L account 41100 — the extra GBP 63,82 left the bank account without settling any debt, because the bank converted more expensively than Business Central's table.

The loss is larger than the gain:

GBP 63,82 - GBP 58,82 = GBP 5,00

Net effect on the income statement: a loss of GBP 5,00 — exactly the difference between what the bank withdrew (1.005,00) and what was booked (1.000,00). The company really did pay GBP 5,00 more than expected.


5. Resulting G/L entries

Account

G/L Account

Debit GBP

Credit GBP

Meaning

Vendors Foreign

82200

1.000,00


The booked debt is cleared in full

GBP bank account

78100


941,18

The part of the payment that settles the debt at Business Central's valuation.

GBP bank account

78100


63,82

The extra amount the bank withdrew because it converted at 0,8543.

Realized exchange loss

41100

63,82


Loss: The bank converted at 0,8543, 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)

Further explanation of the G/L entries 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.005,00 in total. The remaining 63,82 (credit on the bank account) settled no debt — it is the extra cost of the bank's conversion at 0,8543 — and is expensed directly as a realized loss (debit 63,82 on 41100).

6. Net Check

Account

G/L Account

Calculation

Net

Matches

GBP bank account

78100

-941,18 - 63,82

-1.005,00

The bank statement

Vendors Foreign

82200

+1.000,00

+1.000,00

The booked invoice - fully cleared

Realized exchange loss

41100


+63,82

The bank converted more expensively than BC's table

Realized exchange gain

10380


-58,82

BC's rate table: The debt became cheaper

Income statement net


+63,82 - 58,82

+5,00

Net loss: The company paid GBP 5,00 more than the booked amount