Automatic IBAN Checksum Validation for Zoho CRM
Automatically detect invalid IBANs associated to your records without any data leaving your CRM
- Reviewed and approved by Zoho
- Zoho Marketplace Editor's Pick Spring 2023
Key features
- Available in four CRM modules: Accounts, Contacts, Invoices and Vendors. Updated to work as well in custom modules (requires extra configuration).
- Fast: checksum test is performed immediately every time an IBAN is created or modified and the result is displayed within seconds.
- Secure: the extension performs all operations within your CRM instance. No data is sent to us or to any third-party service.
- Intelligent: by default, the extension reformats the IBAN to its electronic format.
Why validate IBANs?
IBANs (International Bank Account Numbers) are used in +70 countries and are mandatory in many of them (for instance, in countries within the SEPA or Single Euro Payments Area). One of their advantages is that, unlike other bank number formats such as BIC, they have check digits to minimize the risks of typographic and transcription errors.
Often businesses keep IBANs in their CRMs, either as part of the billing details of their customers or as payment details of their vendors and suppliers. Furthermore, they can be stored for each individual invoice and even as in the individual records of the business employees for payment of their salaries. All this shows how relevant IBANs are for day to day operations and the importance of them being valid and properly formatted.
This extension automatically verifies the checksum of the IBANs you insert into Zoho CRM and informs you when IBANs do not pass the checksum test, so that you can promptly amend them. Plus, optionally, it standarizes their format to the electronic variant (i.e. upper case and without spaces).
What the extension does (and what not)
The extension performs a checksum validation of the IBAN. This being a first layer of IBAN validation, it detects most invalid IBANs (usually because of typographic and transcription errors).
The extension does NOT perform deeper, additional validations such as country specific format match or BBAN account number checksum. Those are more complex checks usually performed by financial institutions. Should you require those additional validations, there are other third-party services offering them, however at a considerable price if used at scale and requiring you to send IBANs over the internet.
As rule of thumb: if the extension considers an IBAN to be invalid, it is invalid. But if an IBAN passes the validation, there could still be issues affecting the validity such as wrong length for country or BBAN account number checksum.
Supported modules
- Accounts
- Contacts
- Invoices
- Vendors
- Custom modules (requires additional configuration, please contact us at support@d4-data.com for instructions)
Getting started
- Install the extension from the Zoho Marketplace.
- Optionally, adjust the extension settings as described below.
- The extension is now working.
Extension settings
The extension settings will appear upon installation and are the following:
- Enforce Electronic Format: if checked (“ON”), any evaluated IBAN will have the electronic format applied, i.e. all spaces will be removed. If unchecked (“OFF”), the spacings of the IBAN will be kept as they are. Characters from A to Z will be converted to upper case regardless of this setting. The default value is ON.
- Accounts/Contacts/Invoices/Vendors IBAN Field API Name: these text fields define what field for each of the supported modules will be evaluated by the extension for IBAN validation (the “IBAN field”). The default value is ibanchecksumvalidator__IBAN, which is the API name of the field created by the extension with the label IBAN.
Should you want to use another field instead (e.g. a preexisting IBAN field created by you), you may change the field value to the exact (case sensitive) API name of that field. If an invalid name is provided, the field data type is not text or the field is left blank, validation will be disabled for that specific module.
You can change the settings at any time going to Zoho CRM Settings > Marketplace > All and selecting the extension.
How to use
Once at least one module has an IBAN field defined, the extension will automatically evaluate the IBAN field, each and every time a record is created or edited.
- When a record is created or edited: upon saving the record.
- When only a specific record IBAN field is edited: upon saving the field or pressing enter.
Privacy
Support and feedback
Should the extension behave in a way you believe to be caused by a bug, please report it to us at support@d4-data.com for further investigation. We also invite you to share with us at the same email address any support requests, improvement suggestions and comments you might have.