Skip to main content
itzseo
All docs

HR — Monthly reports and CSV exports

Three reports — attendance, leave usage, overtime — with CSV download for spreadsheets.

HRMS & AttendanceUpdated Try it now

/hr/reports exposes three workspace-wide reports as tabs: Monthly attendance, Leave usage, and Overtime. Reach it from HRMS in the sidebar → "For HR" → Reports card. Each tab has its own period selector and a Download CSV button for offline analysis in Excel, Google Sheets, or your payroll system.

Monthly attendance

The default tab. Pick a month with the arrow controls. The stat tiles show:

  • Members — workspace headcount for context.
  • Total worked — sum of all members' worked time for the month.
  • Late sessions — count of days flagged LATE_CHECKIN across the workspace.
  • Auto-closed — count of sessions auto-closed by the midnight cron (a flag for HR follow-up).

Below the tiles, a row per member shows ten columns:

  • NAME — full name + email.
  • DAYS — count of days the member punched in.
  • WORKED — net work time across the month.
  • BREAKS — total break time.
  • LATE — count of LATE_CHECKIN sessions.
  • OT DAYS — days with at least one OT entry.
  • OT MIN — total OT minutes (any status).
  • SUN — count of Sunday sessions.
  • HOLIDAY — count of holiday sessions.
  • AUTO-CLOSED — sessions where the cron had to close the day.

Leave usage

Scoped to a fiscal year (default FY for current date). Each member's panel shows their leave usage broken out across all eight base types — each type renders as a card with available / granted / used numbers. Members who've never applied for leave this FY render with a "No balance rows in this FY" placeholder so they're still visible but flagged.

The "Total used" line per member is the sum of approved leave days across all types — useful as a quick at-a-glance figure for performance reviews or payroll reconciliation.

Overtime

Two modes — month or full year, toggled via the "Switch to full year" link. The stat tiles show the workspace's pending and approved OT totals; the table breaks each member's minutes across the four status columns + the four reason columns (Past shift / Sunday / Holiday / Manual) plus a total Entries column.

Download CSV

Each tab has its own Download CSV button in the top-right. Clicking downloads a UTF-8 CSV file named with the report kind + period (e.g. attendance-2026-05.csv). The file uses standard RFC 4180 quoting so it opens cleanly in Excel and Google Sheets without import wizards.

Tips when working with the CSV:

  • All time values are in the workspace timezone — your payroll spreadsheet may need to convert if it expects UTC.
  • Durations are formatted as minutes in the CSV (the UI shows them as "1h 35m" for readability, but the file uses raw minutes so formulas work).
  • The CSV always includes every workspace member, even those with all zeros, so the row count matches your headcount — handy for full-month rosters.
© 2026 ItzSEO. All docs
All systems normal