Upload Excel File Format
Introduction
This section serves as a comprehensive guide to the required template format for performing bulk Verification of Payee (VOP) checks within the VOP Portal. The template detailed here is designed for use with Excel file, providing a consistent and efficient way for submitting large batches of IBANs for verification.
Template Formatting Guidelines
Adhering to the following formatting rules is essential to ensure your file is processed correctly and efficiently.
- Use clear and unique file names to help identify each batch - consider including a date, batch number or other unique identifiers.
- Double check for extra spaces before, in between or after values, especially in the field names (headers), Beneficiary Name or Beneficiary IBAN.
- Avoid blank rows or merged cells/rows, these can cause errors during processing.
- Ensure there are no formulas or macros in the file, only plain data should be included.
- Use consistent data formats, aligned with the formats specified in the tables below.
The fields that can be included when uploading an Excel are explained in the table below. The fields can be included in any order within the file.
| Field | Man* | Format | Description |
|---|---|---|---|
| E2E ID | O | String | Unique end to end ID to uniquely track and trace individual transactions throughout the process. This identifier is shared with the Payee Bank. Usage Rule: If provided it is used otherwise it’s generated by SurePay on behalf of the customer. We recommend you add this ID yourself for traceability and audit logging. |
| Beneficiary IBAN | M | String Max Length: 34 | The International Bank Account Number of the Beneficiary. Format: ^[A-Z]\{2}[0-9]\{2}[A-Z0-9]\{1,30}$ |
| Beneficiary Name | M | String Max Length: 140 | The name of the Beneficiary. |
| Beneficiary Bank BIC | C | String Max Length: 11 | The Beneficiary Bank’s BIC code. Usage Rule: Mandatory when Requesting PSP does not utilise the SurePay BIC Enrichment service. Format: ^[A-Z]\{6}[A-Z0-9]\{2}([A-Z0-9]\{3})?$ |
* Man = Mandatory. Values: M = Mandatory, C = Conditional, O = Optional