The Bank Account Reconciliations page

6 min.

To perform a bank account reconciliation, you need to have a statement file ready from the bank. If you use manual communication, the file will be in the downloaded location, and if you use direct communication, the file is ready in the bank.

To open the Bank Account Reconciliations page, from the Role Center, search for Bank Account Reconciliations and choose the related link.

The right side of the Reconciliation page displays the open Bank Account Ledger Entries. These are the entries made by the company employees in Business Central.

The left side of the Reconciliation page displays the Bank Statement Lines that you just imported from the bank. These are the entries created in the bank that must be reconciled with the Bank Account Ledger Entries. So you are matching the lines on the left side with the lines on the right side. The lines will be matched based on the setup of Statement Intelligence you defined in the previous module.

The bank statement lines columns

In Statement Intelligence, there are quite a few extra columns available in Payment Management compared to standard Business Central. These will assist you in achieving a perfect match.

Column	Description
Status	Specifies the reconciliation status of the chosen bank statement line.
No. of Reconciliation Suggestions	Specifies the number of possible matches found in the customer ledger entries for the selected bank statement line.
Selected Recon. Found By	Specifies how the reconciliation suggestion, chosen by the user, was found.
Manual Handling	Specifies if the bank statement line should be handled manually. Enable manual handling, and transfer the line to the general journal using the action Create Journal Lines. When posting the general journal line, the bank statement line is automatically reconciled.
Transaction Date	Specifies the posting date of the bank account or check ledger entry on the reconciliation line when the Suggest Lines function is used.
Additional Information	View the additional information for the chosen bank statement line. The information covers notification lines and currency codes that are used when handling the reconciliation.
Description	Specifies a description for the transaction on the reconciliation line.
Statement Amount	Specifies the amount of the transaction on the bank's statement shown on this reconciliation line.
Applied Amount	Specifies the amount of the transaction on the reconciliation line that has been applied to a bank account or check ledger entry.
Difference	Specifies the difference between the amount in the Statement Amount field and the amount in the Applied Amount field.

For additional columns, you can go to the action bar, and select Related > Page > Show more Columns. These additional columns tell you if the matches are correct, or give you the extra information that you need to make a manual match. The information here is only available if the bank supplies it.

Column	Description
Account Type	Specifies the type of account that the bank account statement belongs to.
Account Number	Specifies the account number that the bank account statement belongs to.
Bank Reference	Specifies a bank reference. The field value depends on which bank the bank account statement comes from, and what the sender included in the reference.
Transaction ID	Specifies a reference. The field value depends on which bank the bank account statement comes from, and what the sender included in the reference.
Sender Reference	Specifies a sender reference. If a payment is created with Payment Management, this will contain a UPR no. This field might have a value depending on which bank the bank account statement comes from. and what the sender included in the reference.
Currency	Specifies the currency code of the bank account statement line.

Select Import Bank Statement to import the statement file, and then you can start working with the lines. You'll see how in the next unit.