Wage Sheet Format in Excel with Overtime Calculation

Labour & wages6 min read

Paying construction workers looks simple until month-end: different daily rates, half days, overtime, advances given at odd times and workers who moved between sites. A wage sheet brings all of that into one table, one row per worker, so the amount paid can be explained line by line. This guide covers the columns a construction wage sheet needs, the formulas for hourly rate and overtime, how to deduct advances, and a free Excel format with the formulas already in place.

What is a wage sheet?

A wage sheet is the statement of what each worker earned and is paid for one wage period, usually a week, a fortnight or a month. It takes the days worked and overtime hours from the muster roll, applies each worker’s wage rate, subtracts deductions such as advances, and arrives at the net amount paid.

For a contractor it does three jobs: it tells you how much cash to arrange, it gives each worker a clear account of their pay, and it is the record you show when a worker, labour contractor or client questions a payment.

Pick one wage period per site and keep to it. Weekly wages suit sites with a lot of casual labour, because workers expect to be paid often and advances stay small. Monthly wages suit a steady crew. Whatever the period, the wage sheet should cover exactly the same dates as the muster roll it is built from, so the totals can be matched one to one.

Wage sheet columns for construction workers

Columns in a construction wage sheet, in order.
ColumnWhat goes in it
Worker ID, name, trade, contractorFrom your worker register
Daily wage (₹)The agreed rate for this worker
Days workedFull days plus half of the half days, from the muster roll
Earned wagesDaily wage × days worked
Shift hours per dayNormal working hours in the shift, as per the contract
Hourly rateDaily wage ÷ shift hours
Overtime hoursFrom the overtime grid of the muster roll
Overtime multiplierThe rate your contract or applicable rules set, e.g. 1, 1.5 or 2 times
Overtime amountHourly rate × overtime hours × multiplier
Other additionsAny allowance you have agreed to pay
Gross payEarned wages + overtime amount + other additions
Advance deductedThe part of any advance recovered this period
Other deductionsAnything else agreed or required
Net payGross pay − advance deducted − other deductions
Payment reference and signatureBank or UPI reference, or the worker’s signature or thumb impression for cash
Free wage sheet format (Excel)One row per worker with hourly rate, overtime, advance and net pay formulas, plus an advance register.Free download · Excel · no sign-up

Run your labour & attendance on CivilPilot

Workers, contractors, shifts and daily attendance for every site, turned into wage sheets without a spreadsheet.

Daily wage to hourly rate: the formula

Most construction workers are paid a daily wage, but overtime is paid by the hour. So you first convert the daily wage into an hourly rate:

Hourly rate = Daily wage ÷ Normal working hours per day

Use the normal working hours of the shift as defined in your contract or appointment terms, usually excluding the meal break. In the Excel format above, the daily wage is in column F and shift hours in column I, so the hourly rate on row 2 is =F2/I2. Days worked, counting half days, is =COUNTIF(range,"P")+0.5*COUNTIF(range,"H") on the muster roll.

Worked example: overtime calculation for a daily-wage worker

All figures here are assumptions for the example. In particular, assume your contract pays overtime at twice the ordinary hourly rate. Your actual overtime rate depends on your contract and on the labour rules that apply in your state.

One mason’s wage for the month (example figures).
LineCalculationAmount
Daily wageAssumed₹800
Shift hoursAssumed 8-hour shift8
Hourly rate₹800 ÷ 8₹100
Days worked25 full days + 2 half days26
Earned wages₹800 × 26₹20,800
Overtime hoursFrom the overtime grid12
Overtime amount₹100 × 12 × 2 (assumed rate)₹2,400
Gross pay₹20,800 + ₹2,400₹23,200
Advance deductedRecovered this month₹3,000
Net pay₹23,200 − ₹3,000₹20,200

If your contract paid overtime at the ordinary rate instead, the multiplier would be 1 and the overtime amount would be ₹1,200. That one assumption changes the pay by ₹1,200, which is why the multiplier belongs in its own column where anyone checking the sheet can see it.

Deducting advances without disputes

Advances are normal on construction sites, and they cause more wage arguments than anything else. Keep a separate advance register alongside the wage sheet:

  • Record every advance the day it is given: worker, date, amount and who approved it.
  • Agree the recovery up front: in one wage period or spread over several.
  • Show the balance: advance given − recovered so far = balance still to recover.
  • Never deduct more than the worker earned. A wage sheet should not turn into a debt on the worker. Carry any remaining balance to the next period.

Whether other deductions, such as statutory contributions, apply to your workers depends on your establishment and the laws that cover it. Confirm that with your compliance advisor rather than adding columns by guesswork.

Common wage sheet mistakes

  • Typing days worked by hand. Days should come from the muster roll, not from memory or a contractor’s note.
  • One overtime rate hidden in a formula. Keep the multiplier visible in a column.
  • Advances settled in cash with no record. If it is not in the advance register, it did not happen.
  • No payment reference. For bank or UPI payments, note the reference; for cash, take a signature or thumb impression.
  • One sheet for all projects. Make a sheet per project, so labour cost is booked where the work was done.

Do this in CivilPilot

A wage sheet in Excel is only as reliable as the attendance typed into it. In CivilPilot’s labour and attendance module, the wage sheet is generated from the attendance the site has already marked, so the two cannot drift apart.

  • Worker register: trade, skill, daily wage and labour contractor for each worker, with CSV import for an existing list.
  • Daily attendance: present or absent with check-in, check-out and overtime, marked from a phone browser on site.
  • Muster roll: attendance for any period, by project, to check before you pay.
  • Wage sheets: generated for the period from attendance. Half days count as half. Overtime is priced at the hourly rate on the worker’s record, or the daily wage ÷ 8 when no hourly rate is set, so if your overtime rate is higher, set that rate on the worker.
  • Advances: recorded against the worker and deducted on the wage sheet, never taking net pay below zero. Mark the sheet paid once wages are out.

Expenses, budgets and project P&L are in finance and billing. CivilPilot’s wage sheets do not calculate statutory deductions such as PF or ESI; handle those with your accountant or compliance advisor.

Frequently asked questions

Start counting what your sites really use.

Set up your first project today. Your site engineers can send their first daily report this afternoon.

  • 7-day free trial
  • No credit card
  • Cancel anytime
  • Made in India