Product: ImportOmatic
Description: This solution describes how to resolve the error Invalid Transit/Routing Number: Transit/Routing no.
Environment: All
Versions: All


This error occurs when importing bank information and the Transit/Routing Number does not match the required format.

The Transit/Routing Number must be 8-digits long.

If the Transit/Routing Number 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 Transit/Routing Number

Please refer to the ImportOmatic User Guide additional information.