Just recently a Time Clock MTS user picked up an issue with the Payroll Summary Report that he believed was due to a calculation error by Time Clock MTS. Here’s the part of the report in question:
————————————————————————–
Payroll Summary Report … Printed Jan 26 2011 05:08:25 PM
Period: Jan 11 2011 to Jan 25 2011
————————————————————————–
Employee: Smith, Janice
————————————————————————–
Summary Information For: Smith, Janice
Total Work Time: 86.18 hrs
Total Holidays: 0.00 hrsSSN: 888-88-8888
Regular Hours: 79.63 hrs @ $16.13 /hr = $ 1284.43
Daily OT Hours: 5.23 hrs @ $24.20 /hr = $ 126.57
Total Earnings: $ 1453.58
————————————————————————–
On first glance it appears that Time Clock MTS has indeed made a calculation error with this employee. Notice that the Regular Hours and Daily OT hours do not add up to the Total Work Time figure and the Total Earnings Amount is more than the Regular and Daily Earnings Amounts. However, if we drill down a little we find that the Time Clock MTS user has configured his overtime settings to pay two tiers of overtime (OT and OT2) but there’s no sign of the OT2 hours or earnings in the report. Now we can examine the Payroll Information Report Section Template on the Report Settings screen and we see the following:
Summary Information For: <FULL_NAME>
Total Work Time: <T><TOTAL_WORK_TIME> hrs
Total Holidays: <T><TOTAL_HOLIDAYS_TIME> hrsSSN: <SSN>
Regular Hours: <T><REGULAR_HOURS> hrs @ <NORMAL_RATE> /hr = <NORMAL_EARNINGS>
Daily OT Hours: <T><DAILY_OT_HOURS> hrs @ <OT_RATE> /hr = <DAILY_OT_EARNINGS>Total Earnings: <T><T><T><TOTAL_EARNINGS>
It’s clear from this that this calculation error isn’t an error at all, it’s simply that the OT2 related fields are not being displayed in the report. So, we can make a few quick changes to the report section template and we get the following:
Summary Information For: <FULL_NAME>
Total Work Time: <T><TOTAL_WORK_TIME> hrs
Total Holidays: <T><TOTAL_HOLIDAYS_TIME> hrsSSN: <SSN>
Regular Hours: <T><REGULAR_HOURS> hrs @ <NORMAL_RATE> /hr = <NORMAL_EARNINGS>
Daily OT Hours: <T><DAILY_OT_HOURS> hrs @ <OT_RATE> /hr = <DAILY_OT_EARNINGS>
Daily OT2 Hours:<T><DAILY_OT2_HOURS> hrs @ <OT2_RATE> /hr = <DAILY_OT2_EARNINGS>
Total Earnings: <T><T><T><TOTAL_EARNINGS>
Now we can re-run the report and the payroll summary report for the employee looks a lot better:
————————————————————————–
Payroll Summary Report … Printed Jan 31 2011 02:38:02 PM
Period: Jan 11 2011 to Jan 25 2011
————————————————————————–
Employee: Smith, Janice
————————————————————————–
Summary Information For: Smith, Janice
Total Work Time: 86.18 hrs
Total Holidays: 0.00 hrsSSN: 888-88-8888
Regular Hours: 79.63 hrs @ $16.13 /hr = $ 1284.43
Daily OT Hours: 5.23 hrs @ $24.20 /hr = $ 126.57
Daily OT2 Hours: 1.32 hrs @ $32.26 /hr = $ 42.58
Total Earnings: $ 1453.58
————————————————————————–
Notice now that the total for hours and earnings now total up correctly!
