Create/Edit Import Profile (User-Defined ACH and Wires)
This topic covers all the possible fields that may occur on this page. The page configuration changes based on selections and data entered in some fields. No page configuration has all the field options.
Profile Information
- Profile Name
-
The name that will be used to identify the profile in the system to you and other users if access is public
- File Format
-
The general file format for files that will be imported using the profile
Universal Online Banker supports both standard and user-defined formats for payments and transfers.
This field is read-only and displays your choice from the previous page.
- Format Type
-
The format of the file, such as comma-separated
- File Content Type
-
The available file content types depend on the selected file format.
This field is read-only and displays your choice from the previous page.
- Payment Type
-
A specific type of transaction that will be included in the import, within the broader category of payment type
If importing tax payments, the tax import type is also indicated.
Note: This option applies only to user-defined profiles. This field is read-only and displays your choice from the previous page. - Tax Import Format
-
If Tax Payment is selected as the payment type, this field appears.
Select one of these tax import types:
- Standard Tax
- TXP Segmented
For details about these two tax import options, see General requirements for NACHA files.
- Profile Access
-
Indicates the user's access to the import profile as one of the following:
- Public – All of company users can view and edit the profile.
- Private – Only the user who created the profile can view the profile and can initiate imports based on it.
- Template Import
-
When importing recipients, this determines how they are to be added to the system when there are matching recipients already in the system.
The options are as follows:
- Replace existing recipients and append new recipients – Update the matching recipients, and add any new recipients from the import file
- Append new recipients – Add the recipients that are in the import file
- Replace all existing recipients – Delete all existing recipients and replace them with the recipients in the import file
- Recipient Import
-
When importing recipients, this determines how they are to be added to the system when there are matching recipients already in the system.
The options are as follows:
- Replace existing recipients and append new recipients – Update the matching recipients, and add any new recipients from the import file
- Append new recipients – Add the recipients that are in the import file
- Replace all existing recipients – Delete all existing recipients and replace them with the recipients in the import file
- Date Format
-
The format used for all date values in the import file, such as MM/DD/YYYY.
- Recipient Match Criteria
-
The field (or fields) to be used when comparing imported recipients to existing recipients and deciding whether there are matches.
- Number of Header Rows
-
The number of header rows in the import file
- Option
- Check for duplicate files and reject duplicates
-
Indicates whether the import process checks for duplicate files then rejects duplicates
When selected, the system checks that the following combination of detail in the file's header record is unique to the company:
- Creation Date – The check is limited to a configured number of days.
- Location ID – The validation is not case-sensitive.
- Sequence Number – A literal value is used in the comparison. For example, the values “1” and “0001” will not be interpreted as the same number.
Note: If a duplicate file is found but initially failed during import, then importing the duplicate file will be allowed. - Add 2 decimal places to amounts
-
Indicates whether the import will add two decimal places to amounts in the import file
- Place hold on all zero dollar transactions
-
Indicates whether the import will change the status to "Hold" whenever the recipient has a zero-dollar value
- Check record counts
-
A count of the number of records in the file, up to 9,999
Leading zeros are permitted. For example, 1, 01, 001, and 0001 are all valid values to indicate a file containing one payment record.
For more information on this option, see 75.
- Check hash totals
-
A value obtained by adding together the values in all amount fields
For more information on this option, see 75.
This option does not apply to repetitive payments.
- Make amounts zero
-
When selected, indicates the user wants to change all amounts to zero when the import is executed
Optional Default Field Values
The Default Values section enables you to define values for fields that are required by the banking application to create valid records in the database, but which may not be present in your import files. For example, the banking application requires a Recipient Account Currency for all recipients; however, your import files do not contain this value. To import these files, you must define a default value, and we will use it for all recipients imported with the profile. In addition, if your files contain a particular field, but the field is sometimes blank, you should again define a default value. In this scenario, we will use the default value whenever the field in the file is blank. The fields vary depending on the type of import.
Import Field Selection
- Available Fields
-
The payment fields available for addition to the profile
A field can be added to the profile by selecting it in the list and clicking the right arrow button.
- Fields Included in File
-
The payment fields included in the current profile
A field can be removed from the profile by selecting it in the list and clicking the left arrow button. The Up and Down buttons can be used as needed to order the fields.
An asterisk (*) indicates that a field is required for the selected payment type (selected on the Create Import Profile page).
To return to the previous screen to continue editing the import profile, click Edit Profile.
To go to a preview screen to review your input, click Continue.
