# Monthly Attendance Report

<p class="doc-lead">Full-month attendance grid for all employees with daily status codes and summary totals. Shows one column per day of the month alongside present, absent, leave, and overtime aggregates.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/hr/reports/monthly-attendance-report?id=overview">Overview</a>
<a href="#/hr/reports/monthly-attendance-report?id=use-cases">Use Cases</a>
<a href="#/hr/reports/monthly-attendance-report?id=filters">Filters</a>
<a href="#/hr/reports/monthly-attendance-report?id=columns">Columns</a>
<a href="#/hr/reports/monthly-attendance-report?id=actions">Actions</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>HRMS → Reports → Monthly Attendance</b>.

<img src="hr/images/monthlyattndncereport.webp" alt="Monthly Attendance Report" loading="lazy">

<p><b>What it shows.</b> One row per employee with summary totals and a daily column for each day of the month showing status codes (P = Present, L = Leave, A = Absent, H = Holiday, OT = Overtime).</p>

<p><b>When to use it.</b> Monthly attendance review, payroll processing, and compliance reporting.</p>

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>HR manager</b> — Full-month attendance overview for all employees or a department.</li>
<li><b>Payroll administrator</b> — Verify present, leave, and overtime days before running pay.</li>
<li><b>Compliance officer</b> — Monthly attendance record for labor law compliance.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

| **Filter** | **Description** |
|------------|-----------------|
| Period type | Month or Custom date range. |
| Month | Month picker (when Period type = Month). |
| Custom date range | Start and end dates (when Period type = Custom). |
| Department | Filter by department. |
| Employee | Filter by specific employee. |

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| Code | Employee code. Click to open employee quick view. |
| Name | Employee name. |
| Total | Total days in the period. |
| Working | Working days. |
| Present | Present days. |
| Holiday | Holiday days. |
| Absent | Absent days. |
| Leave (Total) | Total leave days. |
| Leave (Paid) | Paid leave days. |
| Leave (Un-Paid) | Unpaid leave days. |
| Overtime (Days) | Days with overtime. |
| Overtime (Hours) | Total OT hours. |
| Holiday OT | Holiday overtime hours. |
| Total OT | Combined overtime hours. |
| Day columns | One column per day showing status code and weekday letter. |

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report.</li>
<li><b>Export Excel</b> — export to Excel.</li>
<li><b>Print</b> — print the report.</li>
</ul>

<hr class="doc-section-divider">

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<b>Which month does the report use?</b><br>
Calendar month and year selected on the filter — includes all days in that month per employee.

<b>What do day column codes mean?</b><br>
Single-letter or status codes reflect attendance status for each date — match legend on report output (Present, Absent, Leave, Holiday, etc.).

<b>Can I edit attendance from this report?</b><br>
No. Use <a href="#/hr/daily-attendance">Daily Attendance</a> Day Attendance Form to mark or change statuses.

<b>Why are OT hours zero?</b><br>
No extra time beyond the shift, or regular OT for that day is below <a href="#/hr/hrms-settings">HR Settings → Minimum overtime minutes</a> (those days are treated as 0 OT). Holiday OT is not filtered by that setting.

<b>Does the report include inactive employees?</b><br>
Depends on employee filter — default often shows active staff only. Adjust Advanced Filters on the report.

<b>How is this different from Weekly Attendance Report?</b><br>
Monthly shows one calendar month with per-day columns. <a href="#/hr/reports/weekly-attendance-report">Weekly Attendance Report</a> aggregates a custom date range without daily grid.

<b>Are payroll-locked days marked differently?</b><br>
Locked periods still appear on the report but cannot be edited from attendance screens — verify before pay run.

<hr class="doc-section-divider">