Hi, Sneha this side . I would like to understand the process of monthly PF calculation on basics . I want to understand how do we calculate deduction of pf from both employee and employer's end . This query I have raised is from the prospective that in case if have to handle PF process end to end so in that case how can I calculate monthly PF deduction of employees in excel.
Regards
Sneha
From India, New Delhi
Regards
Sneha
From India, New Delhi
Dear Sneha,
You can deduct PF on the basic salary. 12% is employee's share which is deducted from Gross salary of employee and 12% is of employer's share which should not be shown in salary slip but it is considered as part of CTC. Apart from this, employer also has to bear 1.15% total basic salary as admin charges which is only shown in PF Challan. If you're preparing challan by yourself then you've to consider this charges also. If you don't have any format then try to prepare a format by your own understanding and then share with me and if required I'll make necessary changes.
Regards,
Manish
From India, Ahmedabad
49You can deduct PF on the basic salary. 12% is employee's share which is deducted from Gross salary of employee and 12% is of employer's share which should not be shown in salary slip but it is considered as part of CTC. Apart from this, employer also has to bear 1.15% total basic salary as admin charges which is only shown in PF Challan. If you're preparing challan by yourself then you've to consider this charges also. If you don't have any format then try to prepare a format by your own understanding and then share with me and if required I'll make necessary changes.
Regards,
Manish
From India, Ahmedabad
Dear All, This is Sunil, could you please send PF Calculation recent amendment in excel format to my mail id. my mail id is rapallisunil@gmail.com
From India, Hyderabad
From India, Hyderabad
Dear All, This is kuntal, could you please send PF Calculation recent amendment in excel format to my mail id. my mail id is kuntal.chakraborty77@gmail.com
From India, Kolkata
From India, Kolkata
How to we calculate actual amount of PF as per given bellow Salary Structure :-
Basic............Rs.9000/-
TA ...............Rs.3000/-
HRA.............Rs.4000/-
Other Perks.Rs. 4000/-
Total Salary Rs.20000/-
Kindly specified Employee and Employer Contribution with effective rates if joining date before 1-9-14 or after 1-9-2014 and also clarify that have any role of minimum wages also to calculate PF.
Regards
Afzal Husain Khan
From India, Delhi
Basic............Rs.9000/-
TA ...............Rs.3000/-
HRA.............Rs.4000/-
Other Perks.Rs. 4000/-
Total Salary Rs.20000/-
Kindly specified Employee and Employer Contribution with effective rates if joining date before 1-9-14 or after 1-9-2014 and also clarify that have any role of minimum wages also to calculate PF.
Regards
Afzal Husain Khan
From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls