CRS Template Guide

The template spreadsheet consists of two worksheets: Configuration and Data.
This guide contains descriptions of each field.

Sheet: Configuration - Reporting FI details

Field Name/Header Description Required? Example/Values
Name The full legal name of the Reporting FI. Should exaclty match what is configured with receiving tax authority. y My Co Channel Islands Limited
Address The full address (registered office or correspondence) of the Reporting FI. y The Office, The Address, The City, The Country, The Postcode
FI GIN The Reporting FI's GIIN (Global Identification Number) as specified in the tax authority portal. y AB123456
City The City of the Reporting FI (as per the address). y The City
Country The Country of the Reporting FI (as per the address). Must be 2-digit ISO code. y GG, JE, GB, CY, etc.
Receiving Country The Country of the receiving tax authority. Must be 2-digit ISO code. y GG, JE, SG, CH, AE, HK, etc.
Messsage Type Indicator The type of submission being made. y CRS701 - New data
CRS702 - Corrections / deletions
Message Type Ignore - it must be 'CRS'. Will be removed in a later version. y CRS
Reporting Period The year end of the period being reported, in dd/MM/yyyy format. y 12/31/2022
Original MessageRefId Ignore. Only used for corrections. y
Original DocRefId Ignore. Only used for corrections. y
Template Version Ignore. Will be removed in a later version. y 5
Has Been Changed Ignore. Will be removed in a later version. y

Sheet: Data

Field Name/Header Description Required? Example/Values
Original DocRefId Ignore. Used for corrections.
Deletion Marker Ignore. Used for corrections (deletions).
Entity Type The type of entity being reported. y Company / Individual / Trustee
Company Name Full legal company name of the Company being reported. Only if Entity Type = Company MyCo Limited
First Name Legal first/fore name of the individual being reported. Only if Entity Type = Individual Roger
Middle Name Legal middle name of the of the individual being reported. Bob
Last Name Legal surname of the of the individual being reported. Only if Entity Type = Individual Harris
Address Full address of the entity. y House, Street, City, Country, Postcode
City Of Residence City of the reported address. y City
Country Of Residence Country of the reported address. Must be 2-digit ISO code. y
Country Of Tax Residence 2-digit ISO code of primary country of tax residence that issued the reported TIN. y US, GG, JE, etc.
TIN The Tax Identification Number associated with the primary country of tax residence. y AB12345
Country Of Tax Residence 2
TIN 2
Country Of Tax Residence 3
TIN 3
DOB Date Of Birth in dd/MM/yyyy. Only if Entity Type = Individual 01/01/1970
Account No Account number or other identifier used by the FI to identify the account or account holder. y P12345
Account Holder Type CRS specification of the type of account. y Passive Non-Financial Entity with 1 or many Reportable People
CRS Reportable Person
Passive NFE that is CRS Reportable
Undocumented Account Whether the account was pre-existing and therefore not complete data. Should not really be used and will likely be removed in a later version. y True / False
Closed Account Is the account closed (i.e., was it closed during the reporting period). y True / False
Dormant Account Whether the account is dormant. y True / False
Account Currency 3 letter ISO code of the currency of the account. y EUR, GBP, USD, etc.
Last Years Account Value In Account Currency The value of the account at the year end (or the date the account was closed or transferred.) If the Account is Closed this should usually be 0. If specified, it must be a positive number or 0.00. y 10,000.00
Last Year Withdrawals In Account Currency The value of withdrawals or other FATCA relevant payments made during the reporting period. If specified, it must be a positive number or 0.00. 5,000.00
Last Year Dividend Paid In Account Currency The value of any FATCA relevant dividends made during the reporting period. If specified, it must be a positive number or 0.00. 15
Last Year Interest Paid In Account Currency The value of any FATCA relevant interest made during the reporting period. If specified, it must be a positive number or 0.00. 25.25
Last Year Other Income Paid In Account Currency Any other FATCA relevant income or payments not previously captured. If specified, it must be a positive number or 0.00. 50
Controlling Person 1 First Name Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 Middle Name
Controlling Person 1 Last Name Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 TIN Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 Tax Country Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 TIN 2 Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 Tax Country 2 Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 TIN 3 Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 Tax Country 3 Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 Address Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 City Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 Country Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 DOB Only required for Entity Type = Company. Requirements as per above.
Controlling Person 1 Type Only required for Entity Type = Company. Requirements as per above. CRS801 = CP of legal person – ownership
CRS802 = CP of legal person – other means
CRS803 = CP of legal person – senior managing official
CRS804 = CP of legal arrangement – trust – settlor
CRS805 = CP of legal arrangement – trust – trustee
CRS806 = CP of legal arrangement – trust – protector
CRS807 = CP of legal arrangement – trust – beneficiary
CRS808 = CP of legal arrangement – trust – other
CRS809 = CP of legal arrangement – other – settlor-equivalent
CRS810 = CP of legal arrangement – other – trustee-equivalent
CRS811 = CP of legal arrangement – other – protector-equivalent
CRS812 = CP of legal arrangement – other – beneficiary-equivalent
CRS813 = CP of legal arrangement – other – other-equivalent