In this article, you will learn about the different ways to forecast hourly or custom payroll amounts over time.

Formula Guide


Salary based on a Fixed Hourly Rate x Fixed Hours Each Month or a Fixed Amount:


For this example, my employee will work 30 hours a month at a $20 per hour rate.

Step 1: On the employee's / contractors section, Click + Add Employee:

Step 2: Fill in the employee/contractor details such as department, role, job title, and name. (If the name isn't available enter TBD)

Step 3: For Salary, select "Custom Formula" this will allow you to create a custom formula to forecast your employee salary on a monthly basis.

Step 4: Fill in the remaining details such as Start Date, Load Multiplier, Bonus/Commission, etc. then click Add Employee.

Please note: For a fixed salary amount each month such as $3000.00 per month, enter 3000 into the fx variables bar.

Salary Based on a Custom Amount Each Month:


Step 1: Start in the fx variables section and click + add custom variable:

Step 2: Enter the name of the variable, as shown below:

Step 3: Select the Function, for this example I will use a $ (Currency):

Step 4: Scroll to the month of the employee's start date and enter the employee's payment details. This will calculate the salary based on the value entered into the month.

Step 5: Navigate to the Employee / Contractor Section and follow Steps 1 & 2 from Salary based on a Fixed Hourly Rate x Fixed Hours Each Month or a Fixed Amount:

For salary, click Custom Formula. In the fx variable bar enter Custom.SalaryforEmployee1 (name of custom variable)

Once all the employee details are entered, click Add Employee.

Did this answer your question?