Info Page Status: DRAFT

Sample Excel Import File: Import_CRS_Example.xlsx 

Sample Excel Import File 2 Record March 2018: CRSPro_ImportExample_2_recordMar2018.xlsx

Sample Excel Multiple Tabs Import File: Import_CRS_MultipleTabs_Example.xlsx

Sample Excel Multiple Tabs Import File including Joint Account March 2018: CRS_ImportExmples_MultipleTabs_includingJointAccountMar2018.xlsx


Import Form Fields:

Field NameDescriptionNotes
See Form Filer Common Fields

See Recipient Common Fields

RecordTypeP, PMT, AH, CP, CPC,
CodeDescription
PParent. Each line with a "P" Record Type represents a new CRS reportable account.
PMTPayment.  Use this Record Type if more than one Payment is associated with a "P" CRS reportable account.
AHAccount Holder. Use this Record Type if more than one Account Holder / Name / TIN / Address is associated with a "P" CRS reportable account. 
CPUse this Record Type if an Account has one or more Controlling Persons. 
CPCControlling Person Child. Use this Record Type if a Controlling Person has multiple names or addresses.
AH_Type

Account Holder Type

Indicator if the account is held by a Person = CRS007 or an Entity CRS101, CRS102 or CRS103

CodeDescription
CRS007Natural Person (added by Pro)
CRS101Entity - Passive Non-Financial Entity with – one or more controlling person that is a Reportable Person
CRS102Entity - CRS Reportable Person
CP_TypeType of Controlling Person
CodeDescription

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

AccountCreatedDateDate of Account CreationMM/DD/YYYY
BalanceAccount Holders Balance

Total Account Balance

BalanceCurrCode

Balance Currency Code

AN_TypeAccount Number Type
CodeDescription

OECD601:

IBAN International Bank Account Number (follows a known structure)
OECD602:OBAN Other Bank Account Number
OECD603:ISIN International Securities Information Number (follows a known structure)
OECD604:OSIN Other Securities Information Number
OECD605:Other Any other type of account number e.g. insurance
UndocumentedAccountCheck Box

X / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks"

ClosedAccount

Check BoxX / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks"
DormantAccountCheck BoxX / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks"
PaymentAmount

Multiple payments can be associated with a single CRS reportable account.

PaymentCurrCode
Table of Currency Codes
PaymentTypeType of Payment
TypeType of Payment
CRS501Dividends
CRS502Interest
CRS503Gross Proceeds/Redemptions
CRS504Other – CRS. (Example: other income generated with respect to the assets held in the account)
ResCountryCode
Table of CRS Country Codes
TINTax Identification NumberThis data element identifies the Tax identification Number (TIN) used by the receiving tax administration to identify the individual Account Holder. The TIN (if available) should be supplied as specified in the CRS and can be repeated for multiple TINs.
IssuedBy
This attribute identifies the jurisdiction that issued the TIN. If the issuing jurisdiction is not know then is may be left blank.
ORG_INType
Type of Entity Tax Number (filled in at the FILER / Reporting FI)
NameType
NamePerson_TypeThe nameType attribute is the same for Organisations as for Persons. Possible values are:
OECD202indiv
OECD203alias
OECD204nick
OECD205aka
OECD206dba
OECD207legal
OECD208atbirth
OECD201SMFAliasOrOther (not used for CRS)
PrecedingTitleName FieldExample: His Excellency
TitleName FieldGreeting title. Example: Dr, Mr, Ms, Herr, etc. Can have multiple titles.
xnlNameTypePrefixName FieldDefines the type of name associated with the NamePrefix, For example: de, van , van de, von, etc. (Derick de Clarke)
xnlNameTypeFirstName FieldFirst Name of person
xnlNameTypeLastName FieldLast Name of person. Can be Given Name, Forename, Christian Name, Surname, Family Name etc.
Birth_Date
Date of Birth
Birth_City
City of Birthplace
Birth_CitySubentity
City of Birthplace sub entity
Birth_CountryCode
Table of CRS Country Codes
Birth_FormerCountry
Birth Country name field of countries that have changed names or no longer exist
LegalAddressType
LegalAddressType   Type of Address
OECD301residentialOrBusiness
OECD302residential
OECD303business
OECD304registeredOffice
OECD305unspecified
StreetStreet AddressExample: 1 Financial Way
BuildingIDBuilding IdentificationExample: Building A
FloorIDFloor IdentificationExample: Penthouse
SuiteSuite NumberExample: 190, 12th Floor
DistrictNameName of DistrictExample: Gas Lamp District
POBPost Office BoxPost office Box number. Example: Box#20, Box 2A
CityName of CityExample: Los Angeles
CountrySubEntity

Sub Entity of Country

PostCode

The PostCode should always be included where it exists.

CountryCode
AddressFree

This data element allows input of address information in free text. If the user chooses the option to enter the data required in a less structured way in “AddressFree” all available address details shall be presented as one string of bytes, blank or “/” (slash) or carriage return-line feed used as a delimiter between parts of the address. *This option should only be used if the data cannot be presented in the AddressFix format.





FAQ's - Collection Efforts, Account Holder Research and Definitions

Foreign Tax identification numbers (TINs)

High Level Overview of common Reporting Standard (CRS)

OECD - Activated Exchange Relationships for CRS information

OECD - CRS by Jurisdiction (2 years)

OECD - Implementation Handbook (CRS Standard)

Standard for Automatic Exchange of Financial Account information in Tax Matters 2nd Edition



Table of Currency Codes
CodeDescriptionCodeDescription
AEDUAE Dirham: UNITED ARAB EMIRATESMDLUAE Dirham: UNITED ARAB EMIRATES
AFNAfghani: AFGHANISTANMGAAfghani: AFGHANISTAN
ALLLek: ALBANIAMKDLek: ALBANIA
AMDArmenian Dram: ARMENIAMMKArmenian Dram: ARMENIA
ANGNetherlands Antillean Guilder: CURACAO; SINT MAARTEN (DUTCH PART)MNTNetherlands Antillean Guilder: CURACAO; SINT MAARTEN (DUTCH PART)
AOAKwanza: ANGOLAMOPKwanza: ANGOLA
ARSArgentine Peso: ARGENTINAMROArgentine Peso: ARGENTINA
AUDAustralian Dollar: AUSTRALIA; CHRISTMAS ISLAND; COCOS (KEELING) ISLANDS; HEARD ISLAND AND McDONALD ISLANDS; KIRIBATI; NAURU; NORFOLK ISLAND; TUVALUMURAustralian Dollar: AUSTRALIA; CHRISTMAS ISLAND; COCOS (KEELING) ISLANDS; HEARD ISLAND AND McDONALD ISLANDS; KIRIBATI; NAURU; NORFOLK ISLAND; TUVALU
AWGAruban Florin: ARUBAMVRAruban Florin: ARUBA
AZNAzerbaijanian Manat: AZERBAIJANMWKAzerbaijanian Manat: AZERBAIJAN
BAMConvertible Mark: BOSNIA AND HERZEGOVINAMXNConvertible Mark: BOSNIA AND HERZEGOVINA
BBDBarbados Dollar: BARBADOSMXVBarbados Dollar: BARBADOS
BDTTaka: BANGLADESHMYRTaka: BANGLADESH
BGNBulgarian Lev: BULGARIAMZNBulgarian Lev: BULGARIA
BHDBahraini Dinar: BAHRAINNADBahraini Dinar: BAHRAIN
BIFBurundi Franc: BURUNDINGNBurundi Franc: BURUNDI
BMDBermudian Dollar: BERMUDANIOBermudian Dollar: BERMUDA
BNDBrunei Dollar: BRUNEI DARUSSALAMNOKBrunei Dollar: BRUNEI DARUSSALAM
BOBBoliviano: BOLIVIA, PLURINATIONAL STATE OFNPRBoliviano: BOLIVIA, PLURINATIONAL STATE OF
BOVMvdol: BOLIVIA, PLURINATIONAL STATE OFNZDMvdol: BOLIVIA, PLURINATIONAL STATE OF
BRLBrazilian Real: BRAZILOMRBrazilian Real: BRAZIL
BSDBahamian Dollar: BAHAMASPABBahamian Dollar: BAHAMAS
BTNNgultrum: BHUTANPENNgultrum: BHUTAN
BWPPula: BOTSWANAPGKPula: BOTSWANA
BYRBelarussian Ruble: BELARUSPHPBelarussian Ruble: BELARUS
BZDBelize Dollar: BELIZEPKRBelize Dollar: BELIZE
CADCanadian Dollar: CANADAPLNCanadian Dollar: CANADA
CDFCongolese Franc: CONGO, THE DEMOCRATIC REPUBLIC OFPYGCongolese Franc: CONGO, THE DEMOCRATIC REPUBLIC OF
CHEWIR Euro: SWITZERLANDQARWIR Euro: SWITZERLAND
CHFSwiss Franc: LIECHTENSTEIN; SWITZERLANDRONSwiss Franc: LIECHTENSTEIN; SWITZERLAND
CHWWIR Franc: SWITZERLANDRSDWIR Franc: SWITZERLAND
CLFUnidades de fomento: CHILERUBUnidades de fomento: CHILE
CLPChilean Peso: CHILERWFChilean Peso: CHILE
CNYYuan Renminbi: CHINASARYuan Renminbi: CHINA
COPColombian Peso: COLOMBIASBDColombian Peso: COLOMBIA
COUUnidad de Valor Real: COLOMBIASCRUnidad de Valor Real: COLOMBIA
CRCCosta Rican Colon: COSTA RICASDGCosta Rican Colon: COSTA RICA
CUCPeso Convertible: CUBASEKPeso Convertible: CUBA
CUPCuban Peso: CUBASGDCuban Peso: CUBA
CVECape Verde Escudo: CAPE VERDESHPCape Verde Escudo: CAPE VERDE
CZKCzech Koruna: CZECH REPUBLICSLLCzech Koruna: CZECH REPUBLIC
DJFDjibouti Franc: DJIBOUTISOSDjibouti Franc: DJIBOUTI
DKKDanish Krone: DENMARK; FAROE ISLANDS; GREENLANDSRDDanish Krone: DENMARK; FAROE ISLANDS; GREENLAND
DOPDominican Peso: DOMINICAN REPUBLICSSPDominican Peso: DOMINICAN REPUBLIC
DZDAlgerian Dinar: ALGERIASTDAlgerian Dinar: ALGERIA
EGPEgyptian Pound: EGYPTSVCEgyptian Pound: EGYPT
ERNNakfa: ERITREASYPNakfa: ERITREA
ETBEthiopian Birr: ETHIOPIASZLEthiopian Birr: ETHIOPIA
EUREuro: ALAND ISLANDS; ANDORRA; AUSTRIA; BELGIUM; CYPRUS; ESTONIA; EUROPEAN UNION; FINLAND; FRANCE; FRENCH GUIANA; FRENCH SOUTHERN TERRITORIES; GERMANY; GREECE; GUADELOUPE; HOLY SEE (VATICAN CITY STATE); IRELAND; ITALY; LUXEMBOURG; MALTA; MARTINIQUE; MAYOTTE; MONACO; MONTENEGRO; NETHERLANDS; PORTUGAL; REUNION; SAINT BARTHELEMY; SAINT MARTIN (FRENCH PART); SAINT PIERRE AND MIQUELON; SAN MARINO; SLOVAKIA; SLOVENIA; SPAIN; Vatican City State (HOLY SEE)THBEuro: ALAND ISLANDS; ANDORRA; AUSTRIA; BELGIUM; CYPRUS; ESTONIA; EUROPEAN UNION; FINLAND; FRANCE; FRENCH GUIANA; FRENCH SOUTHERN TERRITORIES; GERMANY; GREECE; GUADELOUPE; HOLY SEE (VATICAN CITY STATE); IRELAND; ITALY; LUXEMBOURG; MALTA; MARTINIQUE; MAYOTTE; MONACO; MONTENEGRO; NETHERLANDS; PORTUGAL; REUNION; SAINT BARTHELEMY; SAINT MARTIN (FRENCH PART); SAINT PIERRE AND MIQUELON; SAN MARINO; SLOVAKIA; SLOVENIA; SPAIN; Vatican City State (HOLY SEE)
FJDFiji Dollar: FIJITJSFiji Dollar: FIJI
FKPFalkland Islands Pound: FALKLAND ISLANDS (MALVINAS)TMTFalkland Islands Pound: FALKLAND ISLANDS (MALVINAS)
GBPPound Sterling: GUERNSEY; ISLE OF MAN; JERSEY; UNITED KINGDOMTNDPound Sterling: GUERNSEY; ISLE OF MAN; JERSEY; UNITED KINGDOM
GELLari: GEORGIATOPLari: GEORGIA
GHSGhana Cedi: GHANATRYGhana Cedi: GHANA
GIPGibraltar Pound: GIBRALTARTTDGibraltar Pound: GIBRALTAR
GMDDalasi: GAMBIATWDDalasi: GAMBIA
GNFGuinea Franc: GUINEATZSGuinea Franc: GUINEA
GTQQuetzal: GUATEMALAUAHQuetzal: GUATEMALA
GYDGuyana Dollar: GUYANAUGXGuyana Dollar: GUYANA
HKDHong Kong Dollar: HONG KONGUSDHong Kong Dollar: HONG KONG
HNLLempira: HONDURASUSNLempira: HONDURAS
HRKCroatian Kuna: CROATIAUSSCroatian Kuna: CROATIA
HTGGourde: HAITIUYIGourde: HAITI
HUFForint: HUNGARYUYUForint: HUNGARY
IDRRupiah: INDONESIAUZSRupiah: INDONESIA
ILSNew Israeli Sheqel: ISRAELVEFNew Israeli Sheqel: ISRAEL
INRIndian Rupee: BHUTAN; INDIAVNDIndian Rupee: BHUTAN; INDIA
IQDIraqi Dinar: IRAQVUVIraqi Dinar: IRAQ
IRRIranian Rial: IRAN, ISLAMIC REPUBLIC OFWSTIranian Rial: IRAN, ISLAMIC REPUBLIC OF
ISKIceland Krona: ICELANDXAFIceland Krona: ICELAND
JMDJamaican Dollar: JAMAICAXAGJamaican Dollar: JAMAICA
JODJordanian Dinar: JORDANXAUJordanian Dinar: JORDAN
JPYYen: JAPANXBAYen: JAPAN
KESKenyan Shilling: KENYAXBBKenyan Shilling: KENYA
KGSSom: KYRGYZSTANXBCSom: KYRGYZSTAN
KHRRiel: CAMBODIAXBDRiel: CAMBODIA
KMFComoro Franc: COMOROSXCDComoro Franc: COMOROS
KPWNorth Korean Won: KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OFXDRNorth Korean Won: KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OF
KRWWon: KOREA, REPUBLIC OFXFUWon: KOREA, REPUBLIC OF
KWDKuwaiti Dinar: KUWAITXOFKuwaiti Dinar: KUWAIT
KYDCayman Islands Dollar: CAYMAN ISLANDSXPDCayman Islands Dollar: CAYMAN ISLANDS
KZTTenge: KAZAKHSTANXPFTenge: KAZAKHSTAN
LAKKip: LAO PEOPLE’S DEMOCRATIC REPUBLICXPTKip: LAO PEOPLE’S DEMOCRATIC REPUBLIC
LBPLebanese Pound: LEBANONXSULebanese Pound: LEBANON
LKRSri Lanka Rupee: SRI LANKAXUASri Lanka Rupee: SRI LANKA
LRDLiberian Dollar: LIBERIAXXXLiberian Dollar: LIBERIA
LSLLoti: LESOTHOYERLoti: LESOTHO
LTLLithuanian Litas: LITHUANIAZARLithuanian Litas: LITHUANIA
LVLLatvian Lats: LATVIAZMWLatvian Lats: LATVIA
LYDLibyan Dinar: LIBYAZWLLibyan Dinar: LIBYA
MADMoroccan Dirham: MOROCCO; WESTERN SAHARA
Moroccan Dirham: MOROCCO; WESTERN SAHARA


Table of CRS Country Codes
CRS CodeCRS CountryCRS CodeCRS Country
AFAFGHANISTANLRLIBERIA
AXALAND ISLANDSLYLIBYA
ALALBANIALILIECHTENSTEIN
DZALGERIALTLITHUANIA
ASAMERICAN SAMOALULUXEMBOURG
ADANDORRAMOMACAO
AOANGOLAMKMACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF
AIANGUILLAMGMADAGASCAR
AQANTARCTICAMWMALAWI
AGANTIGUA AND BARBUDAMYMALAYSIA
ARARGENTINAMVMALDIVES
AMARMENIAMLMALI
AWARUBAMTMALTA
AUAUSTRALIAMHMARSHALL ISLANDS
ATAUSTRIAMQMARTINIQUE
AZAZERBAIJANMRMAURITANIA
BSBAHAMASMUMAURITIUS
BHBAHRAINYTMAYOTTE
BDBANGLADESHMXMEXICO
BBBARBADOSFMMICRONESIA, FEDERATED STATES OF
BYBELARUSMDMOLDOVA, REPUBLIC OF
BEBELGIUMMCMONACO
BZBELIZEMNMONGOLIA
BJBENINMEMONTENEGRO
BMBERMUDAMSMONTSERRAT
BTBHUTANMAMOROCCO
BOBOLIVIA, PLURINATIONAL STATE OFMZMOZAMBIQUE
BQBONAIRE, SINT EUSTATIUS AND SABAMMMYANMAR
BABOSNIA AND HERZEGOVINANANAMIBIA
BWBOTSWANANRNAURU
BVBOUVET ISLANDNPNEPAL
BRBRAZILNLNETHERLANDS
IOBRITISH INDIAN OCEAN TERRITORYNCNEW CALEDONIA
BNBRUNEI DARUSSALAMNZNEW ZEALAND
BGBULGARIANINICARAGUA
BFBURKINA FASONENIGER
BIBURUNDINGNIGERIA
KHCAMBODIANUNIUE
CMCAMEROONNFNORFOLK ISLAND
CACANADAMPNORTHERN MARIANA ISLANDS
CVCAPE VERDENONORWAY
KYCAYMAN ISLANDSOMOMAN
CFCENTRAL AFRICAN REPUBLICPKPAKISTAN
TDCHADPWPALAU
CLCHILEPSPALESTINE, STATE OF
CNCHINAPAPANAMA
CXCHRISTMAS ISLANDPGPAPUA NEW GUINEA
CCCOCOS (KEELING) ISLANDSPYPARAGUAY
COCOLOMBIAPEPERU
KMCOMOROSPHPHILIPPINES
CGCONGOPNPITCAIRN
CDCONGO, THE DEMOCRATIC REPUBLIC OF THEPLPOLAND
CKCOOK ISLANDSPTPORTUGAL
CRCOSTA RICAPRPUERTO RICO
CICOTE D'IVOIREQAQATAR
HRCROATIAREREUNION
CUCUBAROROMANIA
CWCURACAORURUSSIAN FEDERATION
CYCYPRUSRWRWANDA
CZCZECH REPUBLICBLSAINT BARTHELEMY
DKDENMARKSHSAINT HELENA, ASCENSION AND TRISTAN DA CUNHA
DJDJIBOUTIKNSAINT KITTS AND NEVIS
DMDOMINICALCSAINT LUCIA
DODOMINICAN REPUBLICMFSAINT MARTIN (FRENCH PART)
ECECUADORPMSAINT PIERRE AND MIQUELON
EGEGYPTVCSAINT VINCENT AND THE GRENADINES
SVEL SALVADORWSSAMOA
GQEQUATORIAL GUINEASMSAN MARINO
ERERITREASTSAO TOME AND PRINCIPE
EEESTONIASASAUDI ARABIA
ETETHIOPIASNSENEGAL
FKFALKLAND ISLANDS (MALVINAS)RSSERBIA
FOFAROE ISLANDSSCSEYCHELLES
FJFIJISLSIERRA LEONE
FIFINLANDSGSINGAPORE
FRFRANCESXSINT MAARTEN (DUTCH PART)
GFFRENCH GUIANASKSLOVAKIA
PFFRENCH POLYNESIASISLOVENIA
TFFRENCH SOUTHERN TERRITORIESSBSOLOMON ISLANDS
GAGABONSOSOMALIA
GMGAMBIAZASOUTH AFRICA
GEGEORGIAGSSOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS
DEGERMANYSSSOUTH SUDAN
GHGHANAESSPAIN
GIGIBRALTARLKSRI LANKA
GRGREECESDSUDAN
GLGREENLANDSRSURINAME
GDGRENADASJSVALBARD AND JAN MAYEN
GPGUADELOUPESZSWAZILAND
GUGUAMSESWEDEN
GTGUATEMALACHSWITZERLAND
GGGUERNSEYSYSYRIAN ARAB REPUBLIC
GNGUINEATWTAIWAN, PROVINCE OF CHINA
GWGUINEA-BISSAUTJTAJIKISTAN
GYGUYANATZTANZANIA, UNITED REPUBLIC OF
HTHAITITHTHAILAND
HMHEARD ISLAND AND MCDONALD ISLANDSTLTIMOR-LESTE
VAHOLY SEE (VATICAN CITY STATE)TGTOGO
HNHONDURASTKTOKELAU
HKHONG KONGTOTONGA
HUHUNGARYTTTRINIDAD AND TOBAGO
ISICELANDTNTUNISIA
ININDIATRTURKEY
IDINDONESIATMTURKMENISTAN
IRIRAN, ISLAMIC REPUBLIC OFTCTURKS AND CAICOS ISLANDS
IQIRAQTVTUVALU
IEIRELANDUGUGANDA
IMISLE OF MANUAUKRAINE
ILISRAELAEUNITED ARAB EMIRATES
ITITALYGBUNITED KINGDOM
JMJAMAICAUSUNITED STATES
JPJAPANUMUNITED STATES MINOR OUTLYING ISLANDS
JEJERSEYUYURUGUAY
JOJORDANUZUZBEKISTAN
KZKAZAKHSTANVUVANUATU
KEKENYAVEVENEZUELA, BOLIVARIAN REPUBLIC OF
KIKIRIBATIVNVIET NAM
KPKOREA, DEMOCRATIC PEOPLE'S REPUBLIC OFVGVIRGIN ISLANDS, BRITISH
KRKOREA, REPUBLIC OFVIVIRGIN ISLANDS, U.S.
KWKUWAITWFWALLIS AND FUTUNA
KGKYRGYZSTANEHWESTERN SAHARA
LALAO PEOPLE'S DEMOCRATIC REPUBLICYEYEMEN
LVLATVIAZMZAMBIA
LBLEBANONZWZIMBABWE
LSLESOTHO


Info Page Status:

Sample Excel Import File: Import_CRS_Example.xlsx 

Sample Excel Multiple Tabs Import File: Import_CRS_MultipleTabs_Example.xlsx


Import Form Fields:

Field NameDescriptionNotes
See Form Filer Common Fields

See Recipient Common Fields

RecordTypeP, PMT, AH, CP, CPC,
CodeDescription
PParent. Each line with a "P" Record Type represents a new CRS reportable account.
PMTPayment.  Use this Record Type if more than one Payment is associated with a "P" CRS reportable account.
AHAccount Holder. Use this Record Type if more than one Account Holder / Name / TIN / Address is associated with a "P" CRS reportable account. 
CPUse this Record Type if an Account has one or more Controlling Persons. 
CPCControlling Person Child. Use this Record Type if a Controlling Person has multiple names or addresses.
AH_Type

Account Holder Type

Indicator if the account is held by a Person = CRS007 or an Entity CRS101, CRS102 or CRS103

CodeDescription
CRS007Natural Person (added by Pro)
CRS101Entity - Passive Non-Financial Entity with – one or more controlling person that is a Reportable Person
CRS102Entity - CRS Reportable Person
CP_TypeType of Controlling Person
CodeDescription

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

AccountCreatedDateDate of Account CreationMM/DD/YYYY
BalanceAccount Holders Balance

Total Account Balance

BalanceCurrCode

Balance Currency Code

AN_TypeAccount Number Type
CodeDescription

OECD601:

IBAN International Bank Account Number (follows a known structure)
OECD602:OBAN Other Bank Account Number
OECD603:ISIN International Securities Information Number (follows a known structure)
OECD604:OSIN Other Securities Information Number
OECD605:Other Any other type of account number e.g. insurance
UndocumentedAccountCheck Box

X / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks"

ClosedAccount

Check BoxX / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks"
DormantAccountCheck BoxX / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks"
PaymentAmount

Multiple payments can be associated with a single CRS reportable account.

PaymentCurrCode
Table of Currency Codes
PaymentTypeType of Payment
TypeType of Payment
CRS501Dividends
CRS502Interest
CRS503Gross Proceeds/Redemptions
CRS504Other – CRS. (Example: other income generated with respect to the assets held in the account)
ResCountryCode
Table of CRS Country Codes
TINTax Identification NumberThis data element identifies the Tax identification Number (TIN) used by the receiving tax administration to identify the individual Account Holder. The TIN (if available) should be supplied as specified in the CRS and can be repeated for multiple TINs.
IssuedBy
This attribute identifies the jurisdiction that issued the TIN. If the issuing jurisdiction is not know then is may be left blank.
ORG_INType
Type of Entity Tax Number (filled in at the FILER / Reporting FI)
NameType
NamePerson_TypeThe nameType attribute is the same for Organisations as for Persons. Possible values are:
OECD202indiv
OECD203alias
OECD204nick
OECD205aka
OECD206dba
OECD207legal
OECD208atbirth
OECD201SMFAliasOrOther (not used for CRS)
PrecedingTitleName FieldExample: His Excellency
TitleName FieldGreeting title. Example: Dr, Mr, Ms, Herr, etc. Can have multiple titles.
xnlNameTypePrefixName FieldDefines the type of name associated with the NamePrefix, For example: de, van , van de, von, etc. (Derick de Clarke)
xnlNameTypeFirstName FieldFirst Name of person
xnlNameTypeLastName FieldLast Name of person. Can be Given Name, Forename, Christian Name, Surname, Family Name etc.
Birth_Date
Date of Birth
Birth_City
City of Birthplace
Birth_CitySubentity
City of Birthplace sub entity
Birth_CountryCode
Table of CRS Country Codes
Birth_FormerCountry
Birth Country name field of countries that have changed names or no longer exist
LegalAddressType
LegalAddressType   Type of Address
OECD301residentialOrBusiness
OECD302residential
OECD303business
OECD304registeredOffice
OECD305unspecified
StreetStreet AddressExample: 1 Financial Way
BuildingIDBuilding IdentificationExample: Building A
FloorIDFloor IdentificationExample: Penthouse
SuiteSuite NumberExample: 190, 12th Floor
DistrictNameName of DistrictExample: Gas Lamp District
POBPost Office BoxPost office Box number. Example: Box#20, Box 2A
CityName of CityExample: Los Angeles
CountrySubEntity

Sub Entity of Country

PostCode

The PostCode should always be included where it exists.

CountryCode
AddressFree

This data element allows input of address information in free text. If the user chooses the option to enter the data required in a less structured way in “AddressFree” all available address details shall be presented as one string of bytes, blank or “/” (slash) or carriage return-line feed used as a delimiter between parts of the address. *This option should only be used if the data cannot be presented in the AddressFix format.





FAQ's - Collection Efforts, Account Holder Research and Definitions

Foreign Tax identification numbers (TINs)

High Level Overview of common Reporting Standard (CRS)

OECD - Activated Exchange Relationships for CRS information

OECD - CRS by Jurisdiction (2 years)

OECD - Implementation Handbook (CRS Standard)

Standard for Automatic Exchange of Financial Account information in Tax Matters 2nd Edition


Table of Currency Codes
CodeDescriptionCodeDescription
AEDUAE Dirham: UNITED ARAB EMIRATESMDLUAE Dirham: UNITED ARAB EMIRATES
AFNAfghani: AFGHANISTANMGAAfghani: AFGHANISTAN
ALLLek: ALBANIAMKDLek: ALBANIA
AMDArmenian Dram: ARMENIAMMKArmenian Dram: ARMENIA
ANGNetherlands Antillean Guilder: CURACAO; SINT MAARTEN (DUTCH PART)MNTNetherlands Antillean Guilder: CURACAO; SINT MAARTEN (DUTCH PART)
AOAKwanza: ANGOLAMOPKwanza: ANGOLA
ARSArgentine Peso: ARGENTINAMROArgentine Peso: ARGENTINA
AUDAustralian Dollar: AUSTRALIA; CHRISTMAS ISLAND; COCOS (KEELING) ISLANDS; HEARD ISLAND AND McDONALD ISLANDS; KIRIBATI; NAURU; NORFOLK ISLAND; TUVALUMURAustralian Dollar: AUSTRALIA; CHRISTMAS ISLAND; COCOS (KEELING) ISLANDS; HEARD ISLAND AND McDONALD ISLANDS; KIRIBATI; NAURU; NORFOLK ISLAND; TUVALU
AWGAruban Florin: ARUBAMVRAruban Florin: ARUBA
AZNAzerbaijanian Manat: AZERBAIJANMWKAzerbaijanian Manat: AZERBAIJAN
BAMConvertible Mark: BOSNIA AND HERZEGOVINAMXNConvertible Mark: BOSNIA AND HERZEGOVINA
BBDBarbados Dollar: BARBADOSMXVBarbados Dollar: BARBADOS
BDTTaka: BANGLADESHMYRTaka: BANGLADESH
BGNBulgarian Lev: BULGARIAMZNBulgarian Lev: BULGARIA
BHDBahraini Dinar: BAHRAINNADBahraini Dinar: BAHRAIN
BIFBurundi Franc: BURUNDINGNBurundi Franc: BURUNDI
BMDBermudian Dollar: BERMUDANIOBermudian Dollar: BERMUDA
BNDBrunei Dollar: BRUNEI DARUSSALAMNOKBrunei Dollar: BRUNEI DARUSSALAM
BOBBoliviano: BOLIVIA, PLURINATIONAL STATE OFNPRBoliviano: BOLIVIA, PLURINATIONAL STATE OF
BOVMvdol: BOLIVIA, PLURINATIONAL STATE OFNZDMvdol: BOLIVIA, PLURINATIONAL STATE OF
BRLBrazilian Real: BRAZILOMRBrazilian Real: BRAZIL
BSDBahamian Dollar: BAHAMASPABBahamian Dollar: BAHAMAS
BTNNgultrum: BHUTANPENNgultrum: BHUTAN
BWPPula: BOTSWANAPGKPula: BOTSWANA
BYRBelarussian Ruble: BELARUSPHPBelarussian Ruble: BELARUS
BZDBelize Dollar: BELIZEPKRBelize Dollar: BELIZE
CADCanadian Dollar: CANADAPLNCanadian Dollar: CANADA
CDFCongolese Franc: CONGO, THE DEMOCRATIC REPUBLIC OFPYGCongolese Franc: CONGO, THE DEMOCRATIC REPUBLIC OF
CHEWIR Euro: SWITZERLANDQARWIR Euro: SWITZERLAND
CHFSwiss Franc: LIECHTENSTEIN; SWITZERLANDRONSwiss Franc: LIECHTENSTEIN; SWITZERLAND
CHWWIR Franc: SWITZERLANDRSDWIR Franc: SWITZERLAND
CLFUnidades de fomento: CHILERUBUnidades de fomento: CHILE
CLPChilean Peso: CHILERWFChilean Peso: CHILE
CNYYuan Renminbi: CHINASARYuan Renminbi: CHINA
COPColombian Peso: COLOMBIASBDColombian Peso: COLOMBIA
COUUnidad de Valor Real: COLOMBIASCRUnidad de Valor Real: COLOMBIA
CRCCosta Rican Colon: COSTA RICASDGCosta Rican Colon: COSTA RICA
CUCPeso Convertible: CUBASEKPeso Convertible: CUBA
CUPCuban Peso: CUBASGDCuban Peso: CUBA
CVECape Verde Escudo: CAPE VERDESHPCape Verde Escudo: CAPE VERDE
CZKCzech Koruna: CZECH REPUBLICSLLCzech Koruna: CZECH REPUBLIC
DJFDjibouti Franc: DJIBOUTISOSDjibouti Franc: DJIBOUTI
DKKDanish Krone: DENMARK; FAROE ISLANDS; GREENLANDSRDDanish Krone: DENMARK; FAROE ISLANDS; GREENLAND
DOPDominican Peso: DOMINICAN REPUBLICSSPDominican Peso: DOMINICAN REPUBLIC
DZDAlgerian Dinar: ALGERIASTDAlgerian Dinar: ALGERIA
EGPEgyptian Pound: EGYPTSVCEgyptian Pound: EGYPT
ERNNakfa: ERITREASYPNakfa: ERITREA
ETBEthiopian Birr: ETHIOPIASZLEthiopian Birr: ETHIOPIA
EUREuro: ALAND ISLANDS; ANDORRA; AUSTRIA; BELGIUM; CYPRUS; ESTONIA; EUROPEAN UNION; FINLAND; FRANCE; FRENCH GUIANA; FRENCH SOUTHERN TERRITORIES; GERMANY; GREECE; GUADELOUPE; HOLY SEE (VATICAN CITY STATE); IRELAND; ITALY; LUXEMBOURG; MALTA; MARTINIQUE; MAYOTTE; MONACO; MONTENEGRO; NETHERLANDS; PORTUGAL; REUNION; SAINT BARTHELEMY; SAINT MARTIN (FRENCH PART); SAINT PIERRE AND MIQUELON; SAN MARINO; SLOVAKIA; SLOVENIA; SPAIN; Vatican City State (HOLY SEE)THBEuro: ALAND ISLANDS; ANDORRA; AUSTRIA; BELGIUM; CYPRUS; ESTONIA; EUROPEAN UNION; FINLAND; FRANCE; FRENCH GUIANA; FRENCH SOUTHERN TERRITORIES; GERMANY; GREECE; GUADELOUPE; HOLY SEE (VATICAN CITY STATE); IRELAND; ITALY; LUXEMBOURG; MALTA; MARTINIQUE; MAYOTTE; MONACO; MONTENEGRO; NETHERLANDS; PORTUGAL; REUNION; SAINT BARTHELEMY; SAINT MARTIN (FRENCH PART); SAINT PIERRE AND MIQUELON; SAN MARINO; SLOVAKIA; SLOVENIA; SPAIN; Vatican City State (HOLY SEE)
FJDFiji Dollar: FIJITJSFiji Dollar: FIJI
FKPFalkland Islands Pound: FALKLAND ISLANDS (MALVINAS)TMTFalkland Islands Pound: FALKLAND ISLANDS (MALVINAS)
GBPPound Sterling: GUERNSEY; ISLE OF MAN; JERSEY; UNITED KINGDOMTNDPound Sterling: GUERNSEY; ISLE OF MAN; JERSEY; UNITED KINGDOM
GELLari: GEORGIATOPLari: GEORGIA
GHSGhana Cedi: GHANATRYGhana Cedi: GHANA
GIPGibraltar Pound: GIBRALTARTTDGibraltar Pound: GIBRALTAR
GMDDalasi: GAMBIATWDDalasi: GAMBIA
GNFGuinea Franc: GUINEATZSGuinea Franc: GUINEA
GTQQuetzal: GUATEMALAUAHQuetzal: GUATEMALA
GYDGuyana Dollar: GUYANAUGXGuyana Dollar: GUYANA
HKDHong Kong Dollar: HONG KONGUSDHong Kong Dollar: HONG KONG
HNLLempira: HONDURASUSNLempira: HONDURAS
HRKCroatian Kuna: CROATIAUSSCroatian Kuna: CROATIA
HTGGourde: HAITIUYIGourde: HAITI
HUFForint: HUNGARYUYUForint: HUNGARY
IDRRupiah: INDONESIAUZSRupiah: INDONESIA
ILSNew Israeli Sheqel: ISRAELVEFNew Israeli Sheqel: ISRAEL
INRIndian Rupee: BHUTAN; INDIAVNDIndian Rupee: BHUTAN; INDIA
IQDIraqi Dinar: IRAQVUVIraqi Dinar: IRAQ
IRRIranian Rial: IRAN, ISLAMIC REPUBLIC OFWSTIranian Rial: IRAN, ISLAMIC REPUBLIC OF
ISKIceland Krona: ICELANDXAFIceland Krona: ICELAND
JMDJamaican Dollar: JAMAICAXAGJamaican Dollar: JAMAICA
JODJordanian Dinar: JORDANXAUJordanian Dinar: JORDAN
JPYYen: JAPANXBAYen: JAPAN
KESKenyan Shilling: KENYAXBBKenyan Shilling: KENYA
KGSSom: KYRGYZSTANXBCSom: KYRGYZSTAN
KHRRiel: CAMBODIAXBDRiel: CAMBODIA
KMFComoro Franc: COMOROSXCDComoro Franc: COMOROS
KPWNorth Korean Won: KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OFXDRNorth Korean Won: KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OF
KRWWon: KOREA, REPUBLIC OFXFUWon: KOREA, REPUBLIC OF
KWDKuwaiti Dinar: KUWAITXOFKuwaiti Dinar: KUWAIT
KYDCayman Islands Dollar: CAYMAN ISLANDSXPDCayman Islands Dollar: CAYMAN ISLANDS
KZTTenge: KAZAKHSTANXPFTenge: KAZAKHSTAN
LAKKip: LAO PEOPLE’S DEMOCRATIC REPUBLICXPTKip: LAO PEOPLE’S DEMOCRATIC REPUBLIC
LBPLebanese Pound: LEBANONXSULebanese Pound: LEBANON
LKRSri Lanka Rupee: SRI LANKAXUASri Lanka Rupee: SRI LANKA
LRDLiberian Dollar: LIBERIAXXXLiberian Dollar: LIBERIA
LSLLoti: LESOTHOYERLoti: LESOTHO
LTLLithuanian Litas: LITHUANIAZARLithuanian Litas: LITHUANIA
LVLLatvian Lats: LATVIAZMWLatvian Lats: LATVIA
LYDLibyan Dinar: LIBYAZWLLibyan Dinar: LIBYA
MADMoroccan Dirham: MOROCCO; WESTERN SAHARA
Moroccan Dirham: MOROCCO; WESTERN SAHARA


Table of CRS Country Codes
CRS CodeCRS CountryCRS CodeCRS Country
AFAFGHANISTANLRLIBERIA
AXALAND ISLANDSLYLIBYA
ALALBANIALILIECHTENSTEIN
DZALGERIALTLITHUANIA
ASAMERICAN SAMOALULUXEMBOURG
ADANDORRAMOMACAO
AOANGOLAMKMACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF
AIANGUILLAMGMADAGASCAR
AQANTARCTICAMWMALAWI
AGANTIGUA AND BARBUDAMYMALAYSIA
ARARGENTINAMVMALDIVES
AMARMENIAMLMALI
AWARUBAMTMALTA
AUAUSTRALIAMHMARSHALL ISLANDS
ATAUSTRIAMQMARTINIQUE
AZAZERBAIJANMRMAURITANIA
BSBAHAMASMUMAURITIUS
BHBAHRAINYTMAYOTTE
BDBANGLADESHMXMEXICO
BBBARBADOSFMMICRONESIA, FEDERATED STATES OF
BYBELARUSMDMOLDOVA, REPUBLIC OF
BEBELGIUMMCMONACO
BZBELIZEMNMONGOLIA
BJBENINMEMONTENEGRO
BMBERMUDAMSMONTSERRAT
BTBHUTANMAMOROCCO
BOBOLIVIA, PLURINATIONAL STATE OFMZMOZAMBIQUE
BQBONAIRE, SINT EUSTATIUS AND SABAMMMYANMAR
BABOSNIA AND HERZEGOVINANANAMIBIA
BWBOTSWANANRNAURU
BVBOUVET ISLANDNPNEPAL
BRBRAZILNLNETHERLANDS
IOBRITISH INDIAN OCEAN TERRITORYNCNEW CALEDONIA
BNBRUNEI DARUSSALAMNZNEW ZEALAND
BGBULGARIANINICARAGUA
BFBURKINA FASONENIGER
BIBURUNDINGNIGERIA
KHCAMBODIANUNIUE
CMCAMEROONNFNORFOLK ISLAND
CACANADAMPNORTHERN MARIANA ISLANDS
CVCAPE VERDENONORWAY
KYCAYMAN ISLANDSOMOMAN
CFCENTRAL AFRICAN REPUBLICPKPAKISTAN
TDCHADPWPALAU
CLCHILEPSPALESTINE, STATE OF
CNCHINAPAPANAMA
CXCHRISTMAS ISLANDPGPAPUA NEW GUINEA
CCCOCOS (KEELING) ISLANDSPYPARAGUAY
COCOLOMBIAPEPERU
KMCOMOROSPHPHILIPPINES
CGCONGOPNPITCAIRN
CDCONGO, THE DEMOCRATIC REPUBLIC OF THEPLPOLAND
CKCOOK ISLANDSPTPORTUGAL
CRCOSTA RICAPRPUERTO RICO
CICOTE D'IVOIREQAQATAR
HRCROATIAREREUNION
CUCUBAROROMANIA
CWCURACAORURUSSIAN FEDERATION
CYCYPRUSRWRWANDA
CZCZECH REPUBLICBLSAINT BARTHELEMY
DKDENMARKSHSAINT HELENA, ASCENSION AND TRISTAN DA CUNHA
DJDJIBOUTIKNSAINT KITTS AND NEVIS
DMDOMINICALCSAINT LUCIA
DODOMINICAN REPUBLICMFSAINT MARTIN (FRENCH PART)
ECECUADORPMSAINT PIERRE AND MIQUELON
EGEGYPTVCSAINT VINCENT AND THE GRENADINES
SVEL SALVADORWSSAMOA
GQEQUATORIAL GUINEASMSAN MARINO
ERERITREASTSAO TOME AND PRINCIPE
EEESTONIASASAUDI ARABIA
ETETHIOPIASNSENEGAL
FKFALKLAND ISLANDS (MALVINAS)RSSERBIA
FOFAROE ISLANDSSCSEYCHELLES
FJFIJISLSIERRA LEONE
FIFINLANDSGSINGAPORE
FRFRANCESXSINT MAARTEN (DUTCH PART)
GFFRENCH GUIANASKSLOVAKIA
PFFRENCH POLYNESIASISLOVENIA
TFFRENCH SOUTHERN TERRITORIESSBSOLOMON ISLANDS
GAGABONSOSOMALIA
GMGAMBIAZASOUTH AFRICA
GEGEORGIAGSSOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS
DEGERMANYSSSOUTH SUDAN
GHGHANAESSPAIN
GIGIBRALTARLKSRI LANKA
GRGREECESDSUDAN
GLGREENLANDSRSURINAME
GDGRENADASJSVALBARD AND JAN MAYEN
GPGUADELOUPESZSWAZILAND
GUGUAMSESWEDEN
GTGUATEMALACHSWITZERLAND
GGGUERNSEYSYSYRIAN ARAB REPUBLIC
GNGUINEATWTAIWAN, PROVINCE OF CHINA
GWGUINEA-BISSAUTJTAJIKISTAN
GYGUYANATZTANZANIA, UNITED REPUBLIC OF
HTHAITITHTHAILAND
HMHEARD ISLAND AND MCDONALD ISLANDSTLTIMOR-LESTE
VAHOLY SEE (VATICAN CITY STATE)TGTOGO
HNHONDURASTKTOKELAU
HKHONG KONGTOTONGA
HUHUNGARYTTTRINIDAD AND TOBAGO
ISICELANDTNTUNISIA
ININDIATRTURKEY
IDINDONESIATMTURKMENISTAN
IRIRAN, ISLAMIC REPUBLIC OFTCTURKS AND CAICOS ISLANDS
IQIRAQTVTUVALU
IEIRELANDUGUGANDA
IMISLE OF MANUAUKRAINE
ILISRAELAEUNITED ARAB EMIRATES
ITITALYGBUNITED KINGDOM
JMJAMAICAUSUNITED STATES
JPJAPANUMUNITED STATES MINOR OUTLYING ISLANDS
JEJERSEYUYURUGUAY
JOJORDANUZUZBEKISTAN
KZKAZAKHSTANVUVANUATU
KEKENYAVEVENEZUELA, BOLIVARIAN REPUBLIC OF
KIKIRIBATIVNVIET NAM
KPKOREA, DEMOCRATIC PEOPLE'S REPUBLIC OFVGVIRGIN ISLANDS, BRITISH
KRKOREA, REPUBLIC OFVIVIRGIN ISLANDS, U.S.
KWKUWAITWFWALLIS AND FUTUNA
KGKYRGYZSTANEHWESTERN SAHARA
LALAO PEOPLE'S DEMOCRATIC REPUBLICYEYEMEN
LVLATVIAZMZAMBIA
LBLEBANONZWZIMBABWE
LSLESOTHO