Pf Employer Contribution Xls Download - CiteHR
Industrial Relations And Labour Laws
+4 Others

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Dear seniors,
Please clarify the PF ceiling amount for an employee who joined the organization on 4th and his da+basic is more than Rs 6500, for that given month.
My payroll software is dividing this 6500 for number of days of in the month and "PF employee contribution" is getting calculated only for the numbers present days.
Community Prime Sponsors - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA.
If you do not contribute or give coverage to an employee whose salary at the time of his joining is more than Rs 6500 and whereas the date of joining is somewhere in between the month so that the salary for the first month will be less than Rs 6500 and due to which the payroll automatically deducts EPF, you have to either manually calculate his salary for that first month or do some adjustment in the system so that no PF will be deducted from the employee.
Thank you very much Madhu Sir, i am sorry for the mistake in my question, it should be employers contribution instead of employee contribution.
Just wanted to know whether the ceiling amount of 6500 to calculate the employers PF contribution remains constant, or will it wary proportionately depending upon the employees DA+BASIC for the given month.
Rs.6500 is the ceiling amount which cant vary, but the employer’s contribution may vary according to the basic+da of employee wereas its % contribution always remains same i.e. 12%.....
It is not mandatory that employer's contribution should be restricted to a salary of Rs 6500. If the employer is willing to contribute on a higher salary the ceiling of Rs 6500 will not apply.
Dear Sam,
I uderstand the tool is calculating the break up, please check if the leave balance is updated approriately/ the weekly offs and holidays are set up correctly, may be the tool by default considering non working days as LOP - my thought

hi sam,
What i understand from your querry is that u joined the organisation on 4 of the month. Correct. If it is correct, u will be eligible for pay and allowances from 4 of the month for that particular month in which u joined the organisation. As regards, contribution towards PF, u can make your contributions to the extent of 100% towards PF.
pf calc, I had try to attachment excel file to upload file error.
Deducation.Contridution.NamesBasicHRAConyothersGrossNo. of DaysGross salyEmply BasicEPS Wages/ Basic > 6500PFESIPTAdv.Mob.Total ded.Net paypf 12%pf 8.33%pf 3.67%Mr. A1400070001540611328653312865314000650016800200 - 18802677316801139541Mr. B1144057201258499523413312341311440650013730200 - 1573218401373832541Mr. C140007000154061132865331286531400065001680020018802677316801139541Mr. D76003800836331915555281405068656500824015097413076824283541Mr. E55002750605230011155311115555005500660010076010395660202458Mr. F64003200704279513099291225459875987718010081811436718219499
This is for you information.
Chandra Sekhar.
Hi, pf calc. Find attachment copy. Regards, Chandra Sekhar.

Attached Files
Membership is required for download. Create An Account First
File Type: xls pf Calc..xls (26.0 KB, 1208 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™