Wage Register Format — Free Excel and App
A wage register records what each worker earned in a period, deductions made and the net amount paid.
Employers use a wage register to show how pay was worked out, from days worked to deductions to net payment, in one place.
Wage Register format preview
| Worker name | Days worked | Daily rate | Gross wages | Deductions | Advance recovered | Net paid | Date paid |
|---|---|---|---|---|---|---|---|
| Suresh Yadav | 26 | ₹600 | ₹15,600 | ₹500 | ₹1,000 | ₹14,100 | 05-Nov-2026 |
The second row is a filled sample.
What each column means
Worker name
Example: Suresh Yadav
Days worked
Example: 26
Daily rate
Example: ₹600
Gross wages
Example: ₹15,600
Deductions
Example: ₹500
Advance recovered
Example: ₹1,000
Net paid
Example: ₹14,100
Date paid
Example: 05-Nov-2026
Please note: Rules on which records you must keep, and in what layout, can differ by state and by business type. Check the requirement that applies to you with your CA or labour consultant before adopting any format.
Wage Register FAQs
What is a wage register?
A register of each worker's earnings, deductions and net pay for a pay period.
What goes in a wage register?
Worker name, days worked, rate, gross wages, deductions, advances recovered, net amount and date of payment.
How is net wage calculated?
Gross wages minus deductions and any advance being recovered.
Can the wage register pull from attendance?
In Recordbook you can link attendance totals to wages with a formula column so you do not retype days worked.
Related registers
Muster Roll
Format and sample
Attendance Register
Format and sample
Salary Advance Register
Format and sample
Running a manufacturing business? See Recordbook for manufacturing · Recordbook vs Excel