Government Compensation Report

The Government Compensation Report provides the data requested by the California State Controller's Office for disclosing wage and benefit information. You'll generate the report in AptaFund and then copy the data into the template provided by the state.

Before you begin

You must complete the following tasks before generating the report.

• Designate primary jobs by checking the Primary box in HR > Employee Jobs > Edit Employee Job.  You can use the Mass Update Jobs feature to speed this process.

• Configure the Lump Sum Jobs parameter in Payroll Configuration on the General tab. Search "lump sum" on the General tab, then click the Lump Sum Jobs link. Select from the list of master positions that should be reported in the Lump Sum Pay column of the report. Edit Configuration Value popup

Report process

1. Download the current LGCompensation File report template from the website: http://www.sco.ca.gov/ard_locinstr_gcc_reporting.html
   Sample template

2. Generate the report in as an Excel file in AptaFund. It is accessed from My AptaFund > Reports > Payroll - California Reports.
   Sample report

3. Edit the Excel file.

• Remove the columns above the row containing the Display Name header, and sort the report by Display Name.

• Complete the Multiple Positions Footnote column since this data isn't available in AptaFund.

4. Copy the data from the Excel file, and paste it into the template. Note: Don't copy the Employee Name column into the template; it's only there for your reference.

5. Complete the applicable fields in the template header.

6. Submit the report to the State Controller's Office.

Fields in Excel file

• Employee Name: This is only a reference column for the user Not used in the template file. Do not copy this column into the template.

• Department: This is the employee’s Department column (from Employee Management)

• Classification: This is the employee’s Job Name (from Employee Management)

• Multiple Positions Footnote: This column is intentionally blank (to be filled in by User)

• Annual Salary Minimum: Minimum salary on the Salary Schedule for this job (if applicable) If there is no Salary Schedule, this will be $0.00

• Annual Salary Maximum: Maximum salary on the Salary Schedule for this job (if applicable) If there is no Salary Schedule, this will be $0.00

• Total Regular Pay: Total of all jobs marked Primary = “Yes” (from Employee Management) Minus any deductions marked as Pre-Social Security in Deduction Management)

• Overtime Pay: Any pay marked as overtime in any payroll register in that year

• Lump Sum Pay: Pay from any job in the “Lump Sum Jobs” parameter in Payroll Configuration Minus any deductions marked as Pre-Social Security in Deduction Management)

• Other Pay: Amounts from any other job not marked Primary or “Lump Sum Jobs” Minus any deductions marked as Pre-Social Security in Deduction Management)

• Applicable Defined Benefit Pension Formula: This is N/A in all cases

• Retirement Plan – Employees’ Share Paid By Employer: This is $0.00 in all cases

• Defined Benefit Plan – Employer’s Share: The sum of Employer’s side for STRS/PERS

• Deferred Compensation/Defined Contribution Plan: Sum of contributions to any deduction marked for the following boxes in Deduction Management

• Box 11 (457(b) deductions)

• Box 12AA (401(k) deductions)

• Box 12BB (403(b) deductions)

• Health, Dental, Vision: Sum of Employer side contributions to any deduction marked for Box 12DD in Deduction Management

Return to California Reports Overview