Payroll - Xls Download - Payroll Software

Hi Shiva,
Herewith I am attaching compensation & benefits Info.
this info I got from senior citehr member.
I hope this will be help u.
Prakash-----------

Hello,
PF Employee Contribution Calculation - 12% on Basic + DA + Food Allowance
ESI Employee Contribution Calculation - 1.75% on Gross Salary
PF Employer Contribution Calculation - 13.61% on Basic + DA + Food Allowance
ESI Employer Contribution Calculation - 4.75% on Gross Salary
Akanksha Kukhraniya

Dear friends
Just i want to know how the salary is calculated ,how much percentage is to be divided for BASIC,HRA,DA & another allowances.Payroll Processing is differ from one company to another company.Please give me the brief discussions.
Thanks & Regards
Paramagurunaath.SPS

could you please tell me that how to prepare payroll. Please do let me know what are all general benefits will come in the payroll.
regards
Ramesh

hi,
wat Sirisha.k says is curruct.
And regarding payroll.
depends on company they will take heads like Basic,HRA,TA,FBP,Allow,Bonuse,etc..
the % also same, few are takeing the basic is 35% or 40% or 45% on Gross.
so,we are not say exectly.
byee

Hi,
The percentage that is divided for the various components varies from one company to another.
In my company we have the following components.
Basic, HRA, CA and CCA
Where basic is 55%
HRA(house rent allowance) is 20%
CCA (City compensatory allowance) is 15%
CA(Conveyance allownace) is 10%
All the above components are calculated on gross.
Where Gross is ctc-employer contribution of pf and ESI(if applicable)

Calculations for PF and ESI
PF to be calculated on Basic
Employer and employer 12%
for basic above 6.5k pf is constantly 780
ESI to be calculated on Gross
Employer 1.75%
Employee 4.75%
EsI applicable only upto net 10k
Net pay is gross - pf-esi-pt
The Professional tax (PT) has the following slab.
Rs.3000/- to 4999/-** --- Rs.30/-
************* 5000/-*to 7999/-** --- Rs.60/-
************* 8000/- to 9999/-** --- Rs.100/-
*********** 10000/- to 14999/-* --- Rs.150/-

Above Rs.15000/- it is Rs.200/
Hope it clarifies.
Regards,
Jayashri

ESI Employee Contribution Calculation - 1.75% on Gross Salary (always roundup) Ex: if contribution amount is Rs.50.20 then you have take it as Rs.51.00
ESI Employer Contribution Calculation - 4.75% on Gross Salary (even employer contribution is also round up)
PF employee- 12% of Basic+DA
PF employer- 12% Basic+DA (out of which 8.33% is towards Pension and 3.67% to PF)

[QUOTE=sharmaneesu;378907]Hi rakesh you are absloutly right. pf is contributed 12% from employee side on basic salary, 12% from the employer side.
ESI is 1.75% from employee side, 4.75% from employer side on gross salary.
ashok

:confused:hi,
you said ESI contributed on gross,so pls can you specify that gross includes the basic salary+incentives or wht it includes.iam little bit confused!! plz do let me know more abt Esi.
And one thng more abt competancy mapping how it measures as it is my project topic.so plz guide me regarding it.

Dear all,
I am attaching the simple salary process in Excel learn it. It will be very useful.
Every one should know how to work in Excel and process of Salary.
It include all the details like PF ESI etc.
I thing that have provided the valuble resource to you all.
Kindly view the attachment.
Warm Regards,
vinoth.R