CREATE CTS TAX FILE

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 in the 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 Payroll Edit Records check box.

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 radio button to create the periodic CTS Tax file. Selecting this button will enable the Periodic group box.

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

Periodic

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

From Check Date

Enter the starting check date that will be processed by this application. Employee Earnings records that have a check date later than, or the same as, the From Check Date and earlier than, or the same as, the To Check Date will be included in the processing.

To Check Date

Enter the last check date that will be processed by this application.  Employee Earnings records that have a check date later than, or the same as, the From Check Date and earlier than, or the same as, the To Check Date will be included in the processing.

Quarterly

Select the payroll year and quarter that will be included in the quarterly CTS tax file.

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, this group box becomes disabled and the "All Records" radio button 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.

Payroll Edit Records

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

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.

• Employee Taxes — Uses the Alaska Occupational Code assigned to the employee in the Employee Taxes screen in People\Employee\Employee Payroll Setup

• Detail Job Title Code — Uses the detail job title code entered for an employee in the Salary Info and History screen in People\Employee\Basic Employee Setup. This option is available only if you use Costpoint Human Resources.

• Job Title Description — Uses the detail job title description entered for an employee in the Salary Info and History screen in People\Employee\Basic Employee Setup.

• User-Defined Info — Uses the label you define in the User-Defined Label field in this screen for all employees.

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, specify the Maine seasonal period start date.

End Date

If applicable, specify the Maine seasonal period end date.

File Name

Use this group box to specify the output file information.

Select

Click this button to select the path and file name of the CTS tax file that is created and sent to CTS. You can enter up to 60 alphanumeric characters in this text field.  Be sure that the directory, path, and file name are correct before processing.

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 in the 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 in the CTS Settings screen, all supplemental SUI data is excluded from the periodic file. This does not apply to the quarterly 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.

We recommend the use of .TXT and .CSV file-naming conventions.