Page 1 of 1

Annual Hourly Rate and Timesheet

Posted: Sun Jun 24, 2007 6:37 am
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

Posted: Sun Jun 24, 2007 9:53 am
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.

Posted: Sun Jun 24, 2007 6:59 pm
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 ??

Posted: Mon Jun 25, 2007 9:42 am
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.

Posted: Thu Dec 13, 2007 7:00 am
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?

Posted: Thu Dec 13, 2007 9:58 am
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.