Importing Holiday Hours
How do I import holiday hours for employees?
Purpose: To easily account for holiday hours worked at your company using our hours importer. Learn how to import these hours, ensuring accurate employee records, time off allocations, and a smooth payroll cycle.
Importing holiday hours
If you do not use BambooHR® Time Tracking, you can import your employees' worked hours into BambooHR for a smooth payroll run. Since holiday hours work differently from regular hours, take the necessary steps to ensure that hours worked or awarded on holidays are imported correctly into your account.
The hours importer feature is available to the Account Owner, Full Admin users, Payroll Admins, and custom access level users with the Manage Hour Imports permission.
When setting up a holiday in Settings, designate whether your employees will receive holiday pay hours for the holiday or an alternate pay rate for hours worked on the holiday. If you have employees who fall into both scenarios, create two holidays—one for each designated setting—and follow the steps for each.
Hours paid for holidays - non-worked
Do not include holiday hours for employees who only receive holiday pay (non-worked hours) in your import. The system will automatically pull awarded holiday pay hours into payroll based on the hours designation in holiday settings.
Hours paid for holidays - worked
When employees receive a multiplied rate for work performed on holidays, establish this designation within Settings. Again, if you have employees who fall into both categories of worked and non-worked holiday pay, set up two events in Holiday Settings to differentiate between the two scenarios.
To set up the holiday for employees working on it, check the box next to "Add holiday hours or set a special pay rate multiplier for this holiday?" and then select the option "Employees receive the following pay rate for any hours worked on this holiday." Next, enter the pay rate multiplier in the box below. This multiplier only applies to hourly employees. The system will pull salaried employees' full salary into payroll, regardless of the holiday.
Now that you have set up your holiday multipliers, add the holiday hours worked to the import hours template as you normally would for any other hours.
For holiday hours, ensure the following:
- The Hours Worked Date column on the import template must match the date of the holiday you set up in Settings.
- The holiday in Column I (Holiday Name) must exactly match the name specified in Settings.
- The Rate Type for holidays is "REG", even if you pay your employees with a multiplier.
- If you are using a pay rate multiplier, leave the Pay Rate column (Column C) blank.
- Leaving this column blank will pull the employee's current pay rate from their Compensation table and multiply it by the holiday rate multiplier in Settings. If you enter a pay rate into the template, this rate will override the holiday pay settings.
Holiday hours in Payroll
If your employee has non-worked or worked holiday hours in a payroll run, you will see a pay type that differentiates between the two. Non-worked hours will be displayed as "Holiday," and worked hours will be displayed as "Worked Holiday xx (rate multiplier)."
Importing holiday hours FAQ
A. Yes, currently, you can only import worked holiday hours through the hours importer, and they must correspond to an existing holiday you configured in Settings.
A. Yes, the employee would receive the non-worked holiday hours, as well as the hours you included in the import.
A. Navigate to Settings > Account > Import Hours. Then, once you select New Hour Import, click on the template file link on the Import Employee Hours page.
