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.
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.
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.
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
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.
This field always displays One.
Enter, or click to select, the taxable entity for which you are creating the direct deposit file.
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.
This field always displays One.
Enter, or click to select, the pay cycle for which you want to update deductions.
The employer tax ID associated with the selected taxable entity ID displays in this field.
This field displays the start ID.
This field displays the first sort criteria for the direct deposit file. Currently, Employee ID is the only sort.
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.
Enter the location of the file you are creating. There are two ways to do this:
In the File Location field, enter, or click to select, the alternate file location where you want to store the export file. Alternate file locations are set up on the Manage Alternate File Locations screen.
or
Leave the File Location field blank. When you execute this application, the export file is saved to the Costpoint database. Use the Export Files application to retrieve it and save it to a location on the network.
Select this check box to overwrite an existing file saved to the File Location, if it has the same file name.
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.
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.
Click to create the ACH file.