Skip to main content
GullyHR
Free template

Employee master data field list

Use this list to set up an employee master in a spreadsheet or an HR system, or to check one you already have. Adapt it by adding or removing fields to suit your business, and have the choice of statutory and personal fields reviewed by your legal adviser.

Download for WordFree. No sign-up.

Personal details

FieldNoteOwner
Employee IDUnique, never reused after someone leavesHR
Full name as on identity documentKeep a separate preferred name if neededEmployee, checked by HR
Date of birthCheck against the identity documentEmployee
GenderOptional field if used for reportingEmployee
Marital statusAdd only if needed for a benefit or formEmployee
Nationality Employee
Blood groupUseful for emergencies at sitesEmployee
Photograph Employee

Job and organisation

FieldNoteOwner
Date of joining HR
Employment typePermanent, fixed term, contract, intern, traineeHR
Designation and gradeLinked to the salary bandHR
Department, cost centre, legal entityNeeded for payroll and reportsHR
Reporting managerUpdate on every change in reporting lineHR
Work location and work mode HR
Probation end date and confirmation date HR
Notice periodAs per appointment letterHR
Shift and weekly off pattern Manager and HR
StatusActive, on notice, on leave, separatedHR

Pay and bank

FieldNoteOwner
Annual CTC (₹) and pay componentsRestrict access to payroll and HRPayroll
Variable pay or incentive plan Payroll
Bank name, account number, IFSCCheck against a cancelled cheque or passbookEmployee, checked by payroll
Pay revision historyDate, old and new pay, approval referencePayroll
Advances, loans and recoveriesLinked to approvalsFinance

Statutory and identity numbers

Keep only the numbers you need for payroll, tax and the registrations that apply to your establishment. Examples are PAN, Aadhaar where you are permitted to hold it, provident fund and insurance numbers, and other state registrations. Which ones apply to you is a question for your legal adviser or compliance consultant.

  • PAN or tax identification: [Field].
  • Provident fund and pension account number: [Field, if applicable].
  • Employee insurance number: [Field, if applicable].
  • Other registrations required for your state or sector: [Field].
  • Nominee details for benefits: [Name, relationship, share].

Contact, documents and history

  • Current and permanent address, official phone number, personal email.
  • Emergency contact: name, relationship, phone number.
  • Education and qualifications, with certificate status: seen, verified, pending.
  • Previous employment: employer, designation, dates, experience letter status.
  • Documents on file: appointment letter, policy acknowledgements, confidentiality agreement, certificates, probation outcome.
  • Movement history: promotions, transfers, role and manager changes, each with effective date and approval.
  • Exit details: resignation date, last working day, reason category, clearance and settlement status.

Looking after the data

  • Give access by role: pay and bank fields only to payroll and HR, medical details only to HR.
  • Keep a log of who changed which field and when.
  • Let employees view and correct their own details through a form or self-service.
  • Collect only what you will use. Remove fields nobody uses.
  • Agree how long records are kept after exit and how they are disposed of, after taking advice from your legal adviser.

A starting point, not legal advice. Check the final wording against your contracts and the rules of your state, and have a qualified professional review it before you issue it.

Let’s find your next step

Is your HR process ready to scale?

Identify critical compliance gaps, payroll leaks, and hiring bottlenecks with a free HR Health Check. Get each area scored, with the fixes ranked by cost and impact.

Want the full picture? See the paid HR Diagnostic.

Prefer a quick message? Chat on WhatsApp

Talk to an HR consultant

Tell us where to reach you. All fields are required unless marked optional.

10-digit Indian mobile, without +91.

Your details stay private. Privacy policy