Head Training & Development
Hr Executive
+2 Others

Thread Started by #shaikh.soyeb

Dear All,
I have tried to develop a CTC format. May be it will help you.I have tried to made some automated calculation.
At top of the sheet you can choose to give PF / Bonus / incentive or not and salary will get calculated accordingly.
Comments and suggestions are most welcome. you can write to me at .
24th July 2014 From India, Hyderabad

Attached Files
Membership is required for download. Create An Account First
File Type: xls Master CTC Format_97-2003.xls (59.5 KB, 3882 views)

Shoeb, Good Job done....But a slight mistake in the formula in the PF calculation field. Regards, Sajeed Shaikh Head - Training & Development
25th July 2014 From India, Mumbai
But I think Soyeb is right for PF Calculation.
PF Accounts Rate of Contribution

Employee 12%

(Basic wages, dearness allowance)

Employer 13.61%


3.67% = Provident Fund (A/c No.1)

8.33% = Pension Fund (A/c No.10)

0.5% = EDLIS -Employees Direct Linked Insurance Scheme (A/c No.21)

Administrative Charges:

1.10% of emoluments = Provident Fund (A/c No.2)

0.01% of emoluments = EDLIS (A/c No.22)
Cp Singh

25th July 2014 From India, Noida
Yes... his working is absolutely correct. Good Work Soyeb !! Regards, Suchita Zonal HR Head
26th July 2014 From India, Pune
Thanks Sajeed, Suchita, Mr.Sing and Mrugen thanks a ton for your comment and time. Hope this type of formats will help us in future. keep in touch if anything needed , I will try my level best to contribute and also will learn by doing.

26th July 2014 From India, Hyderabad
Very Good Job, just need to change formula in PT Hemant HR Executive
2nd August 2014 From India, Pune
Dear Hemant, Yes , you are right!! As PT depend upon state to state,thus required to change the same accordingly. Regards Soyeb
2nd August 2014 From India, Hyderabad
Dear Soyeb,
Though the bifurcation of Employer contribution is 12% + 1.61%= 13.61% is correct, but if you will check 12% is completely calculated on your basic wages whereas 1.1% is calculated on Basic wages, 0.5 % & 0.01% is calculated on your EDLI wages.
Hence, Contribution 1.61% from employer end is for PF Admin, EDLI & EDLI surcharges. which is not consider as a part of employee CTC.
6th August 2014 From India, Pune
Dear Mrugen,
Please find below example.
Employee (12%)=1800 (Basic wages)
Employer (12%)=1800 Pension (EDLI wages 6500*8.33%)=541 & Employer PF=Difference of EPF & Pension-1259. Total 1800
Admin Charges (1.1%)=165 (Basic wages)
EDLI Charges (0.5%)= 32.5 (EDLI Wages-6500)
EDLI Surcharges (0.01%)= 0.65 (EDLI Wages-6500)
6th August 2014 From India, Pune
Respected seniors,
If one's Basic salary is less then Rs. 15000 then ones can be opt out from pf . If yes then How
Cp Singh
================================================== =================

22nd September 2014 From India, Noida
But What If We Dont Have LTA Included? Can I Remove The Row??
11th December 2018 From India, Surat
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™