A weekly labour register is one sheet where every worker's days, agreed rate, advance and payment are written down on the same day you pay. Each row works out gross wages, subtracts any advance taken and shows the balance paid. With a stage column, the same sheet tells you what each phase of construction cost in labour.
What columns should the register have?
| Column | What to write |
|---|---|
| Week starting | Date of the Monday or whichever day your week starts |
| Name and role | Mason, helper, bar bender, electrician, plumber |
| Stage | Foundation, structure, finishing and so on |
| Days worked | Count of days, half days as 0.5 |
| Rate agreed | Per day, as agreed before work started |
| Gross | Days worked times the rate |
| Advance recovered | Advance deducted this week |
| Balance paid | Gross minus advance recovered |
| Mode and reference | UPI reference, cash, or cheque number |
What do the formulas look like?
Put Days worked in column D, Rate in E, Gross in F, Advance recovered in G and Balance paid in H, with data from row 2 down. Then use these.
- Gross in F2: =D2*E2
- Balance paid in H2: =F2-G2
- Total paid in a week, with week start dates in column A and the date to match in K1: =SUMIFS($H$2:$H$500, $A$2:$A$500, $K$1)
- Total gross for one stage, with stage names in column C and the stage in K2: =SUMIFS($F$2:$F$500, $C$2:$C$500, $K$2)
Copy the formulas down each row. SUMIFS takes the range to add first, then the range to check, then what to match, in both Excel and Google Sheets.
A worked week with made-up numbers
| Worker | Days | Rate | Gross | Advance recovered | Balance paid |
|---|---|---|---|---|---|
| Mason | 6 | ₹900 | ₹5,400 | ₹1,000 | ₹4,400 |
| Helper | 4 | ₹600 | ₹2,400 | ₹0 | ₹2,400 |
| Week total | 10 | - | ₹7,800 | ₹1,000 | ₹6,800 |
Check: 6 × 900 = 5,400 and 4 × 600 = 2,400, giving 7,800 gross. After the ₹1,000 advance recovered, 7,800 minus 1,000 is ₹6,800 paid. These are illustrations; use the rates you agreed.
How should I handle advances?
Write the advance in a separate small list when you give it, with the date, the amount and the person's initials, and then recover it in the weekly rows over the weeks you agreed. Keep a running balance per person so everyone knows what is still pending.
What should I do about cash payments?
If you pay in cash, ask the worker or the mestri to sign or put initials against the row at payment time, and write the amount in words. A UPI payment already leaves a reference. For wages shared among a team, note who received the money on behalf of whom.
When a sheet stops being enough
For one house a sheet is plenty. If you want your UPI-paid wages to show up with your other spending, you can upload the bank statement to SpendixAI, review the rows and tag them. The weekly register still holds the details the bank statement does not.
What about festival bonuses and gifts?
In India it is common to give workers a festival bonus or sweets before Diwali or Ugadi. Record any such amount in its own row with the note 'festival bonus', so it does not disappear into the wage totals. If you agreed it in advance with the contractor, mention that in the note, because it affects how you read the labour total for that week.
A weekly routine
- Fill the days worked on the same evening.
- Confirm the total with the mestri before paying.
- Pay, then enter the reference.
- Check the stage total against what you planned.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

