Hi,
I have started working in the HR department of an IT firm, where I have been given a task to develop an employee database in the form of Excel sheets. I want to know what kind of various sheets I can prepare and what columns should be included. Please help me in understanding and preparing various reports with respect to the employee database. It would be a great help if I could get some sample sheets.
Looking forward to a reply.
Thanks & Regards,
Nitu
From India, Hyderabad
Acknowledge(0)
Amend(0)
4I have started working in the HR department of an IT firm, where I have been given a task to develop an employee database in the form of Excel sheets. I want to know what kind of various sheets I can prepare and what columns should be included. Please help me in understanding and preparing various reports with respect to the employee database. It would be a great help if I could get some sample sheets.
Looking forward to a reply.
Thanks & Regards,
Nitu
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi,
An employee database can be prepared in an Excel sheet. You have to add columns such as:
- Name of the Employee
- Employee ID
- Date of Birth
- Date of Joining
- Bank Account Number
- PF Account Number
- PAN Number
- Email Address
- Mobile Number
- Contact Address
Regards,
Zenha
From India, Bangalore
Acknowledge(0)Amend(0)
An employee database can be prepared in an Excel sheet. You have to add columns such as:
- Name of the Employee
- Employee ID
- Date of Birth
- Date of Joining
- Bank Account Number
- PF Account Number
- PAN Number
- Email Address
- Mobile Number
- Contact Address
Regards,
Zenha
From India, Bangalore
Acknowledge(0)Amend(0)
Employee database can be prepared in an Excel sheet. You have to add columns like:
- Name of the Employee
- Employee ID
- Date of Birth
- Father's Name
- Department/Division (If any)
- Department/Division Head
- Date of Joining
- Qualification
- Designation
- Date of confirmation (if probationary period applicable)
- Present Salary
- Last Date of Increment
- Amount of Increment
- Contact No.
- Bank A/C No.
- PF A/C No.
- ESI Insurance No. (If any)
- PAN No.
- Email ID
- Blood Group
- Contact Address
Hope this will help you.
With regards,
Madhu
From India, Bangalore
Acknowledge(0)Amend(0)
- Name of the Employee
- Employee ID
- Date of Birth
- Father's Name
- Department/Division (If any)
- Department/Division Head
- Date of Joining
- Qualification
- Designation
- Date of confirmation (if probationary period applicable)
- Present Salary
- Last Date of Increment
- Amount of Increment
- Contact No.
- Bank A/C No.
- PF A/C No.
- ESI Insurance No. (If any)
- PAN No.
- Email ID
- Blood Group
- Contact Address
Hope this will help you.
With regards,
Madhu
From India, Bangalore
Acknowledge(0)Amend(0)
Nitu, Find attached a sample format....see if this helps. Regards, Suja
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi,
First of all, you have to prepare a simple separate file for each individual employee. In this file, maintain all the documents from the start to the end, such as:
- Resume
- Appointment letter copy
- Previous employment letter
- Salary slip (previous)
- Family photos (passport or postcard)
- ESIC & PF forms
- Induction letter
- Confirmation
- Increment letter
At the time of resignation, maintain an Exit Form.
Okay.
Bye
From India, Mumbai
Acknowledge(0)Amend(0)
First of all, you have to prepare a simple separate file for each individual employee. In this file, maintain all the documents from the start to the end, such as:
- Resume
- Appointment letter copy
- Previous employment letter
- Salary slip (previous)
- Family photos (passport or postcard)
- ESIC & PF forms
- Induction letter
- Confirmation
- Increment letter
At the time of resignation, maintain an Exit Form.
Okay.
Bye
From India, Mumbai
Acknowledge(0)Amend(0)
Hi,
The employee database should have the following information:
- Employee Code
- Employee Name
- Father Name / Spouse Name
- Designation
- Department
- Date of Joining
- Date of Exit
- Date of Birth
- Contact Number
- Email ID
- Communication Address
- Permanent Address
Additional optional fields to include:
- Blood Group
- Gender
- Marital Status
- Bank Account
- PF Account
- ESI Number
- Qualification
- Experience
- Previous Employer Record
- PAN Number
- Passport Number
You can select the fields you find necessary for maintenance.
Bye,
Usha
From India, Hyderabad
Acknowledge(0)Amend(0)
The employee database should have the following information:
- Employee Code
- Employee Name
- Father Name / Spouse Name
- Designation
- Department
- Date of Joining
- Date of Exit
- Date of Birth
- Contact Number
- Email ID
- Communication Address
- Permanent Address
Additional optional fields to include:
- Blood Group
- Gender
- Marital Status
- Bank Account
- PF Account
- ESI Number
- Qualification
- Experience
- Previous Employer Record
- PAN Number
- Passport Number
You can select the fields you find necessary for maintenance.
Bye,
Usha
From India, Hyderabad
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.