Scheduling payroll reports

Scheduling payroll reports

The Report Scheduler emails a payroll report to the people you choose, on a daily, weekly or monthly cadence, without anyone remembering to run it. Use it to send finance a standing payroll export, or to get the payroll details for the previous month in your inbox on the same day each month.

Where: Settings › Bulk Data › Report Scheduler

You need: the Report Scheduler settings right to add, edit or delete schedules

What you can schedule

ReportContains
PayrollThe payroll report as a CSV file, for Closed and Paid payslips only
Payroll detailsThe detailed payroll report as a CSV file, for payslips in every status
ExpensesThe expense report as a CSV file, by receipt date
CheckpointsThe checkpoint locations report as an Excel file, by the time each checkpoint was recorded

Statutory files, the accounting journal and custom report templates cannot be scheduled. Create those from Payroll › Dashboard › View Reports — see Payroll reports.

How to schedule a report

  1. Go to Settings › Bulk Data › Report Scheduler.
  2. Select Add. The Add Report Schedule window opens.
  3. Choose the Report.
  4. Choose the Period, the date range the report covers: Yesterday, This month to date, Last 30 days, Previous month, Previous 3 months, Previous 6 months or This year to date.
  5. Choose the Frequency: Daily, Weekly or Monthly.
  6. Choose the Day it is sent. For Weekly, 1 is Monday and 7 is Sunday. For Monthly, choose a date from 1 to 28. For Daily, the only choice is Yesterday.
  7. Under Recipients, search for and add each person who should receive it. Only active employees can be added.
  8. Select Save.

How to change or stop a schedule

  1. On the Report Scheduler page, find the schedule. The list shows Report, Period, Frequency, Day and Recipients.
  2. Select the edit icon to change any field, then select Save.
  3. Or select the delete icon to stop the schedule for good.

What Happens Next

  • Schedules run once a day at 04:00 UTC, which is noon in the Philippines, Malaysia and Singapore and 11:00 in Jakarta. A schedule set for a day only sends on that day.
  • Each recipient gets an email with the report attached, and the file is also saved in their download centre for 14 days. If the file is too large to attach, the email tells them to download it from the download centre instead.
  • If the period has no data, nothing is sent that day.
  • The period is worked out from the day the report runs. A Previous month report sent on the 3rd covers the whole of the month before.
  • A schedule keeps running until you delete it, including after the person who set it up leaves. Recipients who become inactive stop receiving it.

Tips

  • Pick Payroll for anything that leaves the building. It only includes Closed and Paid payslips, so it does not change after it is sent. Payroll details includes drafts.
  • Send it a few days after your last pay date. A Monthly schedule on the 1st can run before the final batch of the month is closed.
  • Check the first delivery against a report you run yourself from View Reports. If they differ, adjust the period or the day.
  • Add a back-up recipient. A schedule addressed to one person goes unread when they are on leave.
  • Review your schedules once a year. Remove reports nobody uses and people who have changed role.

Troubleshooting / FAQ

Q: The scheduled report didn't arrive. Check the schedule's day, that the recipient is still active, and that the period actually had data. Look in the recipient's download centre too.

Q: Why can't I choose the 30th or 31st for a monthly schedule? Monthly schedules allow days 1 to 28, so they run in every month, including February.

Q: The scheduled Payroll report has fewer people than my report. It leaves out payslips that are not yet Closed or Paid. Use Payroll details if you want every status.

Q: Can I schedule the SSS file or the journal? No. Statutory files and the journal are created from View Reports.

Q: Can I send it to someone outside the company? No. Recipients must be active employees in KAMI.

Related articles