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.
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 select records for processing.
Use this group box to select the type of file that should be created.
Select this option to create the periodic CTS Tax file. Selecting this button will enable the Periodic group box.
Select this option to create the quarterly CTS Tax file. Selecting this button will enable the Quarterly group box.
Use this group box to select the range of check dates that will be included in the Periodic or Quarterly CTS tax file.
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:
All — Select this option to include all dates in the file.
One — Select this option to include only one date in the file.
Range — Select this option to specify range of dates. Enter the beginning date in the Start field and the ending date in the End field.
From Beginning — Select this option to include the first check date up to a date that you specify. Enter the ending date in the End field.
To End — Select this option to include dates from a date that you enter up to last check date. Enter the beginning date in the Start field.
Enter the beginning date of the check date range to be included in the CTS tax file.
Enter the ending date of the check date range to be included in the CTS tax file.
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.
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.
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.
Use this group box to select records for processing.
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.
Select this radio button to include records that have been included in a previous CTS File.
Select this radio button to include only records that have not previously been included in a CTS File.
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.
Select this check box to include Payroll Edit records in addition to Employee Earnings records.
Select this check box to include Employee detail information on the report.
Use this group box to specify Alaska Occupational Code information.
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.
Employee Taxes — Uses the Alaska Occupational Code assigned to the employee on the Manage Employee Taxes screen.
Detail Job Title Code — Uses the detail job title code entered for an employee on the Manage Employee Salary Information screen. This option is available only if you use Costpoint Human Resources.
Job Title Description — Uses the detail job title description entered for an employee on the Manage Employee Salary Information screen.
User-Defined Info — Uses the label you define in the User-Defined Label field in this screen for all employees.
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.
Use this group box to specify the seasonal period start and end dates.
If applicable, enter, or click to select, the Maine seasonal period start date.
If applicable, enter, or click to select, the Maine seasonal period end date.
Indicate whether or not you provide dependent health insurance benefit options to New York employees.
Select this check box if you provide dependent health insurance benefit options to New York employees.
For Puerto Rico SUTA Reporting, specify the user-defined label used to store the second last name.
Enter, or click to select, the User-Defined label used to store the second last name.
Use this group box to specify the output file information. Be sure that the file location and file name are correct before processing.
Enter the location of the files you are exporting. 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.
Enter the file name of the CTS tax file that will be created and sent to CTS.
Important information for creation of the file:
When creating the Periodic file, if you select the Exclude SUI Data check box for the specified CTS Collector ID on the Configure CTS Settings screen, all SUI data will be excluded from the periodic file (this does not apply to the quarterly file).
When creating the Periodic file, if you select the Exclude Supplemental Data check box for the specified CTS Collector ID on the Configure CTS Settings screen, all supplemental SUI data is excluded from the periodic file. This does not apply to the quarterly file.
We recommend the use of . TXT and . CSV file-naming conventions.