Product: ImportOmatic
Description: This solution describes how to resolve the error Invalid Transit/Routing Number: Transit/Routing no.
Environment: All
Versions: All
Answer:
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:
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:
- Highlight the three columns and copy
- Right click in the white space under Replacement Value and choose Paste values from Excel
- Save the dictionary
- Apply the dictionary to the field with the Transit/Routing Number
Please refer to the ImportOmatic User Guide additional information.