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.
Use the options in this group box to select the sort options for printing the report.
Select this radio button to sort by the employee name that was set up in the Basic Employee Info screen in Costpoint Employee.
Select this radio button to sort by employee ID.
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.
Select this checkbox to include payroll records that have not been posted to the General Ledger.
Select this checkbox to include payroll records that have been posted to the General Ledger.
Use this group box to select the pay cycle and range of projects for the certified payroll report.
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.
Enter the start date of the pay cycle.
Enter the end date of the pay cycle.
Use the fields in this group box to select the range of projects for this report.
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."
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.
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.
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 |