Free template template · Word

Employee Skill Matrix

An employee skill matrix is a grid showing each team member against the skills the team needs, rated on a simple scale. Managers use it to spot single points of failure, plan cross-training and assign work to people who are ready for it.

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

Download Word (.docx) — free

Preview of the template

[Highlighted] = fill in

[Company Logo][Company Name]

TEAM SKILL MATRIX

Department / Team:: [Department]
Prepared by:: [Reporting Manager]
Assessment Date:: [DD/MM/YYYY]

Rating Scale

0 – Not trained
1 – Under training
2 – Can perform with supervision
3 – Can perform independently to standard
4 – Expert; can train others

Employee Name	Emp ID	[Skill 1]	[Skill 2]	[Skill 3]	[Skill 4]	[Skill 5]	[Skill 6]	Training Need	Target Date
[Employee Name]	[Employee ID]	[0-4]	[0-4]	[0-4]	[0-4]	[0-4]	[0-4]	[Skill / Programme]	[DD/MM/YYYY]
[Employee Name]	[Employee ID]	[0-4]	[0-4]	[0-4]	[0-4]	[0-4]	[0-4]	[Skill / Programme]	[DD/MM/YYYY]
[Employee Name]	[Employee ID]	[0-4]	[0-4]	[0-4]	[0-4]	[0-4]	[0-4]	[Skill / Programme]	[DD/MM/YYYY]
[Employee Name]	[Employee ID]	[0-4]	[0-4]	[0-4]	[0-4]	[0-4]	[0-4]	[Skill / Programme]	[DD/MM/YYYY]
People at level 3+		[n]	[n]	[n]	[n]	[n]	[n]
Required at level 3+		[n]	[n]	[n]	[n]	[n]	[n]

Gaps and Actions

Skills below required coverage
Cross-training plan
Next review date

Ratings are used only for training and work-planning purposes and are shared with the employee concerned, HR and the department head.

Prepared by
[Reporting Manager]
Date: [Date]

Reviewed by
[HR Name]
Date: [Date]

Download Word (.docx) — free

What this template includes

Skills listed as columns, specific enough to assess
Clear 0–4 rating scale with definitions
Target level per skill for the team
Gap and backup indicators
Training action and due date
Assessed-by and date for credibility

When to use it

Planning cover for leave and shift rotations
Identifying training needs before the annual budget
Preparing for audits that ask for operator qualifications
Allocating new projects to the right people

How to customise this template

1List 6–12 skills that matter most to the team's output
2Agree rating definitions with supervisors before scoring
3Set the minimum number of people needed at level 3 or higher per skill
4Colour-code cells in Excel for quick reading
5Review quarterly and after every training

HR tips

Rate on observed work, not on self-claims alone
Avoid using the matrix as a performance rating
Share each employee's own row with them
Keep at least two trained people for every critical skill

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 a skill matrix used for?+

It shows who can do what, so managers can plan training, backups and work allocation.

What rating scale should a skill matrix use?+

A simple 0–4 scale works well: not trained, in training, can do with help, can do independently, can train others.

Is a skill matrix the same as a competency matrix?+

No. A skill matrix covers specific job tasks; a competency matrix covers broader behaviours and capabilities.

All 50 employee personal & master records →

[Company Logo][Company Name]

COMPETENCY MATRIX

Employee Name:: [Employee Name]
Designation:: [Designation]
Department:: [Department]
Assessment Period:: [DD/MM/YYYY] to [DD/MM/YYYY]

Proficiency Levels

1 – Basic: aware, needs guidance
2 – Developing: applies with some support
3 – Proficient: applies consistently on own
4 – Advanced: handles complex situations, coaches others
5 – Role model: shapes practice across the organisation

Competency Area	Competency	Expected Level	Self Rating	Manager Rating	Gap	Evidence / Example	Development Action
Core	Customer focus	[1-5]	[1-5]	[1-5]	[n]	[Example]	[Action]
Core	Integrity and accountability	[1-5]	[1-5]	[1-5]	[n]	[Example]	[Action]
Functional	[Role-specific competency]	[1-5]	[1-5]	[1-5]	[n]	[Example]	[Action]
Functional	[Role-specific competency]	[1-5]	[1-5]	[1-5]	[n]	[Example]	[Action]
Leadership	Developing others	[1-5]	[1-5]	[1-5]	[n]	[Example]	[Action]

Summary

Top strengths
Priority development areas
Promotion readiness (Ready now / 1–2 years / Not yet)
Next review date

Template · Word

Employee Competency Matrix

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

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 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.

Template · Word

Employee Master Data Sheet

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]

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]

[Company Logo][Company Name]

EMPLOYEE CODE REGISTER

Company / Entity:: [Company Name]
Code Series:: [Prefix]-0001 to [Prefix]-9999
Register Owner:: [HR Name]

Employee Code	Employee Name	Department	Category	Allocation Form Ref.	Date Issued	Date Deactivated	Access Removed (Y/N)	Status	Remarks
[Employee ID]	[Employee Name]	[Department]	[Permanent / Contract / Intern]	[Reference Number]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Y/N]	[Active / Deactivated]	[Remarks]
[Employee ID]	[Employee Name]	[Department]	[Category]	[Reference Number]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Y/N]	[Status]	[Remarks]
[Employee ID]	[Employee Name]	[Department]	[Category]	[Reference Number]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Y/N]	[Status]	[Remarks]
[Employee ID]	[Unallotted]	-	-	-	-	-	-	[Available]	[Next in series]

Rules

Each code is allotted once and is never reused.
Every row must reference an approved Employee ID Allocation Form.
On exit, enter the last working day as the deactivation date within two working days.
Quarterly, reconcile active codes with the payroll register and note mismatches below.

Quarterly reconciliation date
Mismatches found
Action taken

This register holds only the details needed to control employee codes. It is accessible to HR operations and internal audit only, as part of the company's data-minimisation practice under the Digital Personal Data Protection Act, 2023.

Employee Code Register

Download .docx

[Company Logo][Company Name]

EMPLOYEE PHOTO REGISTER

Company:: [Company Name]
Location:: [Work Location]
Maintained by:: [HR Name]

Sl.	Employee ID	Employee Name	Date Taken	Purpose	Consent for Optional Use (Y/N)	Storage Location	Deletion Due	Deleted On	HR Initials
1	[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[ID card / Access system]	[Y/N]	[HRMS / Folder path]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Initials]
2	[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[Purpose]	[Y/N]	[Location]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Initials]
3	[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[Purpose]	[Y/N]	[Location]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Initials]

Permitted purposes

Essential: photo ID card, access control, HRMS profile.
Optional (consent needed): intranet directory, website, brochures, event coverage.

Employee consent for optional use

I, [Employee Name], agree that my photograph may be used for: [Optional Purpose]. I understand I can withdraw this consent at any time by writing to HR, and that withdrawal will not affect my employment.

Employee Photo Register

Download .docx

Employee Skill Matrix

Preview of the template

Rating Scale

Gaps and Actions

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