CTS INTERFACE DATA SETUP

This section outlines the data setup required before you can create a CTS quarterly or periodic tax file. Be sure to review employee records and payroll information before using this interface.

The data that is required for, but not limited to, each Costpoint screen is outlined below. Please refer to the documentation for each screen and/or module for additional details.

Before processing, be sure that Costpoint 4.0 is updated with the following required system patches: 550, 1002, and 1079.

Detail Job Titles

Use the Detail Job Titles screen in Costpoint Compensation Administration to establish job titles at the detail level within your organization. Enter the appropriate information in this screen after you have set up the Functional Job Title table. If you are licensed for Costpoint Human Resources, you can indicate those detail job titles that are corporate officer positions by selecting the Corporate Officer checkbox. The settings in this screen affect the data that you enter in the Salary Info and History screen. If a detail job title is a corporate officer position, the Corporate Officer checkbox will automatically be selected when the Detail Job Title is assigned to employee records in the Salary Info and History screen. Selecting this checkbox in the Detail Job Titles screen will not update existing Salary Info and History records.

Workers' Comp Codes

Use the Workers' Comp Codes screen in Costpoint Labor to set up codes and related descriptions for workers' compensation tracking. You must establish workers' compensation codes before you can complete the Labor Settings screen. For each line in the Worker's Comp Codes screen, you can enter the North American Industry Classification System Code (in the NAICS Code field) or the Standard Industrial Code (in the SIC Code field) that applies to the workers' compensation code if you are reporting the CTS State Employee Wage List information for the state of Wyoming.  The system uses the SIC code to create the Wyoming State Employee Wage List record in the CTS file when reporting wages paid through fourth quarter 2002.  The system uses the NAICS code to create the Wyoming State Employee Wage List record in the CTS file when reporting wages paid in first quarter 2003 or later.  

Salary Info and History

Use the Salary Info and History screen (located in any Employee Setup and/or Employee Info menu throughout Costpoint People) to establish salary and salary-related information for employees. Certain states require employers to specify in their quarterly unemployment reporting whether an employee is a seasonal employee or a corporate officer of the company. In this screen, select the Seasonal Employee checkbox to indicate that the employee is seasonal and therefore will be included in the state's Employee Seasonal Indicator record of the CTS quarterly tax file. Select the Corporate Officer checkbox to indicate that the employee is a corporate officer of the company and therefore will be included in the state's quarterly unemployment reporting. If a Detail Job Title's Corporate Officer checkbox is selected in the Detail Job Titles screen in Costpoint Compensation Administration, the Corporate Officer checkbox will automatically be selected when that Detail Job Title is assigned in the Salary Info and History screen.

Payroll Taxes

Use the Payroll Taxes screen (or the Payroll Taxes subtask of the Maintain Employee Master screen) in Costpoint Payroll to establish payroll tax information and assign pay cycles to employee records. You must complete this screen for proper calculation of payroll and withholding taxes. If the SUTA State is "WY" (Wyoming), "AK" (Alaska), or "CA" (California), you must enter data in the Tax Reporting Info subtask.  Use the Tax Reporting Info subtask to enter quarterly tax information that will be reported to any of these three states by Ceridian Tax Services (CTS). 

Tax Reporting Info

Wyoming

In the Wyoming group box, select a Class Code, Corporate Officer ID, if applicable, and Coverage Type that applies to the employee.  The system will use this information when creating the Wyoming Employee Wage List Special Reporting record in the CTS Quarterly file. The following system-defined options are available in the Class Code drop-down box:

• No Class Code

• Corporate Officer

• Inmate Worker

•  JTPA worker

• Partner

• Sole Proprietor

• Volunteer

• Welfare

• Independent Contractor

If the Class Code is "Corporate Officer," the Corporate Officer ID drop-down list in the Wyoming group box is enabled, and you must select one of the following system-defined options:

• President

• Vice President

• Secretary

• Treasurer

• Other

• None

From the Coverage Type drop-down box in the Wyoming group box, select from the following system-defined coverage options the one to which the employee is assigned:

• Unemployment Only

• Workers Comp Only

• Both (Select this option if the employee is subject to both unemployment and workers compensation.)

• None

Alaska

In the Alaska group box, enter, or use Lookup to select, the Geographic Code that encompasses the employee's primary work site. This information is required for the Alaska Employee Wage List Occupational Code reporting. The following table lists the system-defined values that you can enter in the Geographic Code field for the State of Alaska:

In the Alaska group box, enter, or use Lookup to select, the Occupational Code that represents the employee's occupation. This information is required for the Alaska Employee Wage List Occupational Code reporting.

Minnesota

In the Worksite Number field in the Minnesota group box, enter the 5-digit worksite number assigned by the state.  Enter the worksite location at quarter-end for employees working multiple worksites during the quarter.

California

In the California group box, select the Wage Plan Code that applies to the employee's unemployment insurance and disability insurance coverage. The application uses this value when creating the CA State Employee Wage List SDI Flag record in the CTS Quarterly file. The following system defined options are available in this drop-down list:

• UI and DI Covered Under State

• UI Covered Under State and DI Covered Under Voluntary Plan

• DI Covered Under State & Exempt from UI

• Covered Under Voluntary Plan for DI Only

• Religious Exemption from DI & UI Covered Under State

• Covered Under State Plan for UI (Public Entity Employees Only)

• Covered for Personal Income Tax Only

• None

Virgin Islands

In the Virgin Islands group box, select the U.S. Citizenship status applicable to the employee.  The value selected is used to report the U.S. citizenship status of the employee when reporting Virgin Island SUTA information to CTS.

Local Taxes

Use the Local Taxes screen (located in the Payroll Tax Controls menu in Costpoint Payroll) to enter general information relating to each of the localities for which the employer withholds income taxes. Included is the locality withholding General Ledger account, as well as information relating to the method by which locality taxes are withheld. Also included is the tax rate to be used for Income Tax Withholding for Supplemental (Bonus) wages. Set up this screen when initializing the system, and modify it any time the locality tax information changes.

In this screen, enter, or use Lookup to select, the State to which local tax codes should be linked and for which they will be reported. This is a required field when using the CTS Tax Interface.  

In the CTS Info group box, the Local Code is assigned by CTS to all local tax jurisdictions. In order to report the correct information to CTS, you must link the CTS Local Code to the Costpoint Locality Code.  For a list of CTS Local Codes that you can provide in this field, please contact your CTS representative. If you enter a CTS Local Code, you must select a value from the Tax Type Code drop-down box.

If the Local Code represents a state supplemental tax, enter, or use Lookup to select, the Supplemental Code in the CTS Info group box. The system will use this code to link the Locality Code's information when you create the CTS quarterly or periodic file. You cannot link a Locality Code to both a CTS Local Code and a CTS Supplemental Code; you can populate only one of the fields.

Below is a list of the system-defined supplemental codes available in Costpoint:

If you populated the CTS Local Code field, select a value from the Tax Type Code drop-down list to specify the type of local tax being reported in the RS record of the CTS W-2 file. You can select one of the following values from this drop-down box:

• City Income Tax - Select this option if the local tax is classified as a city income tax. This value is stored as "C" in the CTS W-2 file.

• County Income Tax - Select this option if the local tax is classified as a county income tax. This value is stored as "D" in the CTS W-2 file.

• School District Income Tax - Select this option if the local tax is classified as a school district income tax. This value is stored as "E" in the CTS W-2 file.

• Other Income Tax - Select this option if the local tax is an income tax that cannot be classified as the other three options. This value is stored as "F" in the CTS W-2 file. If the State is "NJ" (New Jersey), you must specify the type of New Jersey Disability Insurance that applies to the Locality Code in the NJ Disability Insurance group box

• State Plan - Select this option if the Locality Code represents a New Jersey State disability plan.

• Private Plan - Select this option if the Locality Code represents a New Jersey private disability plan.

• None - Select this option if the Locality Code does not represent a New Jersey disability plan.

If the State is "NY" (New York), you must select either the "New York City," "Yonkers," or "Not Applicable" radio button in the New York W-2 Reporting group box. The option you select will be used in the Create W-2 Table screen to calculate the amount of local taxes to be reported in Local wages, tips, etc. 

• New York City - Select this option if the locality code is for New York City residents for W-2 and New York State reporting purposes.

• Yonkers - Select this option if the locality code is for Yonkers residents for W-2 and New York State reporting purposes.

• Not Applicable - Select this option if the locality code is not used for Yonkers or New York City residents for W-2 and New York State reporting purposes. 

Depending on the State specified, you may need to enter a county or school code value in the County/School Code data field.

• If the State is "IN," you can use this field to specify the Indiana County Code.

• If the State is "OH," you can use this field to specify the Ohio School District Code.

• If the State is "PA" and the locality code represents a Mifflin County tax, enter "MIFFLIN" in this field.

• If the State is "PA" and the locality code represents an Erie County tax, enter "ERIE" in this field.

Deductions

Use the Deductions screen in Costpoint Payroll to establish company-wide deductions and/or contributions as mandated by your organization. Deduction codes are set up and used for deducting amounts from employees' paychecks, and/or for accruing employer contributions for employees.

If you use CTS for tax reporting, you can use the controls in the CTS Info group box in the main screen to link the Costpoint Deduction code to a CTS Supplemental Code or a CTS Local Code.

Enter, or use Lookup to select, the CTS Supplemental Code if the Deduction code represents a state supplemental tax. The system uses this code to link the Deduction code's information when the CTS quarterly or periodic file is created.

If the contribution represents the employer’s portion of a local tax, enter the four-digit CTS Local Code that corresponds to the local tax.  This field is enabled only if the Contribution check box is selected on this screen and you are licensed for the CTS interface.  The first two characters of the CTS Local Code must be alpha characters and must be equal to a U.S. State.  CTS Local Codes are supplied by CTS.  

If a CTS Local Code is supplied, select the Tax Type Code for the record from this drop-down list.  Valid options are: "City Income Tax," "County Income Tax," "School District Income Tax," "Other Income Tax," and "City Income Tax (Residence only)."  The system uses the value entered here to report the locality type when creating the CTS W-2 file.  This value is required if a CTS Local Code is specified.

•  City Income Tax - Select this option if the local tax is classified as a city income tax. This value is stored as "C" in the CTS W-2 file.

•  County Income Tax - Select this option if the local tax is classified as a county income tax. This value is stored as "D" in the CTS W-2 file.

•  School District Income Tax - Select this option if the local tax is classified as a school district income tax. This value is stored as "E" in the CTS W-2 file.

•  Other Income Tax - Select this option if the local tax is an income tax that cannot be classified as the other three options. This value is stored as "F" in the CTS W-2 file.