Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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?
From India, Chennai
Dear Anjna, Find the attached herewith Salary Working Excel sheet, hope this is helpful for you.
From India, Bangalore

Attached Files
File Type: xls ESI and EPF.xls (44.0 KB, 1374 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 .

From India, Delhi
please tell me the formula for PF and ESI with the argument when the capp is below 15000 and above 15000.
From undefined, undefined
Why would the formula differ Tanzeel? Can you let us know, why you think the formula is different.
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.

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

From India, Delhi
Can any on post the all possible formulas used in salary sheet to make all calculations smoothly. .
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,

From India, Mumbai
Anonymous
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
From India, Delhi

Please Login To Add Reply






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™