EFT Template Designer (EFTTMPL) window
An Electronic Funds Transfer (EFT) template is used to generate the text file for an EFT payment. The National Automated Clearing House Association (NACHA) has specified some standard formats for creating EFT files. Of these, Made2Manage provides you with the following NACHA format templates that you can customize for your use:
- CCD (Corporate Credit or Debit) : Used to pay or collect from other corporate (business) accounts. For example, for making vendor payments.
- PPD (Prearranged Payment and Deposit) : Used to pay or collect from personal (consumer) accounts. For example, for direct deposit of payroll to employees
For more information about the NACHA format templates, refer to the NACHA website.
Use the EFT Template Designer (EFTTMPL) window to:
- Customize the out-of-the box Made2Manage NACHA templates.
- Create your own EFT templates.
The EFT Template Designer (EFTTMPL) window is available only if you have assigned appropriate permissions for the EFT Template Designer (EFTTMPL) window in the User Permission Wizard (PERMWIZ). For more information about assigning permissions, see Assign default permission to the new windows/reports and Manage user permissions.
Generally, an EFT file record is of fixed length and has a blocked structure that includes the following records in the order specified:
-
A file header record : Only one record in each file. Specifies the origin and the destination. It also includes the date, time, and other information that can be used to identify the EFT file.
-
One or more batch header records : One record for each EFT batch. Identifies the batch and briefly describes the purpose of the batch record.
-
One or more entry detail records for each batch : Specifies the EFT transaction amount and the receiving account number.
-
One or more addenda records for each entry detail record : Provides additional information about the entry detail record.
-
One or more batch control records : One record for each EFT batch. Indicates the batch total.
-
A file control record : Only one record in each file. The last logical record. Indicates the file total amount.
-
Filler values : A series of a character appended to complete the block.
** Note: **A NACHA block generally consists of 10 records. 9 is used as the filler character for NACHA format templates.
The EFT Template Designer (EFTTMPL) window is divided into three areas:
- Header
- Row Details
- Column Details
Header area
The following table describes the fields in the Header area.
| Field | Description |
|---|---|
| EFT File Template Name | The EFT file template name. Assign a file name that indicates the EFT file template standard that it adheres to. |
| Standard Template | A check box that is selected for standard out-of-the box templates. |
| Include Filler Records | A check box that is selected if filler records are added to complete the payment information block. This check box is selected by default for the standard out-of-the box NACHA templates and cannot be cleared. |
| Filler Value | The character used in the filler records. The default filler character for the standard out-of-the box NACHA templates is 9 and cannot be changed. This field is enabled only when you select the Include Filler Records check box. |
| Filler Row Width | The row width of the filler records added to complete the payment information block. The default row width for the filler records in the standard out-of-the box NACHA templates is 94 and cannot be changed. This field is enabled only when you select the Include Filler Records check box. |
| File Format Type | The EFT file type. Presently, only text format is supported. |
| Status | The status of the EFT file template: Active or Inactive. More than one EFT file template can be active at a time. The active EFT file templates are available for selection in the Bank Names tab of the Accounts Payable (CSAP) window. |
| Include DM | A check box that when selected indicates that debit memos must be included in the generated EFT file. Select this check box only when the EFT file format is defined to include credit and debit applied invoice amount details. |
| Replacement Code | The code that replaces the credit/debit code defined in the corresponding row-column definition. This field is enabled only if you select the Include DM check box. |
| Replacement Column | The column in which the replacement code must be substituted specified in the format ** |
| Include Zero Amount Vendor Records | A check box that when selected indicates that zero payment amounts that result due to applying debit memo to net off an AP invoice must also be included in the generated EFT file. Select this check box only when the EFT file format is defined to include credit and debit applied invoice amount details. |
| Enable Validation For Mandatory Columns | A check box that when selected checks if the mandatory columns have values specified before generating the EFT file. |
| Tables | A button that when clicked opens the Tables window to view the EFT tables associated with the template or to add EFT tables when creating a template. |
Row Details area
Use the grid in the Row Details area to specify the rows that constitute the EFT file.
The following table describes the columns in the Row Details area grid.
| Column | Description |
|---|---|
| Row Sequence | The order of the row. This is assigned automatically when you add a row. |
| Row Type | The row content type: |
-
Header : For header records such as the file header or the batch header records.
-
Detail : For entry detail records.
-
Trailer : For control record such as the file control or the batch control records.
Row Description | A brief description of the row.
Row Width | The row width. NACHA files have a fixed row width of 94 characters.
Header Link | The parent row number. For example, the header link of the batch header record is the file header row number. The Header Link value must be at least 1 less than that of the Row Sequence.
Row Space | The spacing between the rows of the EFT payment file. If no value is given, single spacing is assumed.
Column Details area
Use the grid in the Column Details area to specify the columns that are present in each row type of the EFT file.
The following table describes the columns in the Column Details area grid.
| Column | Description |
|---|---|
| Column Sequence | The order of the column in the row. This is assigned automatically when you add a column. |
| Data Start Position | The starting position of the column. This is assigned automatically when you add a column. |
| Data End Position | The ending position of the column. This is assigned automatically when you specify the length of the column. |
| Data Length | The length of the column. |
| Column Description | A brief description of the column. |
| Data Type | The data type of the column, that can be one of the following: |
-
FreeText : For hard coded text.
-
Expression : For a computed expression.
-
Current Date : For the system date.
-
Current Time : For the system time.
-
System : For an M2M field from one of the tables associated with the template.
Data Source | The column value’s source or hard coded text. If the hard coded text in the Data Source column of a standard out-of-the box template contains asterisks, you can type your company-specific value in that column.
Mandatory | A check box if selected indicates that the column value is mandatory and must be present in the EFT file. If a column is mandatory, an appropriate value must be entered to ensure proper routing and processing. If not included, the ACH Operator will reject the EFT file.
Justified | The justification that must be applied to the column value if it is less than the column width.
Padding Value | The padding value other than space to be used if the column value is less than the column width. The default padding value is space.
Source Data Trim | The position from which the data must be trimmed if the value exceeds the data length: Right or Left. This is applicable only for column values whose Data Type is Expression or System.
Expression | The expression to be used for columns whose Data Type is Expression :
-
Sum of : To sum the values of a column that contains decimal data.
-
Count of : To count the occurrences of one or more rows.
-
Concatenation of : To concatenate the values in a particular column.
-
Block Count : To include the total number of records in the ACH file, divided by the value of block count as specified in the Block Count column and rounded to the nearest integer based on the value in the Roundoff column.
Expression Reference | The column for which the expression is applicable.
Date Format | The date format to be applied to the column value
Time Format | The time format to be applied to the column value
Separator | The character to be used as the separator for date, time, or system values
Unique Identifier | A check box if selected adds a new row for each unique value of that column. We recommend that you set at least one column as the unique identifier for a row.
Increment | The value by which a hard-coded column value whose Data Type is FreeText must be incremented. The default Increment value is 0.
Row Overfill | A check box if selected indicates that the column value must be wrapped to the next row if it exceeds the row width. When you select the Row Overfill check box, data length validation is not done for the column.
Loop Expression | A check box if selected indicates that the column value is an expression that loops based on the unique column identifier. This check box is enabled only if you select the Row Overfill check box and is usually applicable for Addenda records.
Decimal Length | The number of digits to the right of the decimal separator.
Decimal Separator | The character to be used as the decimal separator.
Block Count | The dividend value used in the block count expression. The value specified in this field is divided into the total records to be included in the ACH file. This column is enabled only if you select Block Count in the Expression column drop-down.
Roundoff | The value to round off the block count to the nearest integer. This column is enabled only if you select Block Count in the Expression column drop-down.