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.
Workplace scene for Employee master data field list

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

How to use this template

  1. HR lists every field the business really uses, and removes the ones nobody reads.
  2. Mark each field as mandatory, optional or restricted, and name who may see and edit it.
  3. Fill it at joining from documents, not from memory. Check against originals.
  4. Update on any change: promotion, address, bank, nominee, exit. Record the date and the person who changed it.
  5. Keep sensitive fields, such as identity and bank numbers, in a protected sheet or system.
  6. Audit a sample of records every quarter against source documents.

A filled example (illustrative)

This example is invented for illustration. Replace every value with your own.

FieldExample valueAccess
Employee IDE-0042HR, manager
DesignationStore SupervisorHR, manager
Reporting managerArea ManagerHR, manager
Bank accountHeld securelyHR and payroll only
Emergency contactRelation and phoneHR only

Common mistakes

  • Keeping the same data in three sheets that disagree with each other.
  • Letting everyone with the file open see pay and identity numbers.
  • Never updating after a promotion or transfer, so reports show old titles.
  • Collecting fields because a form asked for them, without a purpose.
  • No change history, so nobody can say who edited a bank detail.

Adapt it to your business

  • Factory: add token or badge number, shift, skill grade and contractor link where relevant.
  • Shop: add store code, reporting area manager and uniform size.
  • Clinic: add registration number, specialty and licence renewal dates.
  • Office: add cost centre, work location and asset issued.

Questions about this template

A protected HR system or a locked sheet with named access. Avoid sharing it by email.

Start with your business need

What does your HR team need to solve?

Tell us your industry, team size and the issue you want to address. Bring one example of where work gets delayed or ownership is unclear, and the deadline or decision you are working towards.

  • A free first conversation with an HR practitioner
  • A clear scope and fee before any paid work
  • A practical next step for your business

Let’s start with your business

Share your contact details and the HR challenge on your mind. We’ll help you find the right starting point.

Include your country code, for example +44 or +1. Indian numbers can be 10 digits.

Your details stay private. Privacy policy