In part 1 of configuring Time Clock MTS to comply with Californian Overtime Regulations I covered how to setup the software to calculate this sort of overtime automatically. In this second part I’ll cover how it is displayed in reports.
Report Template Changes to Show Overtime Rate 2
Modifying Report Templates
If you have only just started using Time Clock MTS then you will not need to modify your reports to display overtime rate 2 as the software will have set it up by default. You can therefore ignore this part of this article. However, if you are an existing user of Time Clock MTS upgrading an old version of the software to a newer version that supports the Californian Overtime Regulations then you will need to modify the Payroll Information report section template. In the image above you can see the relevant section that I have added to the report section template. I have added this immediately under the line that was already there that displayed the overtime rate 1 information. The line I have added is:
Daily OT2 Hours: <T><DAILY_OT2_HOURS> hrs @ <OT2_RATE> /hr = <DAILY_OT2_EARNINGS>
Basically this displays the heading ‘Daily OT2 Hours:’ along with the actual hours worked at overtime rate 2, the rate of pay for overtime rate 2 (which should be set to double time) and the earnings at overtime rate 2. If you don’t understand what the report section templates are then you should take a look at my posts on customizing Time Clock MTS reports in part 1, part 2, and part 3.
Overtime Rate 2 Report Date in Payroll Summary Section
Viewing Overtime 2 Payment Amounts in Reports
If you choose to display the payroll summary section in a report (or run the payroll summary report) then you will be shown the new overtime rate 2 payment information as per the image above. You can see in this example that the employee is entitled to 1 hour of overtime at overtime rate 2 which is set to double the normal rate.
So, that’s all there is to it. It is very simple to configure Time Clock MTS to comply with the Californian overtime regulations. Doing so will give you significant productivity improvements come payroll calculation time, and will help to you do reduce and eliminate payroll errors. As always please email me if you have any questions.
