Dear all,
Really i am impressed with all those seniors & professionals spending their valuable time in preparing their threads, replying to those in need of hour & almost making new hrs' like us survive in the real business scenario. thanks all.
I completed by UG in 2010 & am 2 years old to this HR field. I am using this cite since then & i feel guilty of not contributing from my favor. Really this motivated me to prepare an excel which serves as an one point access to the below mentioned topics.
a. Employee Personal Profile
1. Employee Summary
2. Employee appointment Order
3. Employee pledge
4. Employer policy
5. Form 1- ESI Nomination
6. Form 2 - EPF Nomination
7. Form 34 - IF Nomination
8. Form G - Gratuity Nomination
9. Employee Wage History
10. Employee Training Details
b. Employee Identity Card
c. Employee Time Card
d. Employee Payroll
e. Employee Payslip
f. ESI Challan
g. EPF Challan
h. IF Statutory Registers
1. Remuneration Registers
Form 12 & 25
Form 10
Form B
Form C
Form D
Form II
Form III
2. Workmen Registers
Form 1
Form 1 (Rule(3))
3. Leaves & Holidays Registers
Form 9
Form 15
Form VI
4. Establishment Registers
Form 7
Form 28
Form 29
5. Safety Regsiters
Form 26
Form 26A
all in one excel. this has taken me a long time in creating this excel. This is been implemented by our company having workers strength of 230 at present. its highly sucessfull. Those who are really interested can reply in this post with your details. Really i am pleasure to help you HRs but at present only to Tamil Nadu (Since these are represented at some point in Tamil Language, like appointment orders, et al)
Thanks & Best regards.
From India, Chennai
4Really i am impressed with all those seniors & professionals spending their valuable time in preparing their threads, replying to those in need of hour & almost making new hrs' like us survive in the real business scenario. thanks all.
I completed by UG in 2010 & am 2 years old to this HR field. I am using this cite since then & i feel guilty of not contributing from my favor. Really this motivated me to prepare an excel which serves as an one point access to the below mentioned topics.
a. Employee Personal Profile
1. Employee Summary
2. Employee appointment Order
3. Employee pledge
4. Employer policy
5. Form 1- ESI Nomination
6. Form 2 - EPF Nomination
7. Form 34 - IF Nomination
8. Form G - Gratuity Nomination
9. Employee Wage History
10. Employee Training Details
b. Employee Identity Card
c. Employee Time Card
d. Employee Payroll
e. Employee Payslip
f. ESI Challan
g. EPF Challan
h. IF Statutory Registers
1. Remuneration Registers
Form 12 & 25
Form 10
Form B
Form C
Form D
Form II
Form III
2. Workmen Registers
Form 1
Form 1 (Rule(3))
3. Leaves & Holidays Registers
Form 9
Form 15
Form VI
4. Establishment Registers
Form 7
Form 28
Form 29
5. Safety Regsiters
Form 26
Form 26A
all in one excel. this has taken me a long time in creating this excel. This is been implemented by our company having workers strength of 230 at present. its highly sucessfull. Those who are really interested can reply in this post with your details. Really i am pleasure to help you HRs but at present only to Tamil Nadu (Since these are represented at some point in Tamil Language, like appointment orders, et al)
Thanks & Best regards.
From India, Chennai
hi Kartik ,
i do need your assistance to prepare such an excel sheet for my clients. Please share your sheet with us so that we can work on that and make it usefull for others.
Please mail it to
From India, Mumbai
i do need your assistance to prepare such an excel sheet for my clients. Please share your sheet with us so that we can work on that and make it usefull for others.
Please mail it to
From India, Mumbai
Dear All,
We can contact be at the below given mail ID.
I would like to explain the process of using this excel before just putting on screen, to every individual who are really in need of these.
This is not complicated to use but i have set lots & lots of Internal presets which can be explained only while using it.
Best Regards
From India, Chennai
We can contact be at the below given mail ID.
I would like to explain the process of using this excel before just putting on screen, to every individual who are really in need of these.
This is not complicated to use but i have set lots & lots of Internal presets which can be explained only while using it.
Best Regards
From India, Chennai
Dear Harish & Vallabh,
Thanks for your interest.
I kindly request to contact me thru mail & also kindly allocate any time of your choice atleast 10-15 mins & intimate me in order to let me explain the process of this excel thru team viewer or any such sys viewers.
Best Regards.
From India, Chennai
Thanks for your interest.
I kindly request to contact me thru mail & also kindly allocate any time of your choice atleast 10-15 mins & intimate me in order to let me explain the process of this excel thru team viewer or any such sys viewers.
Best Regards.
From India, Chennai
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.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Advanced Excel 2003.pdf