About Payroll Reports

The table below lists the available reports in the Payroll > Reports menu.

The most recent report selections are retained on the screen until you 1) close the report parameter screen, which will reset all parameter selections, or 2) change the selections. NOTE: Clicking the Selected or Range radio buttons will reset the selection(s).

Report Name

Report Description

125 Plan Reporting

Shows the current balances for 125 Medical and Dependent Care Plans.

Average Hours Worked

Shows the total and average hours worked for a selected time period.

Check History Details

Shows all the wages, deductions, ECBs, and net pay for each selected employee for the time period selected.

Check History Wages and Deductions

Summarizes wages and shows details of deductions that affect taxes, total other deductions, and net.

Check Register

Shows all the selected checks in Payroll.

Current Labor Distribution Report

Shows either employee detail or a summary of the distribution of wages to various General Ledger account numbers. This report is for the current payroll cycle and must be printed before checks are posted.

Deductions

Shows either totals for each deduction for the time periods selected, or a list of each employee with the selected deductions.

Deductions and ECBs

Shows either totals for each deduction with its matching ECB for the time periods selected, or a list of each employee with the selected deductions.

Department Turnaround

Shows the number of employees in a department at two different periods.

ECBs

Shows either totals for each ECB for the time periods selected, or a list of each employee with the selected ECBs.

ECB Expense by Department Worked

Proportions the total amount of each ECB by the total wages for each department.

EEOC Summary Report

Shows a breakdown of current employees by sex and race.

Employee Audit Report

Shows any changes made to the Employee Information screens.

Employee Benefit Sheets

Lists the contributions and benefits paid out for an employee.

Employee Information

Thirteen different reports of Employee Information.

Employee Labels

Three types of employee labels can be printed: Time Card labels, Mail labels, or Bar Code labels.

Employee Position

Lists employee position information.

Employee Wages and Deductions

Summarizes wages and shows details of deductions that affect taxes, total other deductions, and net. Only one total line is printed for each selected employee.

Employee Work Status and Position

Lists employees by work status. Work status is a user defined table.

Hour Banks

Displays the current balance for the various Hour Banks that have been set up.

Hour Banks Audit

Displays employee hour bank balances at the transactional level. Report totals are displayed per employee, location, and department for each hour bank. Adjustment transactions may be reported in summary and/or detailed format. The Current Column option allows the report to be generated for the current payroll only.

NOTE: Maximum accumulation limit adjustments always appear in their own column and are never summarized. The "Earned Hours" value is the number of hours credited to the employee after any maximum accumulation limit adjustments have been applied.

Hours and Wages Reports > Check History Hours & Wages

Lists each check for the selected period. Regular, overtime, and other hours and wages are shown for each.

Hours and Wages Reports > Department Hours & Wages

Compares up to four periods of department hours and wages in either detail or summary.

Hours and Wages Reports > Employee Hours & Wages

Shows a comparison of select hours and wages for employees for up to four time periods.

Hours and Wages Reports > Employee Department Detail

Shows the hours and wages for each department that an employee works in.

Hours and Wages Reports > Employee Department Distribution

Separates employees' hours and wages by department. Each location/department is printed on separate pages with employee details.

Hours and Wages Reports > Employee Position Detail

Looks at the hours and wages from a position view.

Hours and Wages Reports > Hours and Wages by Position Code within Department

Shows hours and wages by department, position, and wage code.

Hours and Wages Reports > Position Summary

Compares position hours, FTEs, and wages for up to four time periods.

Hours and Wages Reports > Wage Code Summary

Compares hours, FTEs, and wages for each Wage Code for up to four time periods.

Overtime Eligibility

Shows the employees' eligibility for overtime pay. Report criteria includes: Employees (Selected or All), Method Paid (Hourly, Salary, Commission, Per Piece, or All), and Status (Active, Terminated, LOA, or All), and Report Order (Employee Number or Employee Name).

Overtime Regular Rate Criteria

Displays each wage code's inclusion or omission of hours and dollars to the overtime calculation. Inactive wage codes can be included in the report.

Payroll Journal

Lists any journal entry that is created in the Payroll module. Most of these entries come from Post Checks and Accruals. There can also be journal entries at the end of the period for hour bank accruals. Journal Entries can also be printed in General Ledger.

Pension Contribution

Lists the contributions that employees and employers have contributed to a pension plan for the time period entered.

The Other Deductions field is used to include deductions that are set up in the "Z-Other" category. Select None or Selected. The Selected option displays a screen for you to select the deductions you want to include in report. The "Other" deductions are reflected in the report under the Deferred Deduction column with the 8, 9, and C unit deductions.

Pension Eligibility

Lists the employees who meet the requirements for some pension plans.

Quarterly Federal Wages

Lists an employee's federal wages for each quarter with a total for the year.

Remaining Deduction Report

Shows deductions that are paid over time to a lifetime limit.

Standard Salary Level Analysis

Lists salaried employee wages relative to the Department of Labor minimum wage limit. Use this report to verify the overtime exempt status of employees. This report can be generated in detail or summary format for a specified range of check dates, pay frequency, and all or selected employees. Employees with wages < SSL are highlighted yellow in the report.

State Retirement Report

The State Retirement Report window allows you to generate a report showing which employees receive PERA and/or other state retirement deductions. The amounts deducted from each employee's paycheck and the total amount deducted for each type of state retirement code are included on the report. See State Retirement Report for more information.

Taxable Wages

Lists the taxable amounts for each check in each quarter that is selected.

Workers Compensation Report

Displays Workers Compensation information for reporting to a regulatory agency.