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
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. |