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.

Screen	Instructions
Manage Detail Job Titles	Establish job titles at the detail level within your organization. Enter the appropriate information on 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 check box. The settings in this screen affect the data that you enter in the Manage Employee Salary Information screen. If a detail job title is a corporate officer position, the Corporate Officer check box is automatically selected when the Detail Job Title is assigned to employee records in the Manage Employee Salary Information screen. Selecting this check box in the Manage Detail Job Titles screen does not update existing Salary Info and History records.
Manage Workers' Compensation Codes	Set up codes and related descriptions for workers' compensation tracking. You must establish workers' compensation codes before you can complete the Configure Labor Settings screen. For each line in the Manage Workers' Compensation 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. Costpoint 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. Costpoint 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.
Manage Employee Salary Information	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 check box to indicate that the employee is seasonal and therefore is included in the state's Employee Seasonal Indicator record of the CTS quarterly tax file. Select the Corporate Officer check box to indicate that the employee is a corporate officer of the company and therefore is included in the state's quarterly unemployment reporting. If a Detail Job Title's Corporate Officer check box is selected in the Manage Detail Job Titles screen, the Corporate Officer check box is automatically selected when that Detail Job Title is assigned in the Manage Employee Salary Information screen.
Taxes subtask of the Manage Employee Information screen	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 Information tab. Use the Tax Reporting Information tab to enter quarterly tax information that is reported to any of these three states by Ceridian Tax Services (CTS).  Wyoming: In the Wyoming group box, select a Class Code, Corporate Officer ID, if applicable, and Coverage Type that applies to the employee. Costpoint uses this information when creating the Wyoming Employee Wage List Special Reporting record in the CTS Quarterly file. Alaska: In the Alaska group box, 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. Then, 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 five-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. 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.
Manage Local Taxes	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. State: Enter, or click to select, the state to which local tax codes must be linked and for which they are reported. This is a required field when using the CTS Tax Interface. Local Code: In the CTS Information 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 drop-down list. Supplemental Code: If the Local Code represents a state supplemental tax, enter, or click  to select, the Supplemental Code in the CTS Information group box. Costpoint uses 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. Tax Type: If you populated the CTS Local Code field, select a value from the Tax Type drop-down list to specify the type of local tax being reported in the RS record of the CTS W-2 file. Disability Insurance Type: 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 Disability Insurance Type field. New York W-2 Reporting: If the State is NY (New York), you must select either the New York City, Yonkers, or Not Applicable option in the New York W-2 Reporting drop-down list. The option you select is used by the Create W-2 Table screen to calculate the amount of local taxes to be reported in Local wages, tips, etc. Depending on the State specified, you may need to enter a county or school code value in the County/School/Political Subdivision Code 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.
Manage Deductions	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 to link the Costpoint Deduction code to a CTS supplemental code or a CTS local code. Supplemental Code: Enter, or click to select, the CTS supplemental code if the Deduction Code represents a state supplemental tax. Costpoint uses this code to link the Deduction code's information when the CTS quarterly or periodic file is created. Local Code: 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 represent a U.S. State. CTS local codes are supplied by CTS. Tax Type Code: If a CTS Local Code is supplied, select the tax type code for the record from this drop-down list. Costpoint 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.