This information is provided for guidance only; you should always confirm the details before passing the file to BACS software.

The following notations are used to describe the field types and their length, unless otherwise stated.

Note: These are only abbreviations used later within this document and are not themselves a definition of field formats.

Exporting of data is provided to allow Service Users to import posting and balance summaries into other applications. The export process is applicable to posted transactions created by the following accounts types as used by Corporate Online.

Data can be exported from a number of screens, the format available for download is dependent upon which screen / information is being downloaded:

A single account can be downloaded from the View Account Balance and Statement screens. Multiple sterling accounts can be downloaded from the Sterling Report and Account Group Download screens.

Multiple international accounts can only be downloaded from the International Report screen.

The export operation is initiated by clicking the download button. Where a COL CSV file is available only, you will be asked to save the file to your pc. Where there is a choice offering different types of download file, you will be asked to enter a filename and choose what kind of file is required.

The format of each kind of file and information downloaded are dependent upon which screen within Corporate Online is used.

STERLING ACCOUNT Sample File

Deposit,EARL GREY DEVELOPMENTS TEST,80999906008504,"0.48 GBP","01/01/2011","0.00 GBP","0.00 GBP","0.48 GBP","0.00 GBP","0.48 GBP","0.48 GBP","0.00 GBP","0.48 GBP","0.00 GBP","0.48 GBP","0.00 GBP","0.48 GBP","0.00 GBP","0.48 GBP","0.00 GBP","0.48 GBP"

The format of this file for a Sterling account is:

Note: If user preferences are set to display amounts in Euro, then both the Sterling value and Euro equivalent will be downloaded.

INTERNATIONAL ACCOUNT Sample File ( currency with a 10 digit account number)

International,Customer Currency(Current) Acc,99999USD01,"-167.07 USD","-185.07 USD","-211.07 USD","-232.07 USD","-232.07 USD","-232.07 USD","-232.07 USD","01/01/2011"

Sample File (currency with a sort code and account number)

International,Customer Currency(Current) Acc, 12345612345678,"-167.07 USD","-185.07 USD","-211.07 USD","-232.07 USD","-232.07 USD","-232.07 USD","-232.07 USD","01/01/2011"

The format of this file for an International Account is:

Only the COL format is available on the Account Group Download screen (ACC or TRN file). A Service User may export historic balance information and transaction information for UK and International accounts.

A Service User may export information for a single account or for all accounts within the same group. The Service User may select the file name and type for the export (ACC for account balances, and TRN for Account Transactions).

File extensions are:

COL format files are ASCII files. All fields are separated by commas. All fields are enclosed in quotations, including numbers. If a text field contains a quotation mark, then the quotation mark is replaced by two adjacent quotation marks.

All balance fields are signed. If they are negative, the amount is preceded by a minus sign. No plus sign is used for positive balances.

The transaction amount is not signed, but an indicator is used to show if the transaction type is either D (Debit) or C (Credit).

STERLING ACCOUNT POSITION files hold details of historic balances for a UK accounts. The format of all amounts is Amount(18).99 These include projected balance as well as credit and debits. Notice the fixed decimal notation '.' zero amounts will be presented by a fixed length number “0.00”. The string will be padded with leading spaces.

"123456","012346578901","Mr. Smith's Account",,"20110101","44.69",,,,,," 184488.69"," 184488.69"<CR><LF>

"19960925"," 86.00","BGC","003747","D","F","121257","02561237"<CR><LF>

CURRENCY ACCOUNT POSITION files hold details of historic balances for International accounts.

Note: All amounts values have V Z(16).XXX where XXX is the number of decimal points used in the currency.

Refer to this table if your currency account contains 10 digits.

"International Account1","02013","USD","01","","20110101"," 13611.191",,,,,,"157.063"," 39.193"<CR><LF>

Refer to this table if your currency account contains a sort code and account number.

"International Account1","123456","12345678","","20110101","13611.11",,,,,"157.063","39.193"<CR><LF>

CURRENCY ACCOUNT TRANSACTION files hold details of account movements for International accounts. Currency account transactions are only produced for posted transactions.

Note: All amounts values have F Amount(16).XXX where XXX is the number of decimal points used in the currency.

Refer to this table if your currency account contains a sort code and account number.

"20110101","674635.0000","G384532396",,"DBT","F",20110101","123456","12345678"<CR><LF>

Refer to this table if your currency account contains 10 digits.

"20110101","67435.0000","G384532396",,"DBT","F","20110101","02013","USD","04"<CR><LF>

Refer to this table if your currency account contains a sort code and account number.

BAI format is defined by Bank Administration Institute. The version defined here is the interpretation used by Bank of Scotland. BAI is a delimited ASCII format. Under Bank of Scotland's implementation, each file will be an ASCII sequential file with a fixed record length of 80 characters.

A BAI export may only be performed on a single account. A date range must be supplied.

The BAI format defines a file of data with the following record structure:

File Header

Group Header (for each day's data)

Account Header (for each account for the given day, includes balance)

Transaction Details (for each transaction item for the given account on given day)

Account Trailer

Group Trailer

File Trailer

A record consists of a two byte record type followed by a number of fields. Each field is separated by a comma. With only one exception, the end of the last field in a record is indicated by a forward slash</>. As the record is fixed length, space padding is applied to the record so that it occupies the full 80 characters. The record is then terminated with a <CR><LF> pair (making the total length 82 characters).

The exception is when the record is a continuation record and the last field is a string. In this case the field itself is space padded so that the record occupies the full 80 character length. The record is then terminated with a <CR><LF> pair.

The BAI file is terminated by a <CONTROL-Z>.

A list of record types is given below:

Every field is an ASCII presentation of string or number. Strings are NOT embedded in quotes. All fields are of variable length. (Note: for clarity, examples given in this document don't show all 80 characters as many are likely to be empty.)

File Header Format (01)

Only one file header record will appear in each exported file. The format of the record will be:

01,s-id,r-id,c-date,c-time,file-id,rec-len,blk-size,version/

The first line displays character positions, the second line shows an example format.

12345678901234567890123456789012345678901234567890123456789012345678901234567890

01, corpline1,abcdefghijk02,110101,1642,3,80,1,2/

Character 81 = <CR>, 82 = <LF>

Group Header Format (02)

One group header will appear for each day of exported data. The format of the record will be:

02,r-id,o-id,status,a-date,a-time,curr,modifier/

The first line displays character positions, the second line shows an example format.

02,abcdefghijk02, corpline1,1,110101 ,2400,GBP,2/

Character 81 = <CR>, 82 = <LF>

Account Header (03)

An account header, recording balance information, is included for each account written to the file. Three records are used to hold the account header one prefixed with the account header identifier, and two continuation records. The formats of the records are: –

03,ac-no,curr,tc1,am1,,,tc2,am2,,,tc3,am3,,,tc4,am4,ic4/

88,tc5,am5,ic5,/

88,tc6,am6,,,tc7,am7,,/

Notes:
1. Account Headers end with the ic5 field (i.e. fields tc6 onwards are omitted).
2. The number of decimal places for an amount field is implied by the currency.

Transaction type codes are always present in all records even when its corresponding amount is zero. Such amounts
are always set to zero. This ensures that the field is never empty.

The first line displays character positions, the second line shows an example format.

Sterling Account Example:

03,000100021113,GBP,015,11278477,,,045,11278477,,,040,11278477,,/

88,400,4213365,14,,100,188448869,6,/

88,072,0,,,074,0,,/

Currency Account Example:

03,00609 USD 01,USD,015,-3460,,,045,-3460,,,040,-3460,,/
88,400,0,0,,100,6632,43,/
For each record character 81 = <CR>, 82 = <LF> –

Transaction Details

A transaction details record is included for each transaction for the account specified by the account header for the date specified by the group header. The formats of the records are:

16,tc,amount,f-type,v-date,,,/
88,d...d/

Note: All currency account balance and transaction amounts are being displayed multiplied by a factor of 100 e.g a transaction / balance of 0.01 will export as 100 and not as 1.

The first line displays character positions, the second line shows an example format.

For a currency credit transaction:

16,399,123456789012345678,V,110101,,,/

88,Currency transaction: transaction narrative

Sterling debit transaction:

16,699,123456789012345678,0,,,,/

88,Sterling transactions : transaction narrative

For each record character 81 = <CR>, 82 = <LF> –

Note: There is always a space before and after the colon in the description field.

Account Trailer

The format of this record is: 49,tot-amnt,no-rec/

The first line displays character positions, the second line shows an example format.

49,92539296,126/

For this record character 81 = <CR>, 82 = <LF> –

Group Trailer

The format of this record is:

98,tot-amnt,no-acs,no-rec/

The first line displays character positions, the second line shows an example format.

98,7728504576,61,237/

For this record character 81 = <CR>, 82 = <LF> –

File Trailer

The format of this record is:

99,tot-amnt,no-gps,no-rec/

The first line displays character positions, the second line shows an example format.

99,7728504576,1,239/

For this record character 81 = <CR>, 82 = <LF> –

This download file is designed for use in a spreadsheet or similar application.

Each account within the report will have seventeen fields of data downloaded. After the account data there
are then two blank lines of space, and all the fields are totalled up.

Each account reported will show the following fields:

This download file is designed for use in a spreadsheet or similar application.

Each account within the report will have nine fields of data downloaded. After the account data there are then
two blank lines of space, and all Sterling Equivalent balance fields are totalled up.

Each account reported will show the following fields:

This download file is designed for use in a spreadsheet or similar application.

Each entry within the report will have five fields of data downloaded.

Each audit log entry reported will show the following fields:

This download file is designed for use in a spreadsheet or similar application.

Each entry within the report will have nine fields of data downloaded.

Each audit log entry reported will show the following fields:

Payment instructions may be imported from ASCII format files.

1) COL:

In COL format one input file can contain the following record types:
Inter Account Funds Transfer (Sterling and Currency) Domestic Payments, CHAPS, International Payments, Faster Payments.

2) BACS:

Bacs format is used for Bacs Direct only.

Notes: International Drafts, International Payments with Live Rates and Foreign Exchange transfers cannot be imported

A check will be made of the overall file. If any file error is encountered, then processing is stopped and an on-screen message will be displayed.

Payments are not directly created from the import file, instead a template is created and payments may be generated from the template. –

If errors are present in the import file, a template may still successfully be created.

In order to create a payment instruction within the system the Service User must have the appropriate facility to process the instruction type, qualified by the account.

However, as a template is created by the import file, these limits and facilities are not checked until the user tries to convert the template to payments.

The Service User must also be allowed to 'Administer Beneficiaries'.

When the import function is selected, the Service User is presented with a file open dialogue which is used to specify the file to be imported. The system then reads the selected file, and validates its contents as described in the following section:

If the file is valid, then the payments are imported into Corporate Online and a message informs the user of completion.

The COL file is an ASCII format, comma delimited file. The following rules apply to the file:

The file consists of a header record, a number of instruction records and a trailer record.

Fields (both alpha or numeric) can be enclosed in double quotation marks (double quotes). Within a character string which is enclosed in double quotes, two adjacent double quotes are interpreted as one double quote to be included within the input field (and not as the double quote that terminates the character string).

Examples of valid input text strings are in the following table:

The following default field values are applied:

File Header

The format for the file header record is:

"HEA","filename"

Sterling Inter Account Funds Transfer This record holds details of a transfer between Sterling accounts. –

Notes:
1 Debit Sort Code and Debit A/C Number must match a valid account in the system.
2 Credit Sort Code and Credit A/C Number must match a valid account in the system.

"STE","123456","00080914","120103","00107446","1.01","01JAN11","Transfer No 123A"

Currency Inter Account Funds Transfer This record holds details of a transfer between Currency accounts. –

Notes:
1 The Currency Debit A/C Number must match a valid account in the system.
2 The Currency Credit A/C Number must match a valid account in the system.
3 The decimal place is implied by the currency.

"CUR","01234USD03","01234USD02",12345,"01JAN11","Transfer No 123A"

Normal Domestic Payments Value This record holds details of a Domestic Payment. The object mapping column shows the NDP object attributes that are populated by the record. –

"NDP",012345,01234567,012345,01234567,0123,"Beneficiary","Reference","01JAN11"

Faster Payments Service Value This record holds details of a Faster Payment. The object mapping column shows the FPS object attributes that are populated by the record. –

Notes: 1 Debit Sort Code and Debit A/C Number must match a valid account in the system.

"FPS",012345,01234567,012345,01234567,0123,"Beneficiary","Reference","01JAN11"

CHAPS This record holds details of a CHAPS Payment. The object mapping column shows the CHAPS object
Attributes that are populated by the record. –