File formats for Sage Payroll e-Banking files

Summary

This article explains the content of the e-banking file produced by Sage 50 Payroll and Sage Instant Payroll for each bank.

Description

To ensure that you have the latest version of your e-Banking component, you can download the latest component from our website at sage.co.uk/ebanking

Resolution

Choose your bank

Banking software	Adam Online
Required component	Adam Online
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Not required

Payment file format

The format of the payment file is slightly different, depending on the options selected in the Sage Adam Internet Bankline Payment Processing window. If you select Standard Domestic/IATs, the payment file takes the following format:

Choose your banking software

Banking software	iBusiness Banking (iBB)
Required component	Allied Irish iBB
E-payments file type	Text file (*.TXT)

NOTE: When you import the file into iBB, you must choose APACS from the File Format drop-down list and not Sage.

View screenshotnull;null;ss1

Payment file format

NOTE: This service is no longer available. Please refer to Allied Irish Bank (AIB) on 0870 253 0312.

Banking software	Bank of America
Required component	Bank of America
E-payments file type	Text file (*.TXT)

Payment file format

Banking software	Business On Line
Required component	Bank of Ireland Business On Line
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Not required

Payment file format

Banking software	Bottomline Technologies limited
Required component	Bottomline Technologies limited
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Yes

NOTE: To include the BACS Hash, your employees' Payment Method must be set to Direct BACS before you update records. Without the BACS Hash, your exported file won't be accepted by Bottomline Technologies limited. Read more >

Payment file format

Banking software	Corporate Online (CO) TIP: Formerly known as Corporate Internet Banking (CIB) or CHOBS
Required component	Bank of Scotland CHOBS
E-payments file type	The e-payments file format depends on whether BACS or CHOBS is selected during the e-payments process. BACS - text file (.TXT) - Referred to as COL Bacs* on the HBOS website. CHOBS - comma separated file (.CSV) - Referred to as COL CSV* on th HBOS website.
RTI BACS Hash Sub-Reference	Not required

Payment file format

BACS (COL BACS)null;null;Step1

CHOBS (COL CSV)null;null;Step2

Choose your banking software

Banking software	Business Internet Banking Business Master Business Master Lite
Required component	Barclays Business Master II
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Not required

Payment file format

Banking software	OnLine Banking
Required component	Barclays Online Banking
E-payments file type	N/A

You cannot process e-payments with Barclays OnLine Banking.

Banking software	Barclays.Net
Required component	Barclays Business Master II
E-payments file type	Comma separated file (*.CSV)

NOTE: There is no specific plug-in for Barclays.Net, however the Barclays Business Master II plug-in is compatible with this software. This is the Barclays BusinessMaster option on the website.

Payment file format

Choose your banking software

Banking software	Clydesdale / Yorkshire Bank - Business Online
Required component	Clydesdale / Yorkshire BACS Cr
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Yes

NOTE: Telebank is no longer supported by Clydesdale or Yorkshire bank.

Payment file format

Banking software	Clydesdale / Yorkshire Bank - Faster Payment - EFT Service
Required component	Clydesdale / Yorkshire EFT
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Not required

NOTE: Telebank is no longer supported by Clydesdale or Yorkshire bank.

Payment file format

Banking software	Financial Director
Required component	Cooperative Bank Financial Director
E-payments file type	Comma separated file (*.CSV)

Payment file format

Banking software	Coutts Online
Required component	Coutts Online
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Not required

Payment file format

The format of the payment file is slightly different, depending on the options selected in the Sage Coutts Internet Bankline Payment Processing window. If you select Standard Domestic/IATs, the payment file takes the following format:

Banking software	iBusiness banking (iBB)
Required component	Allied Irish iBB
E-payments file type	Text file (*.TXT)

NOTE: When you import the file into iBB, you must choose APACS from the File Format drop-down list and not Sage.

View screenshotnull;null;ss38

Payment file format

Banking software	HSBCNet
Required component	HSBC Net
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Yes

Payment file format

NOTE: If you enter an OIN number in the Payment Processing window, the text SAGE does not appear in the payment file.

Banking software	J P Morgan Access
Required component	J P Morgan Access
E-payments file type	Text file (*.TXT)

Payment file format

NOTE: If you enter an OIN number in the Payment Processing window, the text SAGE does not appear in the payment file.

Choose your banking software:

Lloyds Link

Banking software	LloydsLink
Required component	LloydsLink
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Not required

Payment file format

Lloyds Bank Commercial Banking Online

Banking software	Lloyds Bank Commercial Banking Online
Required component	Lloyds Bank Commercial Banking Online
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Not required

Payment file format

Banking software	TSB Online for Business
Required component	Online for Business
E-payments file type	N/A

You cannot process e-payments with TSB Online for Business.

Banking software	Business EBanking
Required component	National Irish Bank
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Not required

Payment file format

The payment file format is different, depending on the option you select:

Payment 1 To 1 Format null;null;121a

Business eBanking BACS ID Format null;null;BACSIDa

Choose your banking software

NOTE: If the customer isn't using the latest RBS/NatWest Internet Bankline component, the following message may appear when they try to upload their TXT file to their bank:

'Rejected ? Beneficiary for record (56) not found or not active.'

To resolve this, please install the latest version of the RBS/NatWest Internet Bankline component from sage.co.uk/ebanking.

Banking software	RBS / NatWest Internet Bankline
Required component	RBS / NatWest Internet Bankline
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Not required

Payment file format

The format of the payment file is slightly different, depending on the options selected in the Sage RBS/NatWest Internet Bankline Payment Processing window.

Standard Domestic/IATs null;null;SDIAT2

Use a Template for Domestic/IAT null;null;Template2

Bulk List Payments null;null;Bulk2

Ad Hoc Bulk Payments null;null;AdHoc2

Banking software	Online Banking
Required component	NatWest Online
E-payments file type	N/A

You cannot process e-payments with NatWest Online Banking.

Banking software	Payaway
Required component	NatWest Bankline - PayAway
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Yes

Payment file format

Banking software	Business EBanking
Required component	Danske Bank (formerly Northern Bank)
E-payments file type	Comma separated file (*.CSV)

Payment file format

The payment file format is different, depending on the option you select:

NOTE: If you use the Collector of Taxes Wizard to pay HMRC, you currently can't use the Payment 1 to 1 Format. The file is produced in the wrong format and will fail if you try to upload it to Danske Bank. To pay HMRC, please process the payment manually.

Payment 1 To 1 Format null;null;121b

Business eBanking BACS ID Format null;null;BACSIDb

Choose your banking software

NOTE: If the customer isn't using the latest RBS/NatWest Internet Bankline component, the following message may appear when they try to upload their TXT file to their bank:

'Rejected ? Beneficiary for record (56) not found or not active.'

To resolve this, please install the latest version of the RBS/NatWest Internet Bankline component from sage.co.uk/ebanking.

Banking software	RBS / NatWest Internet Bankline
Required component	RBS / NatWest Internet Bankline
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Not required

Payment file format

The format of the payment file is slightly different, depending on the options selected in the Sage RBS/NatWest Internet Bankline Payment Processing window.

Standard Domestic/IATs null;null;SDIAT

Use a Template for Domestic/IAT null;null;Template

Bulk List Payments null;null;Bulk

Ad Hoc Bulk Payments null;null;AdHoc

Banking software	Digital Banking
Required component	RBS Internet Banking
E-payments file type	N/A

You cannot process e-payments with Digital Banking.

Banking software	Santander MyBusinessBank / Santander Connect
Required component	Santander
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Not required

Payment file format

Choose your banking software

Banking software	Ulster Bankline Money Transfer
Required component	Ulster Bank Anytime
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Not required

Payment file format

Banking software	Bankline
Required component	Ulster Bank Bankline
E-payments file type	Text file (*.TXT)
RTI BACS Hash Sub-Reference	Not required

Payment file format

The format of the payment file is slightly different, depending on the options selected in the Sage Sage Ulster Bank Bankline Payment Processing window. If you select Standard Domestic/IATs, the payment file takes the following format:

Choose your banking software

Banking software	Clydesdale / Yorkshire Bank - Business Online
Required component	Clydesdale / Yorkshire BACS Cr
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Yes

NOTE: Telebank is no longer supported by Clydesdale or Yorkshire bank.

Payment file format

Banking software	Clydesdale / Yorkshire Bank - Faster Payment - EFT Service
Required component	Clydesdale / Yorkshire EFT
E-payments file type	Comma separated file (*.CSV)

NOTE: Telebank is no longer supported by Clydesdale or Yorkshire bank.

File formats for Sage Payroll e-Banking files

Summary

Description

Resolution

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

Payment file format

SUPPORT & TRAINING

PARTNERS

COMPANY

FAQs