ACH Pro provides a convenient means of converting Excel files (and other columnar file formats like CSV) into NACHA files. You can import a file once or save a template to more quickly import other files in the future.

Table of Contents

Required Fields

Before you get started, you need to make sure your data contains the following six required fields. The order of these fields does not matter since you will map them during the import process.

Required Field Description
Recipient Name Recipient’s legal name
Account Number Recipient’s account number
Routing Number Recipient’s nine digit routing number
Account Type Indicates what type the recipient account is: must be CHECKING, SAVINGS or LOAN
Amount The amount for the recipient
Entry Type Indicates if the entry should credit or debit the recipient’s account: must be CREDIT or DEBIT.

In addition to the required fields, there are also three optional fields you can use:

Optional Field Description
Unique Identifier A unique ID you can apply to entries for internal identification.
Addendum Remittance data, up to 80 characters.
Batch ID Enables you to create a NACHA file containing multiple batches. Rows with the same batch ID will be grouped into the same batch.

Import Your File

  1. To get started, click Create File in the left menu in ACH Pro. On the Create File page, click From Import.

Untitled

  1. Now you have the option to import a file from scratch or use an existing import template. If you have an existing template, you can select it and click Continue at the bottom of the page. If you want to import a new file from scratch, click + Import above the list of templates.

Untitled

  1. Select the file you want to import and click Upload.