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)
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(0)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(0)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(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
This database sheet is amazing! Can you email me at 
? I'm facing some macro errors while using it. It will be a great help, Rajasekar!
Thank you once again for uploading and sharing it with us.
Renu
From India, New Delhi
Acknowledge(0)Amend(0)
Thank you once again for uploading and sharing it with us.
Renu
From India, New Delhi
Acknowledge(0)Amend(0)
Please find the new version of Salary Master with new features.
A totally user-friendly program.
You can enter your company name, address, department, and designations. You can set categories of fixed earning, other earning, fixed deduction, and other deduction in the salary slip. You can set limits for ESI, P.F, income tax slabs for men and women, surcharge settings, and professional tax.
The program is designed in two modes:
1. In Auto mode, the salary slip will be generated as per your predefined data in the "Company Detail Sheet."
2. In Manual mode, the salary slip will be generated based on the manual details provided by you, independent of the data in the "Company Detail Sheet."
For example, to generate salaries for regular employees as per company policy, you can put these employees on Auto mode, which will calculate the salary based on predefined data. For temporary employees or those not following regular employee rules, Manual mode can be used for manual data entry.
The software contains:
1. Attendance Register.
2. Payroll Register.
3. Generate Salary Slip.
4. Track Employees' Leave history.
5. Track Income Tax of All Employees.
6. Print out Leave History of Employees.
7. Overtime Monitor.
8. Master Data sheet of All Employees.
9. Leave Calculation sheet.
10. ESI Calculation (Set Your Requirements).
11. P.F Calculation (Options based on Basic pay).
12. Pension Scheme (not more than 541 Rs. submission).
13. TDS Calculation.
14. Annual Salary statement of Employee and Employer.
15. Employer Monthly Salary statement.
16. Income Tax Calculations.
17. Generation of Form No-6 (For ESIC).
18. Generation of Form no-3A (PF).
19. Generation of Form no-6A (PF).
Limitation: Monitor employee leave each month; if it goes negative, a red indication will appear. Address it to avoid affecting salary slip generation.
Required Attention: Be vigilant about Auto and Manual modes and P.F Selection.
If you find this useful, don't forget to drop a "Thanks..."
Download: [Free File Hosting & Video Downloads, Free File Sharing, Online Friends Network - Ziddu](http://www.ziddu.com/download/8908540/SalaryMaster-NewVersion-10.3.2010.zip.html)
Please follow the steps in the given sequence:
1. Open "Company Detail Sheet."
- Change the company name and address.
- Modify salary descriptions and categories as per your requirements.
2. Open "Master Data Sheet."
- Enter employee details and designation.
- Provide necessary information for salary processing.
3. Open "Attendance sheet according to a particular Month."
- Record employee attendance, leave, and overtime.
4. Open "Payroll sheet according to a particular Month."
- Enter reimbursement and deduction details.
Most remaining sheets are for monitoring or summarizing data.
From India, New Delhi
Acknowledge(0)Amend(0)
A totally user-friendly program.
You can enter your company name, address, department, and designations. You can set categories of fixed earning, other earning, fixed deduction, and other deduction in the salary slip. You can set limits for ESI, P.F, income tax slabs for men and women, surcharge settings, and professional tax.
The program is designed in two modes:
1. In Auto mode, the salary slip will be generated as per your predefined data in the "Company Detail Sheet."
2. In Manual mode, the salary slip will be generated based on the manual details provided by you, independent of the data in the "Company Detail Sheet."
For example, to generate salaries for regular employees as per company policy, you can put these employees on Auto mode, which will calculate the salary based on predefined data. For temporary employees or those not following regular employee rules, Manual mode can be used for manual data entry.
The software contains:
1. Attendance Register.
2. Payroll Register.
3. Generate Salary Slip.
4. Track Employees' Leave history.
5. Track Income Tax of All Employees.
6. Print out Leave History of Employees.
7. Overtime Monitor.
8. Master Data sheet of All Employees.
9. Leave Calculation sheet.
10. ESI Calculation (Set Your Requirements).
11. P.F Calculation (Options based on Basic pay).
12. Pension Scheme (not more than 541 Rs. submission).
13. TDS Calculation.
14. Annual Salary statement of Employee and Employer.
15. Employer Monthly Salary statement.
16. Income Tax Calculations.
17. Generation of Form No-6 (For ESIC).
18. Generation of Form no-3A (PF).
19. Generation of Form no-6A (PF).
Limitation: Monitor employee leave each month; if it goes negative, a red indication will appear. Address it to avoid affecting salary slip generation.
Required Attention: Be vigilant about Auto and Manual modes and P.F Selection.
If you find this useful, don't forget to drop a "Thanks..."
Download: [Free File Hosting & Video Downloads, Free File Sharing, Online Friends Network - Ziddu](http://www.ziddu.com/download/8908540/SalaryMaster-NewVersion-10.3.2010.zip.html)
Please follow the steps in the given sequence:
1. Open "Company Detail Sheet."
- Change the company name and address.
- Modify salary descriptions and categories as per your requirements.
2. Open "Master Data Sheet."
- Enter employee details and designation.
- Provide necessary information for salary processing.
3. Open "Attendance sheet according to a particular Month."
- Record employee attendance, leave, and overtime.
4. Open "Payroll sheet according to a particular Month."
- Enter reimbursement and deduction details.
Most remaining sheets are for monitoring or summarizing data.
From India, New Delhi
Acknowledge(0)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(0)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(0)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)
Experts have rightly summed up what all important field needed to maintain 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 database but also with their Leave Management, Expense Management, and even running their Payroll Online. Isn't it something that should expedite the whole tedious work with Excel?
Take a look at [FastCollab](http://www.fastcollab.com) | Marketplace | All-In-One Platform
From India, Hyderabad
Acknowledge(0)Amend(0)
Most online tools are making the work of HRs more productive. FastCollab helps you not only with maintaining employee database but also with their Leave Management, Expense Management, and even running their Payroll Online. Isn't it something that should expedite the whole tedious work with Excel?
Take a look at [FastCollab](http://www.fastcollab.com) | Marketplace | All-In-One Platform
From India, Hyderabad
Acknowledge(0)Amend(0)
Hello everyone,
I'm a new member. I am preparing the master data file of the employees' database. Could anyone help me out with the format and which information I have to put in?
Thanks in advance.
With regards,
From Vietnam, Ho Chi Minh City
Acknowledge(0)Amend(0)
I'm a new member. I am preparing the master data file of the employees' database. Could anyone help me out with the format and which information I have to put in?
Thanks in advance.
With regards,
From Vietnam, Ho Chi Minh City
Acknowledge(0)Amend(0)
I want to make an arrear in RPMF rates. I want to set a formula so the value will be available automatically. For example, if an employee's basic pay is up to 7000, his RPMF rate should be 500. If it is between 7000-13999, the rates of RPMF will be 700. Kindly help me to make a formula.
From India, Jaipur
Acknowledge(0)Amend(0)
From India, Jaipur
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.
HR Manual (Employee Hand Book).doc
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip