Pf Employer Contribution Xls Download

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.
Regards
Sam

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.
Regards,
Madhu.T.K

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.
Regards
Sam

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.
Regards,
Madhu.T.K

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
Regards
Nithy

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.
Regards.

Dear
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.
Regards,
Chandra Sekhar.

Hi,
pf calc. Find attachment copy.
Regards,
Chandra Sekhar.