All Collections
PTO
Policies
Importing Hours Worked
Importing Hours Worked

Generate an accrual by importing a file containing people'e work hours.

Rin avatar
Written by Rin
Updated over a week ago

For customers of our PTO module and Timesheets feature.


Before you import people's work hours, ensure you have: 

Note: Only Company Admins and HR Admins can manage and configure PTO policies. To learn more, please refer to: Understanding User Roles & Permissions.

  1. Created an Accrued by Hours Worked policy.

  2. Assigned the policy to the correct individuals.

  3. Set starting balances, if applicable.

To import a file containing people's work hours: 

Note: Only Company Admins and HR Admins can import people's work hours. To learn more, please refer to: Understanding User Roles & Permissions.

  1. Click your company name at the top of the main navigation, then click Company Settings.

  2. Click the Paid Time Off tab and locate the policy for which you want to import hours worked. Click the appropriate policy dropdown, then click Import Hours Worked.

  3. Read the instructions listed on the Import Hours Worked Page, which explains how to format your CSV file. Ensure your CSV file has the following required columns, creating a separate row for each person.
    Name (the person's full name)
    Work Email (or Employee ID also works as a unique identifier)
    Hours Worked (the number of hours each person worked)

  4. Upload your CSV file.

  5. Review accrual amounts before they are processed. You can edit the actual amount each person will receive if needed. Or, you can use the button at the bottom of the page to upload a new file if you prefer to make corrections in your CSV file.

  6. Add an optional note. If you want to add a note that will be included on every accrual transaction, you must complete the note section prior to applying accruals.

  7. Click the Apply Accruals when you're ready to run the accruals.

  8. Once you apply accruals you'll receive a confirmation page stating that your accruals have been processed. Accrued hours from this upload will automatically be added to the individual accounts for each employee included. You may also view the PTO Balance Report to see updated account balances for each person. 

Please contact our customer success team for additional assistance.

Did this answer your question?