Step 01
Create the payment worksheet
Use BSB, Account Number, Account Name, Amount and Description as the five headings. Keep one payment per row and enter amounts as plain numbers without dollar signs or commas.
Microsoft Excel guide
How to create an ABA file from Excel
This Excel to ABA file guide shows how to prepare a clean payment worksheet and upload the .xlsx workbook directly. ABAFlow accepts Excel .xlsx files, so you do not need to convert your spreadsheet to CSV first.
Prepare ExcelUpload .xlsxMap columnsFile settingsReview & download
Prepare
Microsoft Excel
Prepare your Excel payment workbook.
Create a clean payment worksheet and preserve BSB and account-number formatting before adding the workbook to ABAFlow.
Step 02
Preserve BSBs and account numbers
Before entering or pasting data, format the BSB and Account Number columns as Text so Excel keeps leading zeros and avoids scientific notation.
Optional head startUse the preformatted Excel payment template.
Download Excel template ↓BSB and account-number columns are already formatted as Text. The workbook contains no sample payment data.
Add data
Recommended method
Upload your Excel workbook directly.
ABAFlow accepts Excel .xlsx files directly, so you do not need to convert your spreadsheet to CSV first.
- 01
Save the workbook as .xlsx
Keep your prepared payment sheet in a standard Excel workbook. Legacy .xls files are not supported.
- 02
Upload the workbook
Open ABAFlow, choose your Excel .xlsx file and review the payment rows ABAFlow detects before continuing.
Alternative
Other supported inputs
Other ways to add your data.
You can also upload a CSV file or copy your payment table from Excel and paste it directly into ABAFlow.
- 01
Upload an existing CSV file directly to ABAFlow.
- 02
Or select and copy your payment table in Excel.
- 03
Open ABAFlow, choose Paste and paste the spreadsheet data.
- 04
Review the detected rows, then continue to mapping.
ABAFlow
Inside ABAFlow
Create your ABA file with ABAFlow.
Use ABAFlow's ABA file generator to create an ABA file from spreadsheet data. Add an Excel or CSV file, or paste your payment table, then follow the same four-step journey.
Step 01
Add & check your payment data
Upload Excel or CSV, or paste from your spreadsheet — we’ll check your data.
Excel (.xlsx)CSVPaste
XLSX
august-payroll-sample.xlsx5 payment rows detected
✓All rows are valid
BSBAccountNameAmount
063-33312345678Jane Smith$2,500.00
033-45698765432Bob Jones$3,200.00
Step 02
Map
Match your spreadsheet columns to the required ABA payment fields.
4 of 4 mapped
BSBBSB⌄✓
AccountAccount⌄✓
NameName⌄✓
AmountAmount⌄✓
Step 03
File settings
Choose your bank and enter the details required for your ABA file.
Step 04
Review & download
Review the payment summary and download your bank-ready ABA file.
- File name
- august-payroll-sample.aba
- Payment rows
- 5 recipients
- Total
- $12,745.75
✓ All payments validated✓ Ready for your bankDownload ABA file
Bank
Business banking
Upload your ABA file to your bank.
Use your bank's batch or Direct Entry payment area to submit and approve the file.
- 01
Sign in to your business banking.
- 02
Go to the relevant batch or direct-entry payment area.
- 03
Upload the
.abafile. - 04
Review the payment details.
- 05
Authorise the payment.
Help
Microsoft Excel
Common issues.
Check these application-specific fixes if the exported data does not look right.
The leading zero in a BSB disappears
Undo the change, format the BSB column as Text, then re-enter the value.
An account number appears in scientific notation
Format the Account Number column as Text before entering or pasting account numbers.
The Excel workbook will not upload
Confirm the file uses the .xlsx format and is no larger than 25 MB. Legacy .xls workbooks are not supported; save a new .xlsx or CSV UTF-8 copy.