Automatic account selection

Follow
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:
  1. General ledger/Bank Reconciliation/Load File and Auto Account Selection button
  2. General ledger/General journals/Import Bank Statements and Auto Account Selection button
  3. General ledger/Bank reconciliation/match lines button/Add posting rule button
 

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 Transactions 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 import your bank statement in the usual way.
 

Setting up the posting rule (item 3)

If you have entered your bank statement for the bank reconciliation, then in the reconciliation image you can also select the Add posting-rule button to set up a posting rule regarding the line you have selected when the button is selected. I.e. if you have loaded a bank statement with a text "Rent" and you always want rent to be posted to financial account 3410, then fill in this account in the line in the overview with the bank entries from the bank statement and select the Add posting 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 stored in the same table as Automatic account selection, so you can edit and add your posting rules by selecting one of the menu items described in 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.