RBS BankLine BACS
This is a standard text (ASCII) file, with a header, a trailer and field separators. It contains fixed length BACS standard fields separated by groupings of commas. Each BACS record is terminated by a carriage return or line feed. The maximum number of payments that can be contained within an import file is 4000. If there are more than 4000 payments then multiple BACS export files should be created.
Note: All text must be in upper case.
This information is provided for guidance only; you should always confirm the details before passing the file to BACS software.
Field
|
Description
|
Length / Format
|
Example field
|
Header
|
Comma group
|
‘,’ x 3
|
,,,
|
Payment Type
|
01=BACS
|
Must be ‘01’ for BACS file
|
01
|
Separator
|
Comma group
|
‘,’ x 5
|
,,,,,
|
Company Reference
|
BACS reference of the company
|
COMPANYREFERENCE
| |
Separator
|
Comma group
|
‘,’ x 4
|
,,,,
|
Debit Sort Code & Account
|
Sort Code & Account Number of the debited account
|
6 digit sort + 8 digit account number (no space)
|
00000011111111
|
Separator
|
Comma group
|
‘,’ x 4
|
,,,,
|
Value
|
Transaction amount
|
Formatted ‘0.00’
|
25.50
|
Separator
|
Comma group
|
‘,’ x 2
|
,,
|
Credit Date
|
Date of Transaction
|
Formatted ‘DDMMYYYY’
|
25042006
|
Separator
|
Comma group
|
‘,’ x 6
|
,,,,,,
|
Credit Sort Code
|
Sort Code of the credited account
|
6 digit sort code
|
123456
|
Separator
|
Comma group
|
‘,’ x6
|
,,,,,,
|
Credit Account Number
|
Account number of the credited account
|
8 digit account number
|
12345678
|
Separator
|
Comma group
|
‘,’ x 2
|
,,
|
Beneficiary Name
|
Name of the beneficiary
|
Any comma’s removed
|
MR J SMITH
|
Separator
|
Comma group
|
‘,’ x 4
|
,,,,
|
Beneficiary Reference
|
BACS reference of the beneficiary
|
Any comma’s removed
|
JSMITH01
|
Trailer
|
Comma group
|
‘,’ x 43
|
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
|