- Loading...
Info Page Status: FINAL
Sample Excel Import File: Import_CRS_Example.xlsx
Sample Excel Import File - Two Records Only (March 2018): 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 (March 2018): CRS_ImportExmples_MultipleTabs_includingJointAccountMar2018.xlsx
Import Form Fields:
Field Name | Description | Notes | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
See Form Filer Common Fields | ||||||||||||||||||||||||||||||
See Recipient Common Fields | ||||||||||||||||||||||||||||||
RecordType | P, PMT, AH, CP, CPC, |
| ||||||||||||||||||||||||||||
AH_Type | Account Holder Type Indicator if the account is held by a Person = CRS007 or an Entity CRS101, CRS102 or CRS103 |
| ||||||||||||||||||||||||||||
CP_Type | Type of Controlling Person |
| ||||||||||||||||||||||||||||
AccountCreatedDate | Date of Account Creation | MM/DD/YYYY | ||||||||||||||||||||||||||||
Balance | Account Holders Balance | Total Account Balance | ||||||||||||||||||||||||||||
BalanceCurrCode | Balance Currency Code | |||||||||||||||||||||||||||||
AN_Type | Account Number Type |
| ||||||||||||||||||||||||||||
UndocumentedAccount | Check Box | X / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks" | ||||||||||||||||||||||||||||
ClosedAccount | Check Box | X / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks" | ||||||||||||||||||||||||||||
DormantAccount | Check Box | X / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks" | ||||||||||||||||||||||||||||
Payment | Amount | Multiple payments can be associated with a single CRS reportable account. | ||||||||||||||||||||||||||||
PaymentCurrCode | Table of Currency Codes | |||||||||||||||||||||||||||||
PaymentType | Type of Payment |
| ||||||||||||||||||||||||||||
ResCountryCode | Table of CRS Country Codes | |||||||||||||||||||||||||||||
TIN | Tax Identification Number | This 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 |
| |||||||||||||||||||||||||||||
PrecedingTitle | Name Field | Example: His Excellency | ||||||||||||||||||||||||||||
Title | Name Field | Greeting title. Example: Dr, Mr, Ms, Herr, etc. Can have multiple titles. | ||||||||||||||||||||||||||||
xnlNameTypePrefix | Name Field | Defines the type of name associated with the NamePrefix, For example: de, van , van de, von, etc. (Derick de Clarke) | ||||||||||||||||||||||||||||
xnlNameTypeFirst | Name Field | First Name of person | ||||||||||||||||||||||||||||
xnlNameTypeLast | Name Field | Last 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 |
| |||||||||||||||||||||||||||||
Street | Street Address | Example: 1 Financial Way | ||||||||||||||||||||||||||||
BuildingID | Building Identification | Example: Building A | ||||||||||||||||||||||||||||
FloorID | Floor Identification | Example: Penthouse | ||||||||||||||||||||||||||||
Suite | Suite Number | Example: 190, 12th Floor | ||||||||||||||||||||||||||||
DistrictName | Name of District | Example: Gas Lamp District | ||||||||||||||||||||||||||||
POB | Post Office Box | Post office Box number. Example: Box#20, Box 2A | ||||||||||||||||||||||||||||
City | Name of City | Example: 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 | |||
---|---|---|---|
Code | Description | Code | Description |
AED | UAE Dirham: UNITED ARAB EMIRATES | MDL | Moldovan Leu: MOLDOVA, REPUBLIC OF |
AFN | Afghani: AFGHANISTAN | MGA | Malagasy Ariary: MADAGASCAR |
ALL | Lek: ALBANIA | MKD | Denar: MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF |
AMD | Armenian Dram: ARMENIA | MMK | Kyat: MYANMAR |
ANG | Netherlands Antillean Guilder: CURACAO; SINT MAARTEN (DUTCH PART) | MNT | Tugrik: MONGOLIA |
AOA | Kwanza: ANGOLA | MOP | Pataca: MACAO |
ARS | Argentine Peso: ARGENTINA | MRO | Ouguiya: MAURITANIA |
AUD | Australian Dollar: AUSTRALIA; CHRISTMAS ISLAND; COCOS (KEELING) ISLANDS; HEARD ISLAND AND McDONALD ISLANDS; KIRIBATI; NAURU; NORFOLK ISLAND; TUVALU | MUR | Mauritius Rupee: MAURITIUS |
AWG | Aruban Florin: ARUBA | MVR | Rufiyaa: MALDIVES |
AZN | Azerbaijanian Manat: AZERBAIJAN | MWK | Kwacha: MALAWI |
BAM | Convertible Mark: BOSNIA AND HERZEGOVINA | MXN | Mexican Peso: MEXICO |
BBD | Barbados Dollar: BARBADOS | MXV | Mexican Unidad de Inversion (UDI): MEXICO |
BDT | Taka: BANGLADESH | MYR | Malaysian Ringgit: MALAYSIA |
BGN | Bulgarian Lev: BULGARIA | MZN | Mozambique Metical: MOZAMBIQUE |
BHD | Bahraini Dinar: BAHRAIN | NAD | Namibia Dollar: NAMIBIA |
BIF | Burundi Franc: BURUNDI | NGN | Naira: NIGERIA |
BMD | Bermudian Dollar: BERMUDA | NIO | Cordoba Oro: NICARAGUA |
BND | Brunei Dollar: BRUNEI DARUSSALAM | NOK | Norwegian Krone: BOUVET ISLAND; NORWAY; SVALBARD AND JAN MAYEN |
BOB | Boliviano: BOLIVIA, PLURINATIONAL STATE OF | NPR | Nepalese Rupee: NEPAL |
BOV | Mvdol: BOLIVIA, PLURINATIONAL STATE OF | NZD | New Zealand Dollar: COOK ISLANDS; NEW ZEALAND; NIUE; PITCAIRN; TOKELAU |
BRL | Brazilian Real: BRAZIL | OMR | Rial Omani: OMAN |
BSD | Bahamian Dollar: BAHAMAS | PAB | Balboa: PANAMA |
BTN | Ngultrum: BHUTAN | PEN | Nuevo Sol: PERU |
BWP | Pula: BOTSWANA | PGK | Kina: PAPUA NEW GUINEA |
BYR | Belarussian Ruble: BELARUS | PHP | Philippine Peso: PHILIPPINES |
BZD | Belize Dollar: BELIZE | PKR | Pakistan Rupee: PAKISTAN |
CAD | Canadian Dollar: CANADA | PLN | Zloty: POLAND |
CDF | Congolese Franc: CONGO, THE DEMOCRATIC REPUBLIC OF | PYG | Guarani: PARAGUAY |
CHE | WIR Euro: SWITZERLAND | QAR | Qatari Rial: QATAR |
CHF | Swiss Franc: LIECHTENSTEIN; SWITZERLAND | RON | New Romanian Leu: ROMANIA |
CHW | WIR Franc: SWITZERLAND | RSD | Serbian Dinar: SERBIA |
CLF | Unidades de fomento: CHILE | RUB | Russian Ruble: RUSSIAN FEDERATION |
CLP | Chilean Peso: CHILE | RWF | Rwanda Franc: RWANDA |
CNY | Yuan Renminbi: CHINA | SAR | Saudi Riyal: SAUDI ARABIA |
COP | Colombian Peso: COLOMBIA | SBD | Solomon Islands Dollar: SOLOMON ISLANDS |
COU | Unidad de Valor Real: COLOMBIA | SCR | Seychelles Rupee: SEYCHELLES |
CRC | Costa Rican Colon: COSTA RICA | SDG | Sudanese Pound: SUDAN |
CUC | Peso Convertible: CUBA | SEK | Swedish Krona: SWEDEN |
CUP | Cuban Peso: CUBA | SGD | Singapore Dollar: SINGAPORE |
CVE | Cape Verde Escudo: CAPE VERDE | SHP | Saint Helena Pound: SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA |
CZK | Czech Koruna: CZECH REPUBLIC | SLL | Leone: SIERRA LEONE |
DJF | Djibouti Franc: DJIBOUTI | SOS | Somali Shilling: SOMALIA |
DKK | Danish Krone: DENMARK; FAROE ISLANDS; GREENLAND | SRD | Surinam Dollar: SURINAME |
DOP | Dominican Peso: DOMINICAN REPUBLIC | SSP | South Sudanese Pound: SOUTH SUDAN |
DZD | Algerian Dinar: ALGERIA | STD | Dobra: SAO TOME AND PRINCIPE |
EGP | Egyptian Pound: EGYPT | SVC | El Salvador Colon: EL SALVADOR |
ERN | Nakfa: ERITREA | SYP | Syrian Pound: SYRIAN ARAB REPUBLIC |
ETB | Ethiopian Birr: ETHIOPIA | SZL | Lilangeni: SWAZILAND |
EUR | Euro: 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) | THB | Baht: THAILAND |
FJD | Fiji Dollar: FIJI | TJS | Somoni: TAJIKISTAN |
FKP | Falkland Islands Pound: FALKLAND ISLANDS (MALVINAS) | TMT | Turkmenistan New Manat: TURKMENISTAN |
GBP | Pound Sterling: GUERNSEY; ISLE OF MAN; JERSEY; UNITED KINGDOM | TND | Tunisian Dinar: TUNISIA |
GEL | Lari: GEORGIA | TOP | Pa’anga: TONGA |
GHS | Ghana Cedi: GHANA | TRY | Turkish Lira: TURKEY |
GIP | Gibraltar Pound: GIBRALTAR | TTD | Trinidad and Tobago Dollar: TRINIDAD AND TOBAGO |
GMD | Dalasi: GAMBIA | TWD | New Taiwan Dollar: TAIWAN, PROVINCE OF CHINA |
GNF | Guinea Franc: GUINEA | TZS | Tanzanian Shilling: TANZANIA, UNITED REPUBLIC OF |
GTQ | Quetzal: GUATEMALA | UAH | Hryvnia: UKRAINE |
GYD | Guyana Dollar: GUYANA | UGX | Uganda Shilling: UGANDA |
HKD | Hong Kong Dollar: HONG KONG | USD | US 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) |
HNL | Lempira: HONDURAS | USN | US Dollar (Next day): UNITED STATES |
HRK | Croatian Kuna: CROATIA | USS | US Dollar (Same day): UNITED STATES |
HTG | Gourde: HAITI | UYI | Uruguay Peso en Unidades Indexadas (URUIURUI): URUGUAY |
HUF | Forint: HUNGARY | UYU | Peso Uruguayo: URUGUAY |
IDR | Rupiah: INDONESIA | UZS | Uzbekistan Sum: UZBEKISTAN |
ILS | New Israeli Sheqel: ISRAEL | VEF | Bolivar: VENEZUELA, BOLIVARIAN REPUBLIC OF |
INR | Indian Rupee: BHUTAN; INDIA | VND | Dong: VIET NAM |
IQD | Iraqi Dinar: IRAQ | VUV | Vatu: VANUATU |
IRR | Iranian Rial: IRAN, ISLAMIC REPUBLIC OF | WST | Tala: SAMOA |
ISK | Iceland Krona: ICELAND | XAF | CFA Franc BEAC: CAMEROON; CENTRAL AFRICAN REPUBLIC; CHAD; CONGO; EQUATORIAL GUINEA; GABON |
JMD | Jamaican Dollar: JAMAICA | XAG | Silver: ZZ11_Silver |
JOD | Jordanian Dinar: JORDAN | XAU | Gold: ZZ08_Gold |
JPY | Yen: JAPAN | XBA | Bond Markets Unit European Composite Unit (EURCO): ZZ01_Bond Markets Unit European_EURCO |
KES | Kenyan Shilling: KENYA | XBB | Bond Markets Unit European Monetary Unit (E.M.U.-6): ZZ02_Bond Markets Unit European_EMU-6 |
KGS | Som: KYRGYZSTAN | XBC | Bond Markets Unit European Unit of Account 9 (E.U.A.-9): ZZ03_Bond Markets Unit European_EUA-9 |
KHR | Riel: CAMBODIA | XBD | Bond Markets Unit European Unit of Account 17 (E.U.A.-17): ZZ04_Bond Markets Unit European_EUA-17 |
KMF | Comoro Franc: COMOROS | XCD | East Caribbean Dollar: ANGUILLA; ANTIGUA AND BARBUDA; DOMINICA; GRENADA; MONTSERRAT; SAINT KITTS AND NEVIS; SAINT LUCIA; SAINT VINCENT AND THE GRENADINES |
KPW | North Korean Won: KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OF | XDR | SDR (Special Drawing Right): INTERNATIONAL MONETARY FUND (IMF) |
KRW | Won: KOREA, REPUBLIC OF | XFU | UIC-Franc: ZZ05_UIC-Franc |
KWD | Kuwaiti Dinar: KUWAIT | XOF | CFA Franc BCEAO: BENIN; BURKINA FASO; COTE D'IVOIRE; GUINEA-BISSAU; MALI; NIGER; SENEGAL; TOGO |
KYD | Cayman Islands Dollar: CAYMAN ISLANDS | XPD | Palladium: ZZ09_Palladium |
KZT | Tenge: KAZAKHSTAN | XPF | CFP Franc: FRENCH POLYNESIA; NEW CALEDONIA; WALLIS AND FUTUNA |
LAK | Kip: LAO PEOPLE’S DEMOCRATIC REPUBLIC | XPT | Platinum: ZZ10_Platinum |
LBP | Lebanese Pound: LEBANON | XSU | Sucre: SISTEMA UNITARIO DE COMPENSACION REGIONAL DE PAGOS "SUCRE" |
LKR | Sri Lanka Rupee: SRI LANKA | XUA | ADB Unit of Account: MEMBER COUNTRIES OF THE AFRICAN DEVELOPMENT BANK GROUP |
LRD | Liberian Dollar: LIBERIA | XXX | The codes assigned for transactions where no currency is involved: ZZ07_No_Currency |
LSL | Loti: LESOTHO | YER | Yemeni Rial: YEMEN |
LTL | Lithuanian Litas: LITHUANIA | ZAR | Rand: LESOTHO; NAMIBIA; SOUTH AFRICA |
LVL | Latvian Lats: LATVIA | ZMW | Zambian Kwacha: ZAMBIA |
LYD | Libyan Dinar: LIBYA | ZWL | Zimbabwe Dollar: ZIMBABWE |
MAD | Moroccan Dirham: MOROCCO; WESTERN SAHARA |
Table of CRS Country Codes | |||
---|---|---|---|
CRS Code | CRS Country | CRS Code | CRS Country |
AF | AFGHANISTAN | LR | LIBERIA |
AX | ALAND ISLANDS | LY | LIBYA |
AL | ALBANIA | LI | LIECHTENSTEIN |
DZ | ALGERIA | LT | LITHUANIA |
AS | AMERICAN SAMOA | LU | LUXEMBOURG |
AD | ANDORRA | MO | MACAO |
AO | ANGOLA | MK | MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF |
AI | ANGUILLA | MG | MADAGASCAR |
AQ | ANTARCTICA | MW | MALAWI |
AG | ANTIGUA AND BARBUDA | MY | MALAYSIA |
AR | ARGENTINA | MV | MALDIVES |
AM | ARMENIA | ML | MALI |
AW | ARUBA | MT | MALTA |
AU | AUSTRALIA | MH | MARSHALL ISLANDS |
AT | AUSTRIA | MQ | MARTINIQUE |
AZ | AZERBAIJAN | MR | MAURITANIA |
BS | BAHAMAS | MU | MAURITIUS |
BH | BAHRAIN | YT | MAYOTTE |
BD | BANGLADESH | MX | MEXICO |
BB | BARBADOS | FM | MICRONESIA, FEDERATED STATES OF |
BY | BELARUS | MD | MOLDOVA, REPUBLIC OF |
BE | BELGIUM | MC | MONACO |
BZ | BELIZE | MN | MONGOLIA |
BJ | BENIN | ME | MONTENEGRO |
BM | BERMUDA | MS | MONTSERRAT |
BT | BHUTAN | MA | MOROCCO |
BO | BOLIVIA, PLURINATIONAL STATE OF | MZ | MOZAMBIQUE |
BQ | BONAIRE, SINT EUSTATIUS AND SABA | MM | MYANMAR |
BA | BOSNIA AND HERZEGOVINA | NA | NAMIBIA |
BW | BOTSWANA | NR | NAURU |
BV | BOUVET ISLAND | NP | NEPAL |
BR | BRAZIL | NL | NETHERLANDS |
IO | BRITISH INDIAN OCEAN TERRITORY | NC | NEW CALEDONIA |
BN | BRUNEI DARUSSALAM | NZ | NEW ZEALAND |
BG | BULGARIA | NI | NICARAGUA |
BF | BURKINA FASO | NE | NIGER |
BI | BURUNDI | NG | NIGERIA |
KH | CAMBODIA | NU | NIUE |
CM | CAMEROON | NF | NORFOLK ISLAND |
CA | CANADA | MP | NORTHERN MARIANA ISLANDS |
CV | CAPE VERDE | NO | NORWAY |
KY | CAYMAN ISLANDS | OM | OMAN |
CF | CENTRAL AFRICAN REPUBLIC | PK | PAKISTAN |
TD | CHAD | PW | PALAU |
CL | CHILE | PS | PALESTINE, STATE OF |
CN | CHINA | PA | PANAMA |
CX | CHRISTMAS ISLAND | PG | PAPUA NEW GUINEA |
CC | COCOS (KEELING) ISLANDS | PY | PARAGUAY |
CO | COLOMBIA | PE | PERU |
KM | COMOROS | PH | PHILIPPINES |
CG | CONGO | PN | PITCAIRN |
CD | CONGO, THE DEMOCRATIC REPUBLIC OF THE | PL | POLAND |
CK | COOK ISLANDS | PT | PORTUGAL |
CR | COSTA RICA | PR | PUERTO RICO |
CI | COTE D'IVOIRE | QA | QATAR |
HR | CROATIA | RE | REUNION |
CU | CUBA | RO | ROMANIA |
CW | CURACAO | RU | RUSSIAN FEDERATION |
CY | CYPRUS | RW | RWANDA |
CZ | CZECH REPUBLIC | BL | SAINT BARTHELEMY |
DK | DENMARK | SH | SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA |
DJ | DJIBOUTI | KN | SAINT KITTS AND NEVIS |
DM | DOMINICA | LC | SAINT LUCIA |
DO | DOMINICAN REPUBLIC | MF | SAINT MARTIN (FRENCH PART) |
EC | ECUADOR | PM | SAINT PIERRE AND MIQUELON |
EG | EGYPT | VC | SAINT VINCENT AND THE GRENADINES |
SV | EL SALVADOR | WS | SAMOA |
GQ | EQUATORIAL GUINEA | SM | SAN MARINO |
ER | ERITREA | ST | SAO TOME AND PRINCIPE |
EE | ESTONIA | SA | SAUDI ARABIA |
ET | ETHIOPIA | SN | SENEGAL |
FK | FALKLAND ISLANDS (MALVINAS) | RS | SERBIA |
FO | FAROE ISLANDS | SC | SEYCHELLES |
FJ | FIJI | SL | SIERRA LEONE |
FI | FINLAND | SG | SINGAPORE |
FR | FRANCE | SX | SINT MAARTEN (DUTCH PART) |
GF | FRENCH GUIANA | SK | SLOVAKIA |
PF | FRENCH POLYNESIA | SI | SLOVENIA |
TF | FRENCH SOUTHERN TERRITORIES | SB | SOLOMON ISLANDS |
GA | GABON | SO | SOMALIA |
GM | GAMBIA | ZA | SOUTH AFRICA |
GE | GEORGIA | GS | SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS |
DE | GERMANY | SS | SOUTH SUDAN |
GH | GHANA | ES | SPAIN |
GI | GIBRALTAR | LK | SRI LANKA |
GR | GREECE | SD | SUDAN |
GL | GREENLAND | SR | SURINAME |
GD | GRENADA | SJ | SVALBARD AND JAN MAYEN |
GP | GUADELOUPE | SZ | SWAZILAND |
GU | GUAM | SE | SWEDEN |
GT | GUATEMALA | CH | SWITZERLAND |
GG | GUERNSEY | SY | SYRIAN ARAB REPUBLIC |
GN | GUINEA | TW | TAIWAN, PROVINCE OF CHINA |
GW | GUINEA-BISSAU | TJ | TAJIKISTAN |
GY | GUYANA | TZ | TANZANIA, UNITED REPUBLIC OF |
HT | HAITI | TH | THAILAND |
HM | HEARD ISLAND AND MCDONALD ISLANDS | TL | TIMOR-LESTE |
VA | HOLY SEE (VATICAN CITY STATE) | TG | TOGO |
HN | HONDURAS | TK | TOKELAU |
HK | HONG KONG | TO | TONGA |
HU | HUNGARY | TT | TRINIDAD AND TOBAGO |
IS | ICELAND | TN | TUNISIA |
IN | INDIA | TR | TURKEY |
ID | INDONESIA | TM | TURKMENISTAN |
IR | IRAN, ISLAMIC REPUBLIC OF | TC | TURKS AND CAICOS ISLANDS |
IQ | IRAQ | TV | TUVALU |
IE | IRELAND | UG | UGANDA |
IM | ISLE OF MAN | UA | UKRAINE |
IL | ISRAEL | AE | UNITED ARAB EMIRATES |
IT | ITALY | GB | UNITED KINGDOM |
JM | JAMAICA | US | UNITED STATES |
JP | JAPAN | UM | UNITED STATES MINOR OUTLYING ISLANDS |
JE | JERSEY | UY | URUGUAY |
JO | JORDAN | UZ | UZBEKISTAN |
KZ | KAZAKHSTAN | VU | VANUATU |
KE | KENYA | VE | VENEZUELA, BOLIVARIAN REPUBLIC OF |
KI | KIRIBATI | VN | VIET NAM |
KP | KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF | VG | VIRGIN ISLANDS, BRITISH |
KR | KOREA, REPUBLIC OF | VI | VIRGIN ISLANDS, U.S. |
KW | KUWAIT | WF | WALLIS AND FUTUNA |
KG | KYRGYZSTAN | EH | WESTERN SAHARA |
LA | LAO PEOPLE'S DEMOCRATIC REPUBLIC | YE | YEMEN |
LV | LATVIA | ZM | ZAMBIA |
LB | LEBANON | ZW | ZIMBABWE |
LS | LESOTHO |
Info Page Status:FINAL
Sample Excel Import File: Import_CRS_Example.xlsx
Sample Excel Multiple Tabs Import File: Import_CRS_MultipleTabs_Example.xlsx
Import Form Fields:
Field Name | Description | Notes | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
See Form Filer Common Fields | ||||||||||||||||||||||||||||||
See Recipient Common Fields | ||||||||||||||||||||||||||||||
RecordType | P, PMT, AH, CP, CPC, |
| ||||||||||||||||||||||||||||
AH_Type | Account Holder Type Indicator if the account is held by a Person = CRS007 or an Entity CRS101, CRS102 or CRS103 |
| ||||||||||||||||||||||||||||
CP_Type | Type of Controlling Person |
| ||||||||||||||||||||||||||||
AccountCreatedDate | Date of Account Creation | MM/DD/YYYY | ||||||||||||||||||||||||||||
Balance | Account Holders Balance | Total Account Balance | ||||||||||||||||||||||||||||
BalanceCurrCode | Balance Currency Code | |||||||||||||||||||||||||||||
AN_Type | Account Number Type |
| ||||||||||||||||||||||||||||
UndocumentedAccount | Check Box | X / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks" | ||||||||||||||||||||||||||||
ClosedAccount | Check Box | X / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks" | ||||||||||||||||||||||||||||
DormantAccount | Check Box | X / Y / T / 1 = Checks "YES" 0/F = Checks "NO" Blank = "Blank/No checks" | ||||||||||||||||||||||||||||
Payment | Amount | Multiple payments can be associated with a single CRS reportable account. | ||||||||||||||||||||||||||||
PaymentCurrCode | Table of Currency Codes | |||||||||||||||||||||||||||||
PaymentType | Type of Payment |
| ||||||||||||||||||||||||||||
ResCountryCode | Table of CRS Country Codes | |||||||||||||||||||||||||||||
TIN | Tax Identification Number | This 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 |
| |||||||||||||||||||||||||||||
PrecedingTitle | Name Field | Example: His Excellency | ||||||||||||||||||||||||||||
Title | Name Field | Greeting title. Example: Dr, Mr, Ms, Herr, etc. Can have multiple titles. | ||||||||||||||||||||||||||||
xnlNameTypePrefix | Name Field | Defines the type of name associated with the NamePrefix, For example: de, van , van de, von, etc. (Derick de Clarke) | ||||||||||||||||||||||||||||
xnlNameTypeFirst | Name Field | First Name of person | ||||||||||||||||||||||||||||
xnlNameTypeLast | Name Field | Last 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 |
| |||||||||||||||||||||||||||||
Street | Street Address | Example: 1 Financial Way | ||||||||||||||||||||||||||||
BuildingID | Building Identification | Example: Building A | ||||||||||||||||||||||||||||
FloorID | Floor Identification | Example: Penthouse | ||||||||||||||||||||||||||||
Suite | Suite Number | Example: 190, 12th Floor | ||||||||||||||||||||||||||||
DistrictName | Name of District | Example: Gas Lamp District | ||||||||||||||||||||||||||||
POB | Post Office Box | Post office Box number. Example: Box#20, Box 2A | ||||||||||||||||||||||||||||
City | Name of City | Example: 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 | |||
---|---|---|---|
Code | Description | Code | Description |
AED | UAE Dirham: UNITED ARAB EMIRATES | MDL | UAE Dirham: UNITED ARAB EMIRATES |
AFN | Afghani: AFGHANISTAN | MGA | Afghani: AFGHANISTAN |
ALL | Lek: ALBANIA | MKD | Lek: ALBANIA |
AMD | Armenian Dram: ARMENIA | MMK | Armenian Dram: ARMENIA |
ANG | Netherlands Antillean Guilder: CURACAO; SINT MAARTEN (DUTCH PART) | MNT | Netherlands Antillean Guilder: CURACAO; SINT MAARTEN (DUTCH PART) |
AOA | Kwanza: ANGOLA | MOP | Kwanza: ANGOLA |
ARS | Argentine Peso: ARGENTINA | MRO | Argentine Peso: ARGENTINA |
AUD | Australian Dollar: AUSTRALIA; CHRISTMAS ISLAND; COCOS (KEELING) ISLANDS; HEARD ISLAND AND McDONALD ISLANDS; KIRIBATI; NAURU; NORFOLK ISLAND; TUVALU | MUR | Australian Dollar: AUSTRALIA; CHRISTMAS ISLAND; COCOS (KEELING) ISLANDS; HEARD ISLAND AND McDONALD ISLANDS; KIRIBATI; NAURU; NORFOLK ISLAND; TUVALU |
AWG | Aruban Florin: ARUBA | MVR | Aruban Florin: ARUBA |
AZN | Azerbaijanian Manat: AZERBAIJAN | MWK | Azerbaijanian Manat: AZERBAIJAN |
BAM | Convertible Mark: BOSNIA AND HERZEGOVINA | MXN | Convertible Mark: BOSNIA AND HERZEGOVINA |
BBD | Barbados Dollar: BARBADOS | MXV | Barbados Dollar: BARBADOS |
BDT | Taka: BANGLADESH | MYR | Taka: BANGLADESH |
BGN | Bulgarian Lev: BULGARIA | MZN | Bulgarian Lev: BULGARIA |
BHD | Bahraini Dinar: BAHRAIN | NAD | Bahraini Dinar: BAHRAIN |
BIF | Burundi Franc: BURUNDI | NGN | Burundi Franc: BURUNDI |
BMD | Bermudian Dollar: BERMUDA | NIO | Bermudian Dollar: BERMUDA |
BND | Brunei Dollar: BRUNEI DARUSSALAM | NOK | Brunei Dollar: BRUNEI DARUSSALAM |
BOB | Boliviano: BOLIVIA, PLURINATIONAL STATE OF | NPR | Boliviano: BOLIVIA, PLURINATIONAL STATE OF |
BOV | Mvdol: BOLIVIA, PLURINATIONAL STATE OF | NZD | Mvdol: BOLIVIA, PLURINATIONAL STATE OF |
BRL | Brazilian Real: BRAZIL | OMR | Brazilian Real: BRAZIL |
BSD | Bahamian Dollar: BAHAMAS | PAB | Bahamian Dollar: BAHAMAS |
BTN | Ngultrum: BHUTAN | PEN | Ngultrum: BHUTAN |
BWP | Pula: BOTSWANA | PGK | Pula: BOTSWANA |
BYR | Belarussian Ruble: BELARUS | PHP | Belarussian Ruble: BELARUS |
BZD | Belize Dollar: BELIZE | PKR | Belize Dollar: BELIZE |
CAD | Canadian Dollar: CANADA | PLN | Canadian Dollar: CANADA |
CDF | Congolese Franc: CONGO, THE DEMOCRATIC REPUBLIC OF | PYG | Congolese Franc: CONGO, THE DEMOCRATIC REPUBLIC OF |
CHE | WIR Euro: SWITZERLAND | QAR | WIR Euro: SWITZERLAND |
CHF | Swiss Franc: LIECHTENSTEIN; SWITZERLAND | RON | Swiss Franc: LIECHTENSTEIN; SWITZERLAND |
CHW | WIR Franc: SWITZERLAND | RSD | WIR Franc: SWITZERLAND |
CLF | Unidades de fomento: CHILE | RUB | Unidades de fomento: CHILE |
CLP | Chilean Peso: CHILE | RWF | Chilean Peso: CHILE |
CNY | Yuan Renminbi: CHINA | SAR | Yuan Renminbi: CHINA |
COP | Colombian Peso: COLOMBIA | SBD | Colombian Peso: COLOMBIA |
COU | Unidad de Valor Real: COLOMBIA | SCR | Unidad de Valor Real: COLOMBIA |
CRC | Costa Rican Colon: COSTA RICA | SDG | Costa Rican Colon: COSTA RICA |
CUC | Peso Convertible: CUBA | SEK | Peso Convertible: CUBA |
CUP | Cuban Peso: CUBA | SGD | Cuban Peso: CUBA |
CVE | Cape Verde Escudo: CAPE VERDE | SHP | Cape Verde Escudo: CAPE VERDE |
CZK | Czech Koruna: CZECH REPUBLIC | SLL | Czech Koruna: CZECH REPUBLIC |
DJF | Djibouti Franc: DJIBOUTI | SOS | Djibouti Franc: DJIBOUTI |
DKK | Danish Krone: DENMARK; FAROE ISLANDS; GREENLAND | SRD | Danish Krone: DENMARK; FAROE ISLANDS; GREENLAND |
DOP | Dominican Peso: DOMINICAN REPUBLIC | SSP | Dominican Peso: DOMINICAN REPUBLIC |
DZD | Algerian Dinar: ALGERIA | STD | Algerian Dinar: ALGERIA |
EGP | Egyptian Pound: EGYPT | SVC | Egyptian Pound: EGYPT |
ERN | Nakfa: ERITREA | SYP | Nakfa: ERITREA |
ETB | Ethiopian Birr: ETHIOPIA | SZL | Ethiopian Birr: ETHIOPIA |
EUR | Euro: 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) | THB | Euro: 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) |
FJD | Fiji Dollar: FIJI | TJS | Fiji Dollar: FIJI |
FKP | Falkland Islands Pound: FALKLAND ISLANDS (MALVINAS) | TMT | Falkland Islands Pound: FALKLAND ISLANDS (MALVINAS) |
GBP | Pound Sterling: GUERNSEY; ISLE OF MAN; JERSEY; UNITED KINGDOM | TND | Pound Sterling: GUERNSEY; ISLE OF MAN; JERSEY; UNITED KINGDOM |
GEL | Lari: GEORGIA | TOP | Lari: GEORGIA |
GHS | Ghana Cedi: GHANA | TRY | Ghana Cedi: GHANA |
GIP | Gibraltar Pound: GIBRALTAR | TTD | Gibraltar Pound: GIBRALTAR |
GMD | Dalasi: GAMBIA | TWD | Dalasi: GAMBIA |
GNF | Guinea Franc: GUINEA | TZS | Guinea Franc: GUINEA |
GTQ | Quetzal: GUATEMALA | UAH | Quetzal: GUATEMALA |
GYD | Guyana Dollar: GUYANA | UGX | Guyana Dollar: GUYANA |
HKD | Hong Kong Dollar: HONG KONG | USD | Hong Kong Dollar: HONG KONG |
HNL | Lempira: HONDURAS | USN | Lempira: HONDURAS |
HRK | Croatian Kuna: CROATIA | USS | Croatian Kuna: CROATIA |
HTG | Gourde: HAITI | UYI | Gourde: HAITI |
HUF | Forint: HUNGARY | UYU | Forint: HUNGARY |
IDR | Rupiah: INDONESIA | UZS | Rupiah: INDONESIA |
ILS | New Israeli Sheqel: ISRAEL | VEF | New Israeli Sheqel: ISRAEL |
INR | Indian Rupee: BHUTAN; INDIA | VND | Indian Rupee: BHUTAN; INDIA |
IQD | Iraqi Dinar: IRAQ | VUV | Iraqi Dinar: IRAQ |
IRR | Iranian Rial: IRAN, ISLAMIC REPUBLIC OF | WST | Iranian Rial: IRAN, ISLAMIC REPUBLIC OF |
ISK | Iceland Krona: ICELAND | XAF | Iceland Krona: ICELAND |
JMD | Jamaican Dollar: JAMAICA | XAG | Jamaican Dollar: JAMAICA |
JOD | Jordanian Dinar: JORDAN | XAU | Jordanian Dinar: JORDAN |
JPY | Yen: JAPAN | XBA | Yen: JAPAN |
KES | Kenyan Shilling: KENYA | XBB | Kenyan Shilling: KENYA |
KGS | Som: KYRGYZSTAN | XBC | Som: KYRGYZSTAN |
KHR | Riel: CAMBODIA | XBD | Riel: CAMBODIA |
KMF | Comoro Franc: COMOROS | XCD | Comoro Franc: COMOROS |
KPW | North Korean Won: KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OF | XDR | North Korean Won: KOREA, DEMOCRATIC PEOPLE’S REPUBLIC OF |
KRW | Won: KOREA, REPUBLIC OF | XFU | Won: KOREA, REPUBLIC OF |
KWD | Kuwaiti Dinar: KUWAIT | XOF | Kuwaiti Dinar: KUWAIT |
KYD | Cayman Islands Dollar: CAYMAN ISLANDS | XPD | Cayman Islands Dollar: CAYMAN ISLANDS |
KZT | Tenge: KAZAKHSTAN | XPF | Tenge: KAZAKHSTAN |
LAK | Kip: LAO PEOPLE’S DEMOCRATIC REPUBLIC | XPT | Kip: LAO PEOPLE’S DEMOCRATIC REPUBLIC |
LBP | Lebanese Pound: LEBANON | XSU | Lebanese Pound: LEBANON |
LKR | Sri Lanka Rupee: SRI LANKA | XUA | Sri Lanka Rupee: SRI LANKA |
LRD | Liberian Dollar: LIBERIA | XXX | Liberian Dollar: LIBERIA |
LSL | Loti: LESOTHO | YER | Loti: LESOTHO |
LTL | Lithuanian Litas: LITHUANIA | ZAR | Lithuanian Litas: LITHUANIA |
LVL | Latvian Lats: LATVIA | ZMW | Latvian Lats: LATVIA |
LYD | Libyan Dinar: LIBYA | ZWL | Libyan Dinar: LIBYA |
MAD | Moroccan Dirham: MOROCCO; WESTERN SAHARA | Moroccan Dirham: MOROCCO; WESTERN SAHARA |
Table of CRS Country Codes | |||
---|---|---|---|
CRS Code | CRS Country | CRS Code | CRS Country |
AF | AFGHANISTAN | LR | LIBERIA |
AX | ALAND ISLANDS | LY | LIBYA |
AL | ALBANIA | LI | LIECHTENSTEIN |
DZ | ALGERIA | LT | LITHUANIA |
AS | AMERICAN SAMOA | LU | LUXEMBOURG |
AD | ANDORRA | MO | MACAO |
AO | ANGOLA | MK | MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF |
AI | ANGUILLA | MG | MADAGASCAR |
AQ | ANTARCTICA | MW | MALAWI |
AG | ANTIGUA AND BARBUDA | MY | MALAYSIA |
AR | ARGENTINA | MV | MALDIVES |
AM | ARMENIA | ML | MALI |
AW | ARUBA | MT | MALTA |
AU | AUSTRALIA | MH | MARSHALL ISLANDS |
AT | AUSTRIA | MQ | MARTINIQUE |
AZ | AZERBAIJAN | MR | MAURITANIA |
BS | BAHAMAS | MU | MAURITIUS |
BH | BAHRAIN | YT | MAYOTTE |
BD | BANGLADESH | MX | MEXICO |
BB | BARBADOS | FM | MICRONESIA, FEDERATED STATES OF |
BY | BELARUS | MD | MOLDOVA, REPUBLIC OF |
BE | BELGIUM | MC | MONACO |
BZ | BELIZE | MN | MONGOLIA |
BJ | BENIN | ME | MONTENEGRO |
BM | BERMUDA | MS | MONTSERRAT |
BT | BHUTAN | MA | MOROCCO |
BO | BOLIVIA, PLURINATIONAL STATE OF | MZ | MOZAMBIQUE |
BQ | BONAIRE, SINT EUSTATIUS AND SABA | MM | MYANMAR |
BA | BOSNIA AND HERZEGOVINA | NA | NAMIBIA |
BW | BOTSWANA | NR | NAURU |
BV | BOUVET ISLAND | NP | NEPAL |
BR | BRAZIL | NL | NETHERLANDS |
IO | BRITISH INDIAN OCEAN TERRITORY | NC | NEW CALEDONIA |
BN | BRUNEI DARUSSALAM | NZ | NEW ZEALAND |
BG | BULGARIA | NI | NICARAGUA |
BF | BURKINA FASO | NE | NIGER |
BI | BURUNDI | NG | NIGERIA |
KH | CAMBODIA | NU | NIUE |
CM | CAMEROON | NF | NORFOLK ISLAND |
CA | CANADA | MP | NORTHERN MARIANA ISLANDS |
CV | CAPE VERDE | NO | NORWAY |
KY | CAYMAN ISLANDS | OM | OMAN |
CF | CENTRAL AFRICAN REPUBLIC | PK | PAKISTAN |
TD | CHAD | PW | PALAU |
CL | CHILE | PS | PALESTINE, STATE OF |
CN | CHINA | PA | PANAMA |
CX | CHRISTMAS ISLAND | PG | PAPUA NEW GUINEA |
CC | COCOS (KEELING) ISLANDS | PY | PARAGUAY |
CO | COLOMBIA | PE | PERU |
KM | COMOROS | PH | PHILIPPINES |
CG | CONGO | PN | PITCAIRN |
CD | CONGO, THE DEMOCRATIC REPUBLIC OF THE | PL | POLAND |
CK | COOK ISLANDS | PT | PORTUGAL |
CR | COSTA RICA | PR | PUERTO RICO |
CI | COTE D'IVOIRE | QA | QATAR |
HR | CROATIA | RE | REUNION |
CU | CUBA | RO | ROMANIA |
CW | CURACAO | RU | RUSSIAN FEDERATION |
CY | CYPRUS | RW | RWANDA |
CZ | CZECH REPUBLIC | BL | SAINT BARTHELEMY |
DK | DENMARK | SH | SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA |
DJ | DJIBOUTI | KN | SAINT KITTS AND NEVIS |
DM | DOMINICA | LC | SAINT LUCIA |
DO | DOMINICAN REPUBLIC | MF | SAINT MARTIN (FRENCH PART) |
EC | ECUADOR | PM | SAINT PIERRE AND MIQUELON |
EG | EGYPT | VC | SAINT VINCENT AND THE GRENADINES |
SV | EL SALVADOR | WS | SAMOA |
GQ | EQUATORIAL GUINEA | SM | SAN MARINO |
ER | ERITREA | ST | SAO TOME AND PRINCIPE |
EE | ESTONIA | SA | SAUDI ARABIA |
ET | ETHIOPIA | SN | SENEGAL |
FK | FALKLAND ISLANDS (MALVINAS) | RS | SERBIA |
FO | FAROE ISLANDS | SC | SEYCHELLES |
FJ | FIJI | SL | SIERRA LEONE |
FI | FINLAND | SG | SINGAPORE |
FR | FRANCE | SX | SINT MAARTEN (DUTCH PART) |
GF | FRENCH GUIANA | SK | SLOVAKIA |
PF | FRENCH POLYNESIA | SI | SLOVENIA |
TF | FRENCH SOUTHERN TERRITORIES | SB | SOLOMON ISLANDS |
GA | GABON | SO | SOMALIA |
GM | GAMBIA | ZA | SOUTH AFRICA |
GE | GEORGIA | GS | SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS |
DE | GERMANY | SS | SOUTH SUDAN |
GH | GHANA | ES | SPAIN |
GI | GIBRALTAR | LK | SRI LANKA |
GR | GREECE | SD | SUDAN |
GL | GREENLAND | SR | SURINAME |
GD | GRENADA | SJ | SVALBARD AND JAN MAYEN |
GP | GUADELOUPE | SZ | SWAZILAND |
GU | GUAM | SE | SWEDEN |
GT | GUATEMALA | CH | SWITZERLAND |
GG | GUERNSEY | SY | SYRIAN ARAB REPUBLIC |
GN | GUINEA | TW | TAIWAN, PROVINCE OF CHINA |
GW | GUINEA-BISSAU | TJ | TAJIKISTAN |
GY | GUYANA | TZ | TANZANIA, UNITED REPUBLIC OF |
HT | HAITI | TH | THAILAND |
HM | HEARD ISLAND AND MCDONALD ISLANDS | TL | TIMOR-LESTE |
VA | HOLY SEE (VATICAN CITY STATE) | TG | TOGO |
HN | HONDURAS | TK | TOKELAU |
HK | HONG KONG | TO | TONGA |
HU | HUNGARY | TT | TRINIDAD AND TOBAGO |
IS | ICELAND | TN | TUNISIA |
IN | INDIA | TR | TURKEY |
ID | INDONESIA | TM | TURKMENISTAN |
IR | IRAN, ISLAMIC REPUBLIC OF | TC | TURKS AND CAICOS ISLANDS |
IQ | IRAQ | TV | TUVALU |
IE | IRELAND | UG | UGANDA |
IM | ISLE OF MAN | UA | UKRAINE |
IL | ISRAEL | AE | UNITED ARAB EMIRATES |
IT | ITALY | GB | UNITED KINGDOM |
JM | JAMAICA | US | UNITED STATES |
JP | JAPAN | UM | UNITED STATES MINOR OUTLYING ISLANDS |
JE | JERSEY | UY | URUGUAY |
JO | JORDAN | UZ | UZBEKISTAN |
KZ | KAZAKHSTAN | VU | VANUATU |
KE | KENYA | VE | VENEZUELA, BOLIVARIAN REPUBLIC OF |
KI | KIRIBATI | VN | VIET NAM |
KP | KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF | VG | VIRGIN ISLANDS, BRITISH |
KR | KOREA, REPUBLIC OF | VI | VIRGIN ISLANDS, U.S. |
KW | KUWAIT | WF | WALLIS AND FUTUNA |
KG | KYRGYZSTAN | EH | WESTERN SAHARA |
LA | LAO PEOPLE'S DEMOCRATIC REPUBLIC | YE | YEMEN |
LV | LATVIA | ZM | ZAMBIA |
LB | LEBANON | ZW | ZIMBABWE |
LS | LESOTHO |
Moldovan Leu: MOLDOVA, REPUBLIC OF |
Malagasy Ariary: MADAGASCAR |
Denar: MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF |
Kyat: MYANMAR |
Tugrik: MONGOLIA |
Pataca: MACAO |
Ouguiya: MAURITANIA |
Mauritius Rupee: MAURITIUS |
Rufiyaa: MALDIVES |
Kwacha: MALAWI |
Mexican Peso: MEXICO |
Mexican Unidad de Inversion (UDI): MEXICO |
Malaysian Ringgit: MALAYSIA |
Mozambique Metical: MOZAMBIQUE |
Namibia Dollar: NAMIBIA |
Naira: NIGERIA |
Cordoba Oro: NICARAGUA |
Norwegian Krone: BOUVET ISLAND; NORWAY; SVALBARD AND JAN MAYEN |
Nepalese Rupee: NEPAL |
New Zealand Dollar: COOK ISLANDS; NEW ZEALAND; NIUE; PITCAIRN; TOKELAU |
Rial Omani: OMAN |
Balboa: PANAMA |
Nuevo Sol: PERU |
Kina: PAPUA NEW GUINEA |
Philippine Peso: PHILIPPINES |
Pakistan Rupee: PAKISTAN |
Zloty: POLAND |
Guarani: PARAGUAY |
Qatari Rial: QATAR |
New Romanian Leu: ROMANIA |
Serbian Dinar: SERBIA |
Russian Ruble: RUSSIAN FEDERATION |
Rwanda Franc: RWANDA |
Saudi Riyal: SAUDI ARABIA |
Solomon Islands Dollar: SOLOMON ISLANDS |
Seychelles Rupee: SEYCHELLES |
Sudanese Pound: SUDAN |
Swedish Krona: SWEDEN |
Singapore Dollar: SINGAPORE |
Saint Helena Pound: SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA |
Leone: SIERRA LEONE |
Somali Shilling: SOMALIA |
Surinam Dollar: SURINAME |
South Sudanese Pound: SOUTH SUDAN |
Dobra: SAO TOME AND PRINCIPE |
El Salvador Colon: EL SALVADOR |
Syrian Pound: SYRIAN ARAB REPUBLIC |
Lilangeni: SWAZILAND |
Baht: THAILAND |
Somoni: TAJIKISTAN |
Turkmenistan New Manat: TURKMENISTAN |
Tunisian Dinar: TUNISIA |
Pa’anga: TONGA |
Turkish Lira: TURKEY |
Trinidad and Tobago Dollar: TRINIDAD AND TOBAGO |
New Taiwan Dollar: TAIWAN, PROVINCE OF CHINA |
Tanzanian Shilling: TANZANIA, UNITED REPUBLIC OF |
Hryvnia: UKRAINE |
Uganda Shilling: UGANDA |
US 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) |
US Dollar (Next day): UNITED STATES |
US Dollar (Same day): UNITED STATES |
Uruguay Peso en Unidades Indexadas (URUIURUI): URUGUAY |
Peso Uruguayo: URUGUAY |
Uzbekistan Sum: UZBEKISTAN |
Bolivar: VENEZUELA, BOLIVARIAN REPUBLIC OF |
Dong: VIET NAM |
Vatu: VANUATU |
Tala: SAMOA |
CFA Franc BEAC: CAMEROON; CENTRAL AFRICAN REPUBLIC; CHAD; CONGO; EQUATORIAL GUINEA; GABON |
Silver: ZZ11_Silver |
Gold: ZZ08_Gold |
Bond Markets Unit European Composite Unit (EURCO): ZZ01_Bond Markets Unit European_EURCO |
Bond Markets Unit European Monetary Unit (E.M.U.-6): ZZ02_Bond Markets Unit European_EMU-6 |
Bond Markets Unit European Unit of Account 9 (E.U.A.-9): ZZ03_Bond Markets Unit European_EUA-9 |
Bond Markets Unit European Unit of Account 17 (E.U.A.-17): ZZ04_Bond Markets Unit European_EUA-17 |
East Caribbean Dollar: ANGUILLA; ANTIGUA AND BARBUDA; DOMINICA; GRENADA; MONTSERRAT; SAINT KITTS AND NEVIS; SAINT LUCIA; SAINT VINCENT AND THE GRENADINES |
SDR (Special Drawing Right): INTERNATIONAL MONETARY FUND (IMF) |
UIC-Franc: ZZ05_UIC-Franc |
CFA Franc BCEAO: BENIN; BURKINA FASO; COTE D'IVOIRE; GUINEA-BISSAU; MALI; NIGER; SENEGAL; TOGO |
Palladium: ZZ09_Palladium |
CFP Franc: FRENCH POLYNESIA; NEW CALEDONIA; WALLIS AND FUTUNA |
Platinum: ZZ10_Platinum |
Sucre: SISTEMA UNITARIO DE COMPENSACION REGIONAL DE PAGOS "SUCRE" |
ADB Unit of Account: MEMBER COUNTRIES OF THE AFRICAN DEVELOPMENT BANK GROUP |
The codes assigned for transactions where no currency is involved: ZZ07_No_Currency |
Yemeni Rial: YEMEN |
Rand: LESOTHO; NAMIBIA; SOUTH AFRICA |
Zambian Kwacha: ZAMBIA |
Zimbabwe Dollar: ZIMBABWE |