Export a batch payment file and import into a bank account

After you've created a batch payment, export the payment file and upload it to your bank to pay the bills in the batch.

What to check before you export a batch payment file

If you choose to export your batch payment file and upload it to your bank, check that:

  • Your bank account is correct in Xero.
  • Your bank account (typically a business bank account, not a personal account) is able to make direct credit payments to contacts this way.
  • You've entered your direct entry (DE) user ID for these payments into the bank account details screen if your bank requires it.
  • You've checked the box Include self-balancing transaction in the ABA file in the bank account details screen.
  • Your exported batch file will be in APCA Direct Entry format (ABA) suitable for Australian banks.
You don't need to export a batch payment file if you've set up a direct feed with Tyro Payments.

    How to export your batch file

    1. Go to Accounts, then click Bank Accounts.
    2. Click the name of the bank account you made the batch payment from.
    3. Open the batch payment.

    4. Your batch payment is either named Payment: multiple items or Payment: Name/Organisation (for one payment in the batch).
    5. Click Export Batch File to download the batch payment file.

      Export batch file

    If there's a bill in your batch with incomplete information, you'll get a message when you try to export the file. The message lists which payment line has errors. Go back and edit your batch before exporting the file.

    Edit a batch payment

    Importing your saved batch file to your bank

    Once you've downloaded the batch payment file, there is no need to open it. Simply upload the file from your downloads folder on your computer into your online banking.

    If the bank offers you the option to process the batch as either a single statement line or multiple statement lines, choose the single statement line.

    If you import the saved batch file into your bank account, it's important that you don't change the file format or the data in the file.

    If you're new to uploading files into your bank account for these types of payments, contact your bank to find out how to do this.

    You might also be interested in