How to create an ABA file from Google Sheets

Create a google sheet (you can visit sheets.new to create a new sheet) 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. Google 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 visit Format > Number > Plain Text

Double check all your BSBs and account numers are correct.

You can “Paste Special” into your google sheet to remove any formatting from other applications by selecting Edit > Paste Special > Values Only.

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 > Download > Comma-Separated Values (.csv)

Import to Cemtex ABA

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