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.