Info Page Status: FINAL

Sample Excel Import File: Import_CRS_Example.xlsx 

Sample Excel Import File - Two Records Only: CRSPro_ImportExample_2_recordMar2018.xlsx

Sample Excel Import File - Multiple Tabs: Import_CRS_MultipleTabs_Example.xlsx

Sample Excel Import File - Multiple Tabs - Including Joint Account: CRS_ImportExmples_MultipleTabs_includingJointAccountMar2018.xlsx

What's New for 2018

  • No Changes to form for 2018

Import Form Fields:

Field Name

Description

Notes

See Form Filer Common Fields

See Recipient Common Fields

RecordTypeP, PMT, AH, CP, CPC,

Code

Description

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

Code

Description

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

Code

Description

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

Code

Description

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

Type

Type 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_Type

The 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  MM/DD/YYYY
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


Useful Links



Table of Currency Codes
CodeDescriptionCodeDescription
AEDUAE Dirham: UNITED ARAB EMIRATESMDLMoldovan Leu: MOLDOVA, REPUBLIC OF
AFNAfghani: AFGHANISTANMGAMalagasy Ariary: MADAGASCAR
ALLLek: ALBANIAMKDDenar: MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF
AMDArmenian Dram: ARMENIAMMKKyat: MYANMAR
ANGNetherlands Antillean Guilder: CURACAO; SINT MAARTEN (DUTCH PART)MNTTugrik: MONGOLIA
AOAKwanza: ANGOLAMOPPataca: MACAO
ARSArgentine Peso: ARGENTINAMRO

Ouguiya: MAURITANIA

AUDAustralian Dollar: AUSTRALIA; CHRISTMAS ISLAND; COCOS (KEELING) ISLANDS; HEARD ISLAND AND McDONALD ISLANDS; KIRIBATI; NAURU; NORFOLK ISLAND; TUVALUMURMauritius Rupee: MAURITIUS
AWGAruban Florin: ARUBAMVRRufiyaa: MALDIVES
AZNAzerbaijanian Manat: AZERBAIJANMWKKwacha: MALAWI
BAMConvertible Mark: BOSNIA AND HERZEGOVINAMXNMexican Peso: MEXICO
BBDBarbados Dollar: BARBADOSMXVMexican Unidad de Inversion (UDI): MEXICO
BDTTaka: BANGLADESHMYRMalaysian Ringgit: MALAYSIA
BGNBulgarian Lev: BULGARIAMZNMozambique Metical: MOZAMBIQUE
BHDBahraini Dinar: BAHRAINNADNamibia Dollar: NAMIBIA
BIFBurundi Franc: BURUNDINGNNaira: NIGERIA
BMDBermudian Dollar: BERMUDANIOCordoba Oro: NICARAGUA
BNDBrunei Dollar: BRUNEI DARUSSALAMNOKNorwegian Krone: BOUVET ISLAND; NORWAY; SVALBARD AND JAN MAYEN
BOBBoliviano: BOLIVIA, PLURINATIONAL STATE OFNPRNepalese Rupee: NEPAL
BOVMvdol: BOLIVIA, PLURINATIONAL STATE OFNZDNew Zealand Dollar: COOK ISLANDS; NEW ZEALAND; NIUE; PITCAIRN; TOKELAU
BRLBrazilian Real: BRAZILOMRRial Omani: OMAN
BSDBahamian Dollar: BAHAMASPABBalboa: PANAMA
BTNNgultrum: BHUTANPENNuevo Sol: PERU
BWPPula: BOTSWANAPGKKina: PAPUA NEW GUINEA
BYRBelarussian Ruble: BELARUSPHPPhilippine Peso: PHILIPPINES
BZDBelize Dollar: BELIZEPKRPakistan Rupee: PAKISTAN
CADCanadian Dollar: CANADAPLNZloty: POLAND
CDFCongolese Franc: CONGO, THE DEMOCRATIC REPUBLIC OFPYGGuarani: PARAGUAY
CHEWIR Euro: SWITZERLANDQARQatari Rial: QATAR
CHFSwiss Franc: LIECHTENSTEIN; SWITZERLANDRONNew Romanian Leu: ROMANIA
CHWWIR Franc: SWITZERLANDRSDSerbian Dinar: SERBIA
CLFUnidades de fomento: CHILERUBRussian Ruble: RUSSIAN FEDERATION
CLPChilean Peso: CHILERWFRwanda Franc: RWANDA
CNYYuan Renminbi: CHINASARSaudi Riyal: SAUDI ARABIA
COPColombian Peso: COLOMBIASBDSolomon Islands Dollar: SOLOMON ISLANDS
COUUnidad de Valor Real: COLOMBIASCRSeychelles Rupee: SEYCHELLES
CRCCosta Rican Colon: COSTA RICASDGSudanese Pound: SUDAN
CUCPeso Convertible: CUBASEKSwedish Krona: SWEDEN
CUPCuban Peso: CUBASGDSingapore Dollar: SINGAPORE
CVECape Verde Escudo: CAPE VERDESHPSaint Helena Pound: SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA
CZKCzech Koruna: CZECH REPUBLICSLLLeone: SIERRA LEONE
DJFDjibouti Franc: DJIBOUTISOSSomali Shilling: SOMALIA
DKKDanish Krone: DENMARK; FAROE ISLANDS; GREENLANDSRDSurinam Dollar: SURINAME
DOPDominican Peso: DOMINICAN REPUBLICSSPSouth Sudanese Pound: SOUTH SUDAN
DZDAlgerian Dinar: ALGERIASTDDobra: SAO TOME AND PRINCIPE
EGPEgyptian Pound: EGYPTSVCEl Salvador Colon: EL SALVADOR
ERNNakfa: ERITREASYPSyrian Pound: SYRIAN ARAB REPUBLIC
ETBEthiopian Birr: ETHIOPIASZLLilangeni: SWAZILAND
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)THBBaht: THAILAND
FJDFiji Dollar: FIJITJSSomoni: TAJIKISTAN
FKPFalkland Islands Pound: FALKLAND ISLANDS (MALVINAS)TMTTurkmenistan New Manat: TURKMENISTAN
GBPPound Sterling: GUERNSEY; ISLE OF MAN; JERSEY; UNITED KINGDOMTNDTunisian Dinar: TUNISIA
GELLari: GEORGIATOPPa’anga: TONGA
GHSGhana Cedi: GHANATRYTurkish Lira: TURKEY
GIPGibraltar Pound: GIBRALTARTTDTrinidad and Tobago Dollar: TRINIDAD AND TOBAGO
GMDDalasi: GAMBIATWDNew Taiwan Dollar: TAIWAN, PROVINCE OF CHINA
GNFGuinea Franc: GUINEATZSTanzanian Shilling: TANZANIA, UNITED REPUBLIC OF
GTQQuetzal: GUATEMALAUAHHryvnia: UKRAINE
GYDGuyana Dollar: GUYANAUGXUganda Shilling: UGANDA
HKDHong Kong Dollar: HONG KONGUSDUS Dollar: AMERICAN SAMOA; BONAIRE; SINT EUSTATIUS AND SABA; BRITISH INDIAN OCEAN TERRITORY; ECUADOR; EL SALVADOR; GUAM; HAITI; MARSHALL ISLANDS; MICRONESIA, FEDERATED STATES OF; NORTHERN MARIANA ISLANDS; PALAU; PANAMA; PUERTO RICO; TIMOR-LESTE; TURKS AND CAICOS ISLANDS, UNITED STATES; UNITED STATES MINOR OUTLYING ISLANDS; VIRGIN ISLANDS (BRITISH); VIRGIN ISLANDS (US)
HNLLempira: HONDURASUSNUS Dollar (Next day): UNITED STATES
HRKCroatian Kuna: CROATIAUSSUS Dollar (Same day): UNITED STATES
HTGGourde: HAITIUYIUruguay Peso en Unidades Indexadas (URUIURUI): URUGUAY
HUFForint: HUNGARYUYUPeso Uruguayo: URUGUAY
IDRRupiah: INDONESIAUZSUzbekistan Sum: UZBEKISTAN
ILSNew Israeli Sheqel: ISRAELVEFBolivar: VENEZUELA, BOLIVARIAN REPUBLIC OF
INRIndian Rupee: BHUTAN; INDIAVNDDong: VIET NAM
IQDIraqi Dinar: IRAQVUVVatu: VANUATU
IRRIranian Rial: IRAN, ISLAMIC REPUBLIC OFWSTTala: SAMOA
ISKIceland Krona: ICELANDXAFCFA Franc BEAC: CAMEROON; CENTRAL AFRICAN REPUBLIC; CHAD; CONGO; EQUATORIAL GUINEA; GABON
JMDJamaican Dollar: JAMAICAXAGSilver: ZZ11_Silver
JODJordanian Dinar: JORDANXAUGold: ZZ08_Gold
JPYYen: JAPANXBABond Markets Unit European Composite Unit (EURCO): ZZ01_Bond Markets Unit European_EURCO
KESKenyan Shilling: KENYAXBBBond Markets Unit European Monetary Unit (E.M.U.-6): ZZ02_Bond Markets Unit European_EMU-6
KGSSom: KYRGYZSTANXBCBond Markets Unit European Unit of Account 9 (E.U.A.-9): ZZ03_Bond Markets Unit European_EUA-9
KHRRiel: CAMBODIAXBDBond Markets Unit European Unit of Account 17 (E.U.A.-17): ZZ04_Bond Markets Unit European_EUA-17
KMFComoro Franc: COMOROSXCDEast Caribbean Dollar: ANGUILLA; ANTIGUA AND BARBUDA; DOMINICA; GRENADA; MONTSERRAT; SAINT KITTS AND NEVIS; SAINT LUCIA; SAINT VINCENT AND THE GRENADINES
KPWNorth Korean Won: KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OFXDRSDR (Special Drawing Right): INTERNATIONAL MONETARY FUND (IMF)
KRWWon: KOREA, REPUBLIC OFXFUUIC-Franc: ZZ05_UIC-Franc
KWDKuwaiti Dinar: KUWAITXOFCFA Franc BCEAO: BENIN; BURKINA FASO; COTE D'IVOIRE; GUINEA-BISSAU; MALI; NIGER; SENEGAL; TOGO
KYDCayman Islands Dollar: CAYMAN ISLANDSXPDPalladium: ZZ09_Palladium
KZTTenge: KAZAKHSTANXPFCFP Franc: FRENCH POLYNESIA; NEW CALEDONIA; WALLIS AND FUTUNA
LAKKip: LAO PEOPLE’S DEMOCRATIC REPUBLICXPTPlatinum: ZZ10_Platinum
LBPLebanese Pound: LEBANONXSUSucre: SISTEMA UNITARIO DE COMPENSACION REGIONAL DE PAGOS "SUCRE"
LKRSri Lanka Rupee: SRI LANKAXUAADB Unit of Account: MEMBER COUNTRIES OF THE AFRICAN DEVELOPMENT BANK GROUP
LRDLiberian Dollar: LIBERIAXXXThe codes assigned for transactions where no currency is involved: ZZ07_No_Currency
LSLLoti: LESOTHOYERYemeni Rial: YEMEN
LTLLithuanian Litas: LITHUANIAZARRand: LESOTHO; NAMIBIA; SOUTH AFRICA
LVLLatvian Lats: LATVIAZMWZambian Kwacha: ZAMBIA
LYDLibyan Dinar: LIBYAZWLZimbabwe Dollar: ZIMBABWE
MADMoroccan 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

  • No labels