Formula Use In Excell For The Deductions Of PF And ESI In The Salary

Dear seniors,
am currently face a interview in which interviewers asked me a questions how am deducted the PF& ESI in the salary what formula use in excel l sheet in which automatically deductions of the PF and ESI of each employees in the salary .kindly pls told me the formula use ..
thanks
anjna
13th May 2011 From India, Chandigarh

Dear Anjna, Find the attached herewith Excel sheet, hope this is helpful for you.
13th May 2011 From India, Delhi

Attached Files

Membership is required for download. Create An Account First

formula use in excell for the deductions of PF and ESI in the salary.xls (23.0 KB, 23498 views)

ommy thanks , pls tell me one thins that all deductions in gross salary or basic salary means basic salary gross salary and net salary what is difference between these thanks , anjna
13th May 2011 From India, Chandigarh

if u don't mind then i think if u will discuss with me on phone then i can clear u more effectivly.
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

Please review attached. Thanks,
19th May 2011 From Kuwait, Hawalli

Attached Files

Membership is required for download. Create An Account First

SALARY(1).xls (23.5 KB, 7888 views)

Is any Govt rule on Basic, DA & other allowance? who will get the Education allowance, Medical Allowance
19th May 2011 From India, Delhi

Hi this is shekar valeru, its my first time the posted the qustion, my question is what you have given salary formula is very dificult to me give me clarity,tq.
20th May 2011 From India, Hyderabad

Hi This is prabhakar Respected all is there any format for payroll in excel with PF,ESI and PT Statement in deffrent sheet please tel me urjent Thanking You
3rd July 2011 From India, Hyderabad

it would be Basic+DA and on that 12% will be calculated. to arrive at the PF, the maximum of Rs. 780, could be more also as per the provision of the law say for example Baisc - 1200, DA - 800 then PF will be calculated on 1200+800=2000 and it will be 240 for the employee (deduction) for the employer it would be 272.
regards
saurabh
kingofkol
29th September 2012 From India, Calcutta

Dear Sir
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.
Regards
Ravi Narayan
8th August 2013 From India, Kolkata

please explain the over all process of PF, ESI, Payroll and explain these activities and tell the basic and formula, i have 2+ years of exp in HR but i am not have exp in Payroll. its huge dis advantage for me. please seniors explain these process and formula and how to calculate?
18th July 2014 From India, Chennai

Dear Anjna, Find the attached herewith Salary Working Excel sheet, hope this is helpful for you.
18th July 2014 From India, Bangalore

Attached Files

Membership is required for download. Create An Account First

ESI and EPF.xls (44.0 KB, 1184 views)

Dear friend,
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

please tell me the formula for PF and ESI with the argument when the capp is below 15000 and above 15000.
26th August 2017 From undefined, undefined

Why would the formula differ Tanzeel? Can you let us know, why you think the formula is different.
26th August 2017 From India, Mumbai

Dear Ashutosh,
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

Dear Tanzeel,
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;
=IF(A1>=15000,0,A1*12%)
Best Regards,
Mahesh Kumar
26th August 2017 From India, Delhi

Can any on post the all possible formulas used in salary sheet to make all calculations smoothly.
.
28th August 2017 From undefined, undefined

Tanzeel,
Ref the link, below.... the same is already available in the research tab. Please use it...
https://www.citehr.com/179431-excel-...tml#post786745
Regards,
28th August 2017 From India, Mumbai

pls 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

EPF Formula For Employee share For Employer share
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

Dear Sir,
I have preparing salary PT PF & ESI work sheet so please send me excel formula sheet 2018
2nd February 2018 From India, Bengaluru

Silpa
sir/madam,
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,

Dear friends,
Tomorrow is my interview. Please tell me the important things about PF & ESIC.
Please tell me the contribution details and how to submit pf & ESIC online and generate PF Challan.
4th February 2018 From India, Kolkata

Hello Sir/ Madam
I am going to start accountant work with hospitality industry , how to calculate salary with pf. Esi & etc
27th August 2018 From India, Hyderabad

I want to prepare employee on salary PF & ESI CONTRIBUTION and have create a chart to employer please give me right statement for our Company
11th June 2019 From India, Visakhapatnam