Yawmy guide7 min read

Monthly Attendance Report Format: Layout and Checks

A monthly attendance report format that managers and payroll can both use: the columns to include, a sample layout, an exceptions list, and a month-close checklist.

Nada HassanHR-Tech Strategist, YawmyCanonical link

A monthly attendance report is a one-month summary of who worked, who was absent, who was late and how many hours were logged, laid out so that payroll can pay from it and a manager can read it in two minutes. Most Egyptian small businesses build it by hand in the last two days of the month, from a mix of sheets, chats and memory. The format below gives you the columns, a sample layout, an exceptions list and a month-close routine that you can reuse every month. References to pay and records concern private-sector employers in Egypt.

TL;DR. One row per employee, nine columns: code, name, scheduled days, days present, absent, approved leave, late arrivals, hours worked, notes. Add a second page listing only exceptions: missing check-outs, manual edits and disputed days. Close the month with a short checklist and sign-off before payroll starts. Pay calculation rules belong to Egypt's Labour Law and your regulation, so confirm them with a lawyer; this is general information, not legal advice.

This guide is part of our series on employee attendance software in Egypt.

What the report is for

The same report serves two readers, and a format that ignores either fails.

  • Payroll needs exact day and hour counts per person, each traceable to a record, so the pay slip can be defended.
  • Managers need the pattern: which branch, which weekday, which shift is slipping, and who needs a conversation.

If you produce one page for payroll and another for management from different sources, the numbers will disagree, and the month will be spent explaining the gap. Build both from one dataset.

The nine columns that matter

# Column Source Why it is there
1 Employee code HR master list Matches payroll and leave records
2 Name and branch HR master list Lets you filter by site
3 Scheduled days Roster minus rest days and holidays The denominator for every rate
4 Days present Check-in records The base for pay
5 Days absent Scheduled minus present minus leave Feeds the absence rate
6 Approved leave days Leave records Keeps leave out of "absent"
7 Late arrivals Check-in vs shift start Count and total minutes
8 Hours worked Check-in to check-out Overtime and part-day pay
9 Notes Manager Reason for any unusual day

Resist adding more. Every extra column is another thing to reconcile. If you need extras such as overtime hours, add them as a second block to the right of the nine, not in between.

A sample layout

Here is how three rows might look for a month with 22 scheduled days. The figures are invented to show the format.

Code Name Branch Sched. Present Absent Leave Late (times / min) Hours Notes
101 Employee A Nasr City 22 21 0 1 2 / 25 168
102 Employee B Nasr City 22 18 3 1 5 / 70 144 2 sick days, certificate on file
103 Employee C Giza 22 22 0 0 0 / 0 181 Worked one extra shift

Sum the columns at the bottom of each branch and for the company. Present plus absent plus leave must equal scheduled for every row; if a row does not balance, a day is missing from one of the records. That one check catches most errors before payroll sees them.

The exceptions page

The summary page tells you how the month went. The exceptions page tells you what could go wrong when you act on it. List only items that need a human decision:

  • Missing check-outs. The employee checked in and never out, so hours are unknown.
  • Manual edits. Any day altered by someone other than the employee, with who changed it and why.
  • Disputed days. Employee says present, record says absent.
  • Overlaps. Leave approved on a day the employee also checked in.
  • Impossible hours. A shift recorded as longer than any rota allows.

A typical month for a team of thirty produces a short list. If yours produces fifty lines, the root cause is the capture method, not the report. The Excel to app migration guide explains how teams get there.

Report types: which one do you need?

Report Frequency Reader Question it answers
Daily sheet Daily Supervisor Who is here right now?
Monthly summary Monthly Payroll, owner What do we pay and how did we do?
Exceptions list Monthly HR What must be fixed before payroll?
Branch comparison Monthly Owner Which site needs attention?

Start with the monthly summary and the exceptions list. Add the branch comparison once you have two or more sites, and feed it into the rate described in our absenteeism rate guide.

A month-close checklist

Run this in order, every month, with a named owner for each step.

  1. Freeze the roster. Confirm joiners, leavers and transfers, with dates, so scheduled days are right.
  2. Load approved leave. Every approved request should already be recorded. A standard leave request form makes this a copy, not a hunt.
  3. Resolve exceptions. Clear each line on the exceptions page and write the decision in the notes column.
  4. Check the balance rule. Present plus absent plus leave equals scheduled, row by row.
  5. Review totals with each branch manager. Five minutes each, to catch a day that everyone remembers differently.
  6. Sign off. HR and the owner or finance lead sign and date the final version.
  7. Hand to payroll and archive. Keep the signed file with the month's payroll. The wider process is in attendance and payroll reconciliation.

Excel or an app?

Factor Excel / Sheets Attendance app
Setup Fast to start Needs onboarding
Data entry Manual or imported Captured at check-in
Error rate Rises with headcount Lower, if staff use it
Audit trail File versions Time-stamped records
Best for Under about 15 people, one site More staff or several sites

The threshold is a rule of thumb, not a law. If preparing the report takes more than half a day, the sheet is costing more than it saves.

Once the report is closed, absence and overtime figures move onto each person's pay statement. See our payslip template for where each number lands.

How Yawmy fits

Yawmy records check-in and check-out and generates attendance reports, so the monthly summary comes from the same records managers see during the month. The free plan covers 2 employees; Pro is 500 EGP per month or 4,500 EGP per year with unlimited employees. Confirm current plan details on the Yawmy site.

FAQ

What should a monthly attendance report include?

At minimum: employee code and name, scheduled days, days present, absent days, approved leave, late arrivals, hours worked and a notes column. Add an exceptions page for missing check-outs, manual edits and disputed days.

Who should sign off the monthly attendance report?

The HR lead prepares it and a second person, usually the owner or finance lead, reviews and signs. Two signatures on a dated final version protect you if an employee later disputes a month.

Can I send the monthly report to payroll in Excel?

Yes, as long as the version sent is the signed final and the file is archived unchanged. Lock or export the file to PDF so later edits do not rewrite history.

How long should I keep monthly attendance reports?

Keep them with the payroll records for the same month. The legal retention period depends on Egyptian labour, tax and insurance rules, so ask your accountant or lawyer which period applies to you.

How do I handle an employee who forgot to check out?

Flag the day on the exceptions page, ask the employee and their manager for the actual end time, and record the corrected time with the reason and the name of the person who approved it. Do not guess the hours silently.

Written by Nada Hassan, HR-Tech Strategist at Yawmy. This is general information, not legal advice.

To produce the monthly report from live check-in records, open Yawmy or see the Yawmy home page.

Want the monthly report built from live check-ins?

Tell us your team size and branches; your request goes straight to the Yawmy team.

Your details go to the sales team only.
Start here

Turn attendance and payroll into a clean system in minutes.

Try Yawmy for free, add your team, and connect Telegram check-ins, GPS proof, and payroll-ready reports without Excel or WhatsApp chaos.

Yawmy
GPS attendance
Payroll reports
Teams & branches
No hardware