Background
BankLink files can be uploaded in two different formats.
Refer to the following knowledge articles for more information:
- BankLink - BankLink CSV
- BankLink - Multiple Accounts (xml)
- Reset Banklink to load previously loaded data
Common Problems when loading a BankLink File
BankLink File Type (.xml, .csv)
While files you are sent should not be opened prior to loading to Class, you can copy the file and open the copy to check the file structure.
The following are screenshots showing how to identify each type of file.
XML files contain Nodes "<Account>"
In CSV files, all information is separated by a comma ","
BankLink file extensions are currently being created with .CSV despite being .XML files. To fix this problem you can simply edit the file and rename the extention to .XML. Loading the .csv file into Class will still work if you select to load the file as an XML file.
BSB Number (Not recognised)
Occasionally BankLink will allow the entering of a non-valid BSB number into the BSB field. If Class does not recognise the BSB as a valid BSB, Class will not load the data file.
Check the Bank and Branch Name in Class is not empty when the BSB is inserted and saved (it should automatically update).
If the BSB remains blank you will need to confirm the BSB number with the client/statement.
A manual alternative is to edit the <Account_Number>xxxxxxxxxxxxxxxx</Account_Number> section within the file.
You can manually update the file using the instructions in Manually Updating BankLink Files.
BankLink Customer Number (11 Digit account number)
Customer numbers or other numbers are sometimes used as reference/account numbers in BankLink to get feeds from other sources or simply for historical purposes. This causes an issue when loading into Class as only 10 digits for a bank account number are allowed.
Customer numbers in BankLink allow 11 digits. This extra digit can cause problems when loading data files as the account number does not match the number in Class and hence will not load. The workaround is to edit the file <Account_Number>xxxxxxxxxxxxxxxx</Account_Number> to the same 10 digit account number used by Class.
You can manually update the file using the instructions in Manually Updating BankLink Files.
BSB/Account Number (Does not Match)
The BSB and Account numbers used in BankLink need to match the BSB and Account Number in Class Super. A typographical error or changed account number will stop the file from loading.
Manually Updating BankLink files
If you are required to edit a BankLink file, use the following steps to ensure the file remains usable after editing.
Generate the file from BankLink:
- Right click on the file and Open with Notepad
- Only edit content between the " > " and " < " symbols
e.g. <Account_Number>6330009999999999</Account_Number>
The above is for BSB of 663-000, Account number 9999999999. - To change the account number to 1111111111, you would enter
<Account_Number>6330001111111111</Account_Number> - Save and close the file