CREATE ACH BANK FILE

Use this screen to create the direct deposit file (ACH File). The ACH File is a single text file that you can submit to employees' banks via diskette or modem. Costpoint creates a record for each of the employees' accounts when an unpaid paycheck exists in the Employee Payroll table (Payroll Edit table) and the employee has been set up on the Manage Employee Bank Information screen. The presence of either a check number or a check date prevents a record being created. When this file is sent to your bank, the bank then debits the employer's account and credit amounts to employees' accounts that use the same bank and sends payments to other banks for the remaining employees. Therefore, only one file is written; the records are easily distinguishable by the bank ID that is embedded in each record.

The Direct Deposit of Payroll topic discusses the direct deposit feature in detail.

After you have created payroll and reviewed the Payroll Edit Report, Costpoint can generate the ACH File that contains the payment data to be transmitted to the bank. You must create this file before printing payment advices. Note that once the Payroll Journal is posted, the data required for creating the ACH file is no longer available.

When you run the Activate Pending Employee Bank Information utility and the employee's direct deposit file exists, the employee's Employee Bank Pending Line (EMPL_BANK_PEND_LN) records replace the employee's Employee Bank Line records.

There are two ways to work with export files in Costpoint:

If you decide to use the first option, click in the File Location field to select the alternate file location to which you want to save the file. If you choose the second option, leave the File Location field blank when you export the file.

You will not be able to access this screen if there are records in the old EMPL_BANK_HDR, EMPL_BANK_LN, and EMPL_BANK_PEND_LN tables. To address this, run the Restore Employee Bank Information toolkit.

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Taxable Entity

Use this group box to enter taxable entity ID for which you are creating the direct deposit file. You establish taxable entity information on the Configure Company Information screen.

Option

This field always displays One.

Start

Enter, or click to select, the taxable entity for which you are creating the direct deposit file.

Pay Cycle

Use this group box to enter the pay cycle for which you want to create the ACH File (you can create only one pay cycle at a time). If you have a default pay cycle selected, that pay cycle defaults into this field.

Option

This field always displays One.

Start

Enter, or click to select, the pay cycle for which you want to update deductions.

Tax ID

The employer tax ID associated with the selected taxable entity ID displays in this field.

Start

This field displays the start ID.

Sort By

1st Sort

This field displays the first sort criteria for the direct deposit file. Currently, Employee ID is the only sort.

Options

File Name

Enter the file name (and the path, if needed) to be used for the creation of the file on the disk. Every time you create the ACH File, a new file is written.

To keep previous copies of the ACH File, we recommend that you use user-defined characters to identify each separate file. For example, use the month and day of the effective deposit date (BANK0731.DAT). If you have more than one pay cycle, include the pay cycle identifier in your numbering scheme if the month and day alone do not create a unique identifier, for example, BANKB42.DAT, where B represents bi-weekly, 4 represents April, and 2 represents the second bi-weekly payroll in April.

You can create the ACH File as many times as necessary before transmitting it. Each time this selection is made, the old ACH File is overwritten by the new one. Any recreation of the ACH file must take place before you post the Payroll Journal.

W records without a check number and check date on the Employee Payroll table (Payroll Edit table) are included in the ACH file for employees that have an Active status for direct deposit.

File Location

Enter the location of the file you are creating. There are two ways to do this:

or

Overwrite File

Select this check box to overwrite an existing file saved to the File Location, if it has the same file name.

File Data

Tax ID Qualifier

This number precedes the tax ID for the selected taxable entity. This field defaults to 1, but you can modify it if instructed to do so by your financial institution.

Effective Date

Use this field to assign the effective date of the ACH File, which is also the date of the direct deposit of the payroll. Enter, or click to select, the date on which the bank must credit the employees' bank accounts with the paychecks. If paychecks are normally distributed on Friday, for example, enter Friday's date. It is very important that this date be the correct pay date.

Process

Click to create the ACH file.