AMC Banking 365 BC - Bank account reconciliation

AMC Banking uses the standard Bank Account Reonciliation in Microsoft Dynamics 365 Business Central, with additional functionality provided by AMC Banking.Therefore, this guide focuses on the AMC Banking–specific functionality used within the Bank Account Reconciliation in Microsoft Dynamics 365 Business Central.

For a complete description of the standard Bank Acount Reconciliation features,we recommend visiting Microsoft Learn.

Bank Account Reconciliation are usually created in one of the following ways:

1. Created from a Payment Reconciliation Journal When using the Post Only feature in the Payment Reconciliation Journal, a Bank Account Reconciliation Journal is generated — but only if the Payment Reconciliation Journal originated from a Bank Statement.

2. Reconciled Directly in the Payment Reconciliation JournalUsing the Post and Reconcile feature, the bank account reconciliation can be completed directly within the Payment Reconciliation Journal.

3. Direct Import to the Bank Account ReconciliationWhen the bank account is configured with BARJ = true, then imported bank feeds are created directly as Bank Account Reconciliation Journals.

You can access the Bank Account Reconciliation by navigating to AMC Banking > Bank Account Reconciliation, or by using the search function and entering "Bank account reconciliation".

Bank Account Reconciliation List

Gridoverview (Bank Account Reconciliation List)

Bank Account No.Specifies the number of the bank account that you want to reconcile with the bank's statement.

Bank Account NameSpecifies the name of the bank account that you want to reconcile

Statement No.Specifies the number of the bank account statement. (This is the internal statement number in Business Central, not the bank statement number provided by the bank.)

Bank Statement No. (AMC)Bank statement number provided by the bank.

Status (AMC)Shows the current state of the Bank Account Reconciliation Journal.

The status of the Bank Account Reconciliation Journal can be one of the following:

• OpenNo lines are matched against Bank Account Ledger Entries.

• Lines Not CompleteSome lines are missing information, such as the Transaction Date, Amount, or similar required fields. Normally only if lines are manually created.

• Partly matchedSome lines still have an amount difference that remains unmatched.

• Full Match – ImbalanceAll lines are matched against bank account ledger entries, but the total amount does not equal the End Balance minus Start Balance of the bank statement, the status will be set to Full Match – Imbalance.

• Ready to PostAll lines are matched against bank account ledger entries and End Balance / Start Balance also match the expected amount.

• Reconciliation FailedIf any errors are logged in the Auto BankReconcile Log (AMC) during the Auto Bank Account Reconciliation that are not related to posting, the status will be set to Reconciliation Failed.

• Posting FailedIf any errors are logged in the Auto BankReconcile Log (AMC) during the Auto Bank Account Reconciliation that are related to posting, the status will be set to Posting Failed.

Statement DateSpecifies the date on the bank account statement.

Balance Last StatementSpecifies the ending balance shown on the last bank statement, which was used in the last posted bank reconciliation for this bank account.

Statement Ending BalanceSpecifies the ending balance shown on the bank's statement that you want to reconcile with the bank account.

Ribbon (Action bar)

Import Bank feeds (AMC)

Import Bank feeds (AMC) > Reprocess from importlog (AMC)With this action, you can reprocess a previously imported bank feed (Bank Statement) from the Import Log directly into the Bank Account Reconciliation Journal.

Autom. Bank Account Reconciliation (AMC)Add the Auto Bank Account Reconciliation process to the Job Queue.

Autom. Bank Account Reconciliation (AMC) > Run automatic Bank Account Reconciliation (AMC)Run the Auto Bank Account Reconciliation process immediately for this Bank Account Reconciliation Journal.

Autom. Bank Account Reconciliation (AMC) > Auto BankReconcile Log (AMC)

Autom. Bank Account Reconciliation (AMC) > Update status (AMC)Update status for all Bank Account Reconciliation Journals.

Bank Account Reconciliation Lines

General

Bank Account No.Specifies the number of the bank account that you want to reconcile with the bank's statement.

Statement No.Specifies the number of the bank account statement. (This is the internal statement number in Business Central, not the bank statement number provided by the bank.)

Statement DateSpecifies the date on the bank account statement.

Balance Last StatementSpecifies the ending balance shown on the last bank statement, which was used in the last posted bank reconciliation for this bank account.

Statement Ending BalanceSpecifies the ending balance shown on the bank's statement that you want to reconcile with the bank account.

Status (AMC)Shows the current state of the Bank Account Reconciliation Journal.

Ribbon (Action Bar) - General

Bank > Import Bankfeeds (AMC)Import Bank feeds from the AMC Banking webservice containing the related bank transactions.This option allows you to import bank feeds or files directly into the system, making it convenient for reconciling your bank transactions with your accounting records.

Matching > Match Automatically (AMC)Automatically search for and match Bank Statement Lines with Bank Account Ledger Entries using Transaction ID and/or transaction date, including support for summed amounts when multiple ledger entries share the same Transaction ID. If no matches are identified through the Match Automatically (AMC), the system will subsequently execute the standard Business Central “Match Automatically” functionality.

Matching > Map Text to Account (AMC)Map Text to Account for creating GL Entries in the Automatic Bank Account Reconciliation job

Matching > Bank Transaction References (AMC)View the bank references that exists in an imported bank feed for the Bank Account Reconciliation line.

Gridoverview - Bank Statement Lines

Transaction DateSpecifies the posting date of the bank account or check ledger entry on the reconciliation line when the Suggest Lines function is used.

DescriptionSpecifies a description for the transaction on the reconciliation line.

Statement amountSpecifies the amount of the transaction on the bank's statement shown on this reconciliation line.

Applied EntriesSpecifies whether the transaction on the bank's statement has been applied to one or more bank account or check ledger entries.

Applied AmountSpecifies the amount of the transaction on the reconciliation line that has been applied to a bank account or check ledger entry.

DifferenceSpecifies the difference between the amount in the Statement Amount field and the amount in the Applied Amount field.

Transaction IDSpecifies an unique ID of the imported bank transaction. This ID is used to link Bank Account Reconciliation together with the Bank Account Ledger Entries.

Gridoverview - Bank Account Ledger Entries

AppliedSpecifies if the bank account ledger entry has been applied to its related bank transaction.

Posting DateSpecifies the posting date for the entry.

Document TypeSpecifies the document type on the bank account entry. The document type will be Payment, Refund, or the field will be blank.

Document No.Specifies the document number on the bank account entry.

DescriptionSpecifies the description of the bank account entry.

AmountSpecifies the amount of the entry denominated in the applicable foreign currency.

Remaining AmountSpecifies the amount that remains to be applied to. The amount is denominated in the applicable foreign currency.

OpenSpecifies whether the amount on the bank account entry has been fully applied to, or if there is a remaining amount that must be applied to.

Check Ledger EntriesSpecifies the check ledger entries that are associated with the bank account ledger entry.

External Document No.Specifies a document number that refers to the customer's or vendor's numbering system.

Transaction ID (AMC)Specifies the ID of the imported bank transaction.This ID is used to link the Bank Account Ledger Entries with the Bank Account Reconciliation lines.