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).
