Absence Discount

Discussion for TimeTrex open source community developers.
Locked
Soujiro
Posts: 8
Joined: Fri Dec 30, 2011 8:05 am

Absence Discount

Post by Soujiro »

Im currently trying to adapt tiemtrex to the laws of my country, to do this i need to heavealy modify the way timetrex "discount" de absence time from the earning of a monthly salary employee. So i need to known which files/clases are involved in the process and the flow of the process. Thnaks for your advice.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Absence Discount

Post by shaunw »

Can you please explain in detail exactly what you are trying to achieve?
Soujiro
Posts: 8
Joined: Fri Dec 30, 2011 8:05 am

Re: Absence Discount

Post by Soujiro »

An example will explain better:

wage per month (salary)= 300.000
Days of Absence (injury) =3 days
wage per day (acording to law) =300.000/30 =10.000 (every month is 30 days for law pourposes)
Discount per absence= 3X10.000
Base Wage of month (base for taxes and discounts) = 300.000-30.000=270.000
Obligatory Health security discount (7% Base Wage) = 18900
Optional Health security discount= 5.523 (differs for every employee)
Net earning of month = 245577

So my problem is the "wage per day", because timetrex use the hourly rate to calculate the absecense discount.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Absence Discount

Post by shaunw »

Thats correct that TimeTrex deals with hours not days. But each day can consist of a specific number of hours (ie: 8) to get the same result.

When you enter the salary for each employee, make sure you enter the expected average hours per week that they should work and TimeTrex will calculate the hourly wage over a full year. If you create an absence policy that is of type "Dock", TimeTrex will automatically deduct that time from their pay exactly how you described.
Soujiro
Posts: 8
Joined: Fri Dec 30, 2011 8:05 am

Re: Absence Discount

Post by Soujiro »

not work, for example

Work time Monday to Thursday : 8:30AM to 6:00PM
Work time Friday 8:30AM to 5:00PM
Meal time 45 minutes
Wekley hours 42.75 (42:45)
Hours per day 8:33 (42:45/5)

And the amount of earns with one day of absent is 286,153.87 when it has to be 290,000
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Absence Discount

Post by shaunw »

So if they get paid on salary, and they must earn 290,000 for a full day off, you can set their hourly rate based on 290,000 and a set number of hours that you give them for a full day off.

Just for example:

290,000 / 8hrs = 36,250

If you make that the hourly rate, then always give them 8hrs for a full day off, it should work fine. The only question is if you give them partial days or if they need to get paid other amounts based on their absence time.

Because TimeTrex works in hours, it doesn't matter how many hours are considered a "full day", this is arbitrary, it could be 1hr or it could be 24hrs. The only thing that really matters is the end result.
Soujiro
Posts: 8
Joined: Fri Dec 30, 2011 8:05 am

Re: Absence Discount

Post by Soujiro »

ok i get it, only requiere a little more setup.
Locked