The input and output field sizes are advisory. Experian cannot guarantee that the field sizes will remain the same in future releases of the Database Table Files.
For each supported country, this table lists the input field sizes, the output field sizes and the rules applied by Bank Wizard to change the input data to the required format. (Where num is numeric and a-num is alphanumeric).
|
|
The input and output field sizes are advisory. Experian cannot guarantee that the field sizes will remain the same in future releases of the Database Table Files. |
|
Country |
Field |
Input |
Output |
Rule applied |
|---|---|---|---|---|
| Albania (AL) | Bank-branch code | 8 num | 8 num | No transposition |
| Account no. | 16 a-num | 16 a-num | All characters converted to uppercase Padded with leading 0’s to make 16 characters |
|
| Andorra (AD) | Bank code | 4 num | 4 num | No transposition |
| Branch code | 4 num | 4 num | No transposition | |
| Account no. | 6 - 12 a-num | 6 - 12 a-num |
All characters converted to uppercase All separators removed |
|
| Australia (AU) | BSB no. | 7 a-num, - | 6 num | Hyphen removed |
| Account no. | 1 - 9 num | 1 - 9 num | No transposition | |
| Austria (AT) | BLZ | 5 num | 5 num | No transposition |
| Account no. | 4 - 11 num | 11 num | Padded with leading 0’s to make 11 characters | |
| Azerbaijan (AZ) | Bank-branch code | 4 alpha | 4 alpha | No transposition |
| Account no. | 20 num | 20 num | No transposition | |
| Bahrain (BH) | Bank-branch code | 4 alpha | 4 alpha | No transposition |
| Account no. | 14 a-num | 14 a-num | All characters converted to uppercase | |
| Belgium (BE) | Bank-branch code | 3 num | 3 num | No transposition |
| Account no. | 7 num | 7 num | No transposition | |
| Check digits | 2 num | 2 num | No transposition | |
|
Bosnia and Herzegovina (BA) |
Bank code | 3 num | 3 num | No transposition |
| Branch code | 3 num | 3 num | No transposition | |
| Account no. | 1 - 8 num | 8 num | Padded with leading 0’s to make 8 characters | |
| Check digit | 2 num | 2 num | No transposition | |
| Brazil (BR) | Bank code | 8 num | 8 num | No transposition |
| Branch code | 5 num | 5 num | No transposition | |
| Account no. | 10 num + 2 a-num | 10 num + 2 a-num | No transposition | |
| British Virgin Islands (VG) | Bank-branch code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Account no. | 1 - 16 num | 16 num | Padded with leading 0’s to make 16 characters | |
| Bulgaria (BG) | Account no. | 22 a-num | 22 a-num |
All characters converted to uppercase All spaces removed |
| Canada (CA) | Routing no. | 1 - 9 num | 9 num | Padded with leading 0’s to make 9 characters |
| Account no. | 1 - 12 num | 1 - 12 num | No transposition | |
| Costa Rica (CR) | Bank-branch code | 3 num | 3 num | No transposition |
| Account no. | 14 num | 14 num | No transposition | |
| Croatia (HR) | Bank-branch code | 7 num | 7 num | No transposition |
| Account no. | 10 num | 10 num | No transposition | |
| Cyprus (CY) | Bank code | 1 - 3 num | 3 num | Padded with leading 0’s to make 3 characters |
| Branch code | 0 -5 num | 5 num | Padded with leading 0’s to make 5 characters | |
| Account no. | 7 - 16 a-num | 16 a-num | Padded with leading 0’s to make 16 characters | |
| Czech Republic (CZ) | Bank-branch code | 4 num | 4 num | No transposition |
| Prefix | 0 - 6 num | 6 num | Padded with leading 0’s to make 6 characters | |
| Basic | 2 - 10 num | 10 num | Padded with leading 0’s to make 10 characters | |
| Denmark (DK) | Bank-branch code | 1 - 4 num | 4 num | Padded with leading 0’s to make 4 characters |
| Account no. | 4 - 10 num | 10 num | Padded with leading 0’s to make 10 characters | |
| Dominican Republic (DO) | Bank-branch code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Account no. | 1 - 20 num | 20 num | Padded with leading 0’s to make 20 characters | |
| Estonia (EE) | Bank code | 2 num | 2 num | No transposition |
| Account no. | 2 - 12 num | 2 -12 num | No transposition | |
| Finland (FI) | Bank-branch code | 4, 5 or 6 num | 4, 5 or 6 num | No transposition |
| Account no. | 2 - 8 num | 8 num | Padded with leading 0’s to make 8 characters, unless Bank-branch code starts with 4 or 5, when padding is after the first number, (59875 becomes 50009875) | |
| France (FR) | Bank code | 0 - 5 num | 5 num | Padded with leading 0’s to make 5 characters |
| Branch code | 0 - 5 num | 5 num | Padded with leading 0’s to make 5 characters | |
| Account no. | 0 - 11 a-num | 11 a-num |
Padded with leading 0’s to make 11 characters All characters converted to uppercase |
|
| Check digit | 2 num | 2 num | No transposition | |
| Georgia (GE) | Bank-branch code | 2 alpha | 2 alpha | All characters converted to uppercase |
| Account no. | 16 num | 16 num | No transposition | |
| Germany (DE) | Bank-branch code | 8 num | 8 num | No transposition |
| Account no. | 1 - 10 num | 1 - 10 num | No transposition | |
| Gibraltar (GI) | Bank-branch code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Account no. | 15 num | 15 num | No transposition | |
| Greece (GR) | Bank code | 1 - 3 num | 3 num | Padded with leading 0’s to make 3 characters |
| Branch code | 1 - 4 num | 4 num | Padded with leading 0’s to make 4 characters | |
| Account no. | 8 - 16 num | 16 a-num |
Padded with leading 0’s to make 16 characters All characters converted to uppercase |
|
| Guatemala (GT) | Bank-branch code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Account no. | 20 a-num | 20 a-num | All characters converted to uppercase | |
| Hong Kong (HK) | Bank code | 1 - 3 num | 3 num | Padded with leading 0’s to make 3 characters |
| Branch code | 1 - 3 num | 3 num | Padded with leading 0’s to make 3 characters | |
| Account no. | 1 - 9 num | 9 num | No transposition | |
| Hungary (HU) | Bank-branch code | 8 num | 8 num | No transposition |
| Account part 1 | 8 num | 8 num | No transposition | |
| Account part 2 | 8 num | 8 num | No transposition | |
| Iceland (IS) | Bank-branch code | 1 - 4 num | 4 num | Padded with leading 0’s to make 4 characters |
| Account type | 1 - 2 num | 2 num | Padded with leading 0 to make 2 characters | |
| Account no. | 1 - 6 num | 6 num | Padded with leading 0’s to make 6 characters | |
| Identification no. | 1 - 10 num | 10 num |
Hyphen (-), dot (.) and slash (/) removed Padded with leading 0’s to make 10 characters |
|
| India (IN) | IFSC code | 11 a-num | 11 a-num |
Converted to uppercase Non alpha-numeric characters removed |
| Account number | 7 or 9 - 18 a-num | 7 or 9 - 18 a-num |
Converted to uppercase Non alpha-numeric characters removed |
|
| Israel (IL) | Bank code | 3 num | 3 num | No transposition |
| Branch code | 3 num | 3 num | No transposition | |
| Account no. | 13 num | 13 num | No transposition | |
| Italy (IT) | Bank code | 1 - 5 num | 5 num | Padded with leading 0’s to make 5 characters |
| Branch code | 1 - 5 num | 5 num | Padded with leading 0’s to make 5 characters | |
| Account no. | 1 - 12 a-num | 12 a-num |
Padded with leading 0’s to make 12 characters All characters converted to uppercase |
|
| Check digit | 1 alpha | 1 alpha | Converted to uppercase | |
| Jordan (JO) | Bank code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Branch code | 4 num | 4 num | No transposition | |
| Account no. | 18 num | 18 num | No transposition | |
| Kazakhstan (KZ) | Bank-branch code | 3 num | 3 num | No transposition |
| Account no. | 13 a-num | 13 a-num | All characters converted to uppercase | |
| Kosovo (XK) | Bank code | 2 num | 2 num | No transposition |
| Branch code | 2 num | 2 num | No transposition | |
| Account no. | 12 num | 12 num | No transposition | |
| Kuwait (KW) | Bank-branch code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Account no. | 1 - 22 num | 22 num | Padded with leading 0’s to make 22 characters | |
| Latvia (LV) | Account no. | 10 -21 a-num | 21 a-num |
All characters converted to uppercase All spaces removed Account number section transposed to 11 characters by padding with leading 0’s. For example, LV61AIZK435195001 transposed to LV61AIZK0000435195001 |
| Lebanon (LB) | Bank-branch code | 4 num | 4 num | No transposition |
| Account no. | 1 - 20 a-num | 20 a-num | Padded with leading 0’s to make 20 characters | |
| Liechtenstein (LI) | Bank-branch code | 3 - 5 num | 5 num | Padded with leading 0’s to make 5 characters |
| Account no. | 1 - 12 a-num | 1 - 12 a-num | All characters converted to uppercase | |
| Lithuania (LT) | Account no. | 10 -20 a-num | 20 a-num |
All characters converted to uppercase All spaces removed Account number section transposed to 11 characters by padding with leading 0’s. For example, LT123456789 transposed to LT123456700000000089 |
| Luxembourg (LU) | Account no. | 20 a-num | 20 a-num |
All characters converted to uppercase All spaces removed |
| Macedonia (MK) | Bank-branch code | 3 num | 3 num | No transposition |
| Account no. | 12 a-num | 12 a-num | All characters converted to uppercase | |
| Malta (MT) | Bank-branch code | 5 num | 5 num | No transposition |
| Account no. | 8 - 16 a-num | 8 - 16 a-num | All characters converted to uppercase | |
| Mauritania (MR) | Bank code | 5 num | 5 num | No transposition |
| Branch code | 5 num | 5 num | No transposition | |
| Account no. | 13 num | 13 num | No transposition | |
| Mauritius (MU) | Bank code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Branch code | 4 num | 4 num | No transposition | |
| Account no. | 18 a-num | 18 a-num | All characters converted to uppercase | |
| Moldova (MD) | Bank-branch code | 2 alpha | 2 alpha | All characters converted to uppercase |
| Account no. | 18 a-num | 18 a-num | All characters converted to uppercase | |
| Montenegro (ME) | Bank-branch code | 3 num | 3 num | No transposition |
| Account no. | 1 - 13 num | 13 num | Padded with leading 0's to make 13 characters | |
| Check digit | 2 num | 2 num | No transposition | |
| The Netherlands (NL) | Bank identifier | 4 alpha | 4 alpha | All characters converted to uppercase |
| Account no. | 1 - 10 num | 10 num |
Padded with leading 0’s to make 10 characters All separators removed (. / - and space) |
|
| New Zealand (NZ) | Transit routing no. | 6 num | 6 num | No transposition |
| Account no. | 9 - 10 num |
nnnnnnn-nn or nnnnnnn-nnn |
All separators except - after position 7 removed | |
| Norway (NO) | Bank-branch code | 4 num | 4 num | No transposition |
| Account no. | 7 num, space , - / | 7 num | All separators removed (. / - and space) | |
| Pakistan (PK) | Bank-branch code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Account no. | 1 - 16 num | 16 num | Padded with leading 0’s to make 20 characters | |
| Palestine (PS) | Account no. | 29 a-num | 29 a-num |
All characters converted to uppercase All spaces removed |
| Poland (PL) | Bank-branch code | 8 num | 8 num | No transposition |
| Account no. | 16 num | 16 num | No transposition | |
| Check digit | 2 num | 2 num | No transposition | |
| Portugal (PT) | Bank code | 1 - 4 num | 4 num | Padded with leading 0’s to make 4 characters |
| Branch code | 0 - 4 num | 4 num | Padded with leading 0’s to make 4 characters | |
| Account no. | 1 - 11 num | 11 num | Padded with leading 0’s to make 11 characters | |
| Check digit | 2 num | 2 num | No transposition | |
| Qatar (QA) | Account no. | 29 a-num | 29 a-num |
All characters converted to uppercase All spaces removed |
| Republic of Ireland (IE) | Sort code | 6 num, space - | 6 num | All separators removed (- and space) |
| Account no. | 8 num, space - | 8 num | All separators removed (- and space) | |
| Romania (RO) | Account no. | 24 a-num | 24 a-num |
All characters converted to uppercase Spaces removed |
| Saint Lucia (LC) | Bank-branch code | 4 alpha | 4 alpha | All characters converted to uppercase |
| Account no. | 24 num | 24 num | No transposition | |
| Saudi Arabia (SA) | Bank-branch code | 2 num | 2 num | No transposition |
| Account no. | 18 a-num | 18 a-num | All characters converted to uppercase | |
| Serbia (RS) | Bank-branch code | 3 num | 3 num | No transposition |
| Account no. | 1 - 13 num | 13 num | Padded with leading 0's to make 13 characters | |
| Check digit | 2 num | 2 num | No transposition | |
| Singapore (SG) | Bank code | 1 - 4 num | 4 num | Padded with leading 0’s to make 4 characters |
| Branch code | 1 - 3 num | 3 num | Padded with leading 0’s to make 3 characters | |
| Account no. | 1 -11 a-num | 11 a-num |
Padded with leading 0’s to make 11 characters All characters converted to uppercase |
|
| Slovakia (SK) | Bank-branch code |
4 num 4 - 7 alpha |
4 num 4 - 7 alpha |
All characters converted to uppercase |
| Prefix | 0 - 6 num | 6 num | Padded with leading 0’s to make 6 characters | |
| Basic | 2 - 10 num | 10 num | Padded with leading 0’s to make 10 characters | |
| Slovenia (SI) | Bank-branch code | 1, 2, or 5 num | 5 num |
2 padded with trailing 0’s to make 5 characters (nn000) 1 padded with 1 leading and 3 trailing 0's (0n000) |
| Account no. | 1 - 10 num | 10 num | Padded with leading 0’s to make 10 characters | |
| South Africa (ZA) | Bank-branch code | 6 num | 6 num | No transposition |
| Account no. | 1 - 15 a-num | 15 a-num | Padded with leading 0’s to make 15 characters All characters converted to uppercase | |
| Spain (ES) | Bank code | 4 num | 4 num | No transposition |
| Branch code | 4 num | 4 num | No transposition | |
| Account no. | 1 - 10 num | 10 num | Padded with leading 0’s to make 10 characters | |
| Check digit | 2 num | 2 num | No transposition | |
| Sweden (SE) | Bank-branch code | 4 or 5 num | 4 or 5 num | No transposition |
| Account no. | 2 to 10 num | 2 to 10 num | All separators removed | |
| Switzerland (CH) | Bank-branch code | 3 - 5 num | 5 num |
Padded with leading 0’s to make 5 characters For 12 digit UBS account numbers, the bank-branch code is set to the 1st three digits of the account number |
| Account no. | 1 - 12 a-num | 1 - 12 a-num |
All separators are removed All characters converted to uppercase |
|
| Thailand (TH) | Bank code | 1 - 3 num | 3 num | Padded with leading 0’s to make 3 characters |
| Branch code | 1 - 4 num | 4 num | Padded with leading 0’s to make 4 characters | |
| Account no. | 1 - 10 num | 10 num | Padded with leading 0’s to make 10 characters | |
| Timor-Leste (TL) | Bank code | 2, 3 or 4 num | 3 num |
2 num padded with leading 0 to make 3 characters 4 num, cropped to 1st 2 digits then padded with leading 0 |
| Account number | 14 num | 14 num | No transposition | |
| Check digit | 2 num | 2 num | No transposition | |
| Tunisia (TN) | Bank code | 2 num | 2 num | No transposition |
| Branch code | 3 num | 3 num | No transposition | |
| Account no. | 1 - 13 num | 13 num | Padded with leading 0’s to make 13 characters | |
| Check digit | 2 num | 2 num | No transposition | |
| Turkey (TR) | Account no. | 26 a-num | 26 a-num |
All characters converted to uppercase All spaces removed Account number section first character always 0 |
| United Arab Emirates (AE) | Bank-branch code | 3 num | 3 num | No transposition |
| Account no. | 16 num | 16 num | No transposition | |
| United Kingdom (GB) | Sort code | 6 num | 6 num | All separators are removed |
| Account no. | 6 - 8 num | 8 num |
Padded with leading 0’s to make 8 characters All separators are removed |
|
| United States of America (US) | Transit routing | 9 num | 9 num | No transposition |
| Account no. | 1 - 17 a-num | 1 - 17 a-num | No transposition |
See also