Sage 200 - List of e-Banking components and example file formats for Sage 200

Summary

To ensure you are using the latest version of the component, you should download the latest version from our website

Description

This article should be used in conjunction with our guide on How to set up and use e-Banking, and gives information on the file produced by each supported banking component.

To ensure you are using the latest version of the component, you should download the latest version from our website, available here.

Not all supported components are available for selection in Sage 200 immediately after installation. If the service you wish to use is not available from the drop-down list in the Cash Book record, you should use the above link to download the required component. You must close Sage 200 prior to installation.

Resolution

Choose your bank

Choose your bank from the drop-down menu below then, if required, choose the specific bank software you have. The information displayed underneath will give you the e-payments file type/extension you will need for the Payment File Options, when configuring the File Locations, during the set-up of e-banking in your Sage 200 application.

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

This is an example of the file format produced by Sage, for the selected banking software, and the required information it includes.

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	N/A

Bank of America is not compatible with Sage 200.

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	Corporate Online (CO) Tip: Formerly known as Corporate Internet Banking (CIB) or CHOBS
Required component	Corporate Online (CO)
E-payments file type	*.CSV
RTI BACS Hash Sub-Reference	Not required

Payment file format

BACS (COL BACS)null;null;Step1

CHOBS (COL CSV)null;null;Step2

Commercial Banking Onlinenull;null;Step3

Choose your banking software

Banking software	Business Internet Banking Business Master Business Master Lite Barclays.Net
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.

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	N/A

J P Morgan Access is not compatible with Sage 200.

Choose your banking software

NOTE: Lloyds are migrating to a new platform which means the file formats from this component no longer work. However, Lloyds are issuing an import map for customers to manipulate the files into a format compatible with their system.

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

Payment file format

Banking software	Lloyds Commercial
Required component	Lloyds Commercial
E-payments file type	Comma separated file (*.CSV)

Payment file format

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

This is an example of the file format produced by Sage, for the selected banking software, and the required information it includes.

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

Payment 1 To 1 Formatnull;null;121a

Business eBanking BACS ID Formatnull;null;BACSIDa

Choose your banking software

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/IATsnull;null;SDIAT2

Use a Template for Domestic/IATnull;null;Template2

Bulk List Paymentsnull;null;Bulk2

Ad Hoc Bulk Paymentsnull;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	Autopay Online
Required component	Natwest Autopay Online Plus
E-payments file type	Comma separated file (*.CSV)
RTI BACS Hash Sub-Reference	Yes

Payment file format

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

Payment file format

This is an example of the file format produced by Sage, for the selected banking software, and the required information it includes.

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

Payment 1 To 1 Formatnull;null;121b

Business eBanking BACS ID Formatnull;null;BACSIDb

Choose your banking software

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/IATsnull;null;SDIAT

Use a Template for Domestic/IATnull;null;Template

Bulk List Paymentsnull;null;Bulk

Ad Hoc Bulk Paymentsnull;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 Connect
Required component	Santander
E-payments file type	Comma separated file (*.CSV)
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.

Payment file format

Upgrading your licence

Need a little more room? To add extra companies, users, employees, or more to your software licence, leave your details and we'll be in touch.

Leave your details

Sage 200 - List of e-Banking components and example file formats for Sage 200

Summary

Description

Resolution

Choose your bank

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