Supported payment file formats

A bank file is an electronic file that's used by banks to make multiple payments. Sage Intacct supports the following countries and file formats for bank file payments.

Australia

Bank File format File type Notes

ANZ

ABA - ANZ

.aba

-

Commonwealth

ABA - Commonwealth

.aba

-

Generic

  • Generic ABA with balancing entry

  • Generic ABA without balancing entry

.aba

-

National Australia Bank

ABA - NAB

.aba

-

Westpac

ABA - Westpac

.aba

-

Canada

Bank File format File type Notes

ATB Financial

ATB - 1464 byte

.txt

-

Bank of Montreal

BMO - 1464 byte

.txt

-

Central One Credit Union

Central One Credit Union - 1464 byte

.txt

-

CIBC

CIBC - 1464 byte

.dat

-

Desjardin Bank

Desjardins - 1464 byte

.txt

-

National Bank

National Bank - 1464 byte

.txt

-

Royal Bank of Canada

  • RBC - 1464 byte

  • RBC HSBC - 1464 byte

.txt

-

Scotiabank

BNS Scotiabank - 1464 byte

.txt

-

TD Bank

TD Bank - 1464 byte

.txt

-

France

Bank File format File type Notes

Generic

  • Generic - SEPA

  • Generic - SEPA incl Debtor name

.xml

-

HSBC

SEPA

.xml

-

Ireland

Bank File format File type Notes

Generic

Generic SEPA

.xml

-

Bank of Ireland

BOI - SEPA

.xml

-

HSBC

SEPA

.xml

-

South Africa

Bank File name File type Notes

ABSA

ABSA BI Online Unconsolidated

  • Matched

  • Unmatched

.txt

BI Online

NedBank

NedBank

  • CSV

  • CSV Secure

.csv

CSV Secure

Standard Bank

Standard Bank

  • NAMPAY BEFT

  • NAMPAY SSVS

  • NAMPAY SSVS Pre Format

Use the NAMPAY SSVS Pre Format file to enter a creditor code instead of the homing account name and number.

.txt

  • BEFT

  • Nampay

First National Bank

FNB

  • Online Banking

  • Online Banking csv

.fil

.cvs

BankServ (ACB)

United Kingdom

Bank File format File type Notes

Barclays

  • BACS - Barclays.net

  • BACS - BarclaysNet Payment Ref

.csv

.txt

Barclays.net: Reference field will use a incremental number generated by Sage Intacct.

HSBC

  • BACS HSBC

  • HSBC - SEPA

.txt

.xml

Bacs standard 18 for AUDDIS

Reference field will use a incremental number generated by Sage Intacct.

Lloyds

  • BACS - Lloyds

  • BACS - Lloyds, single debit

  • Lloyds Bank - FP

.csv

Lloyds Bank Commercial Banking Online

Use the FP file format for faster payments.

Natwest

  • BACS - NatwestBankLine

  • RBS Natwest Banline - Ad Hoc bulk payment

.csv

Autopay Online

Natwest RBC

BACS - NatwestRBS

.csv

RBS

-

BACS - COOP bulk payments

.txt

-

Santander

  • BACS - Santander

  • Santander - Standard format

.txt

Santander Connect

Virgin Bank

FP - Virgin Bank

.csv

-

Generic

Generic SEPA

.xml

Select this file for UK bank accounts that transact in EUR currency.

United States ACH

Bank File format File type Notes

Generic

NACHA 

  • Balanced

  • Balanced with EOF marker

  • Balanced with EOF marker incl ID number

  • Balanced without EOF marker

  • Balanced without EOF marker incl ID number

  • Single balanced without EOF marker

  • Unbalanced

  • Unbalanced with EOF marker

  • Unbalanced with EOF marker incl ID number

  • Unbalanced without EOF marker

  • Unbalanced without EOF marker incl ID number

  • Single balanced without EOF marker

.txt

Balanced: Entries are balanced per transaction

Single balanced: Grouped by date and SEC code for balancing entries.