Control import for mass verification

Looking to verify all your third parties' bank details simultaneously? My Sis ID makes mass verification straightforward.

Simply fill out the template with the payment identities and upload it to the platform.

This article provides a step-by-step guide on how to verify multiple bank details and companies in one seamless process.

Download the template

Follow these steps to download the import’s template:

1. Login on My Sis ID and select "Controls import" from the "Control" menu
2. Click on the "Check" button (upper right hand side)
3. Download the appropriate template. 

Complete file with data to be verified

Format requirements

• File to import must be an UTF-8 CSV with semicolon as separator
• File must contain no more than 10 000 lines
• To prevent leading 0 from being deleted in identifier and bank details content, the cell format must be set to “text”
• Try opening the file with notepads apps and erase any useless spaces.
• Do not capitalise first names and surnames.

Content requirements

• Import file must contain bank details and entities only for countries covered by Sis ID

Mandatory fields

• Company country code and [Company identifier or DUNS number]
• IBAN or [Bank details country code + Bank Account number + Bank code]

Columns

• Columns names must not be modified
• Columns order is not important
• Columns containing no data can be deleted

Example of valid file ✅

Example of invalid file ❌

Import the file on My Sis ID

1. Login on My Sis ID and select "Controls import" from the "Controls" menu
2. Click on "Check" (upper right hand side)
3. Click on "Browse" and select the file
4. Click on "Check" to launch import
5. Review the progress of import

Get the results details

From the control import page, import result can be reviewed via 2 modes:

• Review the list of controls of the import in the My Sis ID web application by clicking the import line
• Download the result file 

Lines in error

In the results of your bulk check, you may find the mention "Number of lines in error: X". It means that the expected format of the information is incorrect. The lines in error therefore represent data that could not be imported for the check on the platform, and thus there will be no result for them in the export file.

There can be several scenarios:

• The format of the company identifier is incorrect. For example, the expected format for a SIREN is 9 digits; if 8 digits are provided for a SIREN, it will constitute a line in error.
• The format of the bank account details is incorrect. A French IBAN must contain the characters FR followed by 25 characters. If you compile an IBAN composed of FR and 24 characters, it will constitute a line in error.
• The country of the identifier does not match the identifier. If you provide a SIREN for a company whose country code is ES, it will result in an error.

To find the missing lines, you can compare the data in your incoming and outgoing files. This will allow you to correct the erroneous data.

SEPAmail Diamond response pending

If some verifications are pending with SEPAmail Diamond (symbolized by a Diamond logo next to the orange scores) after 20minutes, browse your file again in order to have SEPAmail Diamonds response updated.

Find here the explanations for the reasons that may be reported by SEPAmail Diamond.