Free template template · Word

Employee Master Data Sheet

An employee master data sheet is a single tabular sheet that lists every current employee with their key employment attributes. HR uses it as the reference source for payroll, headcount reports and statutory filings, and updates it whenever an employee joins, moves or leaves.

Editable Word (.docx)
Made for India
15 fill-in fields highlighted
Free, no sign-up

Download Word (.docx) — free

Preview of the template

[Highlighted] = fill in

[Company Logo][Company Name]

EMPLOYEE MASTER DATA SHEET

Company:: [Company Name]
Data as on:: [DD/MM/YYYY]
Maintained by:: [HR Name]

This sheet holds the minimum master data needed to run payroll, headcount reporting and statutory compliance. Bank details, health information and identity documents are kept in separate restricted records and are not entered here.

Emp ID	Employee Name	Department	Designation	Reporting Manager	Date of Joining	Employment Type	Work Location	UAN	ESIC No.	Status	Last Updated
[Employee ID]	[Employee Name]	[Department]	[Designation]	[Reporting Manager]	[DD/MM/YYYY]	[Permanent / Contract / Trainee]	[Work Location]	[UAN]	[ESIC No. / NA]	[Active / Notice / Exited]	[DD/MM/YYYY]
[Employee ID]	[Employee Name]	[Department]	[Designation]	[Reporting Manager]	[DD/MM/YYYY]	[Permanent / Contract / Trainee]	[Work Location]	[UAN]	[ESIC No. / NA]	[Active / Notice / Exited]	[DD/MM/YYYY]
[Employee ID]	[Employee Name]	[Department]	[Designation]	[Reporting Manager]	[DD/MM/YYYY]	[Permanent / Contract / Trainee]	[Work Location]	[UAN]	[ESIC No. / NA]	[Active / Notice / Exited]	[DD/MM/YYYY]
[Employee ID]	[Employee Name]	[Department]	[Designation]	[Reporting Manager]	[DD/MM/YYYY]	[Permanent / Contract / Trainee]	[Work Location]	[UAN]	[ESIC No. / NA]	[Active / Notice / Exited]	[DD/MM/YYYY]

Column guidance

Emp ID: never reuse an ID after an employee exits.
Employment Type: use only the values in your drop-down list.
ESIC No.: enter NA where wages exceed the ESI coverage limit of ₹21,000 per month.
Status: change to Exited only after the last working day is confirmed.

Privacy notice: [Company Name] collects the details on this page only for workforce administration, payroll and statutory reporting. Access is limited to authorised HR staff, and the record will be kept for as long as the employee is on the rolls and for the archival period in the records retention policy, after which it will be securely deleted or destroyed. You may ask HR to see or correct your data, consistent with the Digital Personal Data Protection Act, 2023.

Prepared by
[HR Name]
Date: [Date]

Reviewed by
[Authorised Signatory]
Date: [Date]

Download Word (.docx) — free

What this template includes

Unique employee ID column as the primary key
Department, designation and reporting manager for organisation charts
Joining date and employment type for tenure and gratuity tracking
UAN and ESIC columns for statutory reconciliation
Status column (active, notice, exited) to avoid paying leavers
Last-updated column to show data freshness

When to use it

Small companies that do not yet use an HRMS
Preparing a clean data file before migrating to new HR software
Sharing headcount data with payroll vendors on a need-to-know basis
Monthly reconciliation of payroll against active headcount

How to customise this template

1Copy the table into Excel or Google Sheets and freeze the header row
2Add data-validation lists for department, status and employment type
3Remove columns you will not use so the sheet stays lean
4Protect the file with a password and restrict sharing to HR and payroll
5Set a monthly review date in your HR calendar

HR tips

Keep sensitive data like bank account numbers in a separate restricted file
Never email the full sheet to vendors; share only required columns
Use DD/MM/YYYY consistently to avoid date errors
Keep a version history so you can trace who changed what

For HR & hiring managers

Experienced and fresher candidates across India — blue, grey and white collar. Post a job in 5 minutes and start receiving applications.

Post a job free See plans

Post in 5 minutesDescribe the role in one line — we write the job description.
Verified applicantsEvery applicant has a verified mobile number.
Resume databaseSearch experienced candidates by skill, city and experience.

Frequently asked questions

What is employee master data?+

It is the core set of facts about each employee, such as ID, name, department, designation, joining date and status, that other HR processes depend on.

Should salary be part of the master data sheet?+

Keep CTC in a separate payroll file with tighter access. The master sheet is viewed by more people and should hold only what they need.

How often should the master data sheet be updated?+

Update it on every joining, transfer, promotion or exit, and reconcile it fully with payroll at least once a month.

All 50 employee personal & master records →

[Company Logo][Company Name]

EMPLOYEE MASTER DATA AUDIT REPORT

Company:: [Company Name]
System Audited:: [HRMS Name]
Extract Date:: [DD/MM/YYYY]
Records Tested:: [n]
Auditor:: [Auditor Name]

1. Scope

This audit covers active and recently exited employee records in the HRMS master as on the extract date, reconciled with the payroll register for [Month YYYY].

2. Test Results

Test	Description	Records with Error	Error %	Status
Duplicates	Same PAN or name and date of birth under two IDs	[n]	[%]	[Pass / Fail]
Completeness	Blank mandatory fields (UAN, PAN, joining date)	[n]	[%]	[Status]
Validity	Invalid PAN or IFSC formats, future dates	[n]	[%]	[Status]
Status accuracy	Exited employees still marked active	[n]	[%]	[Status]
Payroll match	HRMS active list vs payroll register	[n]	[%]	[Status]
Privacy	Full Aadhaar, health or other unnecessary data stored	[n]	[%]	[Status]

3. Data-quality Score

Report · Word

Employee Master Data Audit

Download .docx

[Company Logo][Company Name]

Name of Establishment:: [Company Name]
Address:: [Company Address]
Registration No.:: [Registration Number]
Register Period:: [DD/MM/YYYY] to [DD/MM/YYYY]

Sl. No.	Emp ID	Name of Employee	Father / Spouse Name	Gender	Date of Birth	Designation	Nature of Employment	Date of Joining	Date of Leaving	Reason for Leaving	Initials of Authorised Person
1	[Employee ID]	[Employee Name]	[Name]	[M/F/Other]	[DD/MM/YYYY]	[Designation]	[Permanent / Fixed-term / Contract]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Resignation / Retirement / Other]	[Initials]
2	[Employee ID]	[Employee Name]	[Name]	[M/F/Other]	[DD/MM/YYYY]	[Designation]	[Nature]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Reason]	[Initials]
3	[Employee ID]	[Employee Name]	[Name]	[M/F/Other]	[DD/MM/YYYY]	[Designation]	[Nature]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Reason]	[Initials]

Instructions for maintaining this register

Enter employees in order of joining and keep serial numbers continuous.
Fill Date of Leaving and Reason for Leaving only after exit formalities are complete.
Corrections must be struck through once, rewritten and initialled with the date.
The register must not hold bank, health or full Aadhaar details.
Produce the register when requested by an authorised inspector.

Privacy notice: [Company Name] collects the details on this page only for maintaining the statutory register of employees and confirming service history. Access is limited to authorised HR staff, and the record will be kept for the period required by applicable labour laws and the company retention policy, after which it will be securely deleted or destroyed. You may ask HR to see or correct your data, consistent with the Digital Personal Data Protection Act, 2023.

Maintained by
[HR Name]
[Designation]

Certified by
[Authorised Signatory]
For [Company Name]

Employee Master Register

Download .docx

[Company Logo][Company Name]
PERSONAL DATA CORRECTION FORM
Employee Name:
[Employee Name]
Employee ID:
[Employee ID]
Request Date:
[Date]
Request No.:
[Reference Number]
Field Incorrect Value in Records Correct Value Proof Attached
[Name spelling] [Incorrect] [Correct] [PAN]
[Date of Birth] [DD/MM/YYYY] [DD/MM/YYYY] [Class 10 certificate]
[Field] [Incorrect] [Correct] [Proof]
Systems Corrected (HR use)
System / Document Corrected On By
HRMS [DD/MM/YYYY] [HR Name]
Payroll [DD/MM/YYYY] [Name]
PF / ESIC [DD/MM/YYYY] [Name]
Insurance [DD/MM/YYYY] [Name]
Letters reissued [DD/MM/YYYY] [Name]
HR will complete the correction within [number] working days and confirm to you by email. The previous value is kept only in a restricted audit log, as required for accountability, in line with your right to correction under the Digital Personal Data Protection Act, 2023.
Declaration
Form · Word
Employee Personal Data Correction Form
Download .docx
[Company Logo][Company Name]
EMPLOYEE PERSONAL DATA ACCESS REQUEST
Request No.:
[Reference Number]
Date Received:
[Date]
Received by:
[HR Name]
1. Requester
Name [Employee Name]
Employee ID [Employee ID]
Status (Current / Former employee)
Registered mobile / personal email
2. What would you like to know?
- Summary of personal data held about me
- Copy of my personnel file documents
- Payroll and statutory data
- Purposes for which my data is used
- Names or categories of parties my data was shared with (e.g. payroll vendor, insurer)
- Other: [Specify]
Period covered (from – to)
Preferred format (summary / copies / view in person)
Form · Word
Employee Data Access Request
Download .docx
[Company Logo][Company Name]
REQUEST FOR CORRECTION OF PERSONAL DATA
Date:
[Date]
To,
[HR Name]
Head – Human Resources / Data Protection Contact
[Company Name]
[Company Address]
Subject: Request for Correction of My Personal Data – [Employee Name], Employee ID [Employee ID]
Dear [HR Name],
I am writing to request correction of certain personal data held about me by [Company Name]. I was / am employed as [Designation] in the [Department] department from [Date of Joining] [to Last Working Day, if applicable].
The following details are inaccurate or no longer required:
Letter · Word
Employee Data Correction Request
Download .docx
[Company Logo][Company Name]
EMPLOYEE PERSONAL INFORMATION FORM
Company:
[Company Name]
Employee ID:
[Employee ID]
Date of Joining:
[Date of Joining]
Form Date:
[Date]
1. Personal Details
Full Name (as per PAN / ID)
Preferred Name
Date of Birth (DD/MM/YYYY)
Gender (optional)
Nationality
Marital Status (optional)
2. Contact Details
Personal Mobile Number
Alternate Mobile Number
Personal Email ID
Current Address with PIN Code
Permanent Address with PIN Code
3. Statutory and Payroll Details
Form · Word
Employee Personal Information Form
Download .docx

Field	Incorrect Value in Records	Correct Value	Proof Attached
[Name spelling]	[Incorrect]	[Correct]	[PAN]
[Date of Birth]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Class 10 certificate]
[Field]	[Incorrect]	[Correct]	[Proof]

System / Document	Corrected On	By
HRMS	[DD/MM/YYYY]	[HR Name]
Payroll	[DD/MM/YYYY]	[Name]
PF / ESIC	[DD/MM/YYYY]	[Name]
Insurance	[DD/MM/YYYY]	[Name]
Letters reissued	[DD/MM/YYYY]	[Name]

Name	[Employee Name]
Employee ID	[Employee ID]
Status (Current / Former employee)
Registered mobile / personal email

Period covered (from – to)
Preferred format (summary / copies / view in person)

Full Name (as per PAN / ID)
Preferred Name
Date of Birth (DD/MM/YYYY)
Gender (optional)
Nationality
Marital Status (optional)

Personal Mobile Number
Alternate Mobile Number
Personal Email ID
Current Address with PIN Code
Permanent Address with PIN Code

[Company Logo][Company Name]

EMPLOYEE DATABASE FORMAT – FIELD DICTIONARY

Organisation:: [Company Name]
Version:: [Version Number]
Approved on:: [DD/MM/YYYY]
Data Owner:: [HR Name]

This field dictionary defines the employee database for [Company Name]. Each field must have a stated purpose; fields without a purpose are not collected.

Field Name	Data Type / Format	Mandatory	Purpose	Access Level	Retention
Employee ID	Alphanumeric, unique	Yes	Primary key across systems	All HR, payroll, manager	Permanent (service record)
Full Name	Text, as per PAN	Yes	Identification, payslips	All HR, payroll, manager	Employment + retention period
Date of Birth	DD/MM/YYYY	Yes	Age checks, PF records	HR, payroll	Employment + retention period
Aadhaar	Last 4 digits only	No	Identity check, PF KYC	HR only	Employment + retention period
Bank Account / IFSC	Numeric / 11-character code	Yes	Salary credit	Payroll only	Employment + retention period
[Field Name]	[Format]	[Yes / No]	[Purpose]	[Role]	[Period]

Access levels

HR administrator: full read and edit access.
Payroll: salary, bank, statutory fields only.
Reporting manager: work-related fields for direct reports only.
Employee: read access to own record through self-service.

Privacy notice: [Company Name] collects the details on this page only for designing and operating the employee database. Access is limited to authorised HR staff, and the record will be kept for the retention periods listed against each field above, after which it will be securely deleted or destroyed. You may ask HR to see or correct your data, consistent with the Digital Personal Data Protection Act, 2023.

Template · Word

Employee Database Format

Download .docx

[Company Logo][Company Name]
EMPLOYEE ID ALLOCATION FORM
Form No.:
[Reference Number]
Date of Request:
[Date]
Requested by:
[HR Name]
A. Joiner Details
Name of Joiner [Employee Name]
Designation [Designation]
Department [Department]
Reporting Manager [Reporting Manager]
Work Location [Work Location]
Date of Joining [Date of Joining]
B. Category
- Permanent employee
- Fixed-term employee
- Trainee / Apprentice
- Intern
- Rejoining employee (previous ID: [Employee ID])
C. Allocation (HR Operations)
Form · Word
Employee ID Allocation Form
Download .docx

Name of Joiner	[Employee Name]
Designation	[Designation]
Department	[Department]
Reporting Manager	[Reporting Manager]
Work Location	[Work Location]
Date of Joining	[Date of Joining]

Employee Master Data Sheet

Preview of the template

Column guidance

What this template includes

When to use it

How to customise this template

HR tips

Hire top talent from BetterJobs

Frequently asked questions

Related HR templates