-----

This article explains how an admin can add a format validator to ensure employees and managers input their bank details in a specific format. This may help for future reports and integrations, or simply to keep everything neat and tidy.

Similar to the National Insurance / Social Security validation the system currently has, you can validate bank account details. This will stop the user inputting the wrong format in to the relevant field.

To use the validation go to the 'Settings' and click on ‘Company’ in here you will see the fields as below.

Simply put the Regex Code that applies to the relevant jurisdiction, for the UK please see the below.


Sort Code      ^[0-9]{2}[0-9]{2}[0-9]{2}$     without hyphen e.g 123456

                       ^(\d){2}-(\d){2}-(\d){2}$          with hyphen e.g 12-34-56 

Account Number      ^[0-9]{2}[0-9]{2}[0-9]{2}[0-9]{2}$

Thanks,

Customer Services Team