Manpower Supply Timesheet Format in Excel (Free Download)
The sheet a site supervisor signs is the proof of the work, and every dirham is counted from it. Here is a format that works, a free Excel file, and the mistakes worth designing out.
- A manpower timesheet, also called a labour attendance sheet, is a monthly table for one site. One row for each worker, one column for each day.
- It must carry the site, the month, each worker's number, the hours of every day, an A for absent, the totals, and the supervisor's signature.
- The free Excel format below adds up total hours, overtime, rest-day hours and absent days by itself.
- Keep one sheet for each site and month, and never let a total be typed by hand.
What a manpower supply timesheet is
A manpower supply company sends its workers to a customer's site and is paid for every hour they work there. The timesheet is the record of those hours: who worked, on which day, for how long. Some offices call it a labour attendance sheet or a time sheet. It is the same paper.
It is used twice. The customer is billed from it, and the worker is paid from it. A wrong box is therefore wrong two times: once on an invoice and once in a salary.
| Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Total |
|---|---|---|---|---|---|---|---|---|
| Ravi K. | 8 | 8 | 10 | 8 | 8 | 8 | 50 | |
| Imran S. | 8 | 8 | 8 | A | 8 | 8 | 40 | |
| Suresh B. | 9 | 9 | 8 | 8 | 8 | 9 | 51 |
What the sheet must carry
Most arguments about a timesheet come from something that was never written on it. These are the parts that settle an argument before it starts.
| On the sheet | Why it matters |
|---|---|
| Your company, the customer and the site | One sheet belongs to one site. A worker who moves in the middle of the month appears on two sheets. |
| The month | Write the month and the year, not only "Week 2". |
| Each worker's number | Two workers can share a name. A worker number or a labour card number cannot be confused. |
| Designation | Welder, fitter, helper. The customer often pays a different rate for each. |
| One box for each day | The hours worked. Not a tick: a tick does not say eight hours or ten. |
| A for absent | An absent day, a rest day and a day that nobody filled in must look different. |
| The row's total | Written by the supervisor. It is the check on every box in the row. |
| Supervisor's name, signature and date | Without it the sheet proves nothing to the customer's accounts department. |
Download the format
Manpower supply timesheet, monthlyExcel file. Free, no sign-up, nothing to install.
The file has three tabs:
- Timesheet is empty and ready to print or to fill in on a computer. It holds 30 workers; copy a row to add more.
- Example is the same sheet filled in for a made-up site, so you can see what every total does.
- How to use explains each column in a few lines.
Type the first day of the month into the box at the top. The dates, the weekdays and the shading of the rest day follow by themselves.
How to fill it in, step by step
- Start a new sheet for each site on the first day of the month. Write the customer, the site and the month before anything else.
- List every worker who is expected on that site, with number and designation. A worker who joins later gets a new row on the day he arrives.
- Every day, the supervisor writes the hours of each worker in that day's box. A worker who did not come gets an A. The rest day stays empty.
- Correct a mistake by crossing it out once and writing the right figure beside it, with initials. Never write one figure over another.
- On the last working day the supervisor adds up each row, writes the total, signs and dates the sheet.
- The sheet goes to your office the same day: the paper, a scan, or a clear photo.
How the totals are worked out
In the Excel file nobody adds anything up by hand. For a row whose day boxes are in F9 to AJ9, these are the formulas behind the totals.
| Total | Formula | What it does |
|---|---|---|
| Total hours | =SUM(F9:AJ9) |
Adds every number and ignores the A's. |
| Overtime hours | =SUMIF(F9:AJ9,">8")-8*COUNTIF(F9:AJ9,">8") |
Takes only the hours above eight on each day. |
| Rest-day hours | =SUMIF($F$8:$AJ$8,$AN$4,F9:AJ9) |
Adds the hours worked on the weekday you named as the rest day. |
| Days worked | =COUNT(F9:AJ9) |
Counts the boxes that hold a number. |
| Absent days | =COUNTIF(F9:AJ9,"A") |
Counts the A's. |
The file treats eight hours as a normal day, because that is the normal working day in the UAE's labour law. If your contract says something else, change the 8 in the second formula. How overtime is then paid is its own subject: see OT calculation in the UAE for site workers.
Seven mistakes that cost money
A total typed by hand. The supervisor writes 208, the boxes add up to 200, and nobody notices until a worker complains. Let the sheet add itself up, and compare its total with the one the supervisor wrote.
A figure written over another. Is it an 8 or a 9? Whoever types the sheet will guess. Ask supervisors to cross out and rewrite.
An empty box that could mean anything. Absent, rest day, public holiday, or simply forgotten? Agree on A for absent and an empty box only for the rest day.
One worker on two sheets on the same day. It happens when a worker is moved between sites. Both customers are billed, and the worker is paid twice.
Names without numbers. Two workers called Mohammed A. on one site will sooner or later swap their hours.
A sheet without a signature. The customer's accounts department will send it back, and your invoice waits another week.
A sheet that arrives late. Since 1 June 2026 wages in the UAE are due on the first day of the next month. A sheet that reaches the office on the fifth is already late. See the new WPS rules.
From the sheet to the salary and the bill
Once a sheet is checked and approved, the same hours go two ways. Multiplied by the worker's pay rate they become his salary: here is a worked example. Multiplied by the customer's charge rate they become your bill: here is how the two rates relate.
Questions people ask
What is the difference between a timesheet and an attendance sheet?
An attendance sheet records who was present. A timesheet records how many hours each person worked. For a company that is paid by the hour, only the second is enough, and most "labour attendance sheets" on sites are in fact timesheets: they hold hours, not ticks.
Should a manpower timesheet be weekly or monthly?
Monthly, for one site. Salaries and invoices are monthly, so a monthly sheet needs no joining of four or five papers. Some customers ask for a weekly signature as well. That is a good habit: the supervisor signs each week on the same monthly sheet, and mistakes are found while people still remember the day.
Who signs the timesheet?
The customer's site supervisor or site engineer, because the sheet is the customer's confirmation that the work was done. Many companies add a second line for their own office: "checked by".
How long should we keep timesheets?
The UAE's labour law asks an employer to keep a worker's file for at least two years after the worker leaves. Timesheets are the proof behind wages and invoices, so keep them at least that long. Many offices keep them as long as their accounting records.
Can we work from a photo of the sheet?
Yes, if the photo is clear: the whole sheet in the picture, flat, in good light. Reading it by eye and typing it is slow and is where most errors enter. AI can read a handwritten timesheet, as long as a person checks what it was not sure about.