AMC Banking 365 BC - Payment Reconciliation

AMC Banking uses the standard Payment Reonciliation Journal 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 Payment Reconciliation Journal in Microsoft Dynamics 365 Business Central.

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

Payment Reconciliation Journals are usually created in one of the following ways:

1. Host-to-Host Banks with Direct Communication – Bank feeds are retrieved directly from the bank by the AMC Banking Web Service.The journals are typically created automatically by the Synchronization Job in the Import Log page. (Enterprise Solution)

2. Host-to-Host Banks with a Signer – The user triggers a web call through the AMC Banking Web Service to empty the inbox in the bank. (Classic+ Solution)

3. File-Based Bank Feeds – When importing files manually, the Import Bank Feeds option is also used. (Classic+ Solution)

You can access the Payment Reconciliation Journal by navigating toAMC Banking > Payment Reconciliation Journal , or by using the search function and entering "Payment Reconciliation Journal".

Payment Reconciliation Journal List

Gridoverview (Payment Reconciliation Journal List)

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

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 Payment Reconciliation Journal.The status of the Payment Reconciliation Journal can be one of the following:

• OpenNo lines are matched. Match confidence on all lines are None.

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

• Partly MatchedNot all lines meet the minimum match confidence level defined on the Bank Account Card for Auto Payment Reconciliation, or some lines still have an amount difference that remains unmatched.

• Full Match – ImbalanceIf Allow Auto Payment Recon. Posting on the Bank Account Card is set to Post and Reconcile, and all lines meet the minimum match confidence level defined for Auto Payment Reconciliation, but the total amount in the Payment Reconciliation Journal 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 meet the minimum match confidence level defined on the Bank Account Card for Auto Payment Reconciliation and no known imbalance exists

• Reconciliation FailedIf any errors are logged in the Auto Payment Reconcile Log during the Auto Payment Reconciliation that are not related to posting, the status will be set to Reconciliation Failed.

• Posting FailedIf any errors are logged in the Auto Payment Reconcile Log during the Auto Payment Reconciliation that are related to posting, the status will be set to Posting Failed.

Status Date (AMC)Date/Time of last status update.

Fact Box

Auto match history (AMC)The Auto Match History provides detailed information about which lines were processed, which Auto Match Type was used to attempt the match, and which open ledger entries were included in the matching process.The Auto Match History is refreshed each time the Auto Match process is executed for a Payment Reconciliation Journal.

Ribbon (Action bar)

Import Bank feeds (AMC)

Auto Reconcile (AMC) > Auto Payment Reconcile Log (AMC)

Auto Reconcile (AMC) > Update status (AMC)Update status for all Payment Reconciliation Journals.

Auto Reconcile (AMC) > Automatic posting (AMC)Add the Auto Payment Reconciliation process to the Job Queue.

Action > Process > Eval. Bank Statement (AMC)This function uses the latest exported payment journal (Credit Transfer Register) to simulate a bank statement that can be imported into a Payment Reconciliation Journal, allowing you to test and explore the Payment Reconciliation Journal functionality.

Be aware: For safety reasons, this function is only available when AMC Banking is running in Demo Mode.

Payment Reconciliation Journal Lines

Gridoverview (Payment Reconciliation Journal Lines)

Match ConfidenceSpecifies the quality of the automatic payment application on the journal line.

Transaction dateSpecifies the date when the journal line was recorded on the bank account in the bank.

Transaction TextSpecifies the transaction text from the bank account in the bank. This text represents the bank’s posting description and/or may contain payment transaction details entered by the customer or vendor.

It is also possible to define a reference setup on the Bank Account Card, where the specified reference value will be displayed in the Transaction Text.Transaction IDSpecifies an unique ID of the imported bank transaction. This ID is used to link related bank feeds together (e.g., Posting Basis / Bank Statement) and to associate payment reconciliation lines that belong to the same transaction.

Later, during the Bank Account Reconciliation process, the Transaction ID is also used to match bank statement lines with the posted bank ledger entries originating from the Payment Reconciliation Journal.

Transaction amountSpecifies the amount from the bank feed that was imported to the journal line.

The transaction amount is always represented in the bank account’s currency.

Currency codeSpecifies the currency of the Payment Reconciliation Line. This field is used when the bank feed transaction is made in a foreign currency (FCY) while the bank account is maintained in the local currency (LCY).

Amount FCYSpecifies the amount in foreign currency (FCY) of the Payment Reconciliation Line. This field is used when the bank feed transaction is made in a foreign currency (FCY) while the bank account is maintained in the local currency (LCY).

Applied AmountSpecifies the amount that has been applied to one or more open entries.The applied amount is always represented in the bank account’s currency.

DifferenceSpecifies the difference between the amount in the Transaction Amount field and the amount in the Applied Amount field. The difference is always represented in the bank account’s currency.

Document No.Specifies the document number of the open entry that the payment is applied to.

DescriptionSpecifies the description on the open entry that the payment is applied to.

Due DateSpecifies the due date on the open entry that the payment is applied to.

Account NameSpecifies the name of the customer or vendor that the payment is applied to.

Account TypeSpecifies the type of account that the payment application will be posted to when you post the worksheet.

Account No.Specifies the account number that the payment application will be posted to when you post the worksheet.

Total Transaction ID AmountShows Total Amount per Transaction ID

Ribbon (Action bar)

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

Home > Apply Automatically (AMC)Run the Auto Match process for all lines to apply payments to their related open entries or to the appropriate G/L Account, based on data matches between bank transaction information (such as references, party details, transaction text, and/or Text-to-Account mapping) and the corresponding entry information.

If any lines have a match confidence of Manual or Accepted, the user will be asked whether these lines should be preserved or matched again.The Auto Match process uses the rules described below when performing the matching operation.

Home > Apply only selected (AMC)Run the Auto Match process for selected lines to apply payments to their related open entries or to the appropriate G/L Account, based on data matches between bank transaction information (such as references, party details, transaction text, and/or Text-to-Account mapping) and the corresponding entry information.

If any of the selected lines have a match confidence of Manual or Accepted, the user will be asked whether these lines should be preserved or matched again.

Home > Match Details (AMC)After running the AMC Banking Auto Match process, you can view a detailed match overview here.

Manual Application > Set to next Transaction ID (AMC) By default, the Transaction ID is automatically filled in when importing bank feeds. This option is intended for manually created Payment Reconciliation Lines.Set the Transaction ID field on the entry to automatically be filled in with the next no. from the No. series.

Manual Application > Show Non-Transaction Id Lines (AMC)Filter Payment Reconciliation Lines in the list that do not yet have a Transaction ID assigned.

Manual Application > Manual Application (AMC) > Apply Vendors (AMC)Review and apply payments for vendors whose entries were either automatically applied to the wrong open entries or not applied at all for this Payment Reconciliation Line.

Manual Application > Manual Application (AMC) > Apply Customers (AMC)Review and apply payments for customers whose entries were either automatically applied to the wrong open entries or not applied at all for this Payment Reconciliation Line.

Manual Application > Manual Application (AMC) > Add manual text (AMC)Add manual text to be used as matching base, when running Apply Automatically (AMC)

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

Line > Bank Transaction DetailsView the values that exist in an imported bank feed for the selected line.