Data reference guides

The Data Reference Guide (DRG) contains XML specifications and details of validations applied for all data items submitted to us using Gabriel.

The DRG specifications published on this page only apply to FCA data items. For other data items see information on Common Reporting (COREP) & Financial Reporting (FINREP) and information on PRA and RFB data items.

For each version of a data item we publish the following:

  • Data Definition* - a spreadsheet (XLS) containing details on data types, validations and the Handbook layout with sample data.
  • Schema - a document (XSD) defining the XML structure and data type requirements.
  • Sample* -  a document (XML) demonstrating the XML structure and data types in line with the schema.
  • Template - a spreadsheet (XLS) facilitating the import of XML data from Gabriel to view and save (only available for certain data items).

*All sample data provided is for illustrative purposes only.

See our DRG change log for a history of changes made to the specifications.

Please enter the data item code or name in the search field below to filter the results displayed in the table.

Data Item Code

Data Item Name

Version

Status

Applicable From

Data Definition

Schema

Sample

Template

AIF001

AIFMD Manager Report

1.2

Latest

01/10/2014

XLS

XSD

n/a

unavailable

AIF002

Fund Transparency Report

1.2

Latest

01/10/2014

XLS

XSD

n/a

unavailable

AIFMD

AIFMD Data Types

1.2

Latest

01/10/2014

n/a

XSD

n/a

n/a

AIFMD

ESMA Resources and Sample XML

n/a

Latest

n/a

n/a

n/a

Zip

unavailable

CCR001

Consumer credit data: financial data

1

Latest

01/10/2014

XLS

XSD

XML

XLS

CCR002

Consumer credit data: volumes

4.1

Latest

01/12/2017

XLS

XSD

XML

XLS

CCR002

Consumer credit data: volumes

4

Previous

31/10/2016

XLS

XSD

XML

XLS

CCR003

Consumer credit data: lenders

2.1

Latest

21/11/2016

XLS

XSD

XML

XLS

CCR003

Consumer credit data: lenders

1

Previous

01/10/2014

XLS

XSD

XML

unavailable

CCR004

Consumer credit data: debt management firms

2

Latest

31/12/2014

XLS

XSD

XML

unavailable

CCR004

Consumer credit data: debt management firms

1

Previous

01/10/2014

XLS

XSD

XML

unavailable

CCR005

Consumer credit data: client money and assets

1

Latest

01/10/2014

XLS

XSD

XML

unavailable

CCR006

Consumer credit data: debt collection

1

Latest

01/10/2014

XLS

XSD

XML

unavailable

CCR007

Consumer credit data: key data for credit firms with limited permissions

2.2

Latest

01/12/2017

XLS

XSD

XML

unavailable

CCR008

Consumer credit data: credit broking

1

Latest

30/06/2015

XLS

XSD

XML

XLS

CCR-Complaints

CCR-Complaints Return

2.1

Latest

30/12/2016

XLS

XSD

XML

unavailable

CCR-Complaints

CCR-Complaints Return

1

Previous

01/10/2014

XLS

XSD

XML

unavailable

CMAR

Client Money and Asset Return

5

Latest

30/06/2015

XLS

XSD

XML

XLS

CMAR

Client Money and Asset Return

4.2

Previous

22/04/2013

XLS

XSD

XML

XLS

FSA039

Client Money and Client Assets

1

Latest

12/10/2007

XLS

XSD

XML

unavailable

FIN-APF

Authorised Professional Firms Questionnaire

3

Latest

01/10/2018

XLS

XSD

XML

XLS

FIN-APF

Authorised Professional Firms Questionnaire

2.1

Previous

01/12/2015

XLS

XSD

XML

unavailable

Complaints

Complaints DISP 1 Ann 1R

5.3

Latest

20/08/2018

XLS

XSD

Zip

unavailable

Complaints

Complaints DISP 1 Ann 1R

3

Previous

01/10/2014

XLS

XSD

Zip

XLS

PS-Complaints 

Electronic Money and Payment Services Complaints Return

1

Previous

01/12/2018

XLS

XSD

Zip

XLS

RIA-Complaints

Complaints by Retail Investment Advisers

2.1

Latest

19/09/2016

XLS

XSD

Zip

XLS

FIN-A

Annual report and accounts

2

Latest

31/12/2017

XLS

XSD

XML

XLS

FIN-CAP

Capital adequacy

3

Latest

31/03/2017

XLS

XSD

Zip

XLS

FIN066

Capital adequacy (for collective portfolio management firms)

1.1

Latest

01/12/2015

XLS

XSD

XML

unavailable

FIN067

Capital adequacy: supplemental (for collective portfolio management investment firms subject to IFPRU)

1.1

Latest

01/12/2015

XLS

XSD

XML

unavailable

FIN068

Capital adequacy (for collective portfolio management firms subject to BIPRU)

1.2

Latest

01/12/2015

XLS

XSD

XML

unavailable

FIN069

Financial resources requirements for operators of an electronic system in relation to lending

1.1

Latest

22/05/2017

XLS

XSD

XML

unavailable

FIN070

Information on Peer to Peer agreements

1

Latest

01/10/2014

XLS

XSD

XML

unavailable

FSA001

Balance sheet

4.2

Latest

22/04/2013

XLS

XSD

XML

XLS

FSA002

Income statement

3.2

Latest

01/10/2010

XLS

XSD

XML

unavailable

FSA003

Capital adequacy

6.2

Latest

22/04/2013

XLS

XSD

XML

XLS

FSA004

Further breakdown of certain credit risk data

5.1

Latest

30/06/2011

XLS

XSD

XML

unavailable

FSA005

Market risk

7.1

Previous

31/12/2011

XLS

XSD

XML

unavailable

FSA007

Operational risk

2.1

Latest

29/01/2009

XLS

XSD

XML

unavailable

FSA008

Large exposures

5.1

Latest

22/04/2013

XLS

XSD

Zip

XLS

FSA011

Building society liquidity

4

Latest

07/10/2009

XLS

XSD

XML

unavailable

FSA014

Forecast data from firms

2

Latest

16/11/2007

XLS

XSD

XML

unavailable

FSA015

Sectoral information, including arrears and impairment

4.4

Latest

01/03/2011

XLS

XSD

XML

unavailable

FSA016

Solo consolidated data

2

Latest

16/11/2007

XLS

XSD

XML

unavailable

FSA017

Interest rate gap

5

Latest

31/01/2019

XLS

XSD

XML

unavailable

FSA018

UK integrated groups: large exposures

5

Latest

31/03/2016

XLS

XSD

XML

XLS

FSA019

Pillar 2 information

6.1

Latest

22/11/2016

XLS

XSD

XML

unavailable

FSA028

Non-EEA sub groups

5

Latest

31/10/2016

XLS

XSD

Zip

XLS

FSA029

Balance sheet

2

Latest

01/11/2010

XLS

XSD

Zip

XLS

FSA030

Income statement

1.1

Latest

23/06/2014

XLS

XSD

Zip

XLS

FSA031

Capital adequacy for exempt CAD firms subject to IPRU (INV) Ch 9 only

7

Latest

01/10/2018

XLS

XSD

Zip

XLS

FSA032

Capital adequacy for exempt CAD personal investment firms subject to IPRU (INV) Ch 13 choosing to carry out activities under MiFID Article 67(3)

8

Latest

01/10/2018

XLS

XSD

Zip

XLS

FSA033

Capital adequacy for firms subject to IPRU (INV) Ch 3

1

Latest

12/10/2007

XLS

XSD

XML

unavailable

FSA034

Capital adequacy for firms subject to IPRU (INV) Ch 5 not subject to exemption in IPRU (INV) 5.2.3(2)R

2

Latest

05/06/2008

XLS

XSD

XML

unavailable

FSA035

Capital adequacy for firms subject to IPRU (INV) Ch 5 subject to exemption in IPRU (INV) 5.2.3(2)R

1.5

Latest

24/09/2010

XLS

XSD

Zip

unavailable

FSA038

Volumes and type of business

1

Latest

12/10/2007

XLS

XSD

XML

unavailable

FSA040

CFTC data: Specialist data for firms subject to CFTC part 30 exemption order in respect of open positions for LME transactions of US customers

2

Latest

05/06/2008

XLS

XSD

XML

unavailable

FSA042

UCITS

3

Latest

30/09/2017

XLS

XSD

Zip

XLS

FSA045

IRB portfolio risk

6

Previous

04/03/2011

XLS

XSD

XML

unavailable

FSA046

Securitisation: Non-Trading Book

8

Latest

04/11/2011

XLS

XSD

XML

unavailable

FSA056

Authorised Payment Institution Capital Adequacy Return

4.1

Latest

19/11/2018

XLS

XSD

Zip

XLS

FSA057

Payment Services Directive Transactions

2

Latest

13/01/2018

XLS

XSD

XML

XLS

FSA058

Securitisation: Trading Book

3

Latest

04/11/2011

XLS

XSD

XML

unavailable

FSA047

Daily Flows

2.3

Latest

04/03/2011

XLS

XSD

Zip

XLS

FSA048

Enhanced Mismatch Report

1

Latest

06/09/2010

XLS

XSD

XML

XLS

FSA050

Liquidity Buffer Qualifying Securities

2

Latest

31/10/2012

XLS

XSD

XML

unavailable

FSA051

Funding Concentration

1

Latest

30/11/2010

XLS

XSD

XML

unavailable

FSA052

Pricing Data

1.1

Latest

30/09/2012

XLS

XSD

XML

unavailable

FSA053

Retail, SME and large enterprises Type B Funding

1

Latest

31/12/2010

XLS

XSD

XML

unavailable

FSA054

Currency analysis

1

Latest

31/12/2010

XLS

XSD

XML

unavailable

FSA055

Systems and Controls Questionnaire

1

Latest

31/12/2010

XLS

XSD

XML

unavailable

MLA-A1-A2

Balance sheet

1.1

Latest

20/09/2010

XLS

XSD

XML

unavailable

MLA-A3

Analysis of loans to customers

1

Latest

12/10/2007

XLS

XSD

XML

unavailable

MLA-A4

Analysis of second-charge loans to customers

1

Latest

21/03/2016

XLS

XSD

XML

unavailable

MLA-B1

Income statement

1

Latest

12/10/2007

XLS

XSD

XML

unavailable

MLA-B2

Provisions analysis

1

Latest

12/10/2007

XLS

XSD

XML

unavailable

MLA-C

Capital

2.4

Latest

14/03/2016

XLS

XSD

XML

XLS

MLA-D

Lending - business flows and rates

2.1

Latest

31/05/2013

XLS

XSD

XML

XLS

MLA-D1

Second-charge lending – business flow and rates

2

Latest

31/10/2017

XLS

XSD

XML

unavailable

MLA-E

Residential lending to individuals - new business profile

2

Latest

25/01/2008

XLS

XSD

XML

unavailable

MLA-E1

Second-charge lending – loans to individuals

1.1

Latest

09/07/2016

XLS

XSD

XML

unavailable

MLA-F

Mortgage lending – arrears analysis

3

Latest

31/12/2016

XLS

XSD

XML

unavailable

MLA-F1

Second-charge lending – arrears analysis

2

Latest

31/12/2016

XLS

XSD

XML

unavailable

MLA-G

Mortgage administration - business profile

1.1

Latest

22/04/2013

XLS

XSD

XML

XLS

MLA-H

Mortgage administration – arrears analysis

3

Latest

31/12/2016

XLS

XSD

XML

unavailable

MLA-H1

Second-charge mortgage administration – arrears analysis

2

Latest

31/12/2016

XLS

XSD

XML

unavailable

MLA-J

Fee tariff measures

2

Latest

22/04/2013

XLS

XSD

XML

unavailable

MLA-L

Credit risk

1.2

Latest

01/10/2014

XLS

XSD

XML

XLS

MLA-M

Liquidity questionnaire

1.1

Latest

01/10/2014

XLS

XSD

Zip

XLS

RMA-A

Balance sheet

2

Latest

31/12/2013

XLS

XSD

Zip

XLS

RMA-B

Profit and loss account

4

Latest

21/03/2016

XLS

XSD

XML

unavailable

RMA-C

Client money and assets

4

Latest

01/10/2018

XLS

XSD

XML

XLS

RMA-D1

Regulatory capital

5

Latest

30/06/2017

XLS

XSD

Zip

unavailable

RMA-E

Professional indemnity insurance (PII) self-certification

8

Latest

01/10/2018

XLS

XSD

XML

XLS

RMA-F

Threshold conditions

2

Latest

31/05/2013

XLS

XSD

XML

unavailable

RMA-G

Training and competence

6

Latest

28/02/2018

XLS

XSD

Zip

XLS

RMA-H

Conduct of Business Sourcebook (COBS) data

3.2

Latest

31/10/2013

XLS

XSD

XML

unavailable

RMA-I

Supplementary product sales data

3

Latest

31/12/2010

XLS

XSD

XML

unavailable

RMA-J

Data required for collection of fees

7

Latest

01/04/2019

XLS

XSD

XML

XLS

RMA-J

Data required for collection of fees

6

Previous

01/04/2018

XLS

XSD

XML

XLS

RMA-K

Adviser charges

5

Latest

31/12/2016

XLS

XSD

XML

XLS

REP001

Close Links Report

2

Latest

01/11/2014

XLS

XSD

XML

XLS

REP001a

Close Links Notification

2

Latest

01/11/2014

XLS

XSD

XML

XLS

REP002

Controllers Report

2.1

Latest

01/11/2014

XLS

XSD

XML

unavailable

REP003

Persistency Reporting

1

Latest

31/12/2014

XLS

XSD

XML

XLS

REP004

Remuneration Benchmarking Report

1.1

Latest

14/03/2016

XLS

XSD

XML

XLS

REP005

High Earners Report

1.2

Latest

22/05/2017

XLS

XSD

XML

unavailable

REP005

High Earners Report - Template to generate XML file & Nil Return Sample

1.2

Latest

22/05/2017

n/a

n/a

XML

Zip

REP006

Recovery Plans

1.1

Latest

19/09/2016

XLS

XSD

XML

XLS

REP006a

Recovery Plans Notification

1.1

Latest

19/09/2016

XLS

XSD

XML

XLS

REP007

Resolution Plans

1.1

Latest

19/09/2016

XLS

XSD

XML

XLS

REP007a

Resolution Plans Notification

1.1

Latest

19/09/2016

XLS

XSD

XML

XLS

REP008

Notification of Disciplinary Action

2

Previous

01/08/2017

XLS

XSD

Zip

unavailable

REP009

Consumer Buy-To-Let Mortgage Aggregated Data

1

Latest

01/04/2016

XLS

XSD

XML

unavailable

REP010

List of Overseas Regulators and Organogram

1

Latest

01/04/2016

XLS

XSD

XML

XLS

REP011

Monthly Breach Report from Depositaries

1

Latest

01/01/2017

XLS

XSD

XML

XLS

REP012

Quarterly Oversight Report from Depositaries

1

Latest

01/01/2017

XLS

XSD

XML

XLS

REP015

Retirement Income Flow Data

1

Latest

30/09/2018

XLS

XSD

XML

unavailable

REP016

Retirement Income Stock and Withdrawals Flow Data

1

Latest

30/09/2018

XLS

XSD

XML

unavailable

REP017

Payments Fraud Report

1

Previous

31/12/2018

XLS

XSD

XML

unavailable

REP018

Operational and Security Risk

1

Previous

30/09/2018

XLS

XSD

XML

unavailable

REP-CRIM

Financial Crime Report

2

Latest

31/03/2018

XLS

XSD

Zip

XLS

PSD001

Product Sales Data - Mortgage (accounts opened from 1 April 2021)

3

Future

01/04/2021

XLS

XSD

Zip

n/a

PSD001

Product Sales Data - Mortgage (accounts opened between 1 April 2017 and 31 March 2021)

2.1

Latest

24/09/2018

XLS

XSD

Zip

n/a

PSD001

Product Sales Data - Mortgage (accounts opened between 1 January 2015 and 31 March 2017)

1.7.8

Previous

14/03/2016

XLS

XSD

Zip

n/a

PSD001

Product Sales Data - Mortgage (accounts opened before 1 January 2015)

1.3

Previous

22/04/2013

XLS

XSD

XML

n/a

PSD002

Product Sales Data - Retail Investments

1.5

Latest

22/04/2013

XLS

XSD

XML

n/a

PSD003

Product Sales Data - Pure Protection

1.3

Latest

22/04/2013

XLS

XSD

XML

n/a

PSD004

Product Sales Data - Home Reversion Plans

2.1

Latest

22/04/2013

XLS

XSD

XML

n/a

PSD005

Product Sales Data - Home Purchase Plans

2.1

Latest

01/09/2012

XLS

XSD

XML

n/a

PSD006

Product Sales Data - Short Term Loans

1

Latest

01/10/2014

XLS

XSD

XML

n/a

PSD007

Product Sales Data - Mortgage Performance Data (date of balance from 1 April 2017)

2

Latest

01/04/2017

XLS

XSD

XML

n/a

PSD007

Product Sales Data - Mortgage Performance Data (date of balance before 1 April 2017)

1.5

Latest

14/03/2016

XLS

XSD

XML

n/a

Common

Common Data Types (referenced by all data items)

12

Latest

31/03/2018

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

11

Previous

31/05/2016

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

10

Previous

30/11/2015

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

9

Previous

30/06/2015

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

8

Previous

01/09/2014

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

7

Previous

31/10/2013

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

6.1

Previous

01/03/2012

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

5.2

Previous

20/12/2010

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

4

Previous

25/01/2008

XLS

XSD

n/a

n/a

Common

Common Data Types (referenced by all data items)

3

Previous

16/11/2007

XLS

XSD

n/a

n/a

PSD

PSD Common Data Types (referenced by Product Sales Data (PSD) items)

2

Latest

22/11/2010

unavailable

XSD

n/a

n/a

SDS001

Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E)

9

Latest

21/11/2016

XLS

XSD

n/a

n/a

SDS001

Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E)

8

Previous

01/12/2011

XLS

XSD

n/a

n/a

SDS001

Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E)

7

Previous

16/08/2010

XLS

XSD

n/a

n/a

SDS001

Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E)

6

Previous

01/06/2010

XLS

XSD

n/a

n/a

SDS001

Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E)

5

Previous

01/12/2009

XLS

XSD

n/a

n/a

SDS001

Shared Definitions (PII definitions referenced in FSA031, FSA032 and RMA-E)

4

Previous

05/06/2008

XLS

XSD

n/a

n/a

SDS001

Shared Definitions (complex types referenced in FSA031, FSA032 and RMA-E)

3

Previous

19/12/2007

XLS

;

n/a

n/a

SDS002

Shared Definitions (complex types referenced in MLA-F, MLA-F1, MLA-H and MLA-H1)

3

Latest

21/11/2016

XLS

XSD

n/a

n/a

SDS002

Shared Definitions (complex types referenced in MLA-F, MLA-F1, MLA-H and MLA-H1)

2

Previous

25/01/2008

XLS

XSD

n/a

n/a

SDS003

Shared Definitions (referenced by consolidated basis group data items).

4

Latest

07/10/2009

XLS

XSD

n/a

n/a

SDS003

Shared Definitions (referenced by consolidated basis group data items).

3

Previous

25/01/2008

XLS

XSD

n/a

n/a

SDS003

Shared Definitions (referenced by consolidated basis group data items).

2

Previous

16/11/2007

XLS

XSD

n/a

n/a

SDS004

Shared Definitions (complex types referenced in RMA-D1)

1

Latest

05/06/2008

XLS

XSD

n/a

n/a

Meta

Meta Data (supports individual data item schemas)

1

Latest

23/03/2007

XLS

XSD

n/a

n/a

Common

Cross Validation Rules

13

Latest

17/08/2016

PDF

n/a

n/a

n/a

FSA005

Market risk

8

Latest

31/01/2019

XLS

XSD

XML

unavailable

FSA045

IRB portfolio risk

7

Latest

31/01/2019

XLS

XSD

XML

unavailable

REP017

Payments Fraud Report

2

Previous

30/06/2019

XLS

XSD

XML

XLS

PS-Complaints

Electronic Money and Payment Service Complaints Return

2

Latest

01/07/2019

XLS

XSD

Zip

unavailable

REP008

Notification of Disciplinary Action relating to conduct rules staff (other than SMF managers)

3

Latest

31/08/2019

XLS

XSD

Zip

unavailable

REP020

Quarterly statistics on availability and performance of dedicated interfaces

1.1

Latest

30/09/2019

XLS

XSD

Zip

unavailable

REP018

Operational and Security Risk

2

Latest

30/09/2019

XLS

XSD

XML

XLS

REP017

Payments Fraud Report

3.1

Latest

31/12/2019

XLS

XSD

XML

XLS

REP017a

Payments Fraud Report

1

Latest

31/12/2019

XLS

XSD

XML

XLS

REP017b

Payments Fraud Report

1

Latest

31/12/2019

XLS

XSD

XML

XLS