Issue/Symptom/Question

Is there a report in PENTA that will break overtime earnings into separate figures?

Applies To

PENTA Workbench → PR: Labor Hours panel  → Labor Hours link

PENTA for Windows → Reports → Payroll → Worker Comp Wage Audit

Resolution/Fix/Answer

A PENTA Workbench report found under the PR: Labor Hours panel will generate reports that can separate labor with specific columns like Regular/Premium 1/Premium 2/Total hours.

To add the Regular Earnings:

1. Add the panel in Workbench "PR: Labor Hours"
   
2. Set your parameters as needed
3. Select Labor Hours link in the bottom section to initiate Labor Hours Report
   
4. Select the Formula tool
5. Enter a description for the Regular Earnings amount
6. Select Regular Hours from the "Insert a column" field
7. Select insert
8. Enter the * symbol 
9. Select Regular Rate from the "Insert a column" field
10. Select Insert
11. Choose Data Type: Number
12. Choose Display Format: $#,##0.00
13. Select Add

The formula for Regular Gross Pay should look like this:

[Regular Hours]*[Regular Rate]

To add the OT earnings:

1. Enter a description for the OT Earnings column
2. Select Premium 1 Hours from the "Insert a column" field
3. Select insert
4. Enter the * symbol 
5. Select Premium 1 Rate from the "Insert a column" field
6. Select Insert
7. Select Premium 2 Hours from the "Insert a column" field
8. Select insert
9. Enter the * symbol 
10. Select Premium 2 Rate from the "Insert a column" field
11. The formula should look like: ([Premium 1 Hours][Premium 1 Rate])+([Premium 2 Hours][Premium 2 Rate])
12. Choose Data Type: Number
13. Choose Display Format: $#,##0.00
14. Select Add

The report should now display two new columns comparing Regular Earnings versus OT earnings. 

There is also the Worker Comp Wage Audit crystal report. This report displays earning included and earnings excluded from the worker compensation calculation: 

PENTA for Windows → Reports → Payroll → Worker Comp Wage Audit