Statement Format Code
Format Code can be numeric or alpha.
Name
Enter a name to describe the statement format. This will be used when selecting a format to associate with the bank in Bank Details entry.
For more details on descriptions, see The Role of “Names & Descriptions” in Online Advantage
File Format
Displays the standard file type – csv file. Only csv (Comma Separated Value) files can currently be used in Automatic Bank Reconciliation.
Does the bank statement file have headings in the first row?
Select this if the statement file includes a column headings row as the first row of the file.
How many columns are in the file?
Enter the number of expected columns in the statement file. This is used to validate that the right type of file is being uploaded to bank reconciliation.
Which column contains the ‘reference’?
Enter the column number the reference in the statement file is in. e.g. If it is in spread sheet column ‘A’ enter 1. ‘Reference’ refers to invoice number or similar that can be matched to an OA transaction.
Which column contains the ‘date’?
Enter the column number the transaction date in the statement file is in.
What pattern is the date?
Enter the format of the date in the statement file. e.g. dd/MM/yyyy
What column contains the ‘Credit Amount’?
(What sign is the credit amount shown as?)
Enter the column number the transaction amount in the statement file is in. Make sure to select the sign used in the file for credits (deposits). Do not use the ‘none’ setting as this will mean you will need to manually change the sign on amounts to differentiate credits from debits. ‘None’ is only provided to support the editing of old bank formats.
What column contains the ‘Debit Amount’?
(What sign is the debit amount shown as?)
Enter the column number the debit amount in the statement file is in. Make sure to select the sign used in the file for debits (payments). As with credits, do not use the ‘none’ setting as this will mean you will need to manually change the sign on amounts to differentiate credits from debits. ‘None’ is only provided to support the editing of old bank formats.
Note: if the provided bank statement file has no individual debit or credit column but a single amount column, enter that column number into both the ‘Credit Amount’ and ‘Debit amount’ definitions with sign of ‘None’.
What column contains the ‘transaction type?’
Enter the column number the transaction type in the statement file is in. The Transaction Type distinguishes the type of transaction appearing on the statement e.g. deposit, credit, fee etc.
If there are any other identifying details, what column are these in?
This may be some other column that may help identify the payment – something like a reference – or it may be a description on the bank statement explaining bank charges or interest details.
Transaction Type Map
In Online Advantage, certain codes are used to define transaction types. The transaction types appearing on statements will vary from bank to bank, so for each bank statement format, the transaction types on the statement needs to be ‘mapped’ to the Online Advantage transaction type codes.
Choose the Online Advantage transaction type and enter the corresponding ‘code’ that the bank uses to define the same type of transaction on their electronic statements. For example, for deposits, the OA code is ‘DEP’, the bank might show ‘C’, ‘dep’, ‘deposit’, “Cash” etc.
The OA transaction types and corresponding bank codes are entered as a list. Enter all the transaction types that might appear on your statements.