The monthly grid

One row per person, one column per day. It is the screen HR lives in at the end of a month, so it is built to be scanned rather than read.

It opens on this month. Show switches between By month, stepped with the arrows or picked from the list, and Date range, any two dates up to 62 days apart. A date range shows what happened in it, and the export follows it; the pay-day columns and locking the period are a period's, so they are shown by month only.

Each cell carries a letter as well as a colour. The grid is often printed, and colour alone would be unreadable to about one man in twelve.

MarkMeaning
·Complete
LLate or left early
?Miss scan
AAbsent
VLeave
HHoliday
–Day off
ENot required

Somebody exempt from attendance — an owner, a director — is E on every working day and credited in full, whether or not they punch. A day they have approved leave on is V like anybody's, so the leave type decides the pay: unpaid leave is not paid. They are not counted as present or absent on the overview; it counts them on their own.

A day with two stretches is drawn as two marks side by side, the morning then the afternoon. A morning worked and an afternoon missed is not the same day as one missed entirely, and payroll pays them differently.

Before you start

  • The attendance.view permission. The Owner, HR, Payroll and Manager roles all hold it.
  • Seeing the photograph and position behind a check-in needs attendance.view_evidence as well, which is deliberately separate.

Steps

  1. Open Attendance.
  2. Choose the Month.
  3. Narrow the table if you need to: search a name or a staff number, pick a branch or a unit, or press one of the marks above the table to keep only the people who had such a day. All clears them again.
  4. Click a column heading to order the table by it. Press it a second time to turn it round.
  5. Click a day to open it on the right: each stretch of the shift, then the punches it was worked out from and where each one came from.

What you should see

The columns at the end of each row are the person's whole period. Days worked is the days worked: a four-hour stretch in an eight-hour day counts as half a day, so somebody who worked every morning and no afternoon shows half the days of somebody who worked both. Times late or early and Missing punches count occasions, not days: two missing punches in one day are two things to fix. Days absent and Days of paid leave count days, to the half day. Days of paid leave is leave of a type that pays, part-paid leave included, and the annual leave taken for a missing punch nobody resolved; unpaid leave is counted with the unpaid days instead.

A company with the payroll module has three more columns, before the others, and they read as a sum: Days in a pay month (payroll setting) less Days unpaid is Days paid. The last one is shaded, because it is the figure the row comes to.

  • Days in a pay month (payroll setting) is what a month is worth for pay — the day-rate divisor in the payroll settings. A number the company set, or the period's calendar days, is the same for everybody; each person's working days differ from one person to the next with their shifts. Somebody who joined, left or was suspended during the period has it shared by the calendar days they were paid for, as their salary is.
  • Days unpaid is every day payroll will not pay: absence, a missing punch nobody resolved and annual leave did not cover, unpaid leave, and the unpaid share of part-paid leave. Absence is already inside it, so do not add the two.
  • Days paid is the days this person is paid for, exactly as the payroll period will pay them. Thirty days with two days of unpaid leave is 28. A morning worked and an afternoon with a missing punch nobody resolved, with no annual leave left, is half a day paid. While the period is open the figure counts up to today, so it falls as absences happen.

Pressing a mark keeps the people who had such a day, with the rest of their month still in front of you — the days you asked about stay bright and the others fade. The line above the table counts only the rows on screen; the totals at the end of each row are always the whole period.

Lateness is recorded even when nothing is deducted for it. MekongHRM does not penalise lateness unless a company switches that on, but the minutes are kept either way, because a report nobody can produce afterwards is worse than one nobody uses.

On time, and taking the data away

Complete works differently from the other marks. The others keep anybody who had such a day at least once; this one keeps only the people whose every working day in the period was complete — no late arrival, no early leaving, no absence and no missing punch. Leave, public holidays and rest days do not count against anybody.

Export to Excel downloads the table you are looking at — the same month, the same people, whatever filters are set — as an Excel file with three sheets:

  • Summary: one row a person, with their branch, unit and position. Right after whether they are exempt from clocking in come the grid's own totals, under the same names, in the same order and counted the same way: the three pay-day columns when the company has payroll, then days worked, times late or early, days absent, days of paid leave and missing punches. After them: the days they had to work, every count of late, early and absent stretches with their minutes, leave in days with one column for each leave type, holidays, rest days worked, minutes worked, approved overtime, and the number of punches from each source.
  • Day detail: one row a person, a day and a stretch: the shift's times, the times actually punched and where each punch came from, the minutes worked, late and early, the status and what the stretch counted for.
  • Raw punches: every punch in the period, its time, its source and device, whether a photo was taken and the face check result.

Every heading has a filter, and the first row stays put as you scroll. There are no photos and no locations in the file: those are evidence, and they stay on the day detail screen. Each export is written to the activity log.

The period at a glance

Overview is the same month seen from above. Choose a Period or a Week, and a branch or unit if you only want part of the company. It shows:

  • Today: who is in, late, absent or on leave, and how many have not clocked in yet. The comparison with yesterday appears once every shift owed today has ended; until then a card says it will compare later, because a day half done always looks worse than a whole one.
  • The range: the daily trend, the Attendance rate by unit and by day of the week, on time against late by week, leave by type, and where the punches came from.
  • Three short lists — today's attendance, leave waiting for approval and the people most often late — each with View all to open the full screen.

The Attendance rate is the stretches people were there for, on time or late, out of the stretches they owed. Leave, public holidays and rest days are left out. Every figure comes from the same day records as this grid, and covers only the people your role can see. A stretch still under way today counts as attended once somebody has clocked in for it.

If something goes wrong

The month is empty. Nobody has checked in, or nobody has a shift. A person with no shift is treated as not working rather than as absent, so a month of blanks usually means the branch has no default shift.

Somebody is absent on a day they worked. Check whether their punch fell outside the hours their stretch accepts, and whether the right shift was assigned to that day.

Everybody at one branch is absent on the same day. That day is probably a public holiday nobody has declared yet. Adding it recalculates the day.

A day changed after you looked at it. Until the month is locked, days are recalculated whenever something they depend on changes — a late punch arriving, a correction approved, a shift altered. Locking is what makes them stop moving.

Last checked 05/11/2026