CREATE CTS TAX FILE DATA

Use this screen to download tax data from a range of check dates or a payroll year and quarter to a standard ASCII text file in the format prescribed by CTS. You can then transmit this file to CTS for tax processing. You can create a periodic or a quarterly file.

Use this screen after establishing information on the Configure CTS Settings screen. If you are creating the periodic file, use this screen after posting payroll for the period. If you are creating the quarterly file, use this screen after posting all payroll records for the quarter being reported. To include records from the Payroll Edit table, select the Include Payroll Edit Records check box.

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.

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.

Select

Use this group box to select records for processing.

File Type

Use this group box to select the type of file that should be created.

Periodic

Select this option to create the periodic CTS Tax file. Selecting this button will enable the Periodic group box.

Quarterly

Select this option to create the quarterly CTS Tax file. Selecting this button will enable the Quarterly group box.

Select

Use this group box to select the range of check dates that will be included in the Periodic or Quarterly CTS tax file.

Check Date

These fields are active when you select the Periodic file type. From the drop-down list, select the range type of the check dates that will be included in the Periodic CTS tax file. Valid options are:

Start

Enter the beginning date of the check date range to be included in the CTS tax file.

End

Enter the ending date of the check date range to be included in the CTS tax file.

Quarter

These fields are active when you select the Quarterly file type. Select the payroll year and quarter that will be included in the quarterly CTS tax file. The unlabeled range type field always display One.

Payroll Year

Enter the four-digit payroll year that will be processed by this application. The application uses the Payroll Year and Quarter to select checks to include in the quarterly CTS tax file.

Quarter

Select the quarter that will be processed by this application. The application uses the Payroll Year and Quarter to select checks to include in the quarterly CTS tax file.

Options

Use this group box to select records for processing.

Process

When a CTS Tax file is created, the Payroll Edit or Employee Earnings records are flagged as "processed through CTS." This helps prevent the same data from being submitted twice. Use this group box to specify the whether or not to include paychecks that have already been included in a previous CTS periodic file.

If you select Quarterly as the File Type, these fields become disabled and the All Records option is automatically selected.

All Records

Select this radio button to include records that have been included in a previous CTS File.

Unprocessed Records Only

Select this radio button to include only records that have not previously been included in a CTS File.

Include

Use this group box to specify whether Payroll Edit records should be included in the CTS tax file. Only Payroll Edit records that have check numbers are included if this option is selected.

Include Payroll Edit Records

Select this check box to include Payroll Edit records in addition to Employee Earnings records.

Report

Include Employee Detail on Report

Select this check box to include Employee detail information on the report.

Alaska Occupational Code

Use this group box to specify Alaska Occupational Code information.

Source

From the drop-down list, select what you want to use for the Alaska Occupational Code for employees being reported in the Alaska 602 record.

User-Defined Label

If you select the User-Defined Info option in the Source field in this screen, enter the user-defined label you want to use for the Alaska Occupational Code for all employees being reported.

Maine Seasonal Period

Use this group box to specify the seasonal period start and end dates.

Start Date

If applicable, enter, or click to select, the Maine seasonal period start date.

End Date

If applicable, enter, or click to select, the Maine seasonal period end date.

New York Dependent Health Insurance

Indicate whether or not you provide dependent health insurance benefit options to New York employees.

Benefit Options Provided to Employees

Select this check box if you provide dependent health insurance benefit options to New York employees.

Puerto Rico Second Last Name

For Puerto Rico SUTA Reporting, specify the user-defined label used to store the second last name.

User-Defined Label

Enter, or click to select, the User-Defined label used to store the second last name.

Report and Output File

Use this group box to specify the output file information. Be sure that the file location and file name are correct before processing.

File Location

Enter the location of the files you are exporting. There are two ways to do this:

or

File Name

Enter the file name of the CTS tax file that will be created and sent to CTS.

Important information for creation of the file:

International users: The data can contain non-English characters, provided they are in the ASCII character set. Before creating an ASCII text (. TXT) file, be sure that your keyboard language is set to EN (United States English) to prevent the application from generating errors.