Hr & Compliance
Sr. Hr Executive
Kazi Sahir Jaman
13th May 2011 From India, Chandigarh
Basic Means it is decided by state govt. for workers and DA means dearness allowence. so toal basic means ( Basic+ DA)
gross menas his total monthly salary ( how many salary is made for per month) where part of salary is Basic, HRA, Conveyance, Education All. Special Allowence
Net menas after deduction of PF, Esic ( If Applicable) and other deduction as per company policy
13th May 2011 From India, Rudarpur
29th September 2012 From India, Calcutta
I am Ravi Narayan from kolkata, I have theory knowledge of ESI,PF etc but not practical knowledge of ESI,PF, so I want 2 know the how to maintain the ESI,PF records in Xls and how to online filling of forms . pls help me. is there any special formula if any pls provide me.
8th August 2013 From India, Kolkata
18th July 2014 From India, Chennai
1) As per income tax act ESI is calculated on GROSS AMT & the ceiling limit to calculate ESI is 21000 but if an labour wages is 21000 and apart from this he also ears 5000rs as over time, then should we deduct ESI on O.T also.
2) If any one have salary sheet in excel with cool formulas and simple understanding then request you to forward me on my email which is .
4th May 2017 From India, Delhi
PF is deducted to the employees having salary below 15000. those employees earning above 15000 does not come under PF. My question is how to put the formula in excel where it automatically shows PF when we put Gross below 15000 and when gross will be above 15000.
26th August 2017 From undefined, undefined
First of all PF is always deducted over Basic Salary+ Dearness Allow, not on Gross Salary.
Let us assume basic salary+DA is entered in cell A1 and we do calculation for PF in Cell A2. Now formula for calculation of PF will be;
26th August 2017 From India, Delhi
Ref the link, below.... the same is already available in the research tab. Please use it...
28th August 2017 From India, Mumbai
#Anonymouspls some one how can make ecr when
Gross salary -120000.00
Basaic + Da - 30000.00
how can i make ecr in excel as per new UAN format
13th November 2017 From India, Delhi
Salary EPF Share EPS Share EPF Share
6500 780 541 239 24%
EPF Formula For Employee share For Employer share
Salary ESIC Share ESIC Share
12000 210 570 6.50%
Actually not understand the formulla - when Salary 6500 then total esi 24% nd when Salary 12000 esi - 6.5% ? Needs to clarify pls
27th December 2017 From India, Kolkata
I am going to start my career in HR.
so please explain me the formula for PF, ESI and its limits in simple and in detail with examples
3rd February 2018 From India,