There are certain pre-requisites for importing BSB numbers correctly.
To import correctly the BSB has to be entered as a number and formatted as a 6 character text field, otherwise it is possible that Excel will try to convert the value of the BSB field to a date.
"001-200" can be interpreted as "1-Jan".
To import the BSB correctly:
- Enter BSB values as numbers.
The BSB "012-564" will be entered as "12345".
- Enter the fields as '012345.
It will appear in the spreadsheet as
- Format the field as text
Use the drop down option or the Edit format option.
This should format the text with 6 characters where a leading zero will appear.
- Use the format painter to copy the format of this cell to apply to all cells in the BSB column.
There are a number of import spreadsheet templates available on the system which can be viewed/accessed via the link in this article.