Hi friends ...

Help me to design CTC in Excel without using special allowance or other allowance...

just insert CTC and my CTC should get distributed into following heads

Monthly Components

Basic

HRA

Commuting Allowance

Education Allowance

------------------------------------------------

a) Total Gross

------------------------------------------------

Reimbursements

Sodexho Coupons

Business Attire

Information Update

Telephone Reimbursement

Medical Reimbursement

Entertainment Allowance

------------------------------------------------

b) Total Reimbursements

-------------------------------------------------

Monthly Benefits

Medical Insurance

ESIC - Employers' Contribution

PF

------------------------------------------------

c) Total Monthly Benefits

------------------------------------------------

Annual Benefits

LTA

Bonus

Ex-Gratia

------------------------------------------------

d) Total Annual Benefits

------------------------------------------------

e) FBT

------------------------------------------------

Annual CTC ( a+b+c+d+e)

------------------------------------------------

From India , Mumbai
Dear Neha, I think you can take an help from CiteHR Forum. It has lot of CTC templates which might suit your need Regards Siva
From India ,

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server