Salary Increment Calculation In Excel

Hi,Any loss of pay includes all benefits arising out of pay such as increments and seniority, unless specified otherwise. Hence, the increments get postponed accordingly, and no arrears can be paid for the period of LOP.Yogesh

Mr. Ragunathan,You have to consider the attendance of the respective months. For example, if you paid the December 09 salary for 24 days, this increment is applicable for 24 days only and not for 31 days. Is it clear now?Thank you.

Dear Mr. Avika Kapoor,I am working as an HR Assistant, and I would like to request details regarding the following:Our company has decided to provide an 8% increment on gross salary effective from OCT-2009 to MAR-2010\. We adjusted the salaries accordingly start...

Hi All,Arrears calculation will not stop at Gross. We need to calculate PF, ESI, Superannuation based on Salary Increment, and the payments have to be made accordingly.Regards,PK

Hi,It's simple.On a worksheet in Excel, the eligible amount as per the increased salary should be calculated, called as eligible pay. The first column is for the month, the second column for the basic, the third column for DA, and subsequently one column each fo...

Good question and quite well answered! Upgrade yourself or be left behind! I am amazed to see how you people have reached such an important position in HR.

Yes, as said by Kalapoorna, but first, how to arrive at the arrears amount. Once they are calculated, the other usual things are to be adjusted.

Hi,Please find this one. If this is your solution and in case of any confusion, please reply.Thank you.