Product: ImportOmatic
Description: This solution describes how to resolve the Error: Invalid Institution ID: Institution ID
Environment: All
Versions: All


This error occurs when importing bank information and the Institution ID does not match the required format.

The Institution ID must be 8-digits long.

If the Institution ID should have leading zeros, sometimes Excel will strip these leading zeros, resulting in a number that is less than eight digits.

A Regular Expression dictionary can be used to pad the number out to eight digits.

Create an Excel spreadsheet with the following values:

  1. Highlight the three columns and copy
  2. Right click in the white space under Replacement Value and choose Paste values from Excel
  3. Save the dictionary
  4. Apply the dictionary to the field with the Institution ID

Please refer to the ImportOmatic User Guide for additional information.