Annual Hourly Rate and Timesheet

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Post Reply
dawnyee
Posts: 9
Joined: Wed Jun 20, 2007 9:25 pm

Annual Hourly Rate and Timesheet

Post by dawnyee »

1. in the Employee administration, i set monthly salary $21000, in 40 average time/week, i calculate that it is 131.25, but the system generates 120.69?? how to calculate the annual hourly rate?

2. In My Timesheet, when i click total time for the particular day with punches, there is nothing shown on the popup screen, and the employee combo box is blank. This did not occur in 1.1.6 version.

thx for your kind assistance
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

1. in the Employee administration, i set monthly salary $21000, in 40 average time/week, i calculate that it is 131.25, but the system generates 120.69?? how to calculate the annual hourly rate?
TimeTrex bases its calculation off the number of week days in the year. Since there is never exactly 52 weeks in a year.
2. In My Timesheet, when i click total time for the particular day with punches, there is nothing shown on the popup screen, and the employee combo box is blank. This did not occur in 1.1.6 version.
Can you please check your PHP error log for any errors, and try enabling debug mode to see if any messages appear.
dawnyee
Posts: 9
Joined: Wed Jun 20, 2007 9:25 pm

Post by dawnyee »

Understood, i.e. in year 2007 there are totally 52weeks and 1 day:

i.e. 52*40 hours per week + 8 hours per day = 2088 hours
For monthly salary: 21000, it will be (21000 * 12) / 2088 => 120.69 hourly rate.

But in our real case, the calculation is based on monthly salary 21000, if it turns back to hourly rate first, there would be a different values on every month. Thus, can you give me a hint on which area I should modify in order to make it happen ??
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

TimeTrex converts all its salary wages to an annual wage prior to doing any other calculations, including the hourly rate. So it should not change each month.

On top of that when paying a salaried employee it only uses the hourly rate when calculating overtime/undertime. If none of those exist the employee will always get paid the same amount.
vmp
Posts: 99
Joined: Wed Jun 20, 2007 3:41 am

Post by vmp »

We need help to understand the calculation for Hourly Rate for employees.

eg. I have an employee with a monthly salary of 200.30
The overtime hourly rate is set at 1.00 and we get a result of 1.16
We'd be obliged if you would please elaborate on the calculation?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

For salaried employees TimeTrex uses the average time per week value to calculate the hourly rate. For example:

$1000/month salary @ 40hours/week = $1000 / (40*4) = $6.25/hour

Its more exact then that, but thats the rough idea.
Post Reply