ChartHop for Administrators
...
People Ops Tools
Time off for admins
Time off payroll export
overview time off data frequently needs to be recorded for payroll our payroll export allows you to export all time off data to appropriately report on time off taken to export data go to people ops tools > time off payroll export choose the time period for the data you want to see for example, if you need to report on the last two weeks for payroll, click "last n weeks" and insert "2" if you want to filter for certain countries, employement status, or other fields, you can use the filter bar to set that criteria you will see that the payroll export defaults to the time off columns employee employee name policy name policy type type of policy (pto, sick, etc ) type of time off policy type entry type time off is a time off request, upfront balance is a balance adjustment start date start date of request this will only be populated for time off requests, not balance adjustments end date end date of request this will only be populated for time off requests, not balance adjustments days number of days requested or the number of days updated in the balance approval whether the request has been approved, rejected, or is pending note any notes on the time off request balance effective date the date at which the balance is effective for example, start date of a request is 1/7/25 1/10/25 as of 1/7/25, the balance was 15 days (see example below) balance the balance as of the balance effective date "+" this allows you to add any additional columns you may need you can adjust this like the datasheet adding columns and moving them to the best order for your export once you have the data you need, click "export csv" to export your time off data