AMC Banking 365 BC - Accounting Example 6 | Scribe

AMC Banking 365 BC - Accounting Example 6

  • 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 posted, the bank applies a lower 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 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.


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 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 withdrew GBP 995,00, while the invoice was booked at GBP 1.000,00. On top of that, the exchange rate configured in Business Central has changed since the invoice was posted, so two separate differences arise in the same posting:

The payment posting starts as:

Description

Debit GBP

Credit GBP

Vendor payment

1.000,00


Realized exchange loss

58,82


Realized exchange loss


63,82

GBP Bank account


995,00

Total

1.058,82

1.058,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,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 a lower rate:

GBP 995,00 ÷ EUR 1.176,47 = 0,8458

Which is lower than both the invoice rate of 0,85 and 0,90 configured in Business Central, so the bank withdrew GBP 63,82 less than Business Central's valuation of the payment

GBP 1.058,82 - GBP 995,00 = GBP 63,82

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 calculates the loss per application line. The invoice is settled by two lines, the main payment of GBP 995,00 and the gain line of GBP 63,82, and each line carries its own share of the loss, based on how many EUR of the invoice it settles.

Main payment:
The GBP 995,00 is converted at the payment-date rate to find out how many EUR it settles:

GBP 995,00 ÷ 0,90 = EUR 1.105,56

Those EUR were booked at 0,85:

EUR 1.105,56 × 0,85 = GBP 939,73

So the loss on this part is:

GBP 995,00 - GBP 939,73 = GBP 55,27

Gain line:
The remaining part of the invoice is settled by the gain of GBP 63,82, which covers:

GBP 63,82 ÷ 0,90 = EUR 70,91
EUR 70,91 × 0,85 = GBP 60,27 

The loss on this part is:

GBP 63,82 - GBP 60,27 = GBP 3,55

Total:
Together the two lines settle the full invoice:

GBP 55,27 + GBP 3,55 = GBP 58,82

The 58,82 matches the revaluation of the debt.

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

Business Central now values the payment at GBP 1.058,82, but the bank withdrew only GBP 995,00.
AMC Banking created a separate reconciliation line for the difference of GBP 63,82 and applies it to G/L account 10380, the last 63,82 of the revalued debt is cleared without money, because the bank converted more cheaply than Business Central's table.


5. Resulting G/L entries

Account

G/L Account

Debit GBP

Credit GBP

Meaning

Vendors Foreign

82200

995,00


Debt cleared by the actual payment.

Vendors Foreign

82200


55,27

Debt revalued up to the 0,90 rate (part 1 of the loss)

Vendors Foreign

82200

63,82


Last 63,82 of the revalued debt cleared, covered by the gain

Vendors Foreign

82200


3,55

Debt revalued up to the 0,90 rate (part 2 of the loss)

GBP bank account

78100


995,00

The payment leaving the bank

GBP bank account

78100


63,82

Cancels out the 63,82 debit below


GBP bank account

78100

63,82


Cancels out the 63,82 credit above

Realized exchange loss

41100

55,27


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

Realized exchange loss

41100

3,55


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

Realized exchange gain

10380


63,82

The bank converted at 0,8458, cheaper than the 0,90 configured in Business Central.

Further explanation of the G/L entries table:

Before closing the invoice, Business Central revalued the debt to the payment-date rate: the debt grows by 58,82, from 1.000,00 to 1.058,82 (credit 55,27 + 3,55 on the vendor account), and the increase is expensed as a realized loss (debit 55,27 + 3,55 on 41100).

The bank then withdrew GBP 995,00 (credit on the bank account), which writes down 995,00 of the revalued debt of 1.058,82 (debit on the vendor account). However, 63,82 is still missing before the debt is fully cleared, and the vendor has received the full EUR 1.176,47, so nothing more is owed. The journal therefore posts a further 63,82 as if it were paid from the bank (credit) and writes down the remaining 63,82 of the vendor debt (debit). But the bank only withdrew 995,00, so the 63,82 is immediately posted back to the bank account (debit), with the Realized exchange gain account as the counterpart (credit 63,82). The two 63,82 bank lines cancel each other out.

6. Net Check

Account

G/L Account

Calculation

Net

Matches

GBP bank account

78100

-995,00 - 63,82 + 63,82

-995,00

The bank statement

Vendors Foreign

82200

+995,00 + 63,82 - 55,27 - 3,55

+1.000,00

The booked invoice - fully cleared

Realized exchange loss

41100

+55,27 + 3,55

+58,82

BC's rate table: the debt became more expensive

Realized exchange gain

10380

-63,82

-63,82

The bank converted cheaper than BC's table

Income statement net


+58,82 - 63,82

-5,00

A gain of 5,00 - the company paid 995,00 to settle a debt booked at 1.000,00