Dear All,
Please find the attached excel sheet for the CTC break up of the employee.
Just enter the Annual Expcected CTC & Grade for the employee in the cell having red background. I have prepared this sheet as per my company policies.
Need your inputs for the same.
Also please clear my doubt regarding the Reimbursements, whether they should be included in the CTC or not. Currently I considered them over & above CTC.

From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls CTC_breakup.XLS (42.5 KB, 1639 views)

regarding reimbursements... it really depends on your company policy.. we have both cases in our company.. it depends on the grade of employees...
From India, New Delhi
hi, Good spreadsheet. reimbursements should be a part of CTC as the term denotes "Cost to Company", you are spending that amount on the employee so it should be added in you CTC.
From India, New Delhi
Dear Shweta, In this statement you have deducted PF. Since basic is more than 6500. i think you dont have to deduct PF na? Please correct me if i’m wrong. Regards Athif
From India, Madras
Dear swetha,
Really a nice format, thank you for sharing it.
Regarding Reimbursements being a part of CTC or Not. It should be, because the company will have a count on how much it is spending on a employee and also it will be beneficial for the book of accounts.
In our organisation, we add reimbursement as a part of CTC for tax benefits of employees.
Regards,
Jaya

From India, Bangalore
Dear Athif,
If the basic is more than 6500, then you have to deduct PF only on Rs.6500/- you dont need to deduct the same on whole amount. In this also you can deduct employees contribution on whole amount of basic whether it is more than 6500, but for Employers contribution max. limit is 6500.
Regards
Shweta G

From India, Mumbai
Dear all,
I'm working in a private company in chennai which is into seafood exports.
i joined as a store manager at a consolidated pay of Rs.15,000.00
Our company is not deducting PF stating that at the time of joining my Basic is more than Rs.6500.00. is this rule true?
Regards
Athif

From India, Madras
If any one tell me that HRA is compulsory ..And what is HRA minimum limit%
Also tell the component of ctc with minimum LIMIT% in UTTARPRADESH& Also for other states...If possible send me a good format...
I shall be honestly very greatful to all the members......
Basic=
HRA=
DA=
Other Allowance=
Conveyance=
ESI=
PF=
TDS=
Professional Tax=
Bonus=
Gross Salary=
Regards,
Deepak

From India, Calcutta
If any one tell me that HRA is compulsory ..And what is HRA minimum limit%
Also tell the component of ctc with minimum LIMIT% in UTTARPRADESH& Also for other states...If possible send me a good format...(ALL CATEGORY Cashiers, Driver, Armed Guard, Office Boy, HR,ADMIn, LOGISTIC supervisor)
I shall be honestly very greatful to all the members......
Basic=
HRA=
DA=
Other Allowance=
Conveyance=
ESI=
PF=
TDS=
Professional Tax=
Bonus=
Gross Salary=
Regards,
Deepak

From India, Calcutta
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.