Export a batch payment file to 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.

Your bank may charge a fee if you upload a CSV or BACS file.

Before you start

If you want to save the file for your own use, you can choose CSV format. Or BACS to upload it to your bank.

If you bank with Santander bank, Xero provides extra format options: Santander Connect BACS payments and Santander Connect Standard bulk payments.

Make sure:

  • Your bank account is correct in Xero.
  • Your bank (and account - typically a business bank account) can make direct credit payments this way.
  • You've entered your Service User Number (SUN) or Owner ID number for BACS payments into your organisation's financial settings (if you bank with HSBC, you don't have to do this).
  • Details entered in the batch payment fields are within 18 characters (BACS format requirement).
  • The owner ID (entered in Financial Settings) is no longer than 6 characters.

Export your batch file

  1. In the Accounts menu, select Bank Accounts.
  2. Click the name of the bank account you made the batch payment from.
  3. Open the batch payment.

    It's called either Payment: multiple items or Payment: Name of customer (for a single payment).

  4. Click Export Batch File and select the export format you want (CSV, a BACS format, or one of the Santander bank formats). If this option isn't there, it means you've already reconciled the transaction.

    Export batch file

If there's a bill in your batch with incomplete information, you'll get a message showing the payment line errors when you try to export the file. You'll need to edit your batch before exporting the file.

Import the batch payment file to your bank

Once you've downloaded the batch payment file, you don't have to open it.

  1. From your downloads folder on your computer, upload the file into your online banking.
  2. If you're asked to process the batch as 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 not to change the file format or the data in the file.

If you haven't uploaded files into your bank account for these types of payments before, contact your bank to find out how to do this.

You might also be interested in