Open navigation

Rate Grid: Setup Guide

Rate Grids let you control the rate of a Position without needing to enter the rate directly on the position. You can setup a Rate Grid so that it increases the rate automatically after a specific date. This is beneficial because you can update the Rate Grid once and have the new rates applied to any position using that Rate Grid automatically.

For example,

If you had a salaried position with an annual pay increase, you could enter each pay-increase and the date they will occur as Effective Dates in the Rate Grid and the rates will automatically update.

 
Example levelled rate
Instructor Salary Category 1

Year

Rate

2018

46,032.000

2019

48,000.000


2025

53,933.000

Tip:
We will be using this example for through the following steps to create a starting rate for the Rate Grid, then adding a future rate using an Effective Date for the Rate Grid.

Insert Rate Grid

  1. Open Canadian Payroll > Employee Payroll Tables > Rate Grid.

  2. Open the Rate Grid setup by pressing Insert.

  3. Enter the Grid Code, Description, and the Default Rate for this Rate Grid.

  4. Save the new Rate Grid by pressing Apply.

7 31 2018 10 09 43 AM
Important:
You must save the Rate Grid before adding Effective Dates to the Rate Grid.

Add Effective Dates (Optional)

Effective Dates allow the Current Rate of the Rate Grid to be updated automatically on a specified date.

  1. Add a new Effective Date to the Rate Grid by pressing Insert.

  2. Choose the Effective Date for the new rate.

  3. Enter the new Rate that will be applied on the Effective Date.

  4. Add the Effective Date to the Rate Grid by pressing OK.

  5. Save the Rate Grid by pressing OK now.

7 31 2018 10 14 54 AM
J
Jack is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.