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(4)
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(4)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(2)
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(2)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(6)
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(6)+1 more
Amend(0)
Nitu, Find attached a sample format....see if this helps. Regards, Suja
From India, Bangalore
Acknowledge(9)
Amend(0)
From India, Bangalore
Acknowledge(9)+4 more
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(2)
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(2)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(1)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(1)Amend(0)
Hi there,
I am working as an HR coordinator and will try my best to help you out. I have attached the Excel file, please go through it and revert back.
Regards,
Megha
HR and Training Coordinator
KPIT(AIeMS)
Bangalore 😊😊😊
From India, Hubli
Acknowledge(6)
Amend(0)
I am working as an HR coordinator and will try my best to help you out. I have attached the Excel file, please go through it and revert back.
Regards,
Megha
HR and Training Coordinator
KPIT(AIeMS)
Bangalore 😊😊😊
From India, Hubli
Acknowledge(6)+1 more
Amend(0)
Hi, here is the Employees data sheet which we are preparing for our company. I think it will be helpful to you.
From India, Gurgaon
Acknowledge(2)Amend(0)
From India, Gurgaon
Acknowledge(2)Amend(0)
Hi Rajashekhar,
This database sheet is amazing! Could you please email me at gsumaro@gmail.com? I am facing some macro errors while using it. Your assistance would be greatly appreciated, Rajasekar! Thank you once again for uploading and sharing it with us!
Warm regards,
gsumaro
From India, Ghaziabad
Acknowledge(1)
Amend(0)
This database sheet is amazing! Could you please email me at gsumaro@gmail.com? I am facing some macro errors while using it. Your assistance would be greatly appreciated, Rajasekar! Thank you once again for uploading and sharing it with us!
Warm regards,
gsumaro
From India, Ghaziabad
Acknowledge(1)Amend(0)
Hai Rajasekar Can u help us how to use MIS data because we are trying to cheack the formula its not functioning.
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
The Future of Employee Databases: Beyond Excel
Experts have rightly summed up the important fields needed to maintain an employee database in an Excel sheet. However, the question in today's tech-savvy world is, do you still want to continue working on Excel sheets only?
Most online tools are making the work of HRs more productive. FastCollab helps you not only with maintaining employee databases but also with Leave Management, Expense Management, and even running Payroll Online. Isn't it something that should expedite the whole tedious work with Excel?
Take a look at http://www.fastcollab.com | Marketplace | All-In-One Platform
From India, Hyderabad
Acknowledge(0)Amend(0)
Experts have rightly summed up the important fields needed to maintain an employee database in an Excel sheet. However, the question in today's tech-savvy world is, do you still want to continue working on Excel sheets only?
Most online tools are making the work of HRs more productive. FastCollab helps you not only with maintaining employee databases but also with Leave Management, Expense Management, and even running Payroll Online. Isn't it something that should expedite the whole tedious work with Excel?
Take a look at http://www.fastcollab.com | Marketplace | All-In-One Platform
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
HR Manual (Employee Hand Book).doc
HR department.zip