Log inCreate free account
Google Sheets guide

How to create an ABA file from Google Sheets

Create an ABA file from Google Sheets: paste your payment data or download an Excel file to upload.

Optional head start

Start with the template.

Download the template, upload it to Google Drive and open it in Google Sheets. BSB and account columns are already formatted as text.

Download template (.xlsx)
Already have your payment data?

Quick copy & paste.

Copy these five columns in order, then paste them into ABAFlow.

BSB → Account Number → Account Name → Amount → Description

Paste payment data Up to 500 payments · 1 MB
See copy & paste example

Click the payment grid and press Ctrl+V (Windows) or Cmd+V (Mac). Paste skips column mapping.

Copy payment table
  1. Step 01

    Prepare your payment data.

    Use BSB, Account Number, Account Name, Amount and Description headings. Keep one payment per row.

    ABAFlow Payments – Google Sheets
    Google Sheets payment sheet with the five ABAFlow columns and example payment rows

    Next: protect BSBs and account numbers

  2. Step 02

    Preserve BSB and Account formatting.

    Before adding data, select BSB and Account Number columns, then choose Format → Number → Plain text.

    Format → Number → Plain text
    Google Sheets Number format menu with Plain text selected for BSB and Account Number columns

    Ready? Bring your data into ABAFlow

  3. Step 03

    Download as Microsoft Excel (.xlsx)

    Choose File → Download → Microsoft Excel (.xlsx). Save the workbook for upload to ABAFlow.

    File → Download → Microsoft Excel (.xlsx)

    Next: upload your Excel file

  4. Step 04

    Continue in ABAFlow.

    Upload your file, check the payments, then follow ABAFlow to review and download your ABA file.

    Upload & validation
    Excel (.xlsx)CSVPaste
    XLSX
    ABAFlow Payments.xlsx4 payment rows detected
    ✓All rows are valid
    BSBAccountNameAmount
    062-00012345678Harbour Supplies$2,500.00
    032-00187654321Maya Chen$825.50
    114-87923456789Bluegum Consulting$1,425.00
    083-34798765431Summit Office Co$615.75
    Create your 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.

  1. 01

    Sign in to your business banking.

  2. 02

    Go to the relevant batch or direct-entry payment area.

  3. 03

    Upload the .aba file.

  4. 04

    Review the payment details.

  5. 05

    Authorise the payment.

Help
Google Sheets

Common issues.

Check these application-specific fixes if the exported data does not look right.

The workbook contains several sheets

After uploading the .xlsx file, choose the worksheet that contains your payment data when ABAFlow asks.

A BSB loses its leading zero

Set the BSB column to Plain text before entering or pasting the value.

Formulas or comments are missing

ABAFlow reads the displayed payment values from the selected worksheet, not comments or other supporting content.

Ready to begin?

Create your ABA file

Create your ABA file →

Back to all guides