Salary Structure Done In Excel With Formula

Hi Everyone,
I have joined as an HR Executive in Logistic Company.They have asked me to frame an salary structure of the employees in Excel which should include as:
Basic
HRA
Conveyance,
Total Gross,
OverTime, Total False,
PF-Employer(13.61%) nd Employee share(12%),
ESI-Employer(4.75%) nd Employee share(1.75%),
PT, Bonus, Gratutity and last Net Pay .
Kindly help me out to do this calculations.
Thanks in advance.
Regards,
Suman

[QUOTE=viduvipu;1697988]Hi Everyone,
I have joined as an HR Executive in Logistic Company.They have asked me to frame an salary structure of the employees in Excel which should include as:
Basic
HRA
Conveyance,
Total Gross,
OverTime, Total False,
PF-Employer(13.61%) nd Employee share(12%),
ESI-Employer(4.75%) nd Employee share(1.75%),
PT, Bonus, Gratutity and last Net Pay .
Kindly help me out to do this calculations.
Thanks in advance.
Regards,
Suman[this is legal]

Hi Amit,
Went through the format.
It's really helpful for me.
Definetely will cal u if clarifications required.
Thnks & Rgds,
Suman

Hi All,
Can someone help me in arranging the salary structure . I have uploaded the one with formulas but i need to adjust monthly and total ctc which is written outside the border