Salaried Employee Time Card Report
I’ve written about this a few times before but it’s worth mentioning again. From time to time I get an email from a user of our employee time attendance software who has noticed that the total time for punches on a report do not add up to the work time in the summary section of the report. Above you can see just such a report. It’s an employee punchcard report. You can see that the time punches on the report tally up to 86.27 hours but the total work time reported is 80.08 hours. What’s the reason for the discrepancy?
Well it turns out that this employee is set to be paid a salary rather than paid hourly (this is configured on the employee payroll information screen). What’s more they are setup for monthly salary. Thus, when Time Clock MTS generated this report it calculated how much of a month the report period was (about 46.2% it turns out). It took this fraction and multiplied it by the standard hours worked per month (173.3 hours per month) and arrived at the figure reported of 80.08 hours as opposed to the time the punches added up to.
If you do have salaried employees and you do want to report on their actual hours worked (as opposed to their calculated pro-rata hours as shown above) then there’s a report section template field you can include in the payroll information and employee summary report templates. The <ACTUAL_SALARY_WORK_TIME> field will show the actual time recorded by a salaried employee during a report period. Report section templates and fields can be configured on the Time Clock Report Settings screen.
