How to create an ABA file from Apple Numbers Desktop App

Create a new Numbers worksheet and enter in columns for BSB, Account Number, Account Name, Amount and optionally a description for each row.

Please note the accounts here are ficticious

Ensure columns are formatted as text

Ensure all columns are formatted as text. Numbers by default will convert numbers to the “Number format” which will remove any trailing zeros from BSBs and Account Numbers.

Select all the columns then on the right “Format” panel, click on Cell then select Text from the Data Format dropdown.

Double check all your BSBs and account numers are correct.

Export to CSV

Once you’ve confirmed all your BSB and account numbers are correct, you can export the sheet to a CSV file by selecting File > Export to > CSV…

Finally in the export dialog box, ensure the Include table names option is unselected.

Import to Cemtex ABA

Now you can import your CSV file to the Cemtex ABA file converter to create your ABA file.