Skip to main content

Coutts Bankline - Bulk

Coutts Bankline - Bulk

Caution! This information is provided for example only, you must confirm the details when passing it to BACS software.

Bankline allows your business to manage everyday banking over the internet, including the ability to make domestic and international payments. Bankline extends that payment functionality to enable you to import your payment instructions from a file, rather than manually keying them in Bankline.

The records in the file must be in a Comma Separated Value (CSV) text file format. A preceding comma before the first field is not required to define the start of the record, and likewise, a trailing comma is not required after the final field to define the end of the record.

Multiple records can be imported in a single import file, except for the following restrictions on possible combinations:

  • templates cannot be mixed in a file with anything other than other templates

  • payments from a template must reference an existing Bankline template

  • Bulk lists cannot be mixed in a file with anything other than other bulk lists

  • bulk payments must reference an existing Bankline bulk list

  • there can only be one bulk payment in any one file (i.e. a single debit and one or more credits)

Unless specified, if a field is populated with a valid value it does not need to be padded with leading or trailing spaces to reach the full character length for the field.

Coutts Bankline Bulk format

This shows how to format a record for a Coutts Bankline Bulk list payment with a single beneficiary.

Ad Hoc Bulk Payment Debit

Field

Value

Field

Value

Field

Value

Field

Value

Field

Value

H001

T015

T032

T049

T066

H002

EMPLOYEEBACSEXPORT.TXT

T016

27072012

T033

T050

T067

H003

T017

T034

BANKLINENAME

T051

T068

T001

08

T018

T035

T052

T069

T002

T019

T036

T053

T070

T003

T020

T037

T054

T071

T004

N

T021

T038

T055

T072

T005

T022

T039

T056

T073

T006

EMPLOYEEBACSEXPO

T023

T040

T057

T074

T007

T024

T041

T058

T075

T008

N

T025

T042

T059

T076

T009

T026

T043

T060

T077

T010

18000201806542

T027

T044

T061

T078

T011

T028

T045

T062

T079

T012

T029

T046

T063

T080

T013

T030

T047

T064

T081

T014

T031

T048

T065

T082

Example

,EMPLOYEEBACSEXPORT.TXT,08,,N,EMPLOYEEBACSEXPO,N,18000201806542,,,,,27072012,,,,,,,,,,,,,,,,,BANKLINENAME,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Note: The information in the Company Details Account Reference field is used in the Customer Payment Reference (T006) and Beneficiary Reference (T034) when using the Coutts Bankline Bulk BACS Export Format.

H002 (Import File Name) - This is an optional field. This field identifies the name of the import file, and is free format. If left blank it defaults to the import file name.

T001 (Record Type) - This is a mandatory field. The value '08' identifies the payment type as 'ad hoc payment debit'.

T004 (Confidential Indicator) - This is an optional field. This field identifies whether a new bulk list is to be marked as confidential. Values are 'Y' or 'N'. If left blank, this defaults to 'N'.

T006 (Customer Payment Reference) - This is an optional field. This field identifies the payment as it will be known to the remitter. This is a free format field with a 16 character limit. If left blank, it defaults to the first 16 characters of the import file name.

T008 (Priority) - This is an optional field. This field is used to identify standard domestic payments from Inter Account Transfers. Values are 'U' (Inter Account Transfer) and 'N' (Standard Domestic). When left blank, this defaults to 'N'.

T010 (Debit Account Identifier) - This is a mandatory field. The value 18000201806542 is a UK Sterling account with a sort code of 18-00-02 and account number 01806542. No dashes or spaces are required. The debit account must be a valid account as registered to that customer in Bankline.

T016 (Date Payment to Arrive/Credit Date) - This is mandatory field. Values must be in the format ddmmyyyy. The value 27072012 equates to 27th July 2012.

T034 (Beneficiary Reference) - This is an optional field. This identifies the payment as it will be known to the beneficiary. This is a free format field. If left blank, this will default to the debit account name as held in Bankline.

T071 (Remittance Advice Indicator) - This is an optional field. This identifies where there is a remittance advice associated with the payment. Values are 'C' (Remittance advice) or blank (no remittance advice).

Did this answer your question?