Import ACH Data

The Import ACH Data function allows you to create new or update existing Batch Templates and Participant records using a file created by another application. You may import a Standard ACH file (formatted to NACHA specifications) to add new batches to the Business Banking system.

 

The Import ACH Data function may also be used to update existing batch templates and participates based on criteria defined in Delimited Map or Fixed Map instructions used when importing text files created by another application.

 

To display the Import ACH Data screen:

 

The Standard ACH map type is pre-defined based on NACHA file format and does not require you to develop the map layout.

 

Note: If you are enabled for ACH Prefunding, you must import unbalanced batches.  If importing a balanced batch, the offset account will be removed.

   

Delimited and Fixed ACH Map types allow you to define the file layout so the Import process can identify the structure and intent of the file being imported. Import file layout definitions are stored and maintained as ACH Import Maps.

 

Delimited Map – Use this map type to define the delimiter and where each piece of the participant’s data is located in the file.

 

Fixed Map – Use this map type to define the start and end positions of the participant’s data within the file.

 

You must have the ACH file available either on a local drive or on a network-accessible drive.

 

If you know the full pathname of the file, type it in. For convenience, click the Browse… button under 'File Selection' to open a standard Windows dialog box that allows you to search your local and network drives to locate the file.

 

The Map Type selected under Batch/Process Mode Selection section must match the appropriate map type selected/defined in the Map Selection section.

 

Under the Batch/Process Mode Selection section select the appropriate Batch Template the import should affect.

 

NOTE:  For Add, Update and Delete Maps you must perform the import twice: