Head Training & Development
Hr Executive
+2 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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 .

From India, Hyderabad

Attached Files
File Type: xls Master CTC Format_97-2003.xls (59.5 KB, 4221 views)

Shoeb, Good Job done....But a slight mistake in the formula in the PF calculation field. Regards, Sajeed Shaikh Head - Training & Development
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

From India, Noida
Yes... his working is absolutely correct. Good Work Soyeb !! Regards, Suchita Zonal HR Head
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.

From India, Hyderabad
Very Good Job, just need to change formula in PT Hemant HR Executive
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
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.

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)

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
================================================== =================

From India, Noida

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 @ 2020 Cite.Co™