Automatic account selection allows you to set up rules so that account fields are automatically filled in when loading bank statements.
Automatic account selection can be set up in different places in the system:
- General ledger/Bank Reconciliation/Load File and Auto Account Selection button
- General ledger/General journals/Import Bank Statements and Auto Account Selection button
- General Ledger/Bank reconciliation/Match lines button/Add coding rulebutton
Setting up automatic account selection (clause 1+2)
- For example, select General ledger/Bank Reconciliation/Load File and the Auto Account Select button
- Select the Add button
- For example, if you want all items where the text contains the word ‘Interest’ to be posted to account 4310, enter the following:
By checking one of the last three boxes, you define whether the search text should be at the beginning of the text on your bank statement, exactly (equal to) the text, or just part of the text (contains). - Enter as many posting options as you want
- Select the Save button and now load your Account statement from the bank in the usual way.
Setting up the posting rule (item 3)
If you have imported your Import bank statement for Bank reconciliation, you can also select the Add coding rule button in the reconciliation screen to set up a coding rule for the line you have selected when the button is selected.
I.e. if you have an Import bank statement with a text “Rent” and you always want rent to be posted to financial account 3410, then fill in this account on the line in the overview with the bank entries from the bank statement and select the Add GL account rule button and a rule will automatically be suggested based on this, and most often you can just say OK to the prompt that appears.
The posting rules are saved in the same Tables as Automatic Account Selection, so you can edit and Add your posting rules by selecting one of the menu items described as points 1 and 2 above.
Editing posting rules
If you want to change the posting rules, go to Data manipulation. Select the table “BankImportMapClient”
Read more about data manipulation here.