Great Work.Can we please make allowance for the variation of the rate payable to an employee in case of time sheet based payroll.Take for an example a staff of a company X works at various project sites of company project A ,B and C.In a particular month he worked for 14 days in a site A at the rate of $80 per day,he worked for 8 days in site B at the rate of $100 per day and spent the remaining 4 days in site C at the rate of $135 per day.I know you can add more than one time sheet but i am not sure whether different rate is possible.If is not possible,we would request such feature should be added

Secondly,we would also request that it should be made possible that formula can be written on the output of salary calculation to determine one of the salary component.Take for example a staff that has the following salary component: Basic $2,000,HRA $800,Transport $700 .Gross Pay is therefore $3,500.To get his net pay the only deduction which is Personal Income Tax must be calculated.Information needed to calculate his personal income tax are as follow:

$1,200 + 10%of his gross income is declared as not taxable while the remaining balance of his gross income (in this case it is $1,950 i.e $3,500-($1,200+0.1*$3,500)) is subjected to prorated tax as follows:

First $500 at the tax rate of 7% which equal $35

second $500 at the rate of 10% which equal $50

First $1,000 at the rate of 20% which equal $190 (i.e 0.2*$950 )since balance is not up to $1,000 you take the balance.

In this case the Personal Income Tax payable by the staff is $275 (i.e 35+50+190).

The Net Pay of the staff is Gross ($3,500) minus Personal Income Tax ($275) which equal $3,225.

The question is this can we write a formula to calculate this $275:The Personal Income Tax in this New Improved Salary Structure?

Earnestly waiting for positive reply

Thanks

Fred