Operations Performed when Importing a Bank Statement
When you import a bank statement, operations are performed to match the corresponding values in the Account Type field and the Account No. field in the bank statement lines in order to later apply the bank statement with vendor/buyer/employee ledger entries. These operations are performed according to the scheme shown in the figure.
Operations are performed hierarchically which means that the execution of the next operation depends on the result of the previous one.
- By default, in the first step, the action performed is to try to recognize the End-to-End identifier. The End-to-End identifier is used to match corresponding customer/vendor/employee ledger entries.
- If the end-to-end ID match attempt fails, a match attempt is made based on the links defined in the ID-to-Account Mapping table.
- If the system does not find any links in the ID-to-Account Mapping table, it will use the description (or its fragment) in the Text-to-Account Mapping field to recognize the values on the bank statement. if multiple links are found, the priority is taken into account.
If no matches in all the 3 steps are recognized, the Account Type and Account No. values on the bank statement lines will not be populated.
Important
If the Map ID-to-Account table includes more than one relation that contain the account ID used in the bank statement, the Account Type and Account No. fields in the bank statement lines will not be filled in. To fill in the existing mapping into the current line :
- In a bank statement line, select the Map ID-to-Account - Preview action.
- Select a line that contains a mapping to be used for the selected bank statement line.
- Select the Apply to Current Bank Statement Line.
Note
Due to restrictions on the posting process, when the bank statement lines are searched for bank account information, the mappings with the Bank Account value in the Account Type field are not included.