nandababani@gmail.com
4

Hi,
I have started working in HR dept 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 prepare various reports wrt to employee database. It would be a great help if I can get some sample sheets.
Looking froward for reply.
Thanks & Regards
Nitu.

From India, Hyderabad
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Sanjeevntpl
Manager-hr
Jiguparmar
Autocad/plc/scada/adv.excel
Suja_nm
Hr Professional
Shariarkabir
Working In Hr For 6 Years
Hachokshi
Manager - Hr
Amitdho
Accountant
Venu_nani
Hr Executive
+6 Others

zenha
3

Hi,
Employee database can be prepare in a excel sheet, you have to add columns like :
Name of the Employee
Employee id
Date of Birth
Date of Joining
Bank A/c no.
PF A/C No.
PAN No.
Email id
Mobile no.
Contact Address
Regards
Zenha

From India, Bangalore
Madhaviaspl
19

Employee database can be prepare in a 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 helps you.
With regards
Madhu

From India, Bangalore
suja_nm
19

Nitu, Find attached a sample format....see if this helps. Regards, Suja
From India, Bangalore

Attached Files (Download Requires Membership)
File Type: xls Master database-sample.xls (22.0 KB, 24266 views)

sanjeevntpl
7

pls see the attachment. sanjeev
From India, Delhi

Attached Files (Download Requires Membership)
File Type: xls database.xls (17.5 KB, 13205 views)

shariarkabir
11

I hope this attached file will help u.
From Bangladesh, Dhaka

Attached Files (Download Requires Membership)
File Type: xls Employee Database.xls (1.50 MB, 16567 views)

rajasekar16
59

Hi Nanda u can use the attached MIS Rajasekar
From India, Madras

Attached Files (Download Requires Membership)
File Type: xls MIS.xls (605.0 KB, 12456 views)

aparna khairnar
2

Hi
First of all you have to prepare a simple seperate file of individual employee
in that maintain all the document of his/her from start to End like,
Resume
Appointment letter copy
Previous Employement letter
salary slip (privious)
photos passport or postcard of (family)
Esic & Pf form
Induction letter
confirmation
increment letter
and at the time of resign maintain a Exit Form
ok
Byyyyyyyyy

From India, Mumbai
usha HR
2

Hi
The employee database should have the following:
Employee Code
Employee Name
Father Name / Spouse Name
Designation
Department
Date of joining
Date of Exit
Date of Birth
Contact No
E mail ID
CommunicationAddress
Permanent Address
You can also include these too
Blood Group
Gender
Marital Status
Bank Account
PF Account
ESI no
Qualificaition
Experience
Previous Employer record
Pan No
Passport No.
You can include all these or choose only those which you feel are necessary to maintain.
Bye
Usha
ja

From India, Hyderabad
meghabims
6

Hie dear:)
M working as HR coordinator, will try ma best to help u out, I ve attached the excel go thru it and revert back
Regards
Megha
Hr and training coordinator
KPIT(AIeMS)
Bangalore:razz::razz::razz:

From India, Hubli

Attached Files (Download Requires Membership)
File Type: xls Employee excel sheet.xls (24.5 KB, 5228 views)

If You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of Such Discussions in Future - Please Register and Log In to Cite Community.








About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server