City employers in the State of California need to submit an annual GCC report. The report includes the pay and benefit information for

• every compensated employee who received a W-2,

• every elected official who received pay reported on IRS Form 1099, 

• all uncompensated elected officials and/or board members,

• quarterly contribution return and report of wages (DE 9) reporting, and 

• GCC provides an Excel template for filling in the annual reporting data. You can set up the State Combined Wage List to create an Excel file that supports the GCC Excel template.   

Government Compensation in California report column is included in the 2023.05 release. The new report column records the defined benefit pension formula for Government Compensation in California reporting. The new master report prints a detail report and creates the electronic file for the annual GCC report. 

Additional resources

• For more information, see the Government Compensation in California website at publicpay.ca.gov/Reporting/

• To submit the electronic file to the State Controller's Office Data Exchange Portal (DEP) reporting website. 

Before you get started

Set up the applicable defined benefit pension formula for each employee. The formula should include a percentage representation and an age. For example, 2% @ 55 where 2% is the percentage representation and 55 is the employee age. If the position does not have a defined benefit pension formula, leave this field blank. The GCC report will use this field to calculate an amount for the employee's defined benefit pension. 

Job tab > Additional State Reports tab, Applicable defined benefit pension formula

Do this... 

1. Open Connect Payroll > Employees > Modify Existing Employees. 

2. Click to select the Job tab. 

3. Click to select the Additional State Reports tab. 

4. Use the Applicable Defined Benefit Pension Formula box to enter a percentage representation and an age. 

For example, 2% @ 55 where 2% is the percentage representation and 55 is the employee age.

Set up the applicable defined benefit pension formula for

• every compensated employee who received a W-2,

• every elected official who received pay reported on IRS Form 1099, and

• all uncompensated elected officials and/or board members.

• GCC provides an Excel template for filling in the annual reporting data. You can set up the State Combined Wage List to create an Excel file that supports the GCC Excel template.   

If the position does not have a defined benefit pension formula, leave this field blank. 

5. Click Save (CTRL+S). 

Setting up GCC report options

Set up the report and state options for the GCC report. 

Report options

Report dates

Verify the report date range is set up to select the reporting year. 

Print detail report

Select this checkbox to print the detail report. 

Print detail report

Print form

The GCC report is submitted to the GCC website. Do not select this checkbox.  

Print form

Create electronic file

Select this checkbox. Enter the path and electronic file name. Example: GCCYYYY.xlxs

And then select State Combed Wage List (CA) GCC [Caselle Master] as the Format. 

Create electronic file

State options

The options for the State of California are included on the State Options tab. 

Report type

Select GCC Report. 

Report type

DE9 report options

Skip these fields. You do not need to fill in the DE9 report options to create the GCC report. 

DE9 report options

GCC report options

You will need to fill in the GCC report options. 

GCC report options

Lump sum pay pay codes

Select the pay codes that make up the lump sum pay. The lump sum pay includes one-time cash outs, such as paid excess vacation/sick leave. 

Lump sum pay pay codes

Other pay pay codes

Select the pay codes that make up the other pay. Other pay includes but is not limited to car allowances, meeting stipends, incentive pay, bonus pay, retention pay, hazard pay, bilingual pay, and on-call pay. 

Other pay pay codes

Employees' share paid by employer paid codes

Select the pay codes that make up the amount paid by the employer, on behalf of the employee, toward the employee's share of the retirement costs. 

Defined benefit plan employer's share pay codes

Select the pay codes that make up the defined benefit plan amount paid by the employer.

 Deferred compensation plan pay codes

Select the pay codes that make up the deferred compensation/defined contribution plan amount paid by the employer. 

 Health, dental, vision pay codes

Select the pay codes that make up the amount paid by the employer for health, dental, and vision. 

Creating the GCC electronic report

1. Open Connect Payroll > Reports > State Combined Wage List. 

2. Use the Title menu to select State Combined Wage List (CA) - GCC [Caselle Master]. 

3. Verify the reporting period is correct. 

4. Enter the file name. 

Remember to include the path. Example: GCCYYYY.xlxs

5. Set up the state options for the GCC report. 

Lump sum pay pay code

Other pay pay codes

Employees' share paid by employer pay codes

Defined benefit plan employer's share pay codes

Deferred compensation plan pay codes

Health, dental, vision pay codes

6. Click Print (CTRL+P).  

7. Verify the electronic file name. 

The recommended file name and the current file name will be displayed in the Verify File Name window.

Verify File Name window

To use the recommended file name, click  and then click OK.

Verify File Name window

Use the detail report to verify the information that is included in the electronic file is correct. You should check the values in each column on the report. If everything looks good, you're ready to submit the electronic file to the State Controller's Office Data Exchange Portal (DEP) reporting website. 

Copyright © 2025 Caselle, Incorporated. All rights reserved.