Input
The upload file format for this will need to contain the information in this document, click here to download it. The service has a number of optional fields which make it easier for you to upload the data that you have or have been given by your customer. The only mandatory fields for the service are:
- ISO country code
- account number
The national code must also be completed if the account number is not an IBAN or BBAN (see glossary for definitions).
The fields do not have to be in any particular order and in the upload process you can set where each of these columns is in your sheet. Any columns that we do not need will not be uploaded into the system and will be ignored.
The upload file format for this will be as below, if we cannot verify or believe that any of the data is incorrect then our recommendations will be given in the fields.
Upload file format here
Output
The output file will vary depending on your upload options that you select. The key fields on the downloaded file are the status fields and the recommended data fields as these tell you what we validated and the changes we recommend.
The recommended fields are below and a full field description is available below.
| Field Name | Allowed Characters | Description | Mandatory Field | Default Column |
| countryCode | ISO Country Code list | ISO Country Code | Mandatory | 1 |
| nationalId | Alpha numeric, space and extended | National ID or BIC | Optional | 2 |
| accountNumber | Alpha numeric, space and extended | Domestic Account Number, BBAN or IBAN | Optional | 3 |
| ibanBic | Alpha numeric and space | The BIC issued with the IBAN | Optional | 4 |
| ref | Alpha numeric and space | Unique reference for data storage | Optional | 5 |
| group | Alpha numeric and space | If you wish to group your records into records then enter a group name into this field | Optional | 6 |
recNatid (recommended National ID), if we believe the bank id has changed.
recAcct (recommended Account number) this will be given in a number of circumstances for example if domestic details are given for an IBAN country or if we believe the account number should be padded.
recBic this will be the BIC that we recommend depending on the type of BIC selected in the payBranchType. We will also recommend the account number, this field will not only tell you what we submitted but it will also automatically correct any issues if we can. If domestic details were given for an IBAN country and we automatically create the IBAN wherever possible.
The downloaded file field description is available below.
| Field Name | Allowed Characters | Description | Mandatory Field |
| countryCode | ISO Country Code list | ISO Country Code | Mandatory |
| nationalId | Alpha numeric | National ID or BIC | Optional |
| accountNumber | Alpha numeric | Domestic Account Number, BBAN or IBAN | Optional |
| ibanBic | Alpha numeric | The BIC issued with the IBAN | Optional |
| ref | Alpha numeric extended | Unique reference for data storage | Optional |
| group | Alpha numeric extended | If you wish to group your records into records then enter a group name into this field | |
| Status | Alpha numeric extended | Status of the record, Pass, Caution or Fail | Mandatory |
| Comment | Alpha numeric extended | Error text and error code | Optional |
| recNatID | Alpha numeric | Change we recommend to the national id | Optional |
| recAccount | Alpha numeric | Change we recommend to the account number | Optional |
| recBIC | Alpha numeric | Change we recommend to the BIC | Optional |
| nm | Alpha numeric extended | Bank name | Optional |
| branch | Alpha numeric extended | Branch name | Optional |
| city | Alpha numeric extended | Branch city | Optional |