Attendance reports and Excel export

Daily and monthly attendance reports in AttendFirst, with one-click Excel and CSV export for payroll. Filter by date range, department, or employee.

Updated 2026-04-22

AttendFirst’s Reports section turns every check-in into numbers your accountant can paste into a payroll spreadsheet. There are three attendance report views (daily, monthly, and per-employee) plus a one-click Excel or CSV export that downloads everything visible on screen.

Daily report

Daily report tab showing date picker, seven stat cards (Total, Present, Late, Absent, Half Day, Checked In, Checked Out), and a table per employee with check-in, check-out, status, and sessions columns
Daily tab. Defaults to today; pick any date.

Admin → Reports → Daily. Pick any date. The top row shows seven counts: Total, Present, Late, Absent, Half Day, Checked In, Checked Out. The table below lists every employee with:

ColumnMeaning
EmployeeName and employee code
StatusPresent, Late, Half day, Absent, On leave, Holiday
First check-inEarliest session start time
Last check-outLatest session end time
Work hoursTotal minutes in non-break sessions, displayed as h:mm
Break hoursTotal minutes in break sessions
SessionsCount of check-in/out pairs for the day

The report defaults to today. Use it at end-of-day to spot who forgot to check out or who came in late.

Monthly report

Monthly report tab for April 2026 showing 22 working days, Export CSV button, and a table per employee with Working Days, Present, Late, Absent, Half Day, Attendance %

Monthly tab. One month at a time with an Export CSV button in the top right.

Admin → Reports → Monthly. Pick a month with the prev/next arrows. You get a row per employee with aggregated counts:

ColumnMeaning
Present daysDays with status Present or Late
Late daysDays with status Late (subset of Present)
Half daysDays with status Half day
Absent daysDays with status Absent
Leave daysDays with status On leave
HolidaysHolidays in the month
WeekendsNon-working days in the month
Total work hoursSum of work minutes across the month

This is the sheet your accountant wants for monthly payroll.

Employee report

Employee report tab with an employee picker, This month filter, and a Select an employee empty state
Employee tab. Pick one person to see their full attendance trail.

Admin → Reports → Employee. Pick an employee from the dropdown, choose a date range, and see the same KPI cards and attendance history from their profile page, scoped to the range you picked. Useful for one-on-one reviews and payroll reconciliation for a specific person.

CSV export

Every report has a Export CSV button top right. The CSV contains every visible column plus a few extras (employee email, department, manager) so you can pivot or sort in Excel.

Filename format: attendfirst-{reportType}-{companySlug}-{dateRange}.csv. Example: attendfirst-monthly-acme-2026-04.csv.

The file is encoded so Excel on Windows opens Indian names correctly. Dates are in YYYY-MM-DD format, times are HH:MM in company timezone.

Filtering

Both reports support filters:

  • Date range: a calendar picker. Monthly report is month-at-a-time; daily is any single day.
  • Department: dropdown of your departments.
  • Employee: multi-select to compare specific people.
  • Status: filter to a subset of statuses (for example, only show Late and Absent).

Filters apply to both the on-screen view and the CSV export.

Live dashboard vs reports

The admin dashboard has a today summary and a 7-day trend chart that refresh whenever you open or refocus the tab. These are for at-a-glance checks, not for payroll. Use Reports for anything you need to audit, share, or archive.

Frequently asked questions

Can I export a date range across multiple months?

Yes, but only from the daily report with a custom date range. The monthly report is one month at a time by design.

Why does the CSV sometimes show fewer rows than the on-screen report?

Filter state is preserved in the export. If you filter by department “Sales” and then export, only Sales rows are written. Clear filters before exporting if you want the full company.

Can I email the report on a schedule?

The daily report is emailed to the admin automatically at 7 PM company time. A weekly summary goes out every Monday 9 AM. Both are configurable under Admin → Settings → Notifications.

Does the CSV include GPS coordinates?

No, for privacy. The on-screen daily attendance page shows GPS and selfie metadata; the CSV intentionally omits them so you can share the file without leaking location data.

How accurate are the hour totals?

Down to the second, rounded to the minute for display. Every session has a precise start and end timestamp, and reports sum the differences.

Steps

  1. Open the Reports section. Go to Admin → Reports. Three tabs are available - Daily, Monthly, and Employee.
  2. Pick the report type. Use Daily for a single date, Monthly for a calendar month summary per employee, or Employee for one person's attendance across a date range.
  3. Apply filters. Narrow the view with Department, Employee (multi-select), and Status filters. Filters persist in the URL so you can bookmark or share a specific view.
  4. Click Export CSV. The Export CSV button in the top right downloads the current view. The file is UTF-8 with a BOM so Excel opens Indian names correctly. Dates are YYYY-MM-DD in company timezone.
  5. Open in Excel for payroll. The filename follows the pattern attendfirst-{type}-{company}-{range}.csv. Paste into your payroll spreadsheet or upload to Keka, greytHR, or Zoho for processing.

Frequently asked questions

Can I export AttendFirst attendance data to Excel?

Yes. Every report has an Export CSV button. The file is UTF-8 with a BOM so Excel on Windows opens Indian names correctly. Dates are YYYY-MM-DD in company timezone.

Does AttendFirst email attendance reports automatically?

Yes. The daily report emails to the admin at 7 PM company time. A weekly summary goes out every Monday at 9 AM. Both are configurable under Settings → Notifications.

Can I export attendance across multiple months?

Yes, using the daily report with a custom date range. The monthly report is one month at a time by design.

Does the AttendFirst CSV include GPS coordinates?

No, for privacy. The on-screen daily attendance page shows GPS and selfie metadata; the CSV omits them so the file is safe to share.

How accurate are AttendFirst hour totals?

Down to the second, rounded to the minute for display. Every session stores precise start and end timestamps and reports sum the deltas.