PRINT CERTIFIED PAYROLL RPT

Use this screen to print timesheet and payroll information that can be used to satisfy the certified payroll requirement. In order to be able to provide a Certified Payroll report, you must enter daily timesheets and use a weekly timesheet and payroll cycle. The report information is obtained from the Payroll Edit table, for records with paycheck numbers and dates only, and/or from the Employee Earnings table.

Print this report after entering and processing the weekly timesheet data to payroll or after posting the payroll to the Employee Earnings table for the pay period that you want to report.

Multi-state functionality has been added to a number of applications. This functionality allows the proper calculation of withholdings for employee who work in multiple states during a single pay period. Because new tables are needed for multi-state calculation, this application now looks at two new tables, EMPL_PR_STATE and EMPL_EARN_STATE.

Sort

Use the options in this group box to select the sort options for printing the report.

Employee Name 

Select this radio button to sort by the employee name that was set up in the Basic Employee Info screen in Costpoint Employee.

Employee ID 

Select this radio button to sort by employee ID.

Reporting Source

Use the options in this group box to select the source of the paychecks that you want to include in the certified payroll report. You must select one or both of the checkboxes.

Payroll Table

Select this checkbox to include payroll records that have not been posted to the General Ledger.

Earnings Table

Select this checkbox to include payroll records that have been posted to the General Ledger.

Select

Use this group box to select the pay cycle and range of projects for the certified payroll report.

Pay Cycle

Pay Cycle

Enter, or use Lookup to select, the pay cycle that you want to use for the certified payroll report (only one pay cycle can be created at a time). If you have a default pay cycle selected in the Payroll Settings screen, that pay cycle will display in this field. This is a required field.

Start Date

Enter the start date of the pay cycle.

End Date

Enter the end date of the pay cycle.

Project

Use the fields in this group box to select the range of projects for this report.

Range Option

Use this drop-down box to select the range of projects you want to include in this report. Options are "All," "One," "Range," "From Beginning," and "To End."

From

Enter, or use Lookup to select, the project with which you want to start. If you selected "All" or "From Beginning" in the Range Option field, this field will be inactive.

To

Enter, or use Lookup to select, the project with which you want to end. If you selected "All," "One," or "To End" in the Range Option field, this field will be inactive.

Report Sources

Column Heading

Screen

Table Name

Project

Maintain Project Master

PROJ

Contract

Maintain Project Master

PROJ

Customer

Maintain Project Master

PROJ

 

Maintain Customer

CUST_ADDR

Employee

Basic Employee Info

EMPL

Job Category

Enter Timesheets

TS_LN

Work Classification

General Labor Categories

GEN_LAB_CAT

(O/T, REG, Total)

Enter Timesheets

 

LD_TS_LN

Rate of Pay

Enter Timesheets

LD_TS_LN

Fringe Rate

Enter Timesheets

LD_TS_LN

Gross Amount Earned

Maintain Payroll Edit Table

PR_EMPL_PAYROLL

 

Maintain Employee Earnings

PR_EMPL_EARNINGS

FICA W/H

Maintain Payroll Edit Table

PR_EMPL_PAYROLL

 

Maintain Employee Earnings

PR_EMPL_EARNINGS

W/H Tax

Maintain Payroll Edit Table

PR_EMPL_PAYROLL

 

Maintain Employee Earnings

PR_EMPL_EARNINGS

Deduction (1, 2, Others)

Maintain Payroll Edit Table

PR_EMPL_PAYROLL

 

Maintain Employee Earnings

PR_EMPL_EARNINGS

Net Wages

Maintain Payroll Edit Table

PR_EMPL_PAYROLL

 

Maintain Employee Earnings

PR_EMPL_EARNINGS