Import A Non NACHA File Using a New Template

ACH Manager facilitates controlled access to templates that conform to the NACHA standardized file format by implementing NACHA-specific templates that are established by user identity.

Import a non-NACHA file using a new template

Open ACH Manager. The External Transfer Criteria box appears.
From the Management Tools menu, select ACH Manager. The Select External Transfer Criteria box appears.
Select ACH File Import Template and then click Submit. The ACH File Import Template List appears.

Select Non NACHA from the Import File Type drop-down list to view only the non-NACHA file import templates.

Click the ACH File Import Template List toolbar. The New File Import Template box appears.

When accessing the ACH File Import Template function through Access Manager Account Options, click the client name hyperlink from the User List before continuing.

Refer to the Non NACHA Transfers topic under Import ACH Transfer for information on creating a new transfer from a template in this list.

Select Non NACHA from the Import File Type drop-down menu and then click Submit. The system displays the Step 1 – File Selection box as part of the Non NACHA File Import workflow page.

Click Browse. The Choose File to Download dialog box appears.
Select the delimited or fixed-width (non-NACHA format) file, and then click Open. The system displays the file path and name in the File Location field.
Click Next. The Step 2 – Template Details box appears, containing a preview of the imported file contents.

Complete the following fields.

ACH Transfer Type

The ACH Transfer Type field appears as a drop-down list from which you can select the type of transfer that will be imported.

Payroll

indicates a Payroll ACH transfer type.

Prearranged Payment

indicates a Prearranged Payment ACH transfer type.

Prearranged Deposit

indicates Prearranged Payment Deposit ACH transfer type.

HSA Contribution

indicates a HSA Contribution ACH transfer type.

Corporate Credit

indicates a Corporate Credit ACH transfer type.

Corporate Debit

indicates a Corporate Debit ACH transfer type.

Consumer Deposit

indicates a Consumer Deposit ACH transfer type.

Consumer Payment

indicates a Consumer Payment ACH transfer type.

Vendor Payment

indicates a Vendor Payment ACH transfer type.

Remittance

indicates a Remittance ACH transfer type.

Federal Tax Payment

indicates a Federal Tax Payment ACH transfer type.

State/Local Tax Payment

indicates a State/Local Tax Payment ACH transfer type.

Re-presented Check

indicates a Re-presented Check ACH transfer type.

Automated Enrollment Entry

indicates an Automated Enrollment Entry ACH transfer type.

Destroyed Check

indicates a Destroyed Check ACH transfer type.

Corporate Trade Exchange

indicates a Corporate Trade Exchange ACH transfer type.

Customer Initiated Entry

indicates a Customer Initiated Entry ACH transfer type.

Internet Initiated Entry

indicates am Internet Initiated Entry ACH transfer type.

Telephone Initiated Entry

indicates a Telephone Initiated Entry ACH transfer type.

Child Support Payment

indicates a Child Support Payment ACH transfer type.

International ACH

indicates an International ACH transfer type.

Template Description

Enter the name of the file import.

Tax Identification Number

Enter the tax ID number of the account owner at the Originating Depository Financial Institution (ODFI).

Template Group

Click the Add icon to add a new template group or select an existing template group from the drop-down list.

Number of Header Rows to Exclude

Enter the number of header rows at the beginning of the file that are excluded during file import.

Number of Footer Rows to Exclude

Enter the number of footer rows at the end of the file that are excluded during file import.

Insert Decimal into Amounts

Delimited

Indicates the imported file format is Delimited. If the Delimited option is selected, you can further specify the type of delimited format used in the imported file.

Tab

indicates the file delimiter is a tab

Semicolon

indicates the file delimiter is a semicolon

Comma

indicates the file delimiter is a comma

Space

indicates the file delimiter is a space

Other

indicates the file delimiter is other than a space

File formats are either delimited or fixed width.

Text Qualifier

Fixed Width

Indicates that every field in the template has a fixed, defined width, with shorter values being padded with characters. This option produces a file format preview with column headers in the Field Definitions step. Selecting this option overrides any selections in the Delimited field, as files are either delimited or fixed width.

User Access

The ACH Manager users that have access to view, inquire, change and delete the template, as well as review transfers originated using the template. The User Access settings also control who can import files using the template.

All User Access (including new added users)

indicates that all users have access to the template and transfers imported using the template, including future users.

Select All

indicates that all users currently listed in the User Access section have access to the template and transfers imported using the template.

[User Name]

indicates that only users selected in this section have access to the template and transfers imported using the template.

New employees added to the company after the template was created must be manually selected in this section by changing the template before they have access to the template or transfers created from it.

Click Next. The Non NACHA File Import box displays Step 3 – Field Definitions, still showing the imported file contents in the File Preview field.

Complete the following fields.

File Preview

The preview of the ACH file format. If the imported file contains data in columns, Layout Preview displays a drop-down list for each numbered column; select each column's data type from the Column # drop-down.

The data type varies by the ACH transfer type specified for the template. If only a single column displays in Layout Preview, define the data types in the Apply Additional Values to File section.

If any value required for the selected ACH Transfer Type is not defined in the imported ACH file, it needs to be defined in the Apply Additional Values to File section Type and Value fields.

If necessary, complete the following fields.

Type

Select the field type in the ACH file. Values vary depending on the ACH type.

Account Number

indicates the account number.

Amount

indicates the transfer amount. For tax payments, the values include amount type and amount description for one or more payments.

Discretionary Data

indicates discretionary data.

Effective Date

indicates the effective date.

Individual Identification Number or Employee Name

indicates the payee identification number.

Name or Employee Name

indicates the payee name.

Payment Related Information

indicates payment-related information.

R/T Number

indicates the Routing Transit Number.

Transaction Code

indicates the transaction code.

Value

The value of each field type.

Add Column

Click the Add Column hyperlink to define an additional value to the file.

In the Offset Account Options section, complete the following:

Offset Account Defined In File

Select whether the offset account is defined within the import file.

Add Offset Account to File

Select whether the offset account is added into the import file.

In the Effective Date Option section, complete the following:

Date In File

Select whether the effective date is defined within the import file.

Prompt For Date

Select whether the ACH user is prompted for the effective date during the file import process.

Default Current Business Date

Select whether the current business date is added into the file during the import process.

Click Next. The Step 4 – Data Mapping box appears.

The box subheading displays the name of the imported file and the Template field displays the name of the new template. The remaining items show the ACH and data types and values currently defined for the template.
Click Next. The Step 5 – Import box appears.

The Batch ID shows the identification number of the ACH file being imported, along with the number of debits and credits, and the File Details shows the total debits and credits.
Click Finish. The Step 6 – Import Confirmation box appears.

The Batch ID section summarizes the transfer date and debit/credit information, and the File Summary shows the file confirmation number and debit/credit totals in the file. Ensure that the box displays the message, "The following file was successfully imported".
Click Review to make changes to specific transfer information contained in the new file.

Click Save to save the new template.
Close ACH Manager.

Yes	indicates the decimal is inserted to the right most digits of an amount.
No	indicates the decimal is not inserted.

Payroll	indicates a Payroll ACH transfer type.
Prearranged Payment	indicates a Prearranged Payment ACH transfer type.
Prearranged Deposit	indicates Prearranged Payment Deposit ACH transfer type.
HSA Contribution	indicates a HSA Contribution ACH transfer type.
Corporate Credit	indicates a Corporate Credit ACH transfer type.
Corporate Debit	indicates a Corporate Debit ACH transfer type.
Consumer Deposit	indicates a Consumer Deposit ACH transfer type.
Consumer Payment	indicates a Consumer Payment ACH transfer type.
Vendor Payment	indicates a Vendor Payment ACH transfer type.
Remittance	indicates a Remittance ACH transfer type.
Federal Tax Payment	indicates a Federal Tax Payment ACH transfer type.
State/Local Tax Payment	indicates a State/Local Tax Payment ACH transfer type.
Re-presented Check	indicates a Re-presented Check ACH transfer type.
Automated Enrollment Entry	indicates an Automated Enrollment Entry ACH transfer type.
Destroyed Check	indicates a Destroyed Check ACH transfer type.
Corporate Trade Exchange	indicates a Corporate Trade Exchange ACH transfer type.
Customer Initiated Entry	indicates a Customer Initiated Entry ACH transfer type.
Internet Initiated Entry	indicates am Internet Initiated Entry ACH transfer type.
Telephone Initiated Entry	indicates a Telephone Initiated Entry ACH transfer type.
Child Support Payment	indicates a Child Support Payment ACH transfer type.
International ACH	indicates an International ACH transfer type.

Tab	indicates the file delimiter is a tab
Semicolon	indicates the file delimiter is a semicolon
Comma	indicates the file delimiter is a comma
Space	indicates the file delimiter is a space
Other	indicates the file delimiter is other than a space

All User Access (including new added users)	indicates that all users have access to the template and transfers imported using the template, including future users.
Select All	indicates that all users currently listed in the User Access section have access to the template and transfers imported using the template.
[User Name]	indicates that only users selected in this section have access to the template and transfers imported using the template.

Account Number	indicates the account number.
Amount	indicates the transfer amount. For tax payments, the values include amount type and amount description for one or more payments.
Discretionary Data	indicates discretionary data.
Effective Date	indicates the effective date.
Individual Identification Number or Employee Name	indicates the payee identification number.
Name or Employee Name	indicates the payee name.
Payment Related Information	indicates payment-related information.
R/T Number	indicates the Routing Transit Number.
Transaction Code	indicates the transaction code.