Sanjeevntpl
Manager-hr
Jiguparmar
Autocad/plc/scada/adv.excel
Suja_nm
Hr Professional
Shariarkabir
Working In Hr For 6 Years
Hachokshi
Manager - Hr
Venu_nani
Hr Executive
Thaohr
Dis 3
Amitdho
Accountant
+7 Others

Thread Started by #nandababani@gmail.com

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.
18th December 2008 From India, Hyderabad
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
19th December 2008 From India, Bangalore
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
19th December 2008 From India, Bangalore
Nitu, Find attached a sample format....see if this helps. Regards, Suja
19th December 2008 From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls Master database-sample.xls (22.0 KB, 22168 views)

pls see the attachment. sanjeev
19th December 2008 From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls database.xls (17.5 KB, 11861 views)

I hope this attached file will help u.
19th December 2008 From Bangladesh, Dhaka

Attached Files
Membership is required for download. Create An Account First
File Type: xls Employee Database.xls (1.50 MB, 14954 views)

Hi Nanda u can use the attached MIS Rajasekar
19th December 2008 From India, Madras

Attached Files
Membership is required for download. Create An Account First
File Type: xls MIS.xls (605.0 KB, 11180 views)

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
19th December 2008 From India, Mumbai
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

19th December 2008 From India, Hyderabad
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:
20th December 2008 From India, Hubli

Attached Files
Membership is required for download. Create An Account First
File Type: xls Employee excel sheet.xls (24.5 KB, 4021 views)

Hi, here is the Employees data sheet which we are preparing for our company. I think it will be helpful to you.
20th December 2008 From India, Gurgaon

Attached Files
Membership is required for download. Create An Account First
File Type: xls Employees data format.xls (18.0 KB, 2638 views)

this database sheet is amazing..! can mail me on
im facing some macro error while using it. it will be a great help rajasekar!
thankx once again for uploading and sharing it with us!
renu
22nd December 2008 From India, New Delhi
Please find new version of Salary Master with new Feactures..

Totally Usefriendly program.

You can enter your Company name,Address,Department,Designations

You can set Categoeries of Fixed earning-Other Earning-Fixed deduction-Other deduction in Salary Slip.

You can set limit of ESI,P.F,Income Tax Slab for Man and Woman,Surchage setting,Professional Tax.

Program is Designed on Two mode

(1) In Auto mode salary slip will be generated as per Your predefined data given in "Company Detail Sheet"

(2) In Manual mode Salary Slip will be generated as per Manual detail given by You.It will not concern with the data given by you in "Company detail sheet"

Ex: We need to generate salary for Regular Employee as per company Policy for that You may put this employees on Auto mode and it will generate Salary slip as per your predefined data (If Basic is 25% of Gross than auto calculate it)But Some Employees are Temperaroy or We don't Follow Rules as per Regular employee so that This Type of Employee Put on Manual mode and enter your Data manually(here You have manually enter Basic and other details).

Software Contains:

1-Attendance Register.

2-Payroll Register.

3-Generate Salary Slip.

4-Track Employees' Leave history.

5-Track Income Tax of All Employee.

6-Print out Leave History of Employee.

7-Overtime Monitor.

8-Master Data sheet of All Employees.

9-Leave Calculation sheet.

10-ESI Calculation(Set Your Requirements)

11-P.F Calculation

(Here there are Two Options one is if Basic<=6500 than Basic*12% otherwise 6500*12%

Second is 12% of Basic)

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: You have monitor Leave of employee each month when It goes minius Red indication is glow on that cell so You have to Put it on LWP otherwise minus leave will effect on salary sllip generation.

Requied Attention: Please be vigilant about Auto and Manual mode and P.F Selection.

If You find this is useful for You than Don't miss to deop Thanks...

Download:Free File Hosting & Video Downloads, Free File Sharing, Online Friends Network - Ziddu

Please chase the steps as per the given sequence.

First open "Company Detail Sheet"

1-Open "Company Detail Sheet"

2-Change Company name and Address.

3-Change Salary discriptions: By default I gave some categories for Fixed earning/Reimberancement/Other deductions. Change the Names of This Categories as per your reqirements.

4- As you enter detail mentions in step 3 name of the categories will appear in auto generation salary just below the Salary discription.

Enter percentage as per your company requirements to generate salary of all employees(By default I gave Basic= 25% of gross .You can change 25% and enter your %)

5-Enter % of ESI from Employee and Employer and For P.F Choose your Options.

6-For Professional tax Slab enter your criteria.

7- Enter Name of Departments/Designation of Employees of your Orgenizations.

8-Enter Tax Slab for man and Woman.

second open "Master Data Sheet"

1-Enter Employee name-gender-employee code.

2-select his/her designation-department

3-Enter Pan no-Bank A/C No-Bank name-P.F no-ESI No-DOB-DOJ-Location

4-Enter Employees Gross salary/Month

5-Here after If You choose Auto mode than Salary slip will be generated autonatically as per (%wise detail) data given by you in "Company detail sheet"(nomally for Regular Employees put Auto mode).But if You don't want to follow the rules enter by You in "Company detail sheet" put manual mode here You can Enter his/her Basic-Hra and all detail of salary manually.

6- Enter Amount of OT/Hr if Employee do OT

7- Enter leave detail,Previous Year Leave-This Year Leaves.

8-Enter Rentpaid by Employee for exemption under section 10&17

9-Enter Amount for section 80c and 80D for U/S VIA deduction.

Thrid open "Attendance sheet according to perticular Month"

1- Enter Attendance/Leave/Holiday of Employee

2- enter Overtime of The Employee.

Forth open "Payroll sheet according to perticular Month"

1- All salary detail and attendance will automatically carry forward. You have to enter only reimberance detail and other deduction detail only

2- Salry will generate as per your data.

3- Enter Salary Amount Which You have Paid.

4-Select Type of Payment.

Most of remaning sheet are monitoring or summary sheet.
30th March 2010 From India, New Delhi
Hi Rajashekhar,
this database sheet is amazing..! can you mail me on
im facing some macro error while using it. it will be a great help rajasekar!
thankx once again for uploading and sharing it with us!
gsumaro
8th May 2010 From India, Ghaziabad
Hai Rajasekar Can u help us how to use MIS data because we are trying to cheack the formula its not functioning.
7th December 2010
Experts have rightly summed up what all important field needed to maintain employee data base in 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 their Leave Management, Expense Management and even running their Payroll Online. Isn't it something that should fasten the whole tedious work with excel.
Take a look at FastCollab | Marketplace | All-In-One Platform
23rd October 2016 From India, Hyderabad
Hello everyone,
I'm a new member, I am preparing the master data file of employees database, could anyone help me out with the format and which informations I have to put into.
thanks in advance
with regards,
4th November 2017 From Vietnam, Ho Chi Minh City
i Want to make an arrear and in RPMF rates i want to set a formula so value will be available automatically
example if an employee basic pay is upto 7000 his rpmf rate should be 500 if it is 7000-13999 rates of rpmf will be 700 kindt elp me to make a formula
24th December 2017 From India, Jaipur
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information and resources for business and professional growth. Register Here
Prime Sponsor: TALENTEDGE - Certification Courses from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2017 Cite.Co™