What is it?
Use the employee template to help plan and manage hourly employees.
Creating an Hourly Employee Template
Under a Workbook
Click the "+" button to open the Create dropdown
Select Hourly Employee Template
How is monthly Hourly Employee compensation calculated?
Basis calculates a monthly salary for the employee based off the Rate per hour and the hours per week. We assume 4 weeks in every month for the monthly calculations. If the start date is on a date past the first of the month the cost is prorated.
Output Hourly Employee Metrics
Headcount
The number of active hourly employees. Calculated as a count of hourly employees with a start date that is on or before the month and does not have an end date before that month.
Churn
The number of hourly employees that leave the company. Calculated as a count of hourly employees with an end date of the previous month.
Bonus Amount
The monthly accrued annual bonus amount. It is the sum of all employees' Annual Salary multiplied by their Bonus % and divided by 12 to get the monthly value.
The monthly accrued bonus for the hourly employee. Calculated as the Bonus % multiplied by the Rate per Hour multiplied by the Hours per Week, and finally multiplied by 4.
Hourly Employee Template Dimensions
Name
Name of the hourly employee. Not used in calculations.
Role
Role of the hourly employee. Not used in calculations but can be used for grouping and filters.
Start Date
First day of employment for the hourly employee. Determines when the monthly salary starts getting calculated. The monthly salary is prorated if the employee starts on a day past the 1st of the month.
End Date
Last day of employment for the hourly employee. Determines when the monthly salary ends. The last day of employment is not used to calculate the monthly salary.
Rate / Hour
The rate per hour the hourly employee makes. Used in conjunction with Hours per week to calculate the monthly salary.
Hours / Week
The number of hours per week the employee works. Used in conjunction with Rate per hour to calculate the monthly salary.
Type
Free form field. Not used in calculations but can be used for grouping and filters.
Pay Raise Month
The month, as a number from 1-12, of when this hourly employee will get a raise (1 = January, 2 = February, and so on). The pay raise will go into effect if it's at least one month in the future. Used in conjunction with Pay Raise % to determine when and how much monthly salary will increase for the employee.
Pay raise %
The % increase on the annual pay for Pay raises. Monthly pay will then be used to calculate the monthly values for the hourly employee when the Pay Raise Month occurs.
Bonus %
Annual bonus based on a % of the Rate per Hour. Bonuses do not get included in the monthly salary values and instead are added to the Bonus Amount metric.
Integrations Available
Sync any connected Payroll integration. Hourly Employee templates automatically filter out non-hourly employees from syncing with this template. Hourly employees are configured within your Payroll provider.
Common Add-ons
Custom Metrics
Total Hourly Employee Cost
Calculates the total monthly cost for all hourly employees inside the workbook.
sum of [hourly employee template name]
New Hourly Employees
Calculates the number of new hourly employees for a month.
Headcount(month) - Headcount(month-1)
Total Hourly Employee Cost by Department
Calculates the total monthly cost per month of all hourly employees of a certain department inside the workbook. Requires the Department dimension to be created.
sum of [hourly employee template name] where Department is [department name]
Custom Dimensions
Department
Used to categorize hourly employees into different departments.
Custom Assumptions
Benefits
Set a cost % of salary to calculate monthly costs for benefits
Equipment Cost
Set a fixed cost per employee to calculate equipment costs for each new employee
Limitations
This template doesn't currently support non-regular timeframe hourly employees (eg/ works every other month).
We assume there are 4 weeks in every month. This can cause some months to be over or under budget compared to actuals and should be manually adjusted in a custom reconciliation line item.
Manually setting actuals for monthly values for manually created hourly employees. This will cause the past month's values to not match with the Chart of Accounts for payroll and need to be manually reconciled in a companion Block or within the COA forecast.