Prepare Payroll Data

Open the Attendance Report, apply the date range and filters for your payroll cycle, then click Export to download attendance data—including present days, approved leave, and holidays—ready to feed into salary calculation.

The whole point of connecting Leave, Holiday, and Attendance modules the way Hoicko HRMS does is that payroll should never need a separate, manual count at the end of the month. By the time your payroll cycle closes, every number you need — days present, days on approved paid leave, days on unpaid leave, holidays — is already sitting correctly tagged in one exportable report, rather than requiring someone to cross-reference three separate spreadsheets by hand.

This is also where the setup decisions made earlier in this guide pay off directly. Because every leave type was marked as paid or left unmarked back when it was created, and every holiday was correctly added to the right calendar, the export doesn't need any manual correction pass before it's payroll-ready—it reflects those settings automatically.

Step-by-step:

1. Open Attendance Report from Quick Access Applications.
2. Set the date range to match your payroll period (typically the current calendar month, but adjustable for companies running a different payroll cycle).
3. Confirm that approved leave and holiday days are showing correctly against each employee before exporting—this is a good moment to catch any leave request that's still sitting unapproved and would otherwise show as an unexplained absence.
4. Use Filter to isolate a specific department if payroll is processed per team or per cost center rather than for the whole company at once.
5. Click Export to download the report in a spreadsheet-compatible format.
6. Cross-check the Leave Without Pay (LWP) column specifically against unpaid leave types before finalizing salary calculations, since this is the column that directly affects deductions.

FAQ

Does the export include leave without pay separately from paid leave?

Yes—because leave types are marked as paid or not during setup, the export distinguishes paid absence from unpaid absence automatically, with no manual re-tagging needed at export time.

What format does the export come in?

Attendance data exports in a spreadsheet-compatible format, ready to import into most payroll systems without needing to reformat columns manually.

Should I export before or after all leave requests for the period are resolved?

Export after all pending leave requests for the period have been approved or rejected—an export run while requests are still pending will show those days as unexplained absences rather than approved leave, requiring a re-export later.