HR & Labour Registers in Excel (Code on Wages Rules 2026) — Free Template

The four new Labour Codes have reshaped statutory record-keeping for employers. The Code on Wages, 2019 came into force on 21 November 2025, and the Code on Wages (Central) Rules, 2026 (notified 8 May 2026) prescribe a streamlined set of registers that may now be kept electronically. This free Excel workbook bundles them into a single file — enter your establishment details once on the cover sheet and they flow into every register.

HR & Labour Registers — Excel Workbook
Form I, IV, IX and V in one file • Code on Wages (Central) Rules, 2026 • free, no sign-up

⬇ Download Excel Workbook

What is inside the workbook

Employee Register
Form I • Rule 51(1)(i)
All 31 prescribed particulars of each employee — code, joining date, designation, UAN, PAN, bank and exit details.
View format →HR Letters generator →
Register of Wages & Deductions
Form IV • Rule 51(1)(ii)
Wages, overtime, advances, fines and deductions with auto-calculated gross, total deductions and net pay.
View format →Salary Structure Planner →
Attendance Register-cum-Muster Roll
Form IX • Rule 51(1)(iii)
31-day attendance grid with status codes and an auto count of days present, overtime and tour details.
View format →Salary Structure Planner →
Wage Slip
Form V • Rule 52
A printable pay slip with auto gross, total deductions and net wages — issue to each employee on payment.
View format →HR Letters generator →
Enter your establishment name, employer, PAN/TAN and LIN once on the Cover & Instructions sheet; they auto-fill every register header. Form IV totals and Form V net pay are calculated automatically.

How to use it

  1. Download the workbook and open it in Excel or any spreadsheet app.
  2. Fill the Cover & Instructions sheet with your establishment particulars.
  3. Maintain Form I, IV and IX as employees join, are paid and mark attendance; issue the Form V wage slip on or before payment.
  4. Draft the supporting letters and salary structures with our HR Letters generator and Salary Structure Planner.

Frequently asked questions

Which registers must an employer maintain under the new Labour Codes?

Under the Code on Wages (Central) Rules, 2026, every employer must maintain an Employee Register (Form I), a Register of Wages, Overtime, Advances, Fines and Deductions (Form IV) and an Attendance Register-cum-Muster Roll (Form IX), and must issue a wage slip in Form V on or before payment of wages.

Can these registers be kept in Excel or electronic form?

Yes. The Rules expressly allow registers to be maintained electronically or physically, which is why a digital Excel format is acceptable for most establishments.

How long must labour registers be preserved?

Registers maintained under the Wage Rules must be preserved for five years from the date of the last entry.

Disclaimer: This workbook is provided free for general record-keeping convenience and does not constitute legal or professional advice. Maintain these registers in the formats and within the timelines prescribed under the Code on Wages, 2019 and the Code on Wages (Central) Rules, 2026, and applicable State rules. State-specific establishments may need to follow the corresponding State-rule formats. Verify with your labour-law adviser.

Scroll to Top