Previous

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.
PM Reconciliation page

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.

ColumnDescription
StatusSpecifies the reconciliation status of the chosen bank statement line.
No. of Reconciliation SuggestionsSpecifies the number of possible matches found in the customer ledger entries for the selected bank statement line.
Selected Recon. Found BySpecifies how the reconciliation suggestion, chosen by the user, was found.
Manual HandlingSpecifies 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 DateSpecifies the posting date of the bank account or check ledger entry on the reconciliation line when the Suggest Lines function is used.
Additional InformationView the additional information for the chosen bank statement line. The information covers notification lines and currency codes that are used when handling the reconciliation.
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 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.

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.

ColumnDescription
Account TypeSpecifies the type of account that the bank account statement belongs to.
Account NumberSpecifies the account number that the bank account statement belongs to.
Bank ReferenceSpecifies 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 IDSpecifies a reference. The field value depends on which bank the bank account statement comes from, and what the sender included in the reference.
Sender ReferenceSpecifies 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.
CurrencySpecifies 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.