Employee Attendance Sheet Template (Word)

An employee attendance sheet records, for each working day, when each employee arrived, when they left, the breaks they took, any overtime they worked and the reason for any absence, with a manager’s approval at the end. A simple template in Word or a spreadsheet is enough for a small team, as long as it has the right fields and someone checks it every day. Larger teams usually move to an electronic attendance system, but the fields stay the same.

This guide lists the fields the template should hold, shows how to build it in Word, compares paper and spreadsheet sheets with electronic systems, and explains how attendance feeds overtime and payroll and why accurate records matter under the Saudi Labor Law.

What an attendance sheet is and who needs it

An attendance sheet is the daily record of working time. It answers three questions: who worked, for how long, and whether anything happened outside the normal schedule, such as lateness, early departure, overtime or absence. Every employer needs that record in some form, whatever the size of the business, because wages, overtime and leave all depend on it.

A Word template suits small establishments, branches without a time clock, field teams that sign a sheet at the site, and temporary projects. It is also a useful backup when an electronic system is down.

Saudization, HR & Labor — Knowledge Base — Saudization, HR & Labor

Fields every attendance sheet should hold

Put these fields in this order, from left to right across the table, so the sheet reads naturally and matches the way payroll uses it:

Employee name, as it appears in the HR file.
Employee ID, the internal number, and the national ID or iqama number if you need it.
Date of the working day.
Time in, the actual time the employee started work.
Time out, the actual time the employee finished.
Breaks, the start and end of rest or prayer breaks, or the total break time.
Overtime, the hours worked beyond the normal schedule, with a note of who requested them.
Absence reason, such as sick leave, annual leave, an approved permission or an absence without excuse.
Approvals, the employee’s signature, the direct manager’s signature and the HR reviewer for the period.

Add a header with the establishment name, the department, the branch and the month, and a short notes column for anything unusual. Keep the field names the same every month so the sheets can be compared.

How to build the template in Word

Open a new document and set the page to landscape so the table has room for every column.
Type the header: establishment name, department, branch, month, and the name of the responsible manager.
Insert a table with one column for each field in the list above, and either one row per employee per day or one sheet per employee per month.
Set the header row to repeat on every page so a long sheet stays readable.
Add a notes column, and a signature area at the bottom for the manager and HR.
Save the file as a template rather than a document, so each month starts from a clean copy.
Number the pages and write the period on each page, so a loose page can always be put back in place.

If you need totals, such as total hours or total overtime, a spreadsheet in Excel is a better tool than Word, because it adds them up for you and reduces errors. Many teams print the Word sheet for signing on site and then enter the figures into a spreadsheet or the payroll system.

Paper or spreadsheet versus an electronic attendance system

Paper and Word sheets are cheap and quick to start. Their weak points are well known: times written from memory, sheets signed at the end of the week, missing pages, and copying errors when the data is typed into payroll.

Spreadsheets add calculation and make reviews easier, but they can still be edited after the fact unless access is controlled and changes are tracked.

Electronic attendance systems, such as fingerprint or face readers, card readers or mobile apps linked to location, record times automatically and can send the data straight to payroll. They cost more, need setting up and collect personal data. Fingerprint, face and location data should be handled under the personal data protection rules in force, and employees should be told what is collected and why.

A practical rule: start with a good template, and move to a system when the number of employees, branches or shifts makes manual checking unreliable. Whichever you choose, the fields above stay the same.

How attendance links to overtime and payroll

Attendance is the input and payroll is the output. For each month or pay period, the approved attendance sheets give payroll the figures it needs:

Days worked and approved leave.
Overtime hours, which are paid at the rate the Labor Law sets. Check the current text for the rate and the conditions.
Absence without excuse or lateness, which may lead to a deduction from pay, but only within the limits of the Labor Law and the establishment’s approved work regulations.

The salary paid should then match what is reported in the wage protection file submitted through Mudad. If attendance shows overtime that payroll did not pay, or payroll deducts for an absence the sheet does not show, the gap will surface in a complaint or an inspection. Close each period with a short reconciliation: attendance totals, approved overtime, approved deductions and the final payroll figures.

Keeping accurate records under the Labor Law

The Labor Law regulates working hours, rest periods, overtime and leave, and an employer is expected to be able to show that it follows these rules. Accurate attendance records are the simplest way to do that. In a dispute about unpaid overtime or an unfair deduction, the records are usually the main evidence.

Record actual times, not the scheduled times copied down every day.
Have the employee sign or confirm their own record, and the manager approve it, within the same pay period.
Correct errors openly: cross out, write the correction, initial it and note the reason. Never erase.
Approve overtime in writing before or when it is worked, and check the current Labor Law text for the rules on overtime.
Apply penalties for lateness or absence only as set out in the establishment’s work regulations, and in line with the Labor Law.
Keep the sheets in the employee files, or in a secure archive, for as long as your record-keeping policy and the regulations require.
Remember that the Labor Law reduces working hours for Muslim workers during Ramadan, and adjust the schedule in the template accordingly.

Common mistakes

Filling in the sheet at the end of the month from memory.
Using a template with no space for breaks or overtime, so the real hours never appear.
Leaving the absence reason blank, which turns approved leave into an absence without excuse on paper.
Paying overtime that was never approved, or failing to pay overtime that was.
Different templates in different branches, which makes totals impossible to compare.
Letting attendance and payroll drift apart, so the wage protection file no longer matches the sheets.

Frequently asked questions

Is a Word attendance sheet enough, or do I need an electronic system?

A Word or paper sheet can work for a small team if it is filled in daily, signed and kept. As the team grows, an electronic system reduces errors and saves time. What matters is that the record is accurate and can be proved.

What fields should an attendance sheet include?

At least the employee name and ID, the date, time in, time out, breaks, overtime, absence reason and approvals, with a header that shows the establishment, the department and the period.

How do I calculate overtime from the attendance sheet?

Compare the actual hours worked with the employee’s normal schedule, count only the extra hours that were approved, and pay them at the rate set by the Labor Law. Check the current text for the rate.

Can the employer deduct pay for lateness?

Only within the limits of the Labor Law and the establishment’s approved work regulations, and only on the basis of an accurate record.

How long should attendance records be kept?

Follow your record-keeping policy and the current regulations. Many employers keep them with the employee file for the whole period of employment and beyond, because they may be needed in a later dispute.

If you want help designing an attendance template that feeds payroll cleanly, or moving to an electronic system, Innovant’s HR team can help.

Book a free consultation with an Innovant advisor.

Employee Attendance Sheet Template in Word: Fields and Tips