Bulk-Exporting Attendance Reports

Before running payroll, export the whole company's attendance, overtime, and exception records to Excel in one click.

Before running payroll each month, HR or department managers usually need to export every employee's attendance record to reconcile late marks, early departures, absences, and overtime. In FLEXPEO you can export an Excel report that includes exception records.

Step 1: Open the attendance records page

  1. Go to Attendance > Attendance Records (/checkWork/checkWorkRecord).
  2. This page lists every employee's daily clock-in details across the whole company.

Step 2: Set the filters (key step)

To make the export precise, filter on screen first so you only export what you need.

  1. Pick the date range:
    • Open the date picker and pick the month you want to export (e.g. the 1st to the 31st of last month).
  2. Pick a department or attendance group (optional):
    • If you only need a specific department's attendance (e.g. "Retail Frontline"), filter by that department or attendance group.
  3. Filter on exceptions (optional):
    • To show only problem records (e.g. late, missed clock-in), tick the Exception Status filter.
    • Apply the filter and confirm that the displayed records match what you intend to export.

Step 3: Export the report

  1. Click the export button:
    • In the top right or above the list, find and click Bulk Export or Export Report.
  2. Confirm the export options:
    • Follow the options shown on the page and generate the report.
  3. Review the downloaded report:
    • Open the exported file and confirm that its date range and employee records match the filters you selected.

Friction-Killer tip: If the report is full of "missed clock-in" records, get the employees to submit their clock-in correction requests on the mobile app first. Wait for managers to approve them, then re-export the report. It saves HR a lot of manual Excel editing.