To support the new Bank Transaction File Import functionality, a new set of Configurations have been created within the Banking Configuration menu. Please scroll down as we step through them:
ACR ONLY accessible configurations
It should be noted that three of these new fields are an ACR ONLY configuration and will default accordingly. If sites determine they would like to change the default setting, please contact the Training Team via email to request this.
The ‘Bank Transaction Imports’ fields starting with the 3 ACR ONLY configurations are as follows:
- ‘Auto Flag Matched Entries’ : this will default to True. This configuration when set to true, for any entries ticked within the Bank Transaction Imports screen will automatically be flagged as presented in the Bank Reconciliation.
- ‘Minimum length Customer No to match’ : this will default to a minimum value of 5. For those sites with Customers whose Account number is less than 5 digits will need this value amended.
- ‘Exact match Invoice No and Amount’: this will default to True. This configuration when set to True will assist with automatically creating a Cash Receipt when an exact match of a Bank Transaction is made to both an invoice number and amount.
New Site accessible Banking Configurations
Two new GL Account configurations have been created, sites can choose to use the ‘System Account’ or select their own.
- ‘Debtor Clearing GL Account’ : this field will default to 9999 System Account
- ‘Bank Charges GL Account’ : this field will default to 9999 System Account. This configuration must be updated to the correct GL Account or the system will be unable to create a Bank Charges payment entry. Please discuss with your Accountant to determine which GL Account should be set for as the ‘Bank Charges GL Account’.
Bank File Format Options:
‘Auto recognise 3 column format’
This is the Default setting for the Bank File Format. When the system loads the file, and this option is set, the system will use this configuration in order to read the file. Meaning it will read the first 3 columns of the file and check if there is a date, amount and details column. The actual order of the columns will not affect the system in reading the file and if there is an Extra Detail column to load, its values will be appended to the Detail column.
‘Specific single amount format’
If users set this option as the Bank File Format, when the system loads the file, the system will use this configuration in order to read the file. Meaning Users will need to refer to their banks’ Bank File in order to apply the correct number to the matching column within this configuration.
- This format uses column configurations of:
- Date Column No
- Details Column No
- Amount Column No
- Extra Details Column No
‘Specific double amount format’
If users set this option as the Bank File Format, when the system loads the file, the system will use this configuration in order to read the file. Meaning Users will need to refer to their banks’ Bank File in order to apply the correct number to the matching column within this configuration.
- This format uses column configurations of:
- Date Column No
- Details Column No
- Debit Column No and Positive/Negative figure drop down box
- Credit Column No and Positive/Negative drop down box
- Extra Details Column No
