Support Query
When importing Bendigo and DHH Bank files through the MYOB BankLink Function, no transactions are getting imported into SF360.
Solution
This issue is occurring because the Bendigo Bank files from BankLink contain the Account Reference Number of the client as the Bank Account No. For DDH accounts, BankLink do not provide the BSB number in the file and input "000000".
You will need to edit the BankLink xml file and replace the account reference number or BSB number.
- Right-click the XML File.
- Select Open With and choose Notepad from the list.
- In Notepad, go to Edit | Replace...
- For Bendigo Files
In the Find What box: Input the opening "Bank_Account_No" tag, the Reference Number (what currently appears as the Account Number in the XML File) and the closing "Bank_Account_No" tag. For example, <Bank_Account_No>123456789</Bank_Account_No>
In the Replace with box: Input the opening "Bank_Account_No" tab, the correct Account Number (this should match what is in SF360) and the closing "Bank_Account_No" tag. For example, <Bank_Account_No>112233445</Bank_Account_No>
For DDH Files
In the Find What box: Input the opening "BSB" tag, the incorrect BSB Number (this should be showing as 000000 in the XML File) and the closing "BSB" tag. For example, <BSB>000000</BSB>
In the Replace with box: Input the opening "BSB" tag, the correct BSB Number (this should match what is in SF360) and the closing "BSB" tag. For example, <BSB>123456</BSB>
- Select Replace All.
- Save and close the file.
You can then re-import the file and the transactions should flow through.