Specification for BEERS (V24) May 2009
BANK OF ENGLAND
ELECTRONIC REPORTING SYSTEM
BEERS
TECHNICAL SPECIFICATION
VERSION 24
Issued May 2009
www.bankofengland.co.uk/statistics/reporters/electronic/index.htm
For further information or clarification, please contact:
Data Reception Help Desk 020-7601 5360
Analytical:6095996v1
Specification for BEERS (V24) May 2009
1 INTRODUCTION ............................................................................................6
2 ALL FORM TYPES.........................................................................................7
2.1 FILENAMES AND FORM CODES 7
2.2 HEADER RECORDS AND SECTION CODES 7
3 3D FORM TYPES ...........................................................................................8
3.1 DATA HEADER RECORD 8
3.2 DATA RECORDS 9
3.3 TEXT HEADER RECORDS AND TEXT RECORDS 10
4 4D FORM TYPES .........................................................................................11
4.1 COUNTRY CODES 12
4.1.1 AREA BREAKDOWN CODES .............................................................................................. 12
4.2 DATA HEADER RECORD 13
4.3 DATA RECORDS 13
5 MIXED 3D AND 4D FORMS.........................................................................14
5.1 DATA HEADER RECORD 15
6 EXAMPLES OF FORMS ORDERED BY FORM NAME...............................16
6.1 ANALYSIS OF DEPOSITS FROM UK RESIDENTS (FORM AD) 16
6.1.1 SAMPLE AD............................................................................................................................ 16
6.2 ANALYSIS OF LENDING TO UK RESIDENTS (FORM AL) – UNTIL SEPTEMBER
2007 17
6.2.1 SAMPLE AL ............................................................................................................................ 17
6.3 ANALYSIS OF LENDING TO UK RESIDENTS (FORM AL) – FROM DECEMBER 2007
20
6.3.1 SAMPLE AL ............................................................................................................................ 20
6.4 ADDITIONAL SECTORAL DETAIL (FORM BE) – UNTIL SEPTEMBER 2007 21
6.4.1 SAMPLE BE ............................................................................................................................ 22
6.5 ADDITIONAL SECTORAL DETAIL (FORM BE) – FROM OCTOBER 2007 22
6.5.1 SAMPLE BE ............................................................................................................................ 23
6.6 TRANSACTIONS WITH NON-RESIDENTS: INTEREST DIVIDENDS AND OTHER
INCOME BY GEOGRAPHICAL LOCATION (FORM BG) 23
6.6.1 SAMPLE BG............................................................................................................................ 24
-2-
Specification for BEERS (V24) May 2009
6.7 BALANCE SHEET (FORM BT) – UNTIL SEPTEMBER 2007 25
6.7.1 SAMPLE BT ............................................................................................................................ 25
6.8 BALANCE SHEET (FORM BT) – FROM OCTOBER 2007 UNTIL DECEMBER 2008 28
6.8.1 SAMPLE BT ............................................................................................................................ 28
6.9 BALANCE SHEET (FORM BT) – FROM JANUARY 2009 30
6.9.1 SAMPLE BT ............................................................................................................................ 30
6.10 UK REGISTERED INSTITUTIONS COUNTRY EXPOSURE REPORT (FORM C1) 33
6.10.1 SAMPLE C1............................................................................................................................. 33
6.11 CURRENCY ANALYSIS OF LIABILITIES AND CLAIMS IN CURRENCIES OTHER
THAN STERLING (FORM CA) – UNTIL SEPTEMBER 2007 35
6.11.1 SAMPLE CA............................................................................................................................ 35
6.12 CURRENCY ANALYSIS OF LIABILITIES AND CLAIMS IN CURRENCIES OTHER
THAN STERLING (FORM CA) – FROM DECEMBER 2007 36
6.12.1 SAMPLE CA............................................................................................................................ 36
6.13 COUNTRY ANALYSIS OF UK EXTERNAL CLAIMS (FORM CC) – UNTIL
SEPTEMBER 2007 37
6.13.1 SAMPLE CC ............................................................................................................................ 37
6.13.2 SAMPLE CO (Part B) .............................................................................................................. 39
6.14 COUNTRY ANALYSIS OF UK EXTERNAL CLAIMS (FORM CC) – FROM
DECEMBER 2007 40
6.14.1 SAMPLE CC ............................................................................................................................ 40
6.14.2 SAMPLE CO (Parts B and C) .................................................................................................. 42
6.15 UK-OWNED BANKING GROUPS EXPOSURE REPORT (FORM CE) 43
6.15.1 SAMPLE CE ............................................................................................................................ 43
6.16 COUNTRY ANALYSIS OF UK EXTERNAL LIABILITIES (FORM CL) – UNTIL
SEPTEMBER 2007 45
6.16.1 SAMPLE CL ............................................................................................................................ 45
6.16.2 SAMPLE CS............................................................................................................................. 46
6.17 COUNTRY ANALYSIS OF UK EXTERNAL LIABILITIES (FORM CL) – FROM
DECEMBER 2007 47
6.17.1 SAMPLE CL ............................................................................................................................ 47
6.17.2 SAMPLE CS............................................................................................................................. 48
6.18 CAPITAL EXPENDITURE AND FINANCE LEASING DATA (FORM CX) – FROM
DECEMBER 2007 49
6.18.1 SAMPLE CX............................................................................................................................ 49
6.19 TOTAL DERIVATIVES BUSINESS IN BANKS’ TRADING AND BANKING BOOKS
(FORM DQ) – UNTIL SEPTEMBER 2007 50
6.19.1 SAMPLE DQ............................................................................................................................ 50
6.19.2 SAMPLE DR............................................................................................................................ 51
6.19.3 SAMPLE DS ............................................................................................................................ 55
6.19.4 SAMPLE DT ............................................................................................................................ 56
6.19.5 SAMPLE DU............................................................................................................................ 56
-3-
Specification for BEERS (V24) May 2009
6.20 TOTAL DERIVATIVES BUSINESS IN BANKS’ TRADING AND BANKING BOOKS
(FORM DQ) – FROM DECEMBER 2007 57
6.20.1 SAMPLE DQ............................................................................................................................ 57
6.20.2 SAMPLE DR............................................................................................................................ 57
6.20.3 SAMPLE DT ............................................................................................................................ 61
6.21 EFFECTIVE INTEREST RATES ON STERLING BUSINESS BY SECTOR (FORM ER)
62
6.21.1 SAMPLE ER ............................................................................................................................ 62
6.22 FOREIGN AFFILIATES STATISTICS (FORM FT) – FROM DECEMBER 2009 64
6.22.1 SAMPLE FT............................................................................................................................. 64
6.23 GILTS AND TREASURY BILLS (FORM GT) – FROM MAY 2009 64
6.23.1 SAMPLE GT ............................................................................................................................ 64
6.24 FOREIGN DIRECT INVESTMENT TRANSACTIONS (FORM HF) – FROM
DECEMBER 2007 65
6.24.1 SAMPLE HF ............................................................................................................................ 65
6.25 COUNTRY ANALSIS: LEVELS OF INWARD FOREIGN DIRECT INVESMENT
(FORM HI) 66
6.25.1 SAMPLE HI ............................................................................................................................. 66
6.26 COUNTRY ANALSIS: LEVELS OF OUTWARD FOREIGN DIRECT INVESMENT
(FORM HO) 67
6.26.1 SAMPLE HO............................................................................................................................ 67
6.27 ANALYSIS OF LENDING TO UK RESIDENTS (FORM IC) – FROM OCTOBER 2007 68
6.27.1 SAMPLE IC ............................................................................................................................. 68
6.28 FURTHER ANALYSIS OF LOANS AND ADVANCES TO UK INDIVIDUALS (FORM
IO) – FROM OCTOBER 2007 69
6.28.1 SAMPLE IO ............................................................................................................................. 69
6.29 FURTHER ANALYSIS OF SECURED LENDING TO UK INDIVIDUALS (FORM IS) –
FROM OCTOBER 2007 70
6.29.1 SAMPLE IS.............................................................................................................................. 70
6.30 SPECIALIST MORTGAGE INSTITUTIONS – ANALYSIS OF SECURED LENDING TO
INDIVIDUALS AND INDIVIDUAL TRUSTS (FORM MM) 71
6.30.1 SAMPLE MM .......................................................................................................................... 72
6.31 SPECIALIST MORTGAGE INSTITUTIONS – BALANCE SHEET (FORM MQ) 73
6.31.1 SAMPLE MQ ........................................................................................................................... 74
6.32 PROFIT AND LOSS (FORM PL) 75
6.32.1 SAMPLE PL............................................................................................................................. 75
6.33 GILT REPO AND STOCK LENDING ACTIVITY (FORM RSL) 78
6.33.1 SAMPLE RSL .......................................................................................................................... 78
6.34 ANALYSIS OF NET WRITE-OFFS (FORM WO) – FROM MARCH 2008 80
6.34.1 SAMPLE WO........................................................................................................................... 80
-4-
Specification for BEERS (V24) May 2009
7 FORM SUMMARY........................................................................................81
8 SENDING DATA...........................................................................................83
9 DATA COMPRESSION AND BATCHING....................................................83
10 DATA ENCRYPTION.................................................................................83
11 SENDING DATA VIA E-MAIL ...................................................................84
12 RECEIPTS .................................................................................................84
-5-
Specification for BEERS (V24) May 2009
1 INTRODUCTION
The Bank of England Electronic Reporting System (BEERS) enables reporting
institutions that report statistics to the Bank of England’s Monetary and Financial
Statistics Division to transmit that data electronically. BEERS came into live operation
on 4 January 1993.
This Technical Specification contains the information required by software developers to
implement the reporting institutions’ side of the transmission system. The forms are
discussed in form name order.
Any forms that do not appear here are no longer reported and are discussed in past
documents.
Paper forms if needed for reference are available from the Bank of England website at
www.bankofengland.co.uk/statistics/reporters/defs/excelint.htm
-6-
Specification for BEERS (V24) May 2009
2 ALL FORM TYPES
The general structure of all files is:
Data Header record
Data record(s)
Text Header record (if text being sent)
Text record(s) (if any)
Comment Header record (if comments being sent)
Comment record(s) (if any)
Files can contain more than one type of header record.
2.1 FILENAMES AND FORM CODES
Each form is output as a separate file. The format for the filename is:
Fffyymm.FRM
where
F Character F denotes a Form file
ff 2 character Form code
yy Year number (eg 99, or 00 )
mm Month number (01 to 12)
Please do not:
• concatenate different form types as a single .FRM file.
• concatenate records for different periods as a single .FRM file.
However, it is acceptable to batch .FRM files together when compressing.
2.2 HEADER RECORDS AND SECTION CODES
Header records contain 2 character section codes. For most forms types the section codes
are the same as the form codes. However, certain form types are split into sections.
These forms have section codes that are, in general, different from the form codes. These
are shown in the summary at the end of this document. However, as these sections make
up a single form type, they must be concatenated into a single .FRM file.
-7-
Specification for BEERS (V24) May 2009
3 3D FORM TYPES
3D form types are those on which no country or currency analysis appears.
The general structure of the corresponding file is:
Data Header record
Data record(s)
Text Header record (if text being sent)
Text record(s) (if any)
Comment Header record (if comments being sent)
Comment record(s) (if any)
The fields in the DATA records are always:
• of 12 characters
• right-justified
• take numbers of up to 11 digits, preceded if necessary by a – sign
The fields in the TEXT records are almost always:
• left-justified (the exceptions are specified in the detailed descriptions of the forms)
• of 12 characters
The fields in the COMMENT records are always:
• left-justified
• up to 80 characters long
3.1 DATA HEADER RECORD
The data for each 3D form is preceded by a 12 character Data Header record in the
format Hyymmff3bbbb where
Position Character Notes
1 H Character H denotes a Data Header record
2-3 yy Year number (eg 00)
4-5 mm Month number (01 to 12)
6-7 ff 2 character Section code
8 3 Character 3 denotes a 3D form
9-12 bbbb 4 digit Reporter code allocated by the BoE
For example, the Data Header record H0103BT30001 is for the 3D form BT for March
2001 for Reporter code 0001.
-8-
Specification for BEERS (V24) May 2009
3.2 DATA RECORDS
Each Data Header record is followed by a varying number of Data records. Each Data
record contains up to six fields and is in the format:
Field 1 Field 2 Field 3 Field 4 Field 5 Field 6
Where
Position Field Notes
1-12 Field 1 Right justified: up to 11 digits, preceded if necessary by a –
sign
13-24 Field 2 (as field 1)
etc until
61-72 Field 6 (as field 1)
The data fields are derived from the form by listing the data values from left to right and
top to bottom. Totals and other calculated fields must be included.
For example, the following (imaginary) form data
1 1665
2 2575 3758
3 432 54 486 0
3.1 82 9 91 108
are output as the Data records
1665 2575 3758 432 54 486
0 82 9 91 108
Figures are reported in the format given on the front of the paper form (generally £000s
with no decimal places).
A blank field is shown as a right justified zero ie 0
Note that some 3D forms do not fit neatly into the format described above. Such forms
are detailed later on in FORMS ORDERED BY FORM NAME.
-9-
Specification for BEERS (V24) May 2009
3.3 TEXT HEADER RECORDS AND TEXT RECORDS
Some forms contain text. Text records follow the Data records and are preceded by an
11-character Text Header record in the format Tyymmffbbbb where
Position Character Notes
1 T Character T denotes a Text Header record
2-3 yy Year number (eg 99)
4-5 mm Month number (01 to 12)
6-7 ff 2 character Section code
8-11 bbbb 4 digit Reporter code allocated by the BoE
Note that unlike the Data Header record there is no dimension indicator in the 8th
position. Details of the formats of Text Header records and Text records are given under
the entries for the forms concerned later on.
- 10 -
Specification for BEERS (V24) May 2009
4 4D FORM TYPES
4D form types are those on which country and/or currency analyses appear.
An example is form CL; this has one 3D section and one 4D section. The format of the
3D section follows normal 3D conventions. The 4D section consists of a varying amount
of headers depending on what data it being reported for what country code. This figure is
then fed into the WORL line indicating how many coutries are being reported.
The general structure of the corresponding file is
Data Header record for WORL
Data records
Data Header record for first country
Data records
Data Header record for second country
Data records
etc
The WORL Data records store the totals for the countries reported. If no countries are
reported, then the file must contain a WORL Data Header record followed by a single
Data record with a zero in each field.
The fields in the Data records are always of 12 characters; right justified, and take
numbers of up to 11 digits, preceded if necessary by a − sign.
- 11 -
Specification for BEERS (V24) May 2009
4.1 COUNTRY CODES
When reporting 4D data, ie data analysed by country, groups of countries (“area”) or
currency, country codes are used in the Header records. The codes to be used are, with
some exceptions, the four character codes shown in Appendix A. (The exceptions are
covered in the descriptions of the individual forms).
Note that some country codes (eg USA) consist of only three characters. In this case, the
country should be output as left justified.
In some form types, the term “country” may mean “area” or currency.
4.1.1 AREA BREAKDOWN CODES
Where area breakdowns are to be reported on a form, the following code substitutions
should be used.
Printed Printed Use
2 char 4 char
UC EEC ECUN
UW OWEN OWUN
UN OECN OEUN
UX EEUR EEUN
UL LACN CLUN
UM MEOX MXUN
UO OILN OOUN
UR OAFN AFUN
UF FEAN FEUN
UN OTHN OCUN
- 12 -
Specification for BEERS (V24) May 2009
4.2 DATA HEADER RECORD
Data for each Country row of the paper form has its own 20 character Header record in
the format Hyymmff4bbbbccccbnnn where
Position Character Notes
1 H Character H denotes a Header record
2-3 yy Year number (eg 99)
4-5 mm Month number (01 to 12)
6-7 ff 2 character Section code 99
8 4 Character 4 denotes a 4D form
9-12 bbbb 4 digit Reporter code allocated by the BoE
13-16 cccc 4 character Country code (see Appendix A)
17 b a blank space
18-20 nnn First (WORL) Data Header record only: the number of Data
Header records (including that for WORL) contained in the Section,
right justified
For example the Data Header record H9909CC40001WORLbb15 represents the WORL
Header record for the 4D form CC for September 1999 for Reporter code 0001; the form
contains data on 14 countries. The corresponding Header record for Abu Dhabi would be
H9909CC40001ABUD. If no countries are reported then the WORL Header record will
be H9907CC40001WORLbbb1.
4.3 DATA RECORDS
Each country row on the paper form is then output in the same format as a 3D form,
namely left to right. Thus a typical row from Section 1 of a CA form
1264 153 1111 363 35 10 4 12 0 0 1515 300 1215
is output as
1264 153 1111 363 35 10
4 12 0 0 1515 300
1215
- 13 -
Specification for BEERS (V24) May 2009
5 MIXED 3D AND 4D FORMS
There are a number of non standard form types which are a mixture of 3D/4D sections
and with text as well as numerical numbers reported.
The general structure of the corresponding file is
Data Header record for WORL
Data records with values of zero.
Data Header record for first exposure
Data records
Data Header record for second exposure
Data records
etc
Data Header record for last exposure
Data records
Data Header record for total
Data records
The WORL Header record stores the total of exposures reported for each section. The
data records that follow should all be zero.
The total rows are mandatory if shown on the paper return. If no exposures are reported,
then the file must contain a WORL Data Header record and the total record.
The fields in the Data records are always of 12 characters, right justified, and take
numbers of up to 11 digits, preceded if necessary by a − sign.
- 14 -
Specification for BEERS (V24) May 2009
5.1 DATA HEADER RECORD
Data for each exposure row of the paper form has its own 220 character Header record in
the format Hyymmff4bbbbccccbnnnxxxxxxxxxxxxxxxxxxxxxxxxx…… where
Position Character Notes
1 H Character H denotes a Header record
2-3 yy Year number (eg 03)
4-5 mm Month number (01 to 12)
6-7 ff 2 character Section code
8 d Character 4 denotes a 4D form, 3 denotes a 3D form
9-12 bbbb 4 digit Reporter code allocated by the BoE
13-16 cccc 4 character row code (eg 0001, 0002, 0003)
17 b a blank space
18-20 nnn First (WORL) Data Header record only: the number of Data
Header records (including that for WORL) contained in the Section,
right justified
21-220 xxx… Counterparty name. This can be up to 200 characters. The name
does not need to be padded if it is less.
- 15 -
Specification for BEERS (V24) May 2009
6 EXAMPLES OF FORMS ORDERED BY FORM NAME
6.1 ANALYSIS OF DEPOSITS FROM UK RESIDENTS (FORM AD)
Form AD is a standard 3D form.
6.1.1 SAMPLE AD
A full example of the data file for form AD is shown below.
H0403AD30001
Standard Data Header record for section AD – followed by
Standard Data records: each box represents a 12-character field
AD£1 ADE1 ADC1 AD£2 ADE2 ADC2
AD£3 ADE3 ADC3 AD£4 ADE4 ADC4
AD£4A ADE4A ADC4A AD£4B ADE4B ADC4B
AD£4C ADE4C ADC4C AD£4D ADE4D ADC4D
AD£4E ADE4E ADC4E AD£4F ADE4F ADC4F
AD£4G ADE4G ADC4G AD£4H ADE4H ADC4H
AD£5 ADE5 ADC5 AD£5A ADE5A ADC5A
AD£5B ADE5B ADC5B AD£6 ADE6 ADC6
AD£7 ADE7 ADC7 AD£7A ADE7A ADC7A
AD£7B ADE7B ADC7B AD£7C ADE7C ADC7C
AD£8 ADE8 ADC8 AD£9 ADE9 ADC9
AD£10 ADE10 ADC10 AD£10A ADE10A ADC10A
AD£10B ADE10B ADC10B AD£10C ADE10C ADC10C
AD£10D ADE10D ADC10D AD£11 ADE11 ADC11
AD£12 ADE12 ADC12 AD£13 ADE13 ADC13
AD£14 ADE14 ADC14 AD£14A ADE14A ADC14A
AD£14B ADE14B ADC14B AD£15 ADE15 ADC15
AD£15A ADE15A ADC15A AD£15B ADE15B ADC15B
AD£15C ADE15C ADC15C AD£15D ADE15D ADC15D
AD£15E ADE15E ADC15E AD£15F ADE15F ADC15F
AD£15G ADE15G ADC15G AD£15H ADE15H ADC15H
AD£15J ADE15J ADC15J AD£15K ADE15K ADC15K
AD£16 ADE16 ADC16 AD£17 ADE17 ADC17
AD£17A ADE17A ADC17A AD£17AA ADE17AA ADC17AA
AD£17AB ADE17AB ADC17AB AD£17AC ADE17AC ADC17AC
AD£17AD ADE17AD ADC17AD AD£17AE ADE17AE ADC17AE
AD£17AF ADE17AF ADC17AF AD£17AG ADE17AG ADC17AG
AD£17B ADE17B ADC17B AD£18 ADE18 ADC18
AD£19 ADE19 ADC19
- 16 -
Specification for BEERS (V24) May 2009
6.2 ANALYSIS OF LENDING TO UK RESIDENTS (FORM AL) – UNTIL
SEPTEMBER 2007
Form AL is a standard 3D form.
Note that BBA reporters may need to submit this return on a monthly basis to the BBA
only.
6.2.1 SAMPLE AL
H0403AL30001
Standard Data Header record for section AL – followed by
Standard Data records: each box represents a 12-character field
AL£P1 ALEP1 AL£L1 ALEL1 ALCL1 AL£A1
ALEA1 ALCA1 AL£F1 ALEF1 ALCF1 AL£P2
ALEP2 AL£L2 ALEL2 ALCL2 AL£A2 ALEA2
ALCA2 AL£F2 ALEF2 ALCF2 AL£P3 ALEP3
AL£L3 ALEL3 ALCL3 AL£A3 ALEA3 ALCA3
AL£F3 ALEF3 ALCF3 AL£P4 ALEP4 AL£L4
ALEL4 ALCL4 AL£A4 ALEA4 ALCA4 AL£F4
ALEF4 ALCF4 AL£P4A ALEP4A AL£L4A ALEL4A
ALCL4A AL£A4A ALEA4A ALCA4A AL£F4A ALEF4A
ALCF4A AL£P4B ALEP4B AL£L4B ALEL4B ALCL4B
AL£A4B ALEA4B ALCA4B AL£F4B ALEF4B ALCF4B
AL£P4C ALEP4C AL£L4C ALEL4C ALCL4C AL£A4C
ALEA4C ALCA4C AL£F4C ALEF4C ALCF4C AL£P4D
ALEP4D AL£L4D ALEL4D ALCL4D AL£A4D ALEA4D
ALCA4D AL£F4D ALEF4D ALCF4D AL£P4E ALEP4E
AL£L4E ALEL4E ALCL4E AL£A4E ALEA4E ALCA4E
AL£F4E ALEF4E ALCF4E AL£P4F ALEP4F AL£L4F
ALEL4F ALCL4F AL£A4F ALEA4F ALCA4F AL£F4F
ALEP4F ALCF4F AL£P4G ALEP4G AL£L4G ALEL4G
ALCL4G AL£A4G ALEA4G ALCA4G AL£F4G ALEF4G
ALCF4G AL£P4H ALEP4H AL£L4H ALEL4H ALCL4H
AL£A4H ALEA4H ALCA4H AL£F4H ALEF4H ALCF4H
AL£P5 ALEP5 AL£L5 ALEL5 ALCL5 AL£A5
ALEA5 ALCA5 AL£F5 ALEF5 ALCF5 AL£P5A
ALEP5A AL£L5A ALEL5A ALCL5A AL£A5A ALEA5A
ALCA5A AL£F5A ALEF5A ALCF5A AL£P5B ALEP5B
AL£L5B ALEL5B ALCL5B AL£A5B ALEA5B ALCA5B
AL£F5B ALEF5B ALCF5B AL£P6 ALEP6 AL£L6
ALEL6 ALCL6 AL£A6 ALEA6 ALCA6 AL£F6
ALEF6 ALCF6 AL£P7 ALEP7 AL£L7 ALEL7
- 17 -
Specification for BEERS (V24) May 2009
ALCL7 AL£A7 ALEA7 ALCA7 AL£F7 ALEF7
ALCF7 AL£P7A ALEP7A AL£L7A ALEL7A ALCL7A
AL£A7A ALEA7A ALCA7A AL£F7A ALEF7A ALCF7A
AL£P7B ALEP7B AL£L7B ALEL7B ALCL7B AL£A7B
ALEA7B ALCA7B AL£F7B ALEF7B ALCF7B AL£P7C
ALEP7C AL£L7C ALEL7C ALCL7C AL£A7C ALEA7C
ALCA7C AL£F7C ALEF7C ALCF7C AL£P8 ALEP8
AL£L8 ALEL8 ALCL8 AL£A8 ALEA8 ALCA8
AL£F8 ALEF8 ALCF8 AL£P9 ALEP9 AL£L9
ALEL9 ALCL9 AL£A9 ALEA9 ALCA9 AL£F9
ALEF9 ALCF9 AL£P10 ALEP10 AL£L10 ALEL10
ALCL10 AL£A10 ALEA10 ALCA10 AL£F10 ALEF10
ALCF10 AL£P10A ALEP10A AL£L10A ALEL10A ALCL10A
AL£A10A ALEA10A ALCA10A AL£F10A ALEF10A ALCF10A
AL£P10B ALEP10B AL£L10B ALEL10B ALCL10B AL£A10B
ALEA10B ALCA10B AL£F10B ALEF10B ALCF10B AL£P10C
ALEP10C AL£L10C ALEL10C ALCL10C AL£A10C ALEA10C
ALCA10C AL£F10C ALEF10C ALCF10C AL£P10D ALEP10D
AL£L10D ALEL10D ALCL10D AL£A10D ALEA10D ALCA10D
AL£F10D ALEF10D ALCF10D AL£P11 ALEP11 AL£L11
ALEL11 ALCL11 AL£A11 ALEA11 ALCA11 AL£F11
ALEF11 ALCF11 AL£P12 ALEP12 AL£L12 ALEL12
ALCL12 AL£A12 ALEA12 ALCA12 AL£F12 ALEF12
ALCF12 AL£P13 ALEP13 AL£L13 ALEL13 ALCL13
AL£A13 ALEA13 ALCA13 AL£F13 ALEF13 ALCF13
AL£P14 ALEP14 AL£L14 ALEL14 ALCL14 AL£A14
ALEA14 ALCA14 AL£F14 ALEF14 ALCF14 AL£P14A
ALEP14A AL£L14A ALEL14A ALCL14A AL£A14A ALEA14A
ALCA14A AL£F14A ALEF14A ALCF14A AL£P14B ALEP14B
AL£L14B ALEL14B ALCL14B AL£A14B ALEA14B ALCA14B
AL£F14B ALEF14B ALCF14B AL£P15 ALEP15 AL£L15
ALEL15 ALCL15 AL£A15 ALEA15 ALCA15 AL£F15
ALEF15 ALCF15 AL£P15A ALEP15A AL£L15A ALEL15A
ALCL15A AL£A15A ALEA15A ALCA15A AL£F15A ALEF15A
ALCF15A AL£P15B ALEP15B AL£L15B ALEL15B ALCL15B
AL£A15B ALEA15B ALCA15B AL£F15B ALEF15B ALCF15B
AL£P15C ALEP15C AL£L15C ALEL15C ALCL15C AL£A15C
ALEA15C ALCA15C AL£F15C ALEF15C ALCF15C AL£P15D
ALEP15D AL£L15D ALEL15D ALCL15D AL£A15D ALEA15D
ALCA15D AL£F15D ALEF15D ALCF15D AL£P15E ALEP15E
AL£L15E ALEL15E ALCL15E AL£A15E ALEA15E ALCA15E
AL£F15E ALEF15E ALCF15E AL£P15F ALEP15F AL£L15F
- 18 -
Specification for BEERS (V24) May 2009
ALEL15F ALCL15F AL£A15F ALEA15F ALCA15F AL£F15F
ALEF15F ALCF15F AL£P15G ALEP15G AL£L15G ALEL15G
ALCL15G AL£A15G ALEA15G ALCA15G AL£F15G ALEF15G
ALCF15G AL£P15H ALEP15H AL£L15H ALEL15H ALCL15H
AL£A15H ALEA15H ALCA15H AL£F15H ALEF15H ALCF15H
AL£P15J ALEP15J AL£L15J ALEL15J ALCL15J AL£A15J
ALEA15J ALCA15J AL£F15J ALEF15J ALCF15J AL£P15K
ALEP15K AL£L15K ALEL15K ALCL15K AL£A15K ALEA15K
ALCA15K AL£F15K ALEF15K ALCF15K AL£P16 ALEP16
AL£L16 ALEL16 ALCL16 AL£A16 ALEA16 ALCA16
AL£F16 ALEF16 ALCF16 AL£P17 ALEP17 AL£L17
ALEL17 ALCL17 AL£A17 ALEA17 ALCA17 AL£F17
ALEF17 ALCF17 AL£P17A ALEP17A AL£L17A ALEL17A
ALCL17A AL£A17A ALEA17A ALCA17A AL£F17A ALEF17A
ALCF17A AL£P17B ALEP17B AL£L17B ALEL17B ALCL17B
AL£A17B ALEA17B ALCA17B AL£F17B ALEF17B ALCF17B
AL£L18 ALEL18 ALCL18 AL£F18 ALEF18 ALCF18
AL£L18A ALEL18A ALCL18A AL£F18A ALEF18A ALCF18A
AL£L18B ALEL18B ALCL18B AL£F18B ALEF18B ALCF18B
AL£L18C ALEL18C ALCL18C AL£F18C ALEF18C ALCF18C
AL£P19 ALEP19 AL£L19 ALEL19 ALCL19 AL£A19
ALEA19 ALCA19 AL£F19 ALEF19 ALCF19
- 19 -
Specification for BEERS (V24) May 2009
6.3 ANALYSIS OF LENDING TO UK RESIDENTS (FORM AL) – FROM
DECEMBER 2007
Form AL is a standard 3D form.
Note that BBA reporters may need to submit this return on a monthly basis to the BBA
only.
6.3.1 SAMPLE AL
H0712AL30001
Standard Data Header record for section AL – followed by
Standard Data records: each box represents a 12-character field
AL£L1 ALEL1 ALCL1 AL£F1 ALEF1 ALCF1
AL£L2 ALEL2 ALCL2 AL£F2 ALEF2 ALCF2
AL£L3 ALEL3 ALCL3 AL£F3 ALEF3 ALCF3
AL£L4 ALEL4 ALCL4 AL£F4 ALEF4 ALCF4
AL£L4A ALEL4A ALCL4A AL£F4A ALEF4A ALCF4A
AL£L4B ALEL4B ALCL4B AL£F4B ALEF4B ALCF4B
AL£L4C ALEL4C ALCL4C AL£F4C ALEF4C ALCF4C
AL£L4D ALEL4D ALCL4D AL£F4D ALEF4D ALCF4D
AL£L4E ALEL4E ALCL4E AL£F4E ALEF4E ALCF4E
AL£L4F ALEL4F ALCL4F AL£F4F ALEF4F ALCF4F
AL£L4G ALEL4G ALCL4G AL£F4G ALEF4G ALCF4G
AL£L4H ALEL4H ALCL4H AL£F4H ALEF4H ALCF4H
AL£L5 ALEL5 ALCL5 AL£F5 ALEF5 ALCF5
AL£L5A ALEL5A ALCL5A AL£F5A ALEF5A ALCF5A
AL£L5B ALEL5B ALCL5B AL£F5B ALEF5B ALCF5B
AL£L6 ALEL6 ALCL6 AL£F6 ALEF6 ALCF6
AL£L7 ALEL7 ALCL7 AL£F7 ALEF7 ALCF7
AL£L7A ALEL7A ALCL7A AL£F7A ALEF7A ALCF7A
AL£L7B ALEL7B ALCL7B AL£F7B ALEF7B ALCF7B
AL£L7C ALEL7C ALCL7C AL£F7C ALEF7C ALCF7C
AL£L8 ALEL8 ALCL8 AL£F8 ALEF8 ALCF8
AL£L9 ALEL9 ALCL9 AL£F9 ALEF9 ALCF9
AL£L10 ALEL10 ALCL10 AL£F10 ALEF10 ALCF10
AL£L10A ALEL10A ALCL10A AL£F10A ALEF10A ALCF10A
AL£L10B ALEL10B ALCL10B AL£F10B ALEF10B ALCF10B
AL£L10C ALEL10C ALCL10C AL£F10C ALEF10C ALCF10C
AL£L10D ALEL10D ALCL10D AL£F10D ALEF10D ALCF10D
AL£L11 ALEL11 ALCL11 AL£F11 ALEF11 ALCF11
AL£L12 ALEL12 ALCL12 AL£F12 ALEF12 ALCF12
AL£L13 ALEL13 ALCL13 AL£F13 ALEF13 ALCF13
AL£L14 ALEL14 ALCL14 AL£F14 ALEF14 ALCF14
- 20 -
Specification for BEERS (V24) May 2009
AL£L14A ALEL14A ALCL14A AL£F14A ALEF14A ALCF14A
AL£L14B ALEL14B ALCL14B AL£F14B ALEF14B ALCF14B
AL£L15 ALEL15 ALCL15 AL£F15 ALEF15 ALCF15
AL£L15A ALEL15A ALCL15A AL£F15A ALEF15A ALCF15A
AL£L15B ALEL15B ALCL15B AL£F15B ALEF15B ALCF15B
AL£L15C ALEL15C ALCL15C AL£F15C ALEF15C ALCF15C
AL£L15D ALEL15D ALCL15D AL£F15D ALEF15D ALCF15D
AL£L15E ALEL15E ALCL15E AL£F15E ALEF15E ALCF15E
AL£L15F ALEL15F ALCL15F AL£F15F ALEF15F ALCF15F
AL£L15G ALEL15G ALCL15G AL£F15G ALEF15G ALCF15G
AL£L15H ALEL15H ALCL15H AL£F15H ALEF15H ALCF15H
AL£L15J ALEL15J ALCL15J AL£F15J ALEF15J ALCF15J
AL£L15K ALEL15K ALCL15K AL£F15K ALEF15K ALCF15K
AL£L16 ALEL16 ALCL16 AL£F16 ALEF16 ALCF16
AL£L17 ALEL17 ALCL17 AL£F17 ALEF17 ALCF17
AL£L17A ALEL17A ALCL17A AL£F17A ALEF17A ALCF17A
AL£L17B ALEL17B ALCL17B AL£F17B ALEF17B ALCF17B
AL£L18 ALEL18 ALCL18 AL£F18 ALEF18 ALCF18
AL£L18A ALEL18A ALCL18A AL£F18A ALEF18A ALCF18A
AL£L18B ALEL18B ALCL18B AL£F18B ALEF18B ALCF18B
AL£L18C ALEL18C ALCL18C AL£F18C ALEF18C ALCF18C
AL£L19 ALEL19 ALCL19 AL£F19 ALEF19 ALCF19
6.4 ADDITIONAL SECTORAL DETAIL (FORM BE) – UNTIL SEPTEMBER
2007
- 21 -
Specification for BEERS (V24) May 2009
Form BE is created as a standard 3D form.
6.4.1 SAMPLE BE
H0401BE30001
Standard Data Header record for section BE – followed by
Standard Data records: each box represents a 12-character field
BE£2H BEE2H BEC2H BE£2H1 BEE2H1 BEC2H1
BE£2H2 BEE2H2 BEC2H2 BE£2H3 BEE2H3 BEC2H3
BE£2H4 BEE2H4 BEC2H4 BE£2HA BEE2HA BE£2HA1
BEE2HA1 BE£2HA2 BEE2HA2 BE£2HA3 BEE2HA3 BE£2HA4
BEE2HA4 BE£3H BEE3H BEC3H BE£3H1 BEE3H1
BEC3H1 BE£3H2 BEE3H2 BEC3H2 BE£3H3 BEE3H3
BEC3H3 BE£3H4 BEE3H4 BEC3H4 BE£6H BEE6H
BEC6H BE£6H1 BEE6H1 BEC6H1 BE£6H2 BEE6H2
BEC6H2 BE£6H3 BEE6H3 BEC6H3 BE£6H4 BEE6H4
BEC6H4 BE£7H BEE7H BEC7H BE£7H1 BEE7H1
BEC7H1 BE£7H2 BEE7H2 BEC7H2 BE£7H3 BEE7H3
BEC7H3 BE£7H4 BEE7H4 BEC7H4 BE£26EC BEE26EC
BEC26EC BE£26EC1 BEE26EC1 BEC26EC1 BE£26EC2 BEE26EC2
BEC26EC2 BE£26EC3 BEE26EC3 BEC26EC3 BE£26EC4 BEE26EC4
BEC26EC4 BE£26F BEE26F BEC26F BE£26F1 BEE26F1
BEC26F1 BE£26F2 BEE26F2 BEC26F2 BE£29D BEE29D
BEC29D BE£29D1 BEE29D1 BEC29D1 BE£29D2 BEE29D2
BEC29D2 BE£29D3A BEE29D3A BEC29D3A BE£29D3B BEE29D3B
BEC29D3B BE£29D3C BEE29D3C BEC29D3C BE£29D3D BEE29D3D
BEC29D3D BE£29D3E BEE29D3E BEC29D3E BE£29D4 BEE29D4
BEC29D4 BE£29D4A BEE29D4A BEC29D4A BE£30H BEE30H
BEC30H BE£30H1 BEE30H1 BEC30H1 BE£30H2 BEE30H2
BEC30H2 BE£30H3 BEE30H3 BEC30H3 BE£30H4 BEE30H4
BEC30H4 BE£31H BEE31H BEC31H BE£31H1 BEE31H1
BEC31H1 BE£31H2 BEE31H2 BEC31H2 BE£31H3 BEE31H3
BEC31H3 BE£31H4 BEE31H4 BEC31H4 BE£32H BEE32H
BEC32H BE£32H1 BEE32H1 BEC32H1 BE£32H2 BEE32H2
BEC32H2 BE£32H4 BEE32H4 BEC32H4 BE£41F BEE41F
BEC41F BE£41F1 BEE41F1 BEC41F1 BE£41F2 BEE41F2
BEC41F2 BE£41F3 BEE41F3 BEC41F3 BE£41F4 BEE41F4
BEC41F4
6.5 ADDITIONAL SECTORAL DETAIL (FORM BE) – FROM OCTOBER 2007
Form BE is created as a standard 3D form.
- 22 -
Specification for BEERS (V24) May 2009
6.5.1 SAMPLE BE
H0710BE30001
Standard Data Header record for section BE – followed by
Standard Data records: each box represents a 12-character field
BE£2H BEE2H BEC2H BE£2H1 BEE2H1 BEC2H1
BE£2H2 BEE2H2 BEC2H2 BE£2H3A BEE2H3A BEC2H3A
BE£2H3B BEE2H3B BEC2H3B BE£2H4 BEE2H4 BEC2H4
BE£2HA BEE2HA BE£2HA1 BEE2HA1 BE£2HA2 BEE2HA2
BE£2HA3A BEE2HA3A BE£2HA3B BEE2HA3B BE£2HA4 BEE2HA4
BE£3H BEE3H BEC3H BE£3H1 BEE3H1 BEC3H1
BE£3H2 BEE3H2 BEC3H2 BE£3H3A BEE3H3A BEC3H3A
BE£3H3B BEE3H3B BEC3H3B BE£3H4 BEE3H4 BEC3H4
BE£47A BEE47A BE£6H BEE6H BEC6H BE£6H1
BEE6H1 BEC6H1 BE£6H2 BEE6H2 BEC6H2 BE£6H3
BEE6H3 BEC6H3 BE£6H4 BEE6H4 BEC6H4 BE£26EC
BEE26EC BEC26EC BE£26EC1 BEE26EC1 BEC26EC1 BE£26EC2
BEE26EC2 BEC26EC2 BE£26EC3 BEE26EC3 BEC26EC3 BE£26EC4
BEE26EC4 BEC26EC4 BE£26F BEE26F BEC26F BE£26F1
BEE26F1 BEC26F1 BE£26F2 BEE26F2 BEC26F2 BE£29D
BEE29D BEC29D BE£29DA1 BEE29DA1 BEC29DA1 BE£29DA2
BEE29DA2 BEC29DA2 BE£29DA3A BEE29DA3A BEC29DA3A BE£29DA3B
BEE29DA3B BEC29DA3B BE£29DA4 BEE29DA4 BEC29DA4 BE£29DB1
BEE29DB1 BEC29DB1 BE£29DB2 BEE29DB2 BEC29DB2 BE£29DB3A1
BEE29DB3A1 BEC29DB3A1 BE£29DB3A2 BEE29DB3A2 BEC29DB3A2 BE£29DB3A3
BEE29DB3A3 BEC29DB3A3 BE£29DB3A4 BEE29DB3A4 BEC29DB3A4 BE£29DB3B
BEE29DB3B BEC29DB3B BE£29DB4 BEE29DB4 BEC29DB4 BE£29D2A
BEE29D2A BEC29D2A BE£30H BEE30H BEC30H BE£30H1
BEE30H1 BEC30H1 BE£30H2 BEE30H2 BEC30H2 BE£30H3
BEE30H3 BEC30H3 BE£30H4 BEE30H4 BEC30H4 BE£32H
BEE32H BEC32H BE£32HA BEE32HA BEC32HA BE£32HB
BEE32HB BEC32HB BE£32HC BEE32HC BEC32HC BE£32H1
BEE32H1 BEC32H1 BE£32H2 BEE32H2 BEC32H2 BE£32H4
BEE32H4 BEC32H4 BE£41F BEE41F BEC41F BE£41F1
BEE41F1 BEC41F1 BE£41F2 BEE41F2 BEC41F2 BE£41F3
BEE41F3 BEC41F3 BE£41F4 BEE41F4 BEC41F4
6.6 TRANSACTIONS WITH NON-RESIDENTS: INTEREST DIVIDENDS AND
OTHER INCOME BY GEOGRAPHICAL LOCATION (FORM BG)
- 23 -
Specification for BEERS (V24) May 2009
The outward and inward parts of this form should be output in one record for each
country used.
6.6.1 SAMPLE BG
A full example of the data file for the form BG is shown below.
H0403BG40001WORL 6
Standard Data Header record for section BG – followed by
Standard Data records: each box represents a 12-character field
BG1 BG2 BG3 BG4 BG5 BG6
BG 7 BG8 BG9 BG10
H0403BG40001ENTO
BG1 BG2 BG3 BG4 BG5 BG6
BG 7 BG8 BG9 BG10
H0403BG40001ONTO
BG1 BG2 BG3 BG4 BG5 BG6
BG 7 BG8 BG9 BG10
H0403BG40001UNAL
BG1 BG2 BG3 BG4 BG5 BG6
BG 7 BG8 BG9 BG10
H0403BG40001CTOT
BG1 BG2 BG3 BG4 BG5 BG6
BG 7 BG8 BG9 BG10
H0403BG40001CZRP
BG1 BG2 BG3 BG4 BG5 BG6
BG 7 BG8 BG9 BG10
- 24 -
Specification for BEERS (V24) May 2009
6.7 BALANCE SHEET (FORM BT) – UNTIL SEPTEMBER 2007
The BT return is a standard 3D form.
6.7.1 SAMPLE BT
A full example of the data file for form BT is shown below.
H0401BT30001
Standard Data Header record for section BT – followed by
Standard Data records: each box represents a 12-character field
BT£1 BTE1 BT£2 BTE2 BTC2 BT£2A
BTE2A BTC2A BT£2AA BTE2AA BT£2AB BTE2AB
BT£2B BTE2B BTC2B BT£2BA BTE2BA BT£2BB
BTE2BB BT£2C BTE2C BTC2C BT£2CA BTE2CA
BT£2CB BTE2CB BT£2D BTE2D BTC2D BT£2DA
BTE2DA BT£2DB BTE2DB BT£2E BTE2E BTC2E
BT£2EA BTE2EA BT£2EB BTE2EB BT£2F BTE2F
BTC2F BT£2FA BTE2FA BT£2FB BTE2FB BT£2G
BTE2G BTC2G BT£2GA BTE2GA BT£2GB BTE2GB
BT£2H BTE2H BTC2H BT£2HA BTE2HA BT£2HB
BTE2HB BT£2J BTE2J BTC2J BT£2JA BTE2JA
BT£2JB BTE2JB BT£3 BTE3 BTC3 BT£3A
BTE3A BTC3A BT£3B BTE3B BTC3B BT£3C
BTE3C BTC3C BT£3D BTE3D BTC3D BT£3E
BTE3E BTC3E BT£3F BTE3F BTC3F BT£3G
BTE3G BTC3G BT£3H BTE3H BTC3H BT£3HA
BTE3HA BT£3HB BTE3HB BT£3HC BTE3HC BT£3J
BTE3J BTC3J BT£4 BTE4 BTC4 BT£5
BTE5 BTC5 BT£5A BTE5A BTC5A BT£5B
BTE5B BTC5B BT£5C BTE5C BTC5C BT£6
BTE6 BTC6 BT£6A BTE6A BTC6A BT£6B
BTE6B BTC6B BT£6C BTE6C BTC6C BT£6D
BTE6D BTC6D BT£6E BTE6E BTC6E BT£6F
BTE6F BTC6F BT£6G BTE6G BTC6G BT£6H
BTE6H BTC6H BT£6J BTE6J BTC6J BT£7
BTE7 BTC7 BT£7A BTE7A BTC7A BT£7B
BTE7B BTC7B BT£7C BTE7C BTC7C BT£7D
BTE7D BTC7D BT£7E BTE7E BTC7E BT£7F
BTE7F BTC7F BT£7G BTE7G BTC7G BT£7H
BTE7H BTC7H BT£7J BTE7J BTC7J BT£8
BTE8 BTC8 BT£9 BTE9 BTC9 BT£10
BTE10 BTC10 BT£11 BTE11 BTC11 BT£11A
BTE11A BTC11A BT£11B BTE11B BTC11B BT£19
- 25 -
Specification for BEERS (V24) May 2009
BTE19 BTC19 BT£19A BTE19A BTC19A BT£19B
BTE19B BTC19B BT£19C BTE19C BTC19C BTE19CA
BTC19CA BT£19CB BTE19CB BTC19CB BT£19CC BTE19CC
BTC19CC BT£19CCA BTE19CCA BTC19CCA BT£19CCB BTE19CCB
BTC19CCB BT£19CCC BTE19CCC BTC19CCC BT£19CD BTE19CD
BTC19CD BT£20 BTE20 BTC20 BT£21 BTE21
BTC21 BT£21A BTE21A BTC21A BT£21B BTE21B
BTC21B BT£22 BTE22 BTC22 BT£22A BTE22A
BTC22A BT£22B BTE22B BTC22B BT£23 BTE23
BTC23 BT£23D BTE23D BTC23D BT£23E BTE23E
BTC23E BT£23F BTE23F BTC23F BT£23G BTE23G
BTC23G BT£23GA BTE23GA BTC23GA BT£23GB BTE23GB
BTC23GB BT£23GC BTE23GC BTC23GC BT£23H BTE23H
BTC23H BT£23J BTE23J BTC23J BT£23K BTE23K
BTC23K BT£23L BTE23L BTC23L BT£24 BTE24
BT£25 BTE25 BT£26 BTE26 BTC26 BT£26A
BTE26A BTC26A BT£26BA BTE26BA BTC26BA BT£26BB
BTE26BB BTC26BB BT£26C BTE26C BTC26C BT£26DA
BTE26DA BTC26DA BT£26DB BTE26DB BTC26DB BT£26E
BTE26E BTC26E BT£26EA BTE26EA BTC26EA BT£26EB
BTE26EB BTC26EB BT£26EC BTE26EC BTC26EC BT£26F
BTE26F BTC26F BT£26G BTE26G BTC26G BT£26GA
BTE26GA BTC26GA BT£26GB BTE26GB BTC26GB BTE26H
BT£27 BTE27 BTC27 BT£28 BTE28 BT£29
BTE29 BTC29 BT£29A BTE29A BTC29A BT£29B
BTE29B BTC29B BT£29C BTE29C BTC29C BT£29D
BTE29D BTC29D BT£29E BTE29E BTC29E BT£30
BTE30 BTC30 BT£30A BTE30A BTC30A BT£30B
BTE30B BTC30B BT£30C BTE30C BTC30C BT£30D
BTE30D BTC30D BT£30E BTE30E BTC30E BT£30F
BTE30F BTC30F BT£30G BTE30G BTC30G BT£30H
BTE30H BTC30H BT£30J BTE30J BTC30J BT£31
BTE31 BTC31 BT£31A BTE31A BTC31A BT£31B
BTE31B BTC31B BT£31C BTE31C BTC31C BT£31D
BTE31D BTC31D BT£31E BTE31E BTC31E BT£31F
BTE31F BTC31F BT£31G BTE31G BTC31G BT£31H
BTE31H BTC31H BT£31J BTE31J BTC31J BT£32
BTE32 BTC32 BT£32A BTE32A BTC32A BT£32AA
BTE32AA BTC32AA BT£32AB BTE32AB BTC32AB BT£32AC
BTE32AC BTC32AC BT£32B BTE32B BTC32B BT£32BA
BTE32BA BTC32BA BT£32BB BTE32BB BTC32BB BT£32BC
BTE32BC BTC32BC BT£32C BTE32C BTC32C BT£32D
- 26 -
Specification for BEERS (V24) May 2009
BTE32D BTC32D BT£32E BTE32E BTC32E BT£32F
BTE32F BTC32F BT£32G BTE32G BTC32G BT£32H
BTE32H BTC32H BT£32J BTE32J BTC32J BT£32K
BTE32K BTC32K BTE32L BT£33 BTE33 BTC33
BT£34 BTE34 BTC34 BT£35 BTE35 BTC35
BTC35A BT£35B BTE35B BTC35B BT£35C BTE35C
BTC35C BT£35CA BTE35CA BTC35CA BT£35D BTE35D
BTC35D BT£40 BTE40 BTC40 BT£41 BTE41
BTC41 BT£41A BTE41A BTC41A BT£41B BTE41B
BTC41B BT£41C BTE41C BTC41C BT£41D BTE41D
BTC41D BT£41E BTE41E BTC41E BT£41F BTE41F
BTC41F BT£41G BTE41G BTC41G BT£41H BTE41H
BTC41H BT£41J BTE41J BTC41J BT£41K BTE41K
BTC41K BT£42 BTE42 BTC42 BT£43 BTE43
BTC43 BT£44 BTE44 BT£45A BTE45A BTC45A
BT£45B BTE45B BTC45B BT£45BA BTE45BA BTC45BA
BT£45BB BTE45BB BTC45BB BT£45C BTE45C BTC45C
BT£45CA BTE45CA BTC45CA BT£45CB BTE45CB BTC45CB
BT£45D BTE45D BTC45D BT£46 BT£46A BT£46B
BT£47 BTE47 BT£47A BTE47A BT£AA BTEAA
BT£AB BTEAB BT£AC BTEAC BTCAC BT£AD
BTEAD BT£AE BTEAE BT£AF BTEAF BT£AFA
BTEAFA BT£AFB BTEAFB BT£AFC BTEAFC BT£AFD
BTEAFD BT£AG BTEAG BT£AH BTEAH BT£AJ
BTEAJ BTEAK BTEAL BT£B BTEB BT£BA
BTEBA BT£BB BTEBB BT£BC BTEBC
- 27 -
Specification for BEERS (V24) May 2009
6.8 BALANCE SHEET (FORM BT) – FROM OCTOBER 2007 UNTIL
DECEMBER 2008
The BT return is a standard 3D form.
6.8.1 SAMPLE BT
A full example of the data file for form BT is shown below.
H0710BT30001
Standard Data Header record for section BT – followed by
Standard Data records: each box represents a 12-character field
BT£1 BTE1 BT£2 BTE2 BTC2 BT£2A
BTE2A BTC2A BT£2B BTE2B BTC2B BT£2BG
BTE2BG BTC2BG BT£2C BTE2C BTC2C BT£2D
BTE2D BTC2D BT£2E BTE2E BTC2E BT£2F
BTE2F BTC2F BT£2G BTE2G BTC2G BT£2H
BTE2H BTC2H BT£2J BTE2J BTC2J BT£3
BTE3 BTC3 BT£3A BTE3A BTC3A BT£3B
BTE3B BTC3B BT£3BG BTE3BG BTC3BG BT£3C
BTE3C BTC3C BT£3D BTE3D BTC3D BT£3E
BTE3E BTC3E BT£3F BTE3F BTC3F BT£3G
BTE3G BTC3G BT£3H BTE3H BTC3H BT£3HB
BTE3HB BT£3HC BTE3HC BT£3J BTE3J BTC3J
BT£4 BTE4 BTC4 BT£5 BTE5 BTC5
BT£5A BTE5A BTC5A BT£5B BTE5B BTC5B
BT£5C BTE5C BTC5C BT£6 BTE6 BTC6
BT£6A BTE6A BTC6A BT£6B BTE6B BTC6B
BT£6BG BTE6BG BTC6BG BT£6C BTE6C BTC6C
BT£6D BTE6D BTC6D BT£6E BTE6E BTC6E
BT£6F BTE6F BTC6F BT£6G BTE6G BTC6G
BT£6H BTE6H BTC6H BT£6J BTE6J BTC6J
BT£8 BTE8 BTC8 BT£9 BTE9 BTC9
BT£10 BTE10 BTC10 BT£11 BTE11 BTC11
BT£11A BTE11A BTC11A BT£11B BTE11B BTC11B
BT£19 BTE19 BTC19 BT£19A BTE19A BTC19A
BT£19B BTE19B BTC19B BT£19BL BTE19BL BTC19BL
BT£19C BTE19C BTC19C BTE19CA BTC19CA BT£19CB
BTE19CB BTC19CB BT£19CC BTE19CC BTC19CC BT£19CCA
BTE19CCA BTC19CCA BT£19CCB BTE19CCB BTC19CCB BT£19CCC
BTE19CCC BTC19CCC BT£19CD BTE19CD BTC19CD BT£19CDA
BTE19CDA BTC19CDA BT£19CD1 BTE19CD1 BTC19CD1 BT£19CD2
BTE19CD2 BTC19CD2 BT£19CD3 BTE19CD3 BTC19CD3 BT£19CD4
- 28 -
Specification for BEERS (V24) May 2009
BTE19CD4 BTC19CD4 BT£19CD5 BTE19CD5 BTC19CD5 BT£20
BTE20 BTC20 BT£21 BTE21 BTC21 BT£21A
BTE21A BTC21A BT£21B BTE21B BTC21B BT£22
BTE22 BTC22 BT£22A BTE22A BTC22A BT£22B
BTE22B BTC22B BT£23 BTE23 BTC23 BT£23D
BTE23D BTC23D BT£23DG BTE23DG BTC23DG BT£23E
BTE23E BTC23E BT£23F BTE23F BTC23F BT£23G
BTE23G BTC23G BT£23GA BTE23GA BTC23GA BT£23GB
BTE23GB BTC23GB BT£23GC BTE23GC BTC23GC BT£23H
BTE23H BTC23H BT£23J BTE23J BTC23J BT£23K
BTE23K BTC23K BT£23L BTE23L BTC23L BT£24
BTE24 BT£25 BTE25 BT£26 BTE26 BTC26
BT£26A BTE26A BTC26A BT£26B BTE26B BTC26B
BT£26C BTE26C BTC26C BT£26D BTE26D BTC26D
BT£26E BTE26E BTC26E BT£26EA BTE26EA BTC26EA
BT£26EB BTE26EB BTC26EB BT£26EC BTE26EC BTC26EC
BT£26F BTE26F BTC26F BT£26G BTE26G BTC26G
BT£26GA BTE26GA BTC26GA BT£26GB BTE26GB BTC26GB
BT£27 BTE27 BTC27 BT£29 BTE29 BTC29
BT£29A BTE29A BTC29A BT£29B BTE29B BTC29B
BT£29C BTE29C BTC29C BT£29D BTE29D BTC29D
BT£29E BTE29E BTC29E BT£30 BTE30 BTC30
BT£30A BTE30A BTC30A BT£30B BTE30B BTC30B
BT£30BG BTE30BG BTC30BG BT£30C BTE30C BTC30C
BT£30D BTE30D BTC30D BT£30E BTE30E BTC30E
BT£30F BTE30F BTC30F BT£30G BTE30G BTC30G
BT£30H BTE30H BTC30H BT£30J BTE30J BTC30J
BT£32 BTE32 BTC32 BT£32A BTE32A BTC32A
BT£32AA1 BTE32AA1 BTC32AA1 BT£32AA2 BTE32AA2 BTC32AA2
BT£32AB1 BTE32AB1 BTC32AB1 BT£32AB2 BTE32AB2 BTC32AB2
BT£32AC1 BTE32AC1 BTC32AC1 BT£32AC2 BTE32AC2 BTC32AC2
BT£32B BTE32B BTC32B BT£32BA BTE32BA BTC32BA
BT£32BB BTE32BB BTC32BB BT£32BC BTE32BC BTC32BC
BT£32C BTE32C BTC32C BT£32D BTE32D BTC32D
BT£32E BTE32E BTC32E BT£32F BTE32F BTC32F
BT£32G BTE32G BTC32G BT£32H BTE32H BTC32H
BT£32J BTE32J BTC32J BT£32K BTE32K BTC32K
BTE32L BTC32L BT£33 BTE33 BTC33 BT£34
BTE34 BTC34 BT£35 BTE35 BTC35 BTC35A
BT£35B BTE35B BTC35B BT£35C BTE35C BTC35C
BT£35CA BTE35CA BTC35CA BT£35D BTE35D BTC35D
BT£40 BTE40 BTC40 BT£41 BTE41 BTC41
- 29 -
Specification for BEERS (V24) May 2009
BT£41A BTE41A BTC41A BT£41B BTE41B BTC41B
BT£41C BTE41C BTC41C BT£41D BTE41D BTC41D
BT£41E BTE41E BTC41E BT£41F BTE41F BTC41F
BT£41G BTE41G BTC41G BT£41H BTE41H BTC41H
BT£41J BTE41J BTC41J BT£41K BTE41K BTC41K
BT£42 BTE42 BTC42 BT£43 BTE43 BTC43
BT£44 BTE44 BT£45A BTE45A BTC45A BT£45B
BTE45B BTC45B BT£45BA BTE45BA BTC45BA BT£45BB
BTE45BB BTC45BB BT£45C BTE45C BTC45C BT£45CA
BTE45CA BTC45CA BT£45CB BTE45CB BTC45CB BT£45D
BTE45D BTC45D BT£46 BT£46A BT£46B BT£47
BTE47 BT£AA BTEAA BT£AB BTEAB BT£AC
BTEAC BTCAC BT£AD BTEAD BT£AE BTEAE
BT£AF BTEAF BT£AFA BTEAFA BT£AFB BTEAFB
BT£AFC BTEAFC BT£AFD BTEAFD BT£AH BTEAH
BT£AJ BTEAJ BTEAL BTCAL BT£B BTEB
BT£BA BTEBA BT£BB BTEBB BT£BC BTEBC
6.9 BALANCE SHEET (FORM BT) – FROM JANUARY 2009
The BT return is a standard 3D form.
6.9.1 SAMPLE BT
A full example of the data file for form BT is shown below.
H0810BT30001
Standard Data Header record for section BT – followed by
Standard Data records: each box represents a 12-character field
BT£1 BTE1 BT£2 BTE2 BTC2 BT£2A
BTE2A BTC2A BT£2B BTE2B BTC2B BT£2BG
BTE2BG BTC2BG BT£2C BTE2C BTC2C BT£2D
BTE2D BTC2D BT£2E BTE2E BTC2E BT£2F
BTE2F BTC2F BT£2G BTE2G BTC2G BT£2H
BTE2H BTC2H BT£2J BTE2J BTC2J BT£3
BTE3 BTC3 BT£3A BTE3A BTC3A BT£3B
BTE3B BTC3B BT£3BG BTE3BG BTC3BG BT£3C
BTE3C BTC3C BT£3D BTE3D BTC3D BT£3E
BTE3E BTC3E BT£3F BTE3F BTC3F BT£3G
BTE3G BTC3G BT£3H BTE3H BTC3H BT£3HB
BTE3HB BT£3HC BTE3HC BT£3J BTE3J BTC3J
BT£4 BTE4 BTC4 BT£5 BTE5 BTC5
- 30 -
Specification for BEERS (V24) May 2009
BT£5A BTE5A BTC5A BT£5B BTE5B BTC5B
BT£5C BTE5C BTC5C BT£6 BTE6 BTC6
BT£6A BTE6A BTC6A BT£6B BTE6B BTC6B
BT£6BG BTE6BG BTC6BG BT£6C BTE6C BTC6C
BT£6D BTE6D BTC6D BT£6E BTE6E BTC6E
BT£6F BTE6F BTC6F BT£6G BTE6G BTC6G
BT£6H BTE6H BTC6H BT£6J BTE6J BTC6J
BT£8 BTE8 BTC8 BT£9 BTE9 BTC9
BT£10 BTE10 BTC10 BT£11 BTE11 BTC11
BT£11A BTE11A BTC11A BT£11B BTE11B BTC11B
BT£19 BTE19 BTC19 BT£19A BTE19A BTC19A
BT£19B BTE19B BTC19B BT£19BL BTE19BL BTC19BL
BT£19C BTE19C BTC19C BTE19CA BTC19CA BT£19CB
BTE19CB BTC19CB BT£19CC BTE19CC BTC19CC BT£19CCA
BTE19CCA BTC19CCA BT£19CCB BTE19CCB BTC19CCB BT£19CCC
BTE19CCC BTC19CCC BT£19CD BTE19CD BTC19CD BT£19CDA
BTE19CDA BTC19CDA BT£19CD1 BTE19CD1 BTC19CD1 BT£19CD2
BTE19CD2 BTC19CD2 BT£19CD3 BTE19CD3 BTC19CD3 BT£19CD4
BTE19CD4 BTC19CD4 BT£19CD5 BTE19CD5 BTC19CD5 BT£20
BTE20 BTC20 BT£21 BTE21 BTC21 BT£21A
BTE21A BTC21A BT£21B BTE21B BTC21B BT£22
BTE22 BTC22 BT£22A BTE22A BTC22A BT£22B
BTE22B BTC22B BT£23 BTE23 BTC23 BT£23D
BTE23D BTC23D BT£23DG BTE23DG BTC23DG BT£23E
BTE23E BTC23E BT£23F BTE23F BTC23F BT£23G
BTE23G BTC23G BT£23GA BTE23GA BTC23GA BT£23GB
BTE23GB BTC23GB BT£23GC BTE23GC BTC23GC BT£23H
BTE23H BTC23H BT£23J BTE23J BTC23J BT£23K
BTE23K BTC23K BT£23L BTE23L BTC23L BT£24
BTE24 BT£25 BTE25 BT£26 BTE26 BTC26
BT£26A BTE26A BTC26A BT£26B BTE26B BTC26B
BT£26C BTE26C BTC26C BT£26D BTE26D BTC26D
BT£26E BTE26E BTC26E BT£26EA BTE26EA BTC26EA
BT£26EB BTE26EB BTC26EB BT£26EC BTE26EC BTC26EC
BT£26F BTE26F BTC26F BT£26G BTE26G BTC26G
BT£26GA BTE26GA BTC26GA BT£26GB BTE26GB BTC26GB
BT£27 BTE27 BTC27 BT£29 BTE29 BTC29
BT£29A BTE29A BTC29A BT£29B BTE29B BTC29B
BT£29C BTE29C BTC29C BT£29D BTE29D BTC29D
BT£29E BTE29E BTC29E BT£30 BTE30 BTC30
BT£30A BTE30A BTC30A BT£30B BTE30B BTC30B
BT£30BG BTE30BG BTC30BG BT£30C BTE30C BTC30C
- 31 -
Specification for BEERS (V24) May 2009
BT£30D BTE30D BTC30D BT£30E BTE30E BTC30E
BT£30F BTE30F BTC30F BT£30G BTE30G BTC30G
BT£30H BTE30H BTC30H BT£30J BTE30J BTC30J
BT£32 BTE32 BTC32 BT£32A BTE32A BTC32A
BT£32AA1 BTE32AA1 BTC32AA1 BT£32AA2 BTE32AA2 BTC32AA2
BT£32AB1 BTE32AB1 BTC32AB1 BT£32AB2 BTE32AB2 BTC32AB2
BT£32AC1 BTE32AC1 BTC32AC1 BT£32AC2 BTE32AC2 BTC32AC2
BT£32B BTE32B BTC32B BT£32BA BTE32BA BTC32BA
BT£32BB BTE32BB BTC32BB BT£32BC BTE32BC BTC32BC
BT£32C BTE32C BTC32C BT£32D BTE32D BTC32D
BT£32E BTE32E BTC32E BT£32F BTE32F BTC32F
BT£32G BTE32G BTC32G BT£32H BTE32H BTC32H
BT£32J BTE32J BTC32J BT£32K BTE32K BTC32K
BT£32L BTE32L BTC32L BT£33 BTE33 BTC33
BT£34 BTE34 BTC34 BT£35 BTE35 BTC35
BTC35A BT£35B BTE35B BTC35B BT£35C BTE35C
BTC35C BT£35CA BTE35CA BTC35CA BT£35D BTE35D
BTC35D BT£40 BTE40 BTC40 BT£41 BTE41
BTC41 BT£41A BTE41A BTC41A BT£41B BTE41B
BTC41B BT£41C BTE41C BTC41C BT£41D BTE41D
BTC41D BT£41E BTE41E BTC41E BT£41F BTE41F
BTC41F BT£41G BTE41G BTC41G BT£41H BTE41H
BTC41H BT£41J BTE41J BTC41J BT£41K BTE41K
BTC41K BT£42 BTE42 BTC42 BT£43 BTE43
BTC43 BT£44 BTE44 BT£45A BTE45A BTC45A
BT£45B BTE45B BTC45B BT£45BA BTE45BA BTC45BA
BT£45BB BTE45BB BTC45BB BT£45C BTE45C BTC45C
BT£45CA BTE45CA BTC45CA BT£45CB BTE45CB BTC45CB
BT£45D BTE45D BTC45D BT£46 BT£46A BT£46B
BT£47 BTE47 BT£AA BTEAA BT£AB BTEAB
BT£AC BTEAC BTCAC BT£AD BTEAD BT£AE
BTEAE BT£AF BTEAF BT£AFA BTEAFA BT£AFB
BTEAFB BT£AFC BTEAFC BT£AFD BTEAFD BT£AH
BTEAH BT£AJ BTEAJ BT£AL BTEAL BTCAL
BT£B BTEB BT£BA BTEBA BT£BB BTEBB
BT£BC BTEBC
- 32 -
Specification for BEERS (V24) May 2009
6.10 UK REGISTERED INSTITUTIONS COUNTRY EXPOSURE REPORT
(FORM C1)
The following boxes on the form have been crossed out and should be reported as zeroes:
ENTO, Columns 1.1, 2.1, 2.2, 3.11, 3.12, 4.1, 4.11, 4.12
ONTO, Columns 1.1, 2.1, 2.2, 3.11, 3.12, 4.1, 4.11, 4.12
UKIN, Columns 1, 1.1, 1.2, 1.3, 1.8, 1.9, 1.10, 1.11, 1.12, 1.13, 1.14, 1.15, 1.16, 1.17,
1A, 2.1, 2.2, 5, 6, 4, 4.1, 4.2, 4.3
6.10.1 SAMPLE C1
Full examples of the data files for this form are shown below.
H0403C140001WORL 6
Standard Data Header record for C1 - followed by
Standard Data records: each box represents a 12-character field
C11 C11.1 C11.2 C11.3 C11.8 C11.9
C11.10 C11.11 C11.12 C11.13 C11.14 C11.15
C11.16 C11.17 C1DA C12.1 C12.2 C13.11
C13.12 C13.13 C13.14 C15 C16 C14
C14.1 C14.2 C14.3 C14.11 C14.12 C14.13
C14.14
H0403C140001ENTO
C11 C11.1 C11.2 C11.3 C11.8 C11.9
C11.10 C11.11 C11.12 C11.13 C11.14 C11.15
C11.16 C11.17 C1DA C12.1 C12.2 C13.11
C13.12 C13.13 C13.14 C15 C16 C14
C14.1 C14.2 C14.3 C14.11 C14.12 C14.13
C14.14
H0403C140001ONTO
C11 C11.1 C11.2 C11.3 C11.8 C11.9
C11.10 C11.11 C11.12 C11.13 C11.14 C11.15
C11.16 C11.17 C1DA C12.1 C12.2 C13.11
C13.12 C13.13 C13.14 C15 C16 C14
C14.1 C14.2 C14.3 C14.11 C14.12 C14.13
C14.14
H0403C140001UNAL
C11 C11.1 C11.2 C11.3 C11.8 C11.9
C11.10 C11.11 C11.12 C11.13 C11.14 C11.15
C11.16 C11.17 C1DA C12.1 C12.2 C13.11
C13.12 C13.13 C13.14 C15 C16 C14
C14.1 C14.2 C14.3 C14.11 C14.12 C14.13
C14.14
- 33 -
Specification for BEERS (V24) May 2009
H0403C140001CTOT
C11 C11.1 C11.2 C11.3 C11.8 C11.9
C11.10 C11.11 C11.12 C11.13 C11.14 C11.15
C11.16 C11.17 C1DA C12.1 C12.2 C13.11
C13.12 C13.13 C13.14 C15 C16 C14
C14.1 C14.2 C14.3 C14.11 C14.12 C14.13
C14.14
H040C140001MALD
C11 C11.1 C11.2 C11.3 C11.8 C11.9
C11.10 C11.11 C11.12 C11.13 C11.14 C11.15
C11.16 C11.17 C1DA C12.1 C12.2 C13.11
C13.12 C13.13 C13.14 C15 C16 C14
C14.1 C14.2 C14.3 C14.11 C14.12 C14.13
C14.14
- 34 -
Specification for BEERS (V24) May 2009
6.11 CURRENCY ANALYSIS OF LIABILITIES AND CLAIMS IN
CURRENCIES OTHER THAN STERLING (FORM CA) – UNTIL
SEPTEMBER 2007
Form CA is output in one section with both parts of the form being output under one
header. Therefore each record will consist of 25 data items. The total line is output as
the WORL header record in the normal way.
6.11.1 SAMPLE CA
An example of the data file for form CA is shown below.
H0403CA40001WORL 4
Standard Data Header record for section CA – followed by
Standard Data records: each box represents a 12-character field
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
C2C1 C2C2 C2C3 C2C4 C2C5 C2C6
C2C7 C2C8 C2C9 C2C10 C2C11 C2C12
C2C13
H0403CA40001CANA
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
C2C1 C2C2 C2C3 C2C4 C2C5 C2C6
C2C7 C2C8 C2C9 C2C10 C2C11 C2C12
C2C13
H0403CA40001JAPA
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
C2C1 C2C2 C2C3 C2C4 C2C5 C2C6
C2C7 C2C8 C2C9 C2C10 C2C11 C2C12
C2C13
H0403CA40001EURO
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
C2C1 C2C2 C2C3 C2C4 C2C5 C2C6
C2C7 C2C8 C2C9 C2C10 C2C11 C2C12
C2C13
- 35 -
Specification for BEERS (V24) May 2009
6.12 CURRENCY ANALYSIS OF LIABILITIES AND CLAIMS IN
CURRENCIES OTHER THAN STERLING (FORM CA) – FROM
DECEMBER 2007
Form CA is output in one section with both parts of the form being output under one
header. Therefore each record will consist of 23 data items. The total line is output as
the WORL header record in the normal way.
6.12.1 SAMPLE CA
A full example of the data file for form CA is shown below.
H0712CA40001WORL 5
Standard Data Header record for section CA – followed by
Standard Data records: each box represents a 12-character field
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
CAC1 CAC2 CAC3 CAC4 CAC5 CAC6
CAC7 CAC8 CAC11 CAC12 CAC13
H0712CA40001USA
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
CAC1 CAC2 CAC3 CAC4 CAC5 CAC6
CAC7 CAC8 CAC11 CAC12 CAC13
H0712CA40001JAPA
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
CAC1 CAC2 CAC3 CAC4 CAC5 CAC6
CAC7 CAC8 CAC11 CAC12 CAC13
H0712CA40001SWIT
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
CAC1 CAC2 CAC3 CAC4 CAC5 CAC6
CAC7 CAC8 CAC11 CAC12 CAC13
H0712CA40001OTHC
CAL1 CAL2 CAL3 CAL4 CAL5 CAL6
CAL7 CAL8 CAL9 CAL10 CAL11 CAL12
CAC1 CAC2 CAC3 CAC4 CAC5 CAC6
CAC7 CAC8 CAC11 CAC12 CAC13
- 36 -
Specification for BEERS (V24) May 2009
6.13 COUNTRY ANALYSIS OF UK EXTERNAL CLAIMS (FORM CC) –
UNTIL SEPTEMBER 2007
The form has two sections, part A and part B.
Part A of the form should be treated as a separate section and should be entered as a 4D
form with the Section code CC.
Part B of the form should be treated as a separate section and should be entered as a 3D
form with the Section code CO.
The two sections are concatenated (in the order CC, CO) in a file using the Form code
CC in the filename.
6.13.1 SAMPLE CC
An example of the data file for the form CC follows.
H0403CC40001WORL 6
Standard Data Header record for section CC - followed by
Standard Data records: each box represents a 12-character field
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18 CC19 CC20
CC21 CC22 CC23 CC24
H0403CC40001ENTO
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18 CC19 CC20
CC21 CC22 CC23 CC24
- 37 -
Specification for BEERS (V24) May 2009
H0403CC40001ONTO
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18 CC19 CC20
CC21 CC22 CC23 CC24
H0403CC40001UNAL
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18 CC19 CC20
CC21 CC22 CC23 CC24
H0403CC40001CTOT
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18 CC19 CC20
CC21 CC22 CC23 CC24
- 38 -
Specification for BEERS (V24) May 2009
H0403CC40001ABUD
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18 CC19 CC20
CC21 CC22 CC23 CC24
6.13.2 SAMPLE CO (Part B)
An example of the data file for form CO is shown below.
H0403CO30001
Standard Data Header record for section CO - followed by
Standard Data records: each box represents a 12-character field
COBTOT COBTOT1 COBTOT2 COBTOT3 COBTOT4 COBTOT5
COBTOT6
- 39 -
Specification for BEERS (V24) May 2009
6.14 COUNTRY ANALYSIS OF UK EXTERNAL CLAIMS (FORM CC) – FROM
DECEMBER 2007
The form has three sections, A, B and C.
Part A of the form should be treated as a separate section and should be entered as a 4D
form with the Section code CC.
Parts B and C of the form should be treated as a combined 3D section and sent in under
the Section code CO.
The two sections are concatenated (in the order CC, CO) in a file using the Form code
CC in the filename.
6.14.1 SAMPLE CC
An example of the data file for the form CC follows.
H0712CC40001WORL 6
Standard Data Header record for section CC - followed by
Standard Data records: each box represents a 12-character field
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18
H0712CC40001ENTO
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18
H0712CC40001ONTO
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
- 40 -
Specification for BEERS (V24) May 2009
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18
H0712CC40001UNAL
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18
H0712CC40001CTOT
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18
H0712CC40001ABUD
CC1 CC2 CC3 CC4 CC5 CC6
CC15 CC1AA CC2AA CC3AA CC4AA CC1BA
CC2BA CC3BA CC4BA CC1AB CC2AB CC3AB
CC4AB CC1BB CC2BB CC3BB CC4BB CC1AD
CC2AD CC3AD CC4AD CC1BD CC2BD CC3BD
CC4BD CC1AE CC2AE CC3AE CC4AE CC1BE
CC2BE CC3BE CC4BE CC1AL CC2AL CC3AL
CC4AL CC1BL CC2BL CC3BL CC4BL CC1AM
CC2AM CC3AM CC4AM CC1BM CC2BM CC3BM
CC4BM CC16 CC17 CC18
- 41 -
Specification for BEERS (V24) May 2009
6.14.2 SAMPLE CO (Parts B and C)
An example of the data file for form CO is shown below.
H0712CO30001
Standard Data Header record for section CO - followed by
Standard Data records: each box represents a 12-character field
CO£ML COEML COCML CO£NRO COENRO COCNRO
CO£NRC COENRC COCNRC CO£ONR COEONR COCONR
CO£DI COEDI COCDI CO£SO COESO COCSO
CO£AS COEAS COCAS
- 42 -
Specification for BEERS (V24) May 2009
6.15 UK-OWNED BANKING GROUPS EXPOSURE REPORT (FORM CE)
6.15.1 SAMPLE CE
H0403CE40001WORL 6
Standard Data Header record for CE - followed by
Standard Data records: each box represents a 12-character field
CE1 CE1.1 CE1.2 CE1.3 CE2 CE2.1
CE2.2 CE2.3 CE3.1 CE3.2 CE3.3 CE3.4
CE3.5 CE3.6 CE3.7 CE3.8 CE3.9 CE3.10
CE4 CE4.1 CE4.2 CE4.3 CE5 CE6.11
CE6.12 CE6.21 CE6.22 CE6.31 CE6.32 CE7.11
CE7.12 CE7.21 CE7.22 CE7.31 CE7.32 CE8
CE8.1 CE8.2 CE9 CE9.1 CE9.2 CE10
CE10.1 CE10.2 CE11 CE12
H0403CE40001ENTO
CE1 CE1.1 CE1.2 CE1.3 CE2 CE2.1
CE2.2 CE2.3 CE3.1 CE3.2 CE3.3 CE3.4
CE3.5 CE3.6 CE3.7 CE3.8 CE3.9 CE3.10
CE4 CE4.1 CE4.2 CE4.3 CE5 CE6.11
CE6.12 CE6.21 CE6.22 CE6.31 CE6.32 CE7.11
CE7.12 CE7.21 CE7.22 CE7.31 CE7.32 CE8
CE8.1 CE8.2 CE9 CE9.1 CE9.2 CE10
CE10.1 CE10.2 CE11 CE12
H0403CE40001ONTO
CE1 CE1.1 CE1.2 CE1.3 CE2 CE2.1
CE2.2 CE2.3 CE3.1 CE3.2 CE3.3 CE3.4
CE3.5 CE3.6 CE3.7 CE3.8 CE3.9 CE3.10
CE4 CE4.1 CE4.2 CE4.3 CE5 CE6.11
CE6.12 CE6.21 CE6.22 CE6.31 CE6.32 CE7.11
CE7.12 CE7.21 CE7.22 CE7.31 CE7.32 CE8
CE8.1 CE8.2 CE9 CE9.1 CE9.2 CE10
CE10.1 CE10.2 CE11 CE12
H0403CE40001UNAL
CE1 CE1.1 CE1.2 CE1.3 CE2 CE2.1
CE2.2 CE2.3 CE3.1 CE3.2 CE3.3 CE3.4
CE3.5 CE3.6 CE3.7 CE3.8 CE3.9 CE3.10
CE4 CE4.1 CE4.2 CE4.3 CE5 CE6.11
CE6.12 CE6.21 CE6.22 CE6.31 CE6.32 CE7.11
CE7.12 CE7.21 CE7.22 CE7.31 CE7.32 CE8
CE8.1 CE8.2 CE9 CE9.1 CE9.2 CE10
CE10.1 CE10.2 CE11 CE12
- 43 -
Specification for BEERS (V24) May 2009
H0403CE40001CTOT
CE1 CE1.1 CE1.2 CE1.3 CE2 CE2.1
CE2.2 CE2.3 CE3.1 CE3.2 CE3.3 CE3.4
CE3.5 CE3.6 CE3.7 CE3.8 CE3.9 CE3.10
CE4 CE4.1 CE4.2 CE4.3 CE5 CE6.11
CE6.12 CE6.21 CE6.22 CE6.31 CE6.32 CE7.11
CE7.12 CE7.21 CE7.22 CE7.31 CE7.32 CE8
CE8.1 CE8.2 CE9 CE9.1 CE9.2 CE10
CE10.1 CE10.2 CE11 CE12
H040CE40001AUSL
CE1 CE1.1 CE1.2 CE1.3 CE2 CE2.1
CE2.2 CE2.3 CE3.1 CE3.2 CE3.3 CE3.4
CE3.5 CE3.6 CE3.7 CE3.8 CE3.9 CE3.10
CE4 CE4.1 CE4.2 CE4.3 CE5 CE6.11
CE6.12 CE6.21 CE6.22 CE6.31 CE6.32 CE7.11
CE7.12 CE7.21 CE7.22 CE7.31 CE7.32 CE8
CE8.1 CE8.2 CE9 CE9.1 CE9.2 CE10
CE10.1 CE10.2 CE11 CE12
- 44 -
Specification for BEERS (V24) May 2009
6.16 COUNTRY ANALYSIS OF UK EXTERNAL LIABILITIES (FORM CL) –
UNTIL SEPTEMBER 2007
This form is made up of three sections, Part A, Part B and Part C.
Part A of the form is output as a 4D data record with the Section code of CL. Parts B and
C of the form should be treated as a combined 3D section and sent in under the Section
code CS. The two sections are still to be concatenated (in the order CL, CS) in a file
using form code CL in the filename.
6.16.1 SAMPLE CL
An example of the data file for the form CL follows.
H0512CL40001WORL 7
Standard Data Header record for section CL - followed by
Standard Data records: each box represents a 12-character field
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0512CL40001ENTO
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0512CL40001ONTO
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0512CL40001UNAL
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0512CL40001CTOT
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0512CL40001BELG
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
- 45 -
Specification for BEERS (V24) May 2009
H0512CL40001SWED
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
6.16.2 SAMPLE CS
An example of the data file for form CS follows.
H0512CS30001
Standard Data Header record for section CS - followed by
Standard Data records: each box represents a 12-character field
CS£B1.1 CSEB2.1 CS£B1.2 CSEB2.2 CS£B1.3 CSEB2.3
CS£B1 CSEB2 CS£C1.1 CSEC2.1 CSCC3.1 CS£C1.2
CSEC2.2
- 46 -
Specification for BEERS (V24) May 2009
6.17 COUNTRY ANALYSIS OF UK EXTERNAL LIABILITIES (FORM CL) –
FROM DECEMBER 2007
This form is made up of three sections, Part A, Part B and Part C.
Part A of the form is output as a 4D data record with the Section code of CL. Parts B and
C of the form should be treated as a combined 3D section and sent in under the Section
code CS. The two sections are still to be concatenated (in the order CL, CS) in a file
using form code CL in the filename.
6.17.1 SAMPLE CL
An example of the data file for the form CL follows.
H0712CL40001WORL 7
Standard Data Header record for section CL - followed by
Standard Data records: each box represents a 12-character field
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0712CL40001ENTO
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0712CL40001ONTO
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0712CL40001UNAL
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0712CL40001CTOT
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
H0712CL40001BELG
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
- 47 -
Specification for BEERS (V24) May 2009
H0712CL40001SWED
CL1 CL1AA CL1BA CL1AB CL1BB CL1AD
CL1BD CL1AE CL1BE CL1AL CL1BL CL1AM
CL1BM CLA1 CLA2 CL2 CL3 CL4
CL5
6.17.2 SAMPLE CS
An example of the data file for form CS follows.
H0712CS30001
Standard Data Header record for section CS - followed by
Standard Data records: each box represents a 12-character field
CS£B1 CSEB1 CSCB1 CS£B2 CSEB2 CSCB2
CS£C1.1 CSEC2.1 CSCC3.1 CS£C1.2 CSEC2.2
- 48 -
Specification for BEERS (V24) May 2009
6.18 CAPITAL EXPENDITURE AND FINANCE LEASING DATA (FORM CX) –
FROM DECEMBER 2007
Form CX is created as a standard 3D form.
6.18.1 SAMPLE CX
H0712CX30001
Standard Data Header record for section CX – followed by
Standard Data records: each box represents a 12-character field
CX£1 CXE1 CXC1 CX£2 CXE2 CXC2
CX£3 CXE3 CXC3 CX£4 CXE4 CXC4
CX£5 CXE5 CXC5 CX£6 CXE6 CXC6
CX£6A CXE6A CXC6A CX£6B CXE6B CXC6B
CX£6B1 CXE6B1 CXC6B1 CX£6B2 CXE6B2 CXC6B2
CX£6B3 CXE6B3 CXC6B3 CX£7 CXE7 CXC7
CX£7A CXE7A CXC7A CX£8 CXE8 CXC8
CX£9 CXE9 CXC9 CX£10 CXE10 CXC10
CX£11 CXE11 CXC11 CX£12 CXE12 CXC12
CX£12A CXE12A CXC12A CX£12B CXE12B CXC12B
CX£12C CXE12C CXC12C CX£12D CXE12D CXC12D
CX£12E CXE12E CXC12E CX£12F CXE12F CXC12F
CX£12G CXE12G CXC12G CX£12H CXE12H CXC12H
CX£12J CXE12J CXC12J CX£12K CXE12K CXC12K
CX£12L CXE12L CXC12L CX£12M CXE12M CXC12M
CX£12N CXE12N CXC12N CX£12O CXE12O CXC12O
- 49 -
Specification for BEERS (V24) May 2009
6.19 TOTAL DERIVATIVES BUSINESS IN BANKS’ TRADING AND
BANKING BOOKS (FORM DQ) – UNTIL SEPTEMBER 2007
Form DQ is created as five separate sections.
The first section is a 3D section and consists of all the items in section 1. This is output
under section code DQ.
The second section is a 3D section and consists of all the items in section 2. This is is
output under section code DR.
The third section is a 3D section and consists of all the items from section 3 and section
4. This is output under section code DS.
The fourth section is a 4D section and consists of section 5. This is output under section
code DT.
The fifth section is a 4D section and consists of section 6. This is output under the
section code DU.
The five sections are to be concatenated (in the order DQ,DR,DS, DT, DU) in a file using
form code DQ in the filename.
6.19.1 SAMPLE DQ
H0403DQ30001
Standard Data Header record for section DQ - followed by
Standard Data records: each box represents a 12-character field
DQ£1 DQE1 DQC1 DQ£1A DQE1A DQC1A
DQ£1B DQE1B DQC1B DQ£1C DQE1C DQC1C
DQ£1D DQ£E1D DQC1D DQ£1E DQE1E DQC1E
DQ£1F DQE1F DQC1F DQ£1G DQE1G DQC1G
DQ£1H DQE1H DQC1H DQ£1J DQE1J DQC1J
DQ£1K DQE1K DQC1K DQ£1L DQE1L DQC1L
DQ£1M DQE1M DQC1M DQ£1N DQE1N DQC1N
DQ£2 DQE2 DQC2 DQ£2A DQE2A DQC2A
DQ£2B DQE2B DQC2B DQ£2C DQE2C DQC2C
DQ£2D DQE2D DQC2D DQ£2E DQE2E DQC2E
DQ£2F DQE2F DQC2F DQ£2G DQE2G DQC2G
DQ£2H DQE2H DQC2H DQ£2J DQE2J DQC2J
DQ£2K DQE2K DQC2K DQ£2L DQE2L DQC2L
DQ£2M DQE2M DQC2M DQ£2N DQE2N DQC2N
- 50 -
Specification for BEERS (V24) May 2009
6.19.2 SAMPLE DR
H0403DR30001
Standard Data Header record for section DR - followed by
Standard Data records: each box represents a 12-character field
DR£3 DRE3 DRC3 DR£3A DRE3A DRC3A
DR£3B DRE3B DRC3B DR£3C DRE3C DRC3C
DR£3D DRE3D DRC3D DR£3E DRE3E DRC3E
DR£3F DRE3F DRC3F DR£3G DRE3G DRC3G
DR£3H DRE3H DRC3H DR£3J DRE3J DRC3J
DR£3K DRE3K DRC3K DR£3L DRE3L DRC3L
DR£3M DRE3M DRC3M DR£3N DRE3N DRC3N
DR£4 DRE4 DRC4 DR£4A DRE4A DRC4A
DR£4B DRE4B DRC4B DR£4C DRE4C DRC4C
DR£4D DRE4D DRC4D DR£4E DRE4E DRC4E
DR£4F DRE4F DRC4F DR£4G DRE4G DRC4G
DR£4H DRE4H DRC4H DR£4J DRE4J DRC4J
DR£4K DRE4K DRC4K DR£4L DRE4L DRC4L
DR£4M DRE4M DRC4M DR£4N DRE4N DRC4N
DR£5 DRE5 DRC5 DR£5A DRE5A DRC5A
DR£5B DRE5B DRC5B DR£5C DRE5C DRC5C
DR£5D DRE5D DRC5D DR£5E DRE5E DRC5E
DR£5F DRE5F DRC5F DR£5G DRE5G DRC5G
DR£5H DRE5H DRC5H DR£5J DRE5J DRC5J
DR£5K DRE5K DRC5K DR£5L DRE5L DRC5L
DR£5M DRE5M DRC5M DR£5N DRE5N DRC5N
DR£6 DRE6 DRC6 DR£6A DRE6A DRC6A
DR£6B DRE6B DRC6B DR£6C DRE6C DRC6C
DR£6D DRE6D DRC6D DR£6E DRE6E DRC6E
DR£6F DRE6F DRC6F DR£6G DRE6G DRC6G
DR£6H DRE6H DRC6H DR£6J DRE6J DRC6J
DR£6K DRE6K DRC6K DR£6L DRE6L DRC6L
DR£6M DRE6M DRC6M DR£6N DRE6N DRC6N
DR£7 DRE7 DRC7 DR£7A DRE7A DRC7A
DR£7B DRE7B DRC7B DR£7C DRE7C DRC7C
DR£7D DRE7D DRC7D DR£7E DRE7E DRC7E
DR£7F DRE7F DRC7F DR£7G DRE7G DRC7G
DR£7H DRE7H DRC7H DR£7J DRE7J DRC7J
DR£7K DRE7K DRC7K DR£7L DRE7L DRC7L
DR£7M DRE7M DRC7M DR£7N DRE7N DRC7N
DR£10 DRE10 DRC10 DR£10A DRE10A DRC10A
DR£10B DRE10B DRC10B DR£10C DRE10C DRC10C
DR£10D DRE10D DRC10D DR£10E DRE10E DRC10E
- 51 -
Specification for BEERS (V24) May 2009
DR£10F DRE10F DRC10F DR£10G DRE10G DRC10G
DR£10H DRE10H DRC10H DR£10J DRE10J DRC10J
DR£10K DRE10K DRC10K DR£10L DRE10L DRC10L
DR£10M DRE10M DRC10M DR£10N DRE10N DRC10N
DR£11 DRE11 DRC11 DR£11A DRE11A DRC11A
DR£11B DRE11B DRC11B DR£11C DRE11C DRC11C
DR£11D DRE11D DRC11D DR£11E DRE11E DRC11E
DR£11F DRE11F DRC11F DR£11G DRE11G DRC11G
DR£11H DRE11H DRC11H DR£11J DRE11J DRC11J
DR£11K DRE11K DRC11K DR£11L DRE11L DRC11L
DR£11M DRE11M DRC11M DR£11N DRE11N DRC11N
DR£12 DRE12 DRC12 DR£12A DRE12A DRC12A
DR£12B DRE12B DRC12B DR£12C DRE12C DRC12C
DR£12D DRE12D DRC12D DR£12E DRE12E DRC12E
DR£12F DRE12F DRC12F DR£12G DRE12G DRC12G
DR£12H DRE12H DRC12H DR£12J DRE12J DRC12J
DR£12K DRE12K DRC12K DR£12L DRE12L DRC12L
DR£12M DRE12M DRC12M DR£12N DRE12N DRC12N
DR£13 DRE13 DRC13 DR£13A DRE13A DRC13A
DR£13B DRE13B DRC13B DR£13C DRE13C DRC13C
DR£13D DRE13D DRC13D DR£13E DRE13E DRC13E
DR£13F DRE13F DRC13F DR£13G DRE13G DRC13G
DR£13H DRE13H DRC13H DR£13J DRE13J DRC13J
DR£13K DRE13K DRC13K DR£13L DRE13L DRC13L
DR£13M DRE13M DRC13M DR£13N DRE13N DRC13N
DR£14 DRE14 DRC14 DR£14A DRE14A DRC14A
DR£14B DRE14B DRC14B DR£14C DRE14C DRC14C
DR£14D DRE14D DRC14D DR£14E DRE14E DRC14E
DR£14F DRE14F DRC14F DR£14G DRE14G DRC14G
DR£14H DRE14H DRC14H DR£14J DRE14J DRC14J
DR£14K DRE14K DRC14K DR£14L DRE14L DRC14L
DR£14M DRE14M DRC14M DR£14N DRE14N DRC14N
DR£17 DRE17 DRC17 DR£17A DRE17A DRC17A
DR£17B DRE17B DRC17B DR£17C DRE17C DRC17C
DR£17D DRE17D DRC17D DR£17E DRE17E DRC17E
DR£17F DRE17F DRC17F DR£17G DRE17G DRC17G
DR£17H DRE17H DRC17H DR£17J DRE17J DRC17J
DR£17K DRE17K DRC17K DR£17L DRE17L DRC17L
DR£17M DRE17M DRC17M DR£17N DRE17N DRC17N
DR£18 DRE18 DRC18 DR£18A DRE18A DRC18A
DR£18B DRE18B DRC18B DR£18C DRE18C DRC18C
DR£18D DRE18D DRC18D DR£18E DRE18E DRC18E
- 52 -
Specification for BEERS (V24) May 2009
DR£18F DRE18F DRC18F DR£18G DRE18G DRC18G
DR£18H DRE18H DRC18H DR£18J DRE18J DRC18J
DR£18K DRE18K DRC18K DR£18L DRE18L DRC18L
DR£18M DRE18M DRC18M DR£18N DRE18N DRC18N
DR£19 DRE19 DRC19 DR£19A DRE19A DRC19A
DR£19B DRE19B DRC19B DR£19C DRE19C DRC19C
DR£19D DRE19D DRC19D DR£19E DRE19E DRC19E
DR£19F DRE19F DRC19F DR£19G DRE19G DRC19G
DR£19H DRE19H DRC19H DR£19J DRE19J DRC19J
DR£19K DRE19K DRC19K DR£19L DRE19L DRC19L
DR£19M DRE19M DRC19M DR£19N DRE19N DRC19N
DR£20 DRE20 DRC20 DR£20A DRE20A DRC20A
DR£20B DRE20B DRC20B DR£20C DRE20C DRC20C
DR£20D DRE20D DRC20D DR£20E DRE20E DRC20E
DR£20F DRE20F DRC20F DR£20G DRE20G DRC20G
DR£20H DRE20H DRC20H DR£20J DRE20J DRC20J
DR£20K DRE20K DRC20K DR£20L DRE20L DRC20L
DR£20M DRE20M DRC20M DR£20N DRE20N DRC20N
DR£24 DRE24 DRC24 DR£24A DRE24A DRC24A
DR£24B DRE24B DRC24B DR£24C DRE24C DRC24C
DR£24D DRE24D DRC24D DR£24E DRE24E DRC24E
DR£24F DRE24F DRC24F DR£24G DRE24G DRC24G
DR£24H DRE24H DRC24H DR£24J DRE24J DRC24J
DR£24K DRE24K DRC24K DR£24L DRE24L DRC24L
DR£24M DRE24M DRC24M DR£24N DRE24N DRC24N
DR£25 DRE25 DRC25 DR£25A DRE25A DRC25A
DR£25B DRE25B DRC25B DR£25C DRE25C DRC25C
DR£25D DRE25D DRC25D DR£25E DRE25E DRC25E
DR£25F DRE25F DRC25F DR£25G DRE25G DRC25G
DR£25H DRE25H DRC25H DR£25J DRE25J DRC25J
DR£25K DRE25K DRC25K DR£25L DRE25L DRC25L
DR£25M DRE25M DRC25M DR£25N DRE25N DRC25N
DR£26 DRE26 DRC26 DR£26A DRE26A DRC26A
DR£26B DRE26B DRC26B DR£26C DRE26C DRC26C
DR£26D DRE26D DRC26D DR£26E DRE26E DRC26E
DR£26F DRE26F DRC26F DR£26G DRE26G DRC26G
DR£26H DRE26H DRC26H DR£26J DRE26J DRC26J
DR£26K DRE26K DRC26K DR£26L DRE26L DRC26L
DR£26M DRE26M DRC26M DR£26N DRE26N DRC26N
DR£27 DRE27 DRC27 DR£27A DRE27A DRC27A
DR£27B DRE27B DRC27B DR£27C DRE27C DRC27C
DR£27D DRE27D DRC27D DR£27E DRE27E DRC27E
- 53 -
Specification for BEERS (V24) May 2009
DR£27F DRE27F DRC27F DR£27G DRE27G DRC27G
DR£27H DRE27H DRC27H DR£27J DRE27J DRC27J
DR£27K DRE27K DRC27K DR£27L DRE27L DRC27L
DR£27M DRE27M DRC27M DR£27N DRE27N DRC27N
DR£31 DRE31 DRC31 DR£31A DRE31A DRC31A
DR£31B DRE31B DRC31B DR£31C DRE31C DRC31C
DR£31D DRE31D DRC31D DR£31E DRE31E DRC31E
DR£31F DRE31F DRC31F DR£31G DRE31G DRC31G
DR£31H DRE31H DRC31H DR£31J DRE31J DRC31J
DR£31K DRE31K DRC31K DR£31L DRE31L DRC31L
DR£31M DRE31M DRC31M DR£31N DRE31N DRC31N
DR£32 DRE32 DRC32 DR£32A DRE32A DRC32A
DR£32B DRE32B DRC32B DR£32C DRE32C DRC32C
DR£32D DRE32D DRC32D DR£32E DRE32E DRC32E
DR£32F DRE32F DRC32F DR£32G DRE32G DRC32G
DR£32H DRE32H DRC32H DR£32J DRE32J DRC32J
DR£32K DRE32K DRC32K DR£32L DRE32L DRC32L
DR£32M DRE32M DRC32M DR£32N DRE32N DRC32N
DR£38 DRE38 DRC38 DR£38A DRE38A DRC38A
DR£38B DRE38B DRC38B DR£38C DRE38C DRC38C
DR£38D DRE38D DRC38D DR£38E DRE38E DRC38E
DR£38F DRE38F DRC38F DR£38G DRE38G DRC38G
DR£38H DRE38H DRC38H DR£38J DRE38J DRC38J
DR£38K DRE38K DRC38K DR£38L DRE38L DRC38L
DR£38M DRE38M DRC38M DR£38N DRE38N DRC38N
DR£39 DRE39 DRC39 DR£39A DRE39A DRC39A
DR£39B DRE39B DRC39B DR£39C DRE39C DRC39C
DR£39D DRE39D DRC39D DR£39E DRE39E DRC39E
DR£39F DRE39F DRC39F DR£39G DRE39G DRC39G
DR£39H DRE39H DRC39H DR£39J DRE39J DRC39J
DR£39K DRE39K DRC39K DR£39L DRE39L DRC39L
DR£39M DRE39M DRC39M DR£39N DRE39N DRC39N
- 54 -
Specification for BEERS (V24) May 2009
6.19.3 SAMPLE DS
H0403DS30001
Standard Data Header record for section DS - followed by
Standard Data records: each box represents a 12-character field
DQ£60 DQE60 DQC60 DQ£60A DQE60A DQC60A
DQ£60B DQE60B DQC60B DQ£60C DQE60C DQC60C
DQ£61 DQE61 DQC61 DQ£61A DQE61A DQC61A
DQ£61B DQE61B DQC61B DQ£61C DQE61C DQC61C
DQ£62 DQE62 DQC62 DQ£62A DQE62A DQC62A
DQ£62B DQE62B DQC62B DQ£62C DQE62C DQC62C
DQ£63 DQE63 DQC63 DQ£63A DQE63A DQC63A
DQ£63B DQE63B DQC63B DQ£63C DQE63C DQC63C
DQ£64 DQE64 DQC64 DQ£64A DQE64A DQC64A
DQ£64B DQE64B DQC64B DQ£64C DQE64C DQC64C
DQ£65 DQE65 DQC65 DQ£65A DQE65A DQC65A
DQ£65B DQE65B DQC65B DQ£65C DQE65C DQC65C
DQ£68 DQE68 DQC68 DQ£68A DQE68A DQC68A
DQ£68B DQE68B DQC68B DQ£68C DQE68C DQC68C
DQ£69 DQE69 DQC69 DQ£69A DQE69A DQC69A
DQ£69B DQE69B DQC69B DQ£69C DQE69C DQC69C
DQ£70 DQE70 DQC70 DQ£70A DQE70A DQC70A
DQ£70B DQE70B DQC70B DQ£70C DQE70C DQC70C
DQ£71 DQE71 DQC71 DQ£71A DQE71A DQC71A
DQ£71B DQE71B DQC71B DQ£71C DQE71C DQC71C
DQ£72 DQE72 DQC72 DQ£72A DQE72A DQC72A
DQ£72B DQE72B DQC72B DQ£72C DQE72C DQC72C
DQ£73 DQE73 DQC73 DQ£73A DQE73A DQC73A
DQ£73B DQE73B DQC73B DQ£73C DQE73C DQC73C
DQ£79 DQE79 DQC79 DQ£79A DQE79A DQC79A
DQ£79B DQE79B DQC79B DQ£79C DQE79C DQC79C
DQ£79D DQE79D DQC79D DQ£80 DQE80 DQC80
DQ£80A DQE80A DQC80A DQ£80B DQE80B DQC80B
DQ£80C DQE80C DQC80C DQ£80D DQE80D DQC80D
DQ£81 DQE81 DQC81 DQ£81A DQE81A DQC81A
DQ£81B DQE81B DQC81B DQ£81C DQE81C DQC81C
DQ£81D DQE81D DQC81D DQ£82 DQE82 DQC82
DQ£82A DQE82A DQC82A DQ£82B DQE82B DQC82B
DQ£82C DQE82C DQC82C DQ£82D DQE82D DQC82D
DQ£83A DQE83A DQC83A DQ£84 DQE84 DQC84
DQ£84A DQE84A DQC84A DQ£84B DQE84B DQC84B
DQ£84C DQE84C DQC84C DQ£84D DQE84D DQC84D
DQ£85 DQE85 DQC85 DQ£85A DQE85A DQC85A
DQ£85B DQE85B DQC85B DQ£85C DQE85C DQC85C
- 55 -
Specification for BEERS (V24) May 2009
DQ£85D DQE85D DQC85D DQ£85AA DQE85AA DQC85AA
DQ£85AB DQE85AB DQC85AB
6.19.4 SAMPLE DT
H0403DT40001WORL 7
Standard Data Header record for section DT - followed by
Standard Data records: each box represents a 12-character field
DT£L DTEL DTCL DT£C DTEC DTCC
H0403DT40001ENTO
DT£L DTEL DTCL DT£C DTEC DTCC
H0403DT40001ONTO
DT£L DTEL DTCL DT£C DTEC DTCC
H0403DT40001UNAL
DT£L DTEL DTCL DT£C DTEC DTCC
H0403DT40001CTOT
DT£L DTEL DTCL DT£C DTEC DTCC
H0403DT40001ABUD
DT£L DTEL DTCL DT£C DTEC DTCC
H0403DT40001USA
DT£L DTEL DTCL DT£C DTEC DTCC
6.19.5 SAMPLE DU
H0403DU40001WORL 3
Standard Data Header record for section DU - followed by
Standard Data records: each box represents a 12-character field
COL1 COL2 COL3 COL4 COL5 COL6
H0403DU40001USA
COL1 COL2 COL3 COL4 COL5 COL6
H0403DU40001AUSL
COL1 COL2 COL3 COL4 COL5 COL6
- 56 -
Specification for BEERS (V24) May 2009
6.20 TOTAL DERIVATIVES BUSINESS IN BANKS’ TRADING AND
BANKING BOOKS (FORM DQ) – FROM DECEMBER 2007
Form DQ is created as three separate sections.
The first section is a 3D section and consists of all the items in section 1. This is output
under section code DQ.
The second section is a 3D section and consists of all the items in section 2. This is is
output under section code DR.
The third section is a 4D section and consists of section 3. This is output under section
code DT.
The three sections are to be concatenated (in the order DQ, DR, DT) in a file using form
code DQ in the filename.
6.20.1 SAMPLE DQ
H0712DQ30001
Standard Data Header record for section DQ - followed by
Standard Data records: each box represents a 12-character field
DQ£1 DQE1 DQC1 DQ£1A DQE1A DQC1A
DQ£1B DQE1B DQC1B DQ£1C DQE1C DQC1C
DQ£1D DQ£E1D DQC1D DQ£1E DQE1E DQC1E
DQ£1F DQE1F DQC1F DQ£1G DQE1G DQC1G
DQ£1H DQE1H DQC1H DQ£1J DQE1J DQC1J
DQ£1K DQE1K DQC1K DQ£1L DQE1L DQC1L
DQ£1M DQE1M DQC1M DQ£1N DQE1N DQC1N
DQ£2 DQE2 DQC2 DQ£2A DQE2A DQC2A
DQ£2B DQE2B DQC2B DQ£2C DQE2C DQC2C
DQ£2D DQE2D DQC2D DQ£2E DQE2E DQC2E
DQ£2F DQE2F DQC2F DQ£2G DQE2G DQC2G
DQ£2H DQE2H DQC2H DQ£2J DQE2J DQC2J
DQ£2K DQE2K DQC2K DQ£2L DQE2L DQC2L
DQ£2M DQE2M DQC2M DQ£2N DQE2N DQC2N
6.20.2 SAMPLE DR
H0712DR30001
Standard Data Header record for section DR - followed by
Standard Data records: each box represents a 12-character field
DR£3 DRE3 DRC3 DR£3A DRE3A DRC3A
DR£3B DRE3B DRC3B DR£3C DRE3C DRC3C
DR£3D DRE3D DRC3D DR£3E DRE3E DRC3E
DR£3F DRE3F DRC3F DR£3G DRE3G DRC3G
- 57 -
Specification for BEERS (V24) May 2009
DR£3H DRE3H DRC3H DR£3J DRE3J DRC3J
DR£3K DRE3K DRC3K DR£3L DRE3L DRC3L
DR£3M DRE3M DRC3M DR£3N DRE3N DRC3N
DR£4 DRE4 DRC4 DR£4A DRE4A DRC4A
DR£4B DRE4B DRC4B DR£4C DRE4C DRC4C
DR£4D DRE4D DRC4D DR£4E DRE4E DRC4E
DR£4F DRE4F DRC4F DR£4G DRE4G DRC4G
DR£4H DRE4H DRC4H DR£4J DRE4J DRC4J
DR£4K DRE4K DRC4K DR£4L DRE4L DRC4L
DR£4M DRE4M DRC4M DR£4N DRE4N DRC4N
DR£5 DRE5 DRC5 DR£5A DRE5A DRC5A
DR£5B DRE5B DRC5B DR£5C DRE5C DRC5C
DR£5D DRE5D DRC5D DR£5E DRE5E DRC5E
DR£5F DRE5F DRC5F DR£5G DRE5G DRC5G
DR£5H DRE5H DRC5H DR£5J DRE5J DRC5J
DR£5K DRE5K DRC5K DR£5L DRE5L DRC5L
DR£5M DRE5M DRC5M DR£5N DRE5N DRC5N
DR£6 DRE6 DRC6 DR£6A DRE6A DRC6A
DR£6B DRE6B DRC6B DR£6C DRE6C DRC6C
DR£6D DRE6D DRC6D DR£6E DRE6E DRC6E
DR£6F DRE6F DRC6F DR£6G DRE6G DRC6G
DR£6H DRE6H DRC6H DR£6J DRE6J DRC6J
DR£6K DRE6K DRC6K DR£6L DRE6L DRC6L
DR£6M DRE6M DRC6M DR£6N DRE6N DRC6N
DR£7 DRE7 DRC7 DR£7A DRE7A DRC7A
DR£7B DRE7B DRC7B DR£7C DRE7C DRC7C
DR£7D DRE7D DRC7D DR£7E DRE7E DRC7E
DR£7F DRE7F DRC7F DR£7G DRE7G DRC7G
DR£7H DRE7H DRC7H DR£7J DRE7J DRC7J
DR£7K DRE7K DRC7K DR£7L DRE7L DRC7L
DR£7M DRE7M DRC7M DR£7N DRE7N DRC7N
DR£10 DRE10 DRC10 DR£10A DRE10A DRC10A
DR£10B DRE10B DRC10B DR£10C DRE10C DRC10C
DR£10D DRE10D DRC10D DR£10E DRE10E DRC10E
DR£10F DRE10F DRC10F DR£10G DRE10G DRC10G
DR£10H DRE10H DRC10H DR£10J DRE10J DRC10J
DR£10K DRE10K DRC10K DR£10L DRE10L DRC10L
DR£10M DRE10M DRC10M DR£10N DRE10N DRC10N
DR£11 DRE11 DRC11 DR£11A DRE11A DRC11A
DR£11B DRE11B DRC11B DR£11C DRE11C DRC11C
DR£11D DRE11D DRC11D DR£11E DRE11E DRC11E
DR£11F DRE11F DRC11F DR£11G DRE11G DRC11G
- 58 -
Specification for BEERS (V24) May 2009
DR£11H DRE11H DRC11H DR£11J DRE11J DRC11J
DR£11K DRE11K DRC11K DR£11L DRE11L DRC11L
DR£11M DRE11M DRC11M DR£11N DRE11N DRC11N
DR£12 DRE12 DRC12 DR£12A DRE12A DRC12A
DR£12B DRE12B DRC12B DR£12C DRE12C DRC12C
DR£12D DRE12D DRC12D DR£12E DRE12E DRC12E
DR£12F DRE12F DRC12F DR£12G DRE12G DRC12G
DR£12H DRE12H DRC12H DR£12J DRE12J DRC12J
DR£12K DRE12K DRC12K DR£12L DRE12L DRC12L
DR£12M DRE12M DRC12M DR£12N DRE12N DRC12N
DR£13 DRE13 DRC13 DR£13A DRE13A DRC13A
DR£13B DRE13B DRC13B DR£13C DRE13C DRC13C
DR£13D DRE13D DRC13D DR£13E DRE13E DRC13E
DR£13F DRE13F DRC13F DR£13G DRE13G DRC13G
DR£13H DRE13H DRC13H DR£13J DRE13J DRC13J
DR£13K DRE13K DRC13K DR£13L DRE13L DRC13L
DR£13M DRE13M DRC13M DR£13N DRE13N DRC13N
DR£14 DRE14 DRC14 DR£14A DRE14A DRC14A
DR£14B DRE14B DRC14B DR£14C DRE14C DRC14C
DR£14D DRE14D DRC14D DR£14E DRE14E DRC14E
DR£14F DRE14F DRC14F DR£14G DRE14G DRC14G
DR£14H DRE14H DRC14H DR£14J DRE14J DRC14J
DR£14K DRE14K DRC14K DR£14L DRE14L DRC14L
DR£14M DRE14M DRC14M DR£14N DRE14N DRC14N
DR£17 DRE17 DRC17 DR£17A DRE17A DRC17A
DR£17B DRE17B DRC17B DR£17C DRE17C DRC17C
DR£17D DRE17D DRC17D DR£17E DRE17E DRC17E
DR£17F DRE17F DRC17F DR£17G DRE17G DRC17G
DR£17H DRE17H DRC17H DR£17J DRE17J DRC17J
DR£17K DRE17K DRC17K DR£17L DRE17L DRC17L
DR£17M DRE17M DRC17M DR£17N DRE17N DRC17N
DR£18 DRE18 DRC18 DR£18A DRE18A DRC18A
DR£18B DRE18B DRC18B DR£18C DRE18C DRC18C
DR£18D DRE18D DRC18D DR£18E DRE18E DRC18E
DR£18F DRE18F DRC18F DR£18G DRE18G DRC18G
DR£18H DRE18H DRC18H DR£18J DRE18J DRC18J
DR£18K DRE18K DRC18K DR£18L DRE18L DRC18L
DR£18M DRE18M DRC18M DR£18N DRE18N DRC18N
DR£19 DRE19 DRC19 DR£19A DRE19A DRC19A
DR£19B DRE19B DRC19B DR£19C DRE19C DRC19C
DR£19D DRE19D DRC19D DR£19E DRE19E DRC19E
DR£19F DRE19F DRC19F DR£19G DRE19G DRC19G
- 59 -
Specification for BEERS (V24) May 2009
DR£19H DRE19H DRC19H DR£19J DRE19J DRC19J
DR£19K DRE19K DRC19K DR£19L DRE19L DRC19L
DR£19M DRE19M DRC19M DR£19N DRE19N DRC19N
DR£20 DRE20 DRC20 DR£20A DRE20A DRC20A
DR£20B DRE20B DRC20B DR£20C DRE20C DRC20C
DR£20D DRE20D DRC20D DR£20E DRE20E DRC20E
DR£20F DRE20F DRC20F DR£20G DRE20G DRC20G
DR£20H DRE20H DRC20H DR£20J DRE20J DRC20J
DR£20K DRE20K DRC20K DR£20L DRE20L DRC20L
DR£20M DRE20M DRC20M DR£20N DRE20N DRC20N
DR£24 DRE24 DRC24 DR£24A DRE24A DRC24A
DR£24B DRE24B DRC24B DR£24C DRE24C DRC24C
DR£24D DRE24D DRC24D DR£24E DRE24E DRC24E
DR£24F DRE24F DRC24F DR£24G DRE24G DRC24G
DR£24H DRE24H DRC24H DR£24J DRE24J DRC24J
DR£24K DRE24K DRC24K DR£24L DRE24L DRC24L
DR£24M DRE24M DRC24M DR£24N DRE24N DRC24N
DR£25 DRE25 DRC25 DR£25A DRE25A DRC25A
DR£25B DRE25B DRC25B DR£25C DRE25C DRC25C
DR£25D DRE25D DRC25D DR£25E DRE25E DRC25E
DR£25F DRE25F DRC25F DR£25G DRE25G DRC25G
DR£25H DRE25H DRC25H DR£25J DRE25J DRC25J
DR£25K DRE25K DRC25K DR£25L DRE25L DRC25L
DR£25M DRE25M DRC25M DR£25N DRE25N DRC25N
DR£26 DRE26 DRC26 DR£26A DRE26A DRC26A
DR£26B DRE26B DRC26B DR£26C DRE26C DRC26C
DR£26D DRE26D DRC26D DR£26E DRE26E DRC26E
DR£26F DRE26F DRC26F DR£26G DRE26G DRC26G
DR£26H DRE26H DRC26H DR£26J DRE26J DRC26J
DR£26K DRE26K DRC26K DR£26L DRE26L DRC26L
DR£26M DRE26M DRC26M DR£26N DRE26N DRC26N
DR£27 DRE27 DRC27 DR£27A DRE27A DRC27A
DR£27B DRE27B DRC27B DR£27C DRE27C DRC27C
DR£27D DRE27D DRC27D DR£27E DRE27E DRC27E
DR£27F DRE27F DRC27F DR£27G DRE27G DRC27G
DR£27H DRE27H DRC27H DR£27J DRE27J DRC27J
DR£27K DRE27K DRC27K DR£27L DRE27L DRC27L
DR£27M DRE27M DRC27M DR£27N DRE27N DRC27N
DR£31 DRE31 DRC31 DR£31A DRE31A DRC31A
DR£31B DRE31B DRC31B DR£31C DRE31C DRC31C
DR£31D DRE31D DRC31D DR£31E DRE31E DRC31E
DR£31F DRE31F DRC31F DR£31G DRE31G DRC31G
- 60 -
Specification for BEERS (V24) May 2009
DR£31H DRE31H DRC31H DR£31J DRE31J DRC31J
DR£31K DRE31K DRC31K DR£31L DRE31L DRC31L
DR£31M DRE31M DRC31M DR£31N DRE31N DRC31N
DR£32 DRE32 DRC32 DR£32A DRE32A DRC32A
DR£32B DRE32B DRC32B DR£32C DRE32C DRC32C
DR£32D DRE32D DRC32D DR£32E DRE32E DRC32E
DR£32F DRE32F DRC32F DR£32G DRE32G DRC32G
DR£32H DRE32H DRC32H DR£32J DRE32J DRC32J
DR£32K DRE32K DRC32K DR£32L DRE32L DRC32L
DR£32M DRE32M DRC32M DR£32N DRE32N DRC32N
DR£38 DRE38 DRC38 DR£38A DRE38A DRC38A
DR£38B DRE38B DRC38B DR£38C DRE38C DRC38C
DR£38D DRE38D DRC38D DR£38E DRE38E DRC38E
DR£38F DRE38F DRC38F DR£38G DRE38G DRC38G
DR£38H DRE38H DRC38H DR£38J DRE38J DRC38J
DR£38K DRE38K DRC38K DR£38L DRE38L DRC38L
DR£38M DRE38M DRC38M DR£38N DRE38N DRC38N
DR£39 DRE39 DRC39 DR£39A DRE39A DRC39A
DR£39B DRE39B DRC39B DR£39C DRE39C DRC39C
DR£39D DRE39D DRC39D DR£39E DRE39E DRC39E
DR£39F DRE39F DRC39F DR£39G DRE39G DRC39G
DR£39H DRE39H DRC39H DR£39J DRE39J DRC39J
DR£39K DRE39K DRC39K DR£39L DRE39L DRC39L
DR£39M DRE39M DRC39M DR£39N DRE39N DRC39N
6.20.3 SAMPLE DT
H0712DT40001WORL 7
Standard Data Header record for section DT - followed by
Standard Data records: each box represents a 12-character field
DT£L DTEL DTCL DT£C DTEC DTCC
H0712DT40001ENTO
DT£L DTEL DTCL DT£C DTEC DTCC
H0712DT40001ONTO
DT£L DTEL DTCL DT£C DTEC DTCC
H0712DT40001UNAL
DT£L DTEL DTCL DT£C DTEC DTCC
H0712DT40001CTOT
DT£L DTEL DTCL DT£C DTEC DTCC
H0712DT40001ABUD
DT£L DTEL DTCL DT£C DTEC DTCC
H0712DT40001USA
DT£L DTEL DTCL DT£C DTEC DTCC
- 61 -
Specification for BEERS (V24) May 2009
6.21 EFFECTIVE INTEREST RATES ON STERLING BUSINESS BY SECTOR
(FORM ER)
The form ER is a standard 3D form.
All input into Column C of the return must have two decimal places. Items with no
decimal data must be reported as .00 ie 5 should be reported as 5.00.
It should be transmitted under a formcode of ER.
6.21.1 SAMPLE ER
A full example of the data file for form ER follows.
H0401ER30001
Standard Data Header record for section ER - followed by
Standard Data records: each box represents a 12-character field
ERA1 ERA2 ERB2 ERC2 ERA3 ERB3
ERC3 ERA4 ERA5 ERB5 ERC5 ERA6
ERB6 ERC6 ERA7 ERB7 ERC7 ERA8
ERB8 ERC8 ERA9 ERB9 ERC9 ERA10
ERA11 ERB11 ERC11 ERA12 ERB12 ERC12
ERA13 ERA14 ERB14 ERC14 ERA15 ERB15
ERC15 ERA16 ERA17 ERB17 ERC17 ERA18
ERB18 ERC18 ERA19 ERA20 ERB20 ERC20
ERA21 ERB21 ERC21 ERA22 ERB22 ERC22
ERA23 ERB23 ERC23 ERA24 ERB24 ERC24
ERA25 ERA26 ERB26 ERC26 ERA27 ERB27
ERC27 ERA28 ERB28 ERC28 ERA29 ERB29
ERC29 ERA30 ERB30 ERC30 ERA31 ERB31
ERC31 ERA32 ERA33 ERB33 ERC33 ERA34
ERB34 ERC34 ERA35 ERB35 ERC35 ERA36
ERB36 ERC36 ERA37 ERB37 ERC37 ERA38
ERB38 ERC38 ERA39 ERB39 ERC39 ERA40
ERB40 ERC40 ERA41 ERB41 ERC41 ERA42
ERB42 ERC42 ERA43 ERB43 ERC43 ERA44
ERB44 ERC44 ERA45 ERB45 ERC45 ERA46
ERB46 ERC46 ERA47 ERB47 ERC47 ERA48
ERB48 ERC48 ERA49 ERB49 ERC49 ERA50
ERB50 ERC50 ERA51 ERB51 ERC51 ERA52
ERB52 ERC52 ERA53 ERB53 ERC53 ERA54
ERB54 ERC54 ERA55 ERB55 ERC55 ERA56
ERB56 ERC56 ERA57 ERB57 ERC57 ERA58
ERB58 ERC58 ERA59 ERB59 ERC59 ERA60
ERB60 ERC60 ERA61 ERB61 ERC61 ERA62
- 62 -
Specification for BEERS (V24) May 2009
ERA63 ERB63 ERC63 ERA64 ERB64 ERC64
ERA65 ERB65 ERC65 ERA66 ERB66 ERC66
ERA67 ERB67 ERC67 ERA68 ERB68 ERC68
ERA69 ERB69 ERC69 ERA70 ERB70 ERC70
ERA71 ERB71 ERC71 ERA72 ERB72 ERC72
ERA73 ERB73 ERC73 ERA74 ERB74 ERC74
ERA75 ERB75 ERC75 ERA76 ERB76 ERC76
ERA77 ERB77 ERC77 ERA78 ERB78 ERC78
ERA79 ERB79 ERC79 ERD79 ERA80 ERB80
ERC80 ERD80 ERA81 ERB81 ERC81 ERD81
ERA82 ERB82 ERC82 ERD82 ERA83 ERB83
ERC83 ERD83 ERA84 ERB84 ERC84 ERD84
ERA85 ERB85 ERC85 ERD85 ERA86 ERB86
ERC86 ERD86 ERA87 ERB87 ERC87 ERD87
ERA88 ERB88 ERC88 ERD88 ERA89 ERB89
ERC89 ERD89 ERA90 ERB90 ERC90 ERD90
ERA91 ERB91 ERC91 ERD91 ERA92 ERB92
ERC92 ERD92 ERA93 ERB93 ERC93 ERD93
ERA94 ERB94 ERC94 ERD94 ERA95 ERB95
ERC95 ERD95 ERA96 ERB96 ERC96 ERD96
ERA97 ERB97 ERC97 ERD97 ERA98 ERB98
ERC98 ERD98 ERA99 ERB99 ERC99 ERD99
ERA100 ERB100 ERC100 ERD100 ERA101 ERB101
ERC101 ERD101 ERA102 ERB102 ERC102 ERD102
ERA103 ERB103 ERC103 ERD103 ERA104 ERB104
ERC104 ERD104 ERA105 ERB105 ERC105 ERD105
ERA106 ERB106 ERC106 ERD106 ERA107 ERB107
ERC107 ERD107 ERA108 ERB108 ERC108 ERD108
ERA109 ERB109 ERC109 ERD109 ERA110 ERB110
ERC110 ERD110 ERA111 ERB111 ERC111 ERD111
ERA112 ERB112 ERC112 ERD112 ERA113 ERB113
ERC113 ERD113 ERA114 ERB114 ERC114 ERD114
ERA115 ERB115 ERC115 ERD115 ERA116 ERB116
ERC116 ERD116 ERA117 ERB117 ERC117 ERD117
ERA118 ERB118 ERC118 ERD118 ERA119 ERB119
ERC119 ERD119 ERA120 ERB120 ERC120 ERD120
ERA121 ERB121 ERC121 ERD121 ERA122 ERB122
ERC122 ERD122 ERA123 ERB123 ERC123 ERD123
ERA124 ERB124 ERC124 ERD124 ERA125 ERB125
ERC125 ERD125 ERA126 ERB126 ERC126 ERD126
ERA127 ERB127 ERC127 ERD127 ERC128 ERC129
- 63 -
Specification for BEERS (V24) May 2009
6.22 FOREIGN AFFILIATES STATISTICS (FORM FT) – FROM DECEMBER
2009
The form FT is a standard 4D form.
6.22.1 SAMPLE FT
An example of the data file the form FT is shown below.
H0912FT40001WORL 7
Standard Data Header record for section FT – followed by
Standard Data records: each box represents a 12-character field
FT1 FT2 FT3
H0912FT40001ENTO
FT1 FT2 FT3
H0912FT40001ONTO
FT1 FT2 FT3
H0912FT40001UNAL
FT1 FT2 FT3
H0912FT40001CTOT
FT1 FT2 FT3
H0912FT40001ABUD
FT1 FT2 FT3
H0912FT40001USA
FT1 FT2 FT3
6.23 GILTS AND TREASURY BILLS (FORM GT) – FROM MAY 2009
The form GT is a standard 3D form.
It should be transmitted under a formcode of GT.
6.23.1 SAMPLE GT
A full example of the data file for form GT follows.
H0905GT30001
Standard Data Header record for section GT – followed by
Standard Data records: each box represents a 12-character field
GT£26A GT£26A1 GT£26A2 GT£32D GT£32D1 GT£32D1A
GT£32D1B GT£32D1C GT£32D2 GT£32D2A GT£32D2B GT£32D2C
- 64 -
Specification for BEERS (V24) May 2009
6.24 FOREIGN DIRECT INVESTMENT TRANSACTIONS (FORM HF) –
FROM DECEMBER 2007
Form HF is output in one section with both parts of the form being output under one
header. Therefore each record will consist of 6 data items. The total line is output as the
WORL header record in the normal way.
6.24.1 SAMPLE HF
A full example of the data file the form HF is shown below.
H0712HF40001WORL 3
Standard Data Header record for section HF – followed by
Standard Data records: each box represents a 12-character field
HF1 HF2A HF2B HF3 HF4A HF4B
HF5 HF6A HF6B HF7 HF8A HF8B
H0712HF40001BELG
HF1 HF2A HF2B HF3 HF4A HF4B
HF5 HF6A HF6B HF7 HF8A HF8B
H0712HF40001FRAN
HF1 HF2A HF2B HF3 HF4A HF4B
HF5 HF6A HF6B HF7 HF8A HF8B
- 65 -
Specification for BEERS (V24) May 2009
6.25 COUNTRY ANALSIS: LEVELS OF INWARD FOREIGN DIRECT
INVESMENT (FORM HI)
Percentage figures in Section 3A should be rounded to the nearest whole number.
Please note that nil returns must be submitted.
6.25.1 SAMPLE HI
A full example of the data file the form HI is shown below.
H0412HI40001WORL 3
Standard Data Header record for section HI – followed by
Standard Data records: each box represents a 12-character field
HI1A HI2A HI2B HI2C HI2D HI3A
HI3BA HI3BB HI3BC HI4A HI4BA
H0412HI40001BELG
HI1A HI2A HI2B HI2C HI2D HI3A
HI3BA HI3BB HI3BC HI4A HI4BA
H0412HI40001FRAN
HI1A HI2A HI2B HI2C HI2D HI3A
HI3BA HI3BB HI3BC HI4A HI4BA
- 66 -
Specification for BEERS (V24) May 2009
6.26 COUNTRY ANALSIS: LEVELS OF OUTWARD FOREIGN DIRECT
INVESMENT (FORM HO)
Percentage figures in Section 3A should be rounded to the nearest whole number.
Please note that nil returns must be submitted.
6.26.1 SAMPLE HO
A full example of the data file the form HO is shown below.
H0412HO40001WORL 3
Standard Data Header record for section HO – followed by
Standard Data records: each box represents a 12-character field
HO1A HO2A HO2B HO2C HO2D HO3A
HO3BA HO3BB HO3BC
H0412HO40001BELG
HO1A HO2A HO2B HO2C HO2D HO3A
HO3BA HO3BB HO3BC
H0412HO40001FRAN
HO1A HO2A HO2B HO2C HO2D HO3A
HO3BA HO3BB HO3BC
- 67 -
Specification for BEERS (V24) May 2009
6.27 ANALYSIS OF LENDING TO UK RESIDENTS (FORM IC) – FROM
OCTOBER 2007
Form IC is a standard 3D form.
6.27.1 SAMPLE IC
H0710IC30001
Standard Data Header record for section IC – followed by
Standard Data records: each box represents a 12-character field
IC£XFKD1 ICEXFKD1 IC£XFKD2 ICEXFKD2 IC£XFKD3 ICEXFKD3
IC£XFKD4 ICEXFKD4 IC£XFKD5 ICEXFKD5 IC£XFKD6 ICEXFKD6
IC£XFKD7 ICEXFKD7 IC£XFKD8A ICEXFKD8A IC£XFKD8B ICEXFKD8B
- 68 -
Specification for BEERS (V24) May 2009
6.28 FURTHER ANALYSIS OF LOANS AND ADVANCES TO UK
INDIVIDUALS (FORM IO) – FROM OCTOBER 2007
Form IO is a standard 3D form.
6.28.1 SAMPLE IO
H0710IO30001
Standard Data Header record for section I0 – followed by
Standard Data records: each box represents a 12-character field
IO£XFKF IOEXFKF IO£XFKF1 IOEXFKF1 IO£XFKF2 IOEXFKF2
IO£XFKF3 IOEXFKF3 IO£XFKF4 IOEXFKF4
- 69 -
Specification for BEERS (V24) May 2009
6.29 FURTHER ANALYSIS OF SECURED LENDING TO UK INDIVIDUALS
(FORM IS) – FROM OCTOBER 2007
Form IS is a standard 3D form.
6.29.1 SAMPLE IS
H0710IS30001
Standard Data Header record for section IS – followed by
Standard Data records: each box represents a 12-character field
IS£XFKBA ISEXFKBA IS£XFKBB ISEXFKBB IS£XFKBC ISEXFKBC
IS£XFKBD ISEXFKBD IS£XFKBE ISEXFKBE IS£XFKBF ISEXFKBF
IS£XFKBG ISEXFKBG IS£XFKBH ISEXFKBH IS£XFKBJ ISEXFKBJ
IS£XFKBJ1 ISEXFKBJ1 IS£XFKBJA ISEXFKBJA IS£XFKBJB ISEXFKBJB
IS£XFKBK1 ISEXFKBK1 IS£XFKBK2 ISEXFKBK2 IS£XFKVA ISEXFKVA
IS£XFKVAA ISEXFKVAA IS£XFKVAB ISEXFKVAB IS£XFKVAC ISEXFKVAC
IS£XFKVAD ISEXFKVAD IS£XFKVC ISEXFKVC IS£XFKVCA ISEXFKVCA
IS£XFKVCB ISEXFKVCB IS£XFKVCC ISEXFKVCC IS£XFKVCD ISEXFKVCD
IS£XFKNA ISEXFKNA IS£XFKNAA ISEXFKNAA IS£XFKNAB ISEXFKNAB
IS£XFKNAC ISEXFKNAC IS£XFKNAD ISEXFKNAD IS£XFKNC ISEXFKNC
IS£XFKNCA ISEXFKNCA IS£XFKNCB ISEXFKNCB IS£XFKNCC ISEXFKNCC
IS£XFKNCD ISEXFKNCD
- 70 -
Specification for BEERS (V24) May 2009
6.30 SPECIALIST MORTGAGE INSTITUTIONS – ANALYSIS OF SECURED
LENDING TO INDIVIDUALS AND INDIVIDUAL TRUSTS (FORM MM)
Form MM is created as a 3D form.
The Supplementary Information at the back of the form are included as three separate
Text records at the end of the Data records, and all three must be sent. Even if a bank has
nothing to report, the text record must be sent with ‘no values to report’ as the text.
Text record one should include the information 1 to 12 (List all parts of the group whose
business is included on the return)
Text record two should include the information 1 to 12 (List all parts of the group whose
business is excluded from the return).
Text record three should include the information 7 to 8 (list all mortgage portfolios
aqquired / disposed of).
Text records follow the Data records and are preceded by a Text Header record. The
Text records include one record for each counterparty, where each record consists of one
40 character field. There is a maximum of 20 counterparty records for sections one and
two.
Text records one and two -
Field 1
Where
Position Field Notes Format
1-40 Field 1 Counterparty Left justified
Text record three includes four 40 character fields. There is a maximum of 20
counterparty records for each section.
Position Field Notes Format
1-40 Field 1 Transaction Left justified
41-80 Field 2 Value of mortgage book Right justified
81-120 Field 3 Institution brought Right justified
from/sold to
121-160 Field 4 Date transaction Right justified
occured
- 71 -
Specification for BEERS (V24) May 2009
6.30.1 SAMPLE MM
A full example of the data file for form MM is shown below.
H0312MM30001
Standard Data Header record for MM - followed by
Standard Data records: each box represents a 12-character field
MM£1F MM£1O MME1 MM£2F MM£2O MME2
MM£3F MM£3O MME3 MM£4F MM£4O MME4
MM£5F MM£5O MME5 MM£6F MM£6O MME6
MM£7F MM£7O MME7 MM£8F MM£8O MME8
MM£9F MM£9O MME9 MM£10F MM£10O MME10
MM11N MM£11F MM£11O MME11 MM11AN MM£11AF
MM£11AO MME11A MM11BN MM£11BF MM£11BO MME11B
MM11CN MM£11CF MM£11CO MME11C MM11DN MM£11DF
MM£11DO MME11D MM12N MM£12F MM£12O MME12
MM12AN MM£12AF MM£12AO MME12A MM12BN MM£12BF
MM£12BO MME12B MM12CN MM£12CF MM£12CO MME12C
MM12DN MM£12DF MM£12DO MME12D
T0312MM0001
Standard Text Header record: this section must be output even if there are no records and should have ‘no
values to report’ as the text.
CounterParty 1
CounterParty 2
Output only a maximum of 20 records.
T0312MM0001
Standard Text Header record: this section must be output even if there are no records and should have ‘no
values to report’ as the text.
CounterParty 1
CounterParty 2
Output only a maximum of 20 records.
T0312MM0001
Standard Text Header record: this section must be output even if there are no records and should have ‘no
values to report’ as the text.
Transaction Value of Institution Date
Mortgage bought transaction
book from/sold to occured
Transaction Value of Institution Date
Mortgage bought transaction
book from/sold to occured
Output only a maximum of 20 records
- 72 -
Specification for BEERS (V24) May 2009
6.31 SPECIALIST MORTGAGE INSTITUTIONS – BALANCE SHEET (FORM
MQ)
Form MQ is created as a 3D form.
The Supplementary Information at the back of the form is included as two separate Text
records at the end of the Data records, and both must be sent. Even if a bank has nothing
to report, the text record must be sent with ‘no values to report’ as the text.
Text record one should include the information 1 to 12 (List all parts of the group whose
business is included on the return)
Text record two should include the information 1 to 12 (List all parts of the group whose
business is excluded from the return).
Text records follow the Data records and are preceded by a Text Header record. The
Text records include one record for each counterparty, where each record consists of one
40 character field. There is a maximum of 20 counterparty records for sections one and
two.
Text records one and two -
Field 1
Where
Position Field Notes Format
1-40 Field 1 Counterparty Left justified
- 73 -
Specification for BEERS (V24) May 2009
6.31.1 SAMPLE MQ
H0312MQ30001
Standard Data Header record for MM - followed by
Standard Data records: each box represents a 12-character field
MQ£1 MQE1 MQC1 MQ£2 MQE2 MQC2
MQ£3 MQE3 MQC3 MQ£4 MQE4 MQC4
MQ£5 MQE5 MQC5 MQ£6 MQE6 MQC6
MQ£7 MQE7 MQC7 MQ£8 MQE8 MQC8
MQ£9 MQE9 MQC9 MQ£10 MQE10 MQC10
MQ£11 MQE11 MQC11 MQ£12 MQE12 MQC12
MQ£13 MQE13 MQC13 MQ£14 MQE14 MQC14
MQ£15 MQE15 MQC15 MQ£16 MQE16 MQC16
MQ£17 MQE17 MQC17 MQ£18 MQE18 MQC18
MQ£18A MQE18A MQC18A MQ£18B MQE18B MQC18B
MQ£18C MQE18C MQC18C MQ£19 MQE19 MQC19
MQ£20 MQE20 MQC20 MQ£21 MQE21 MQC21
MQ£22 MQE22 MQC22 MQ£22A MQE22A MQC22A
MQ£23 MQE23 MQC23 MQ£24 MQE24 MQC24
MQ£25 MQE25 MQC25 MQ£26 MQE26 MQC26
T0312MQ0001
Standard Text Header record: this section must be output even if there are no records and should have ‘no
values to report’ as the text.
CounterParty 1
CounterParty 2
Output only a maximum of 20 records.
T0312MQ0001
Standard Text Header record: this section must be output even if there are no records and should have ‘no
values to report’ as the text.
CounterParty 1
CounterParty 2
Output only a maximum of 20 records.
- 74 -
Specification for BEERS (V24) May 2009
6.32 PROFIT AND LOSS (FORM PL)
This form can be reported either quarterly or annually, and is a standard 3D form.
6.32.1 SAMPLE PL
A full example of the data file for form PL is shown below.
H0403PL30001
Standard Data Header record for section PL – followed by
Standard Data records: each box represents a 12-character field
PL£1 PLE1 PLC1 PL£1A PLE1A PLC1A
PL£1AA PLE1AA PLC1AA PL£1B PLE1B PLC1B
PL£1BA PLE1BA PLC1BA PL£1BB PLE1BB PLC1BB
PL£1BC PLE1BC PLC1BC PL£1BD PLE1BD PLC1BD
PL£1BE PLE1BE PLC1BE PL£1BEA PLE1BEA PLC1BEA
PL£1BEB PLE1BEB PLC1BEB PL£1BEC PLE1BEC PLC1BEC
PL£1BF PLE1BF PLC1BF PL£1BG PLE1BG PLC1BG
PL£1BH PLE1BH PLC1BH PL£1BJ PLE1BJ PLC1BJ
PL£1BJA PLE1BJA PLC1BJA PL£1BJB PLE1BJB PLC1BJB
PL£1BJC PLE1BJC PLC1BJC PL£1BJD PLE1BJD PLC1BJD
PL£1BK PLE1BK PLC1BK PL£1BKA PLE1BKA PLC1BKA
PL£1BKB PLE1BKB PLC1BKB PL£1BKC PLE1BKC PLC1BKC
PL£1BKD PLE1BKD PLC1BKD PL£1BKE PLE1BKE PLC1BKE
PL£1BL PLE1BL PLC1BL PL£1BM PLE1BM PLC1BM
PL£1BMA PLE1BMA PLC1BMA PL£1BMB PLE1BMB PLC1BMB
PL£1C PLE1C PLC1C PL£1CA PLE1CA PLC1CA
PL£1CB PLE1CB PLC1CB PL£1CC PLE1CC PLC1CC
PL£1CD PLE1CD PLC1CD PL£1CE PLE1CE PLC1CE
PL£1CF PLE1CF PLC1CF PL£1CG PLE1CG PLC1CG
PL£1CH PLE1CH PLC1CH PL£1CJ PLE1CJ PLC1CJ
PL£1CK PLE1CK PLC1CK PL£1CL PLE1CL PLC1CL
PL£1CM PLE1CM PLC1CM PL£1CMA PLE1CMA PLC1CMA
PL£1CMB PLE1CMB PLC1CMB PL£1D PLE1D PLC1D
PL£1DA PLE1DA PLC1DA PL£2 PLE2 PLC2
PL£2A PLE2A PLC2A PL£2B PLE2B PLC2B
PL£2BA PLE2BA PLC2BA PL£2BB PLE2BB PLC2BB
PL£2BC PLE2BC PLC2BC PL£2BD PLE2BD PLC2BD
PL£2BE PLE2BE PLC2BE PL£2BEA PLE2BEA PLC2BEA
PL£2BEB PLE2BEB PLC2BEB PL£2BEC PLE2BEC PLC2BEC
PL£2BF PLE2BF PLC2BF PL£2BG PLE2BG PLC2BG
PL£2BH PLE2BH PLC2BH PL£2BJ PLE2BJ PLC2BJ
PL£2BK PLE2BK PLC2BK PL£2BKA PLE2BKA PLC2BKA
PL£2BL PLE2BL PLC2BL PL£2BM PLE2BM PLC2BM
- 75 -
Specification for BEERS (V24) May 2009
PL£2BMA PLE2BMA PLC2BMA PL£2BMB PLE2BMB PLC2BMB
PL£2C PLE2C PLC2C PL£2CA PLE2CA PLC2CA
PL£2CB PLE2CB PLC2CB PL£2CC PLE2CC PLC2CC
PL£2CD PLE2CD PLC2CD PL£2CE PLE2CE PLC2CE
PL£2CF PLE2CF PLC2CF PL£2CG PLE2CG PLC2CG
PL£2CH PLE2CH PLC2CH PL£2CJ PLE2CJ PLC2CJ
PL£2CK PLE2CK PLC2CK PL£2CL PLE2CL PLC2CL
PL£2CM PLE2CM PLC2CM PL£2CMA PLE2CMA PLC2CMA
PL£2CMB PLE2CMB PLC2CMB PL£2D PLE2D PLC2D
PL3 PL4 PL4A PL5 PL5A PL5AA
PL5AB PL5B PL5BA PL5C PL5CA PL5D
PL5E PL5EA PL5F PL5FA PL5FB PL5G
PL5GA PL5GB PL5H PL5HA PL5HB PL6
PL6A PL6AA PL6AB PL7 PL£8 PLE8
PLC8 PL£8A PLE8A PLC8A PL£8AA PLE8AA
PLC8AA PL£8B PLE8B PLC8B PL£8BA PLE8BA
PLC8BA PL£8C PLE8C PLC8C PL£8CA PLE8CA
PLC8CA PL£9 PLE9 PLC9 PL£9A PLE9A
PLC9A PL£9B PLE9B PLC9B PL£9C PLE9C
PLC9C PL£9D PLE9D PLC9D PL£9DA PLE9DA
PLC9DA PL10 PL11 PL12 PL12A PL12AA
PL12AB PL12AC PL12AD PL12AE PL12AF PL12AG
PL12B PL12BA PL12BAA PL12BAB PL12BB PL12BC
PL12BD PL12BDA PL12BDB PL12BDC PL12BDD PL12BDE
PL12BDF PL12BDG PL12C PL12CA PL13 PL14
PL15 PL16 PL16A PL16B PL17 PL18
PL19 PL20A PL20AA PL20AAA PL20AAB PL20AAC
PL20AAD PL20AAE PL20AAF PL20AAG PL20AB PL20AC
PL20ACA PL20ACB PL20ACC PL20ACD PL20ACE PL20ACF
PL20ACG PL20AD PL20AE PL20AEA PL20AEB PL20AEC
PL20AED PL20AEE PL20AEF PL20AEG PL20B PL21
PL22 PL23 PLM PL£24 PLE24 PLC24
PL£24A PLE24A PLC24A PL£24AA PLE24AA PLC24AA
PL£24B PLE24B PLC24B PL£24BA PLE24BA PLC24BA
PL£24C PLE24C PLC24C PL£24CA PLE24CA PLC24CA
PL£24D PLE24D PLC24D PL£24DA PLE24DA PLC24DA
PL£24E PLE24E PLC24E PL£24EA PLE24EA PLC24EA
PL£24F PLE24F PLC24F PL£24FA PLE24FA PLC24FA
PL£25 PLE25 PLC25 PL£25A PLE25A PLC25A
PL£25AA PLE25AA PLC25AA PL£25B PLE25B PLC25B
PL£25BA PLE25BA PLC25BA PL£25C PLE25C PLC25C
PL£25CA PLE25CA PLC25CA PL£26 PLE26 PLC26
- 76 -
Specification for BEERS (V24) May 2009
PL£26A PLE26A PLC26A PL£26AA PLE26AA PLC26AA
PL£26B PLE26B PLC26B PL£26BA PLE26BA PLC26BA
PL27 PL27A PL27B PL27C PL27D PL27E
PL27F PL27G PL27H PL27J PL28 PL28A
PL28B PL28C PL28D PL28E PL28F PL28G
PL28H PL28J PL£29A PLE29A PLC29A PL£29AA
PLE29AA PLC29AA PL£29B PLE29B PLC29B PL£29BA
PLE29BA PLC29BA PL£30A PLE30A PLC30A PL£30AA
PLE30AA PLC30AA PL31A PL31AA PL31B PL31BA
PL32A PL32AA PL32B PL32BA PL33A PL33B
- 77 -
Specification for BEERS (V24) May 2009
6.33 GILT REPO AND STOCK LENDING ACTIVITY (FORM RSL)
Form RSL is a standard 3D format. Data for sections not reported are output as zeros.
6.33.1 SAMPLE RSL
A sample of RSL follows.
H0401RS30001
Standard Data Header record for RSL - followed by
Standard Data records: each box represents a 12-character field
RS11A RS11B RS11C RS11D RS11E RS11F
RS11G RS11H RS11J RS12A RS12B RS12C
RS12D RS12E RS12F RS12G RS12H RS12J
RS13A RS13B RS13C RS13D RS13E RS13F
RS13G RS13H RS13J RS14A RS14B RS14C
RS14D RS14E RS14F RS14G RS14H RS14J
RS15A RS15B RS15C RS15D RS15E RS15F
RS15G RS15H RS15J RS16A RS16B RS16C
RS16D RS16E RS16F RS16G RS16H RS16J
RS17A RS17B RS17C RS17D RS17E RS17F
RS17G RS17H RS17J RS18A RS18B RS18C
RS18D RS18E RS18F RS18G RS18H RS18J
RS21A RS21B RS21C RS21D RS21E RS21F
RS21G RS21H RS21J RS22A RS22B RS22C
RS22D RS22E RS22F RS22G RS22H RS22J
RS23A RS23B RS23C RS23D RS23E RS23F
RS23G RS23H RS23J RS24A RS24B RS24C
RS24D RS24E RS24F RS24G RS24H RS24J
RS25A RS25B RS25C RS25D RS25E RS25F
RS25G RS25H RS25J RS26A RS26B RS26C
RS26D RS26E RS26F RS26G RS26H RS26J
RS27A RS27B RS27C RS27D RS27E RS27F
RS27G RS27H RS27J RS28A RS28B RS28C
RS28D RS28E RS28F RS28G RS28H RS28J
RS31A RS31B RS31C RS31D RS31E RS31F
RS31G RS31H RS31J RS32A RS32B RS32C
RS32D RS32E RS32F RS32G RS32H RS32J
RS33A RS33B RS33C RS33D RS33E RS33F
RS33G RS33H RS33J RS34A RS34B RS34C
RS34D RS34E RS34F RS34G RS34H RS34J
RS35A RS35B RS35C RS35D RS35E RS35F
- 78 -
Specification for BEERS (V24) May 2009
RS35G RS35H RS35J RS36A RS36B RS36C
RS36D RS36E RS36F RS36G RS36H RS36J
RS37A RS37B RS37C RS37D RS37E RS37F
RS37G RS37H RS37J RS38A RS38B RS38C
RS38D RS38E RS38F RS38G RS38H RS38J
- 79 -
Specification for BEERS (V24) May 2009
6.34 ANALYSIS OF NET WRITE-OFFS (FORM WO) – FROM MARCH 2008
Form WO is a standard 3D format.
6.34.1 SAMPLE WO
A sample of a WO follows.
H0803WO30001
Standard Data Header record for section WO - followed by
Standard Data records: each box represents a 12-character field
WO£1 WOE1 WOC1 WO£1A WOE1A WOC1A
WO£1B WOE1B WOC1B WO£1C WOE1C WOC1C
WO£1D WOE1D WOC1D WO£1E WOE1E WOC1E
WO£1F WOE1F WOC1F WO£1G WOE1G WOC1G
WO£1H WOE1H WOC1H WO£1HA WOE1HA WOC1HA
WO£1J WOE1J WOC1J WO£1JA WOE1JA WOC1JA
WO£1JB WOE1JB WOC1JB WO£1K WOE1K WOC1K
WO£1L WOE1L WOC1L WO£2 WOE2 WOC2
WO£3 WOE3 WOC3
- 80 -
Specification for BEERS (V24) May 2009
7 FORM SUMMARY
The following returns can all be sent electronically:
PAPER FORM ELECTRONIC DIMENSIONS NUMBER FORM DATE
NAME FORM NAME OF BOXES
AD AD 3 171 Sep 97
AL AL 3 563 Sep 97 – Sep 07
AL AL 3 318 Dec 07
BE BE 3 181 Sep 97 – Sep 07
BE BE 3 185 Oct 07
BG BG 4 10 Sep 97
BT BT 3 605 Sep 02 – Sep 07
BT BT 3 540 Oct 07
BT BT 3 542 Jan 09
C1 C1 4 31 Mar 99
CA CA 4 25 Dec 98 – Sep 07
CA CA 4 23 Dec 07
CC CC 4 64 Dec 98 – Sep 07
CO 3 7 Dec 98 – Sep 07
CC CC 4 58 Dec 07
CO 3 21 Dec 07
CE CE 4 46 Dec-04
CL CL 4 19 Dec 98 – Sep 07
CS 3 13 Dec 98 – Sep 07
CL CL 4 19 Dec 07
CS 3 11 Dec 07
CX CX 3 96 Dec 07
DQ DQ 3 84 Nov 98 – Sep 07
DR 3 924 Nov 98 – Sep 07
DS 3 243 Nov 98 – Sep 07
DT 4 6 Nov 98 – Sep 07
DU 4 6 Nov 98 – Sep 07
DQ DQ 3 84 Dec 07
DR 3 924 Dec 07
DT 4 6 Dec 07
ER ER 3 414 Mar 04
FT FT 4 3 Dec 09
G GD 3 48 Mar 05 – Dec 09
GT GT 3 12 May 09
HF HF 4 12 Dec 07
HI HI 4 9 Dec 00
HO HO 4 9 Dec 00
IC IC 3 18 Oct 07
IO IO 3 10 Oct 07
IS IS 3 68 Oct 07
MM MM 3 70 Oct 02
MQ MQ 3 90 Oct 02
- 81 -
Specification for BEERS (V24) May 2009
PL PL 3 510 Mar 04
RSL RS 3 216 May 04
WO WO 3 51 Mar 08
The following returns cannot be sent electronically:
PAPER FORM NAME FORM TITLE
HC Bank Holding Companies annual income, expenditure and
balance sheet positions.
- 82 -
Specification for BEERS (V24) May 2009
8 SENDING DATA
Data sent via BEERS must be compressed, encrypted and transmitted (in that order).
Sending data requires the use of three software packages:
• Compression WINZIP
• Encryption PUBLIC
• Transmission E-MAIL
9 DATA COMPRESSION AND BATCHING
Data files must be compressed using the compression software WINZIP.
The compression software will allow several files for different forms to be batched
together. The filename for the resulting compressed file is of the form Abbbb.ZIP
where
A "B" if the destination is the BoE (only)
"C" if the destination is the BBA (or both the BBA and the BoE)
bbbb 4 digit Reporter code allocated by the BoE
10 DATA ENCRYPTION
For security, data files are encrypted using the encryption software PUBLIC, which is
available from Sophos Plc, 21 The Quadrant, Abingdon Science Park, Abingdon,
Oxfordshire, OX14 3YP: tel 0235 559933, fax 0235 559935. To obtain the software,
follow these steps:
1. Raise a purchase order and fax it to Sophos Plc. UK (01235 559935), or post it to
Sophos PLC, Abingdon Science Park, Abingdon, OX14 3YP.
2. Sophos will then send a username and password to allow access to the download
section of the Sophos website
(http://www.sophos.com/companyinfo/contacting/uk/). This will also include the
documentation and licence.
3. The charge will be £895 (plus VAT) for each licence of PUBLIC 5.
4. Any questions can be directed to Jonathan Brooks (01235 544042).
5. The user name and password will be valid for a limited time.
Encryption keys need to be generated and exchanged with the BoE.
Key generation is explained in the relevant section in the PUBLIC manual (Setting up a
PUBLIC communications system). The key must be given a name: this is BANKxxxx,
where xxxx is the unique 4 digit Reporter code allocated by the BoE. To obtain your
unique reporter code please email your request to
MFSD_ELECTRONIC_QUERIES@BANKOFENGLAND.CO.UK
- 83 -
Specification for BEERS (V24) May 2009
Key can now also be sent to the Electronic Queries email address above. The key will be
included in the BoE users' library, and the BoE key sent to the reporting bank for
inclusion in its library.
MBBG members that report to the British Bankers' Association (BBA) will be sent a
second key for use when transmitting data to the BBA.
11 SENDING DATA VIA E-MAIL
Institutions should now send data to the Bank via e-mail.
Live transmissions must be sent to the e-mail address
MFSD_BEERS@BANKOFENGLAND.CO.UK
Test transmissions must be sent to MFSD_EBEERS_TEST@BANKOFENGLAND.CO.UK.
Before sending a test transmission please contact
DATARECEPTION@BANKOFENGLAND.CO.UK
These files must not be sent to any other e-mail address at the Bank. Reporting
Institutions must not send Excel spreadsheets to this address.
Banks who send data e-mail to the BBA must send their encrypted BEERS files to
STATS@BBA.ORG.UK .
Please ensure when sending BEERS files to the BBA, the recipient in the header of the
encrypted file is the BBA and not the Bank of England.
12 RECEIPTS
All forms sent in will receive a receipt. There are three types of receipt.
The first a “valid receipt”, will be sent if the form you send us is in a valid format and the
internal validations are correct. The text will be:
“Thank you for your electronic transmission, your file is formatted correctly and the form
XX for MMM-YYYY has passed internal validation checks. This form was received on
DD/MM/YY at HH:MM.
Many Thanks
Data Reception, MFSD
Please note that anything received after 17.00 will be logged as being received on the
following working day. Cross form validations and plausibility checking have not yet
been performed on these data.”
You will receive the second form of receipt, an “invalid receipt”, if the form you send us
is in a valid format but the internal validations are invalid. The text will be:
“Thank you for your e-mail, your file is formatted correctly but the form XX for MMM-
YYYY has failed internal validation checks. A member of the Data Reception Team will
contact you about this. The form was received on DD/MM/YY at HH:MM.
Many thanks
- 84 -
Specification for BEERS (V24) May 2009
Data Reception, MFSD
Please note that anything received after 17.00 will be logged as being received on the
following working day. Cross form validations and plausibility checking have not yet
been performed on these data. ”
The third receipt, a “pending receipt” will be used if your transmission is waiting longer
than normal to load. The text will be:
“Thank you for your e-mail, your file is currently waiting to load. When this file is
processed, you will receive a further message. This file was received on DD/MM/YY at
HH:MM.
Many thanks
Data Reception, MFSD
Please note that anything received after 17.00 will be logged as being received on the
following working day. Cross form validations and plausibility checking have not yet
been performed on these data.”
This third type of receipt will always be followed by a type one or two. A receipt will be
sent per form. For example, if you send us a single attachment that contains two forms,
then two receipts will be sent back. The text of the receipt will be sent in the body of the
e-mail and also as a text attachment to the e-mail.
If the file you send is incorrectly formatted, no receipt will be sent but you will be
contacted by a member of the Data Reception Team.
- 85 -