Set Up a Rate Table

1. Select Setup > Employees > Benefits > Rate Table Setup.
2. From the Employer drop-down list, select DEU (or DEC if using Canadian sample data).
3. Click Add. The Benefit Rate Table Setup Detail page opens.
4. For our example, enter GTL-MO in the Code field and GTL Taxable - Mo in the Description field.
5. On the Column 1 tab, enter Employee's Age as the Column Heading.
6. From the Column Match Types drop-down list, select Up To and Including since we are defining rates to calculate the taxable portion of employees excess life coverage.
7. In the Column Expression field, enter: Yearsold(). Because you are only checking for one condition, do not enter any information for Column 2 or 3.
8. Click the Rate Table tab. Notice that Sage HRMS has defined the column Employee's Age. Now you can set the order and rates.

Entering Rate Table Data

1. When you set rates for the conditions you are checking for (in our example, Employee's Age), you specify the order in which Sage HRMS checks the conditions and the rates it should use for those conditions.
2. On the Rate Table tab, click Add. Sage HRMS automatically inserts the number 1 in the Order column of the first row.
3. Press Tab to move to the Employee's Age column. Follow the table below to help you define the rates. These rates use the standard calculations in the IRS age table setup.

Note: Before setting up your rate table, be sure to verify current IRS calculations, since they are subject to change.

Order	Employee's Age	Rate
1	24	((be.b_coverage-50000)/1000)*.05
2	29	((be.b_coverage-50000)/1000)*.06
3	34	((be.b_coverage-50000)/1000)*.08
4	39	((be.b_coverage-50000)/1000)*.09
5	44	((be.b_coverage-50000)/1000)*.10
6	49	((be.b_coverage-50000)/1000)*.15
7	54	((be.b_coverage-50000)/1000)*.23
8	59	((be.b_coverage-50000)/1000)*.43

4. Repeat the process, clicking Add for each new rate, until you've completed the rates for the example plan.
5. Click OK to save your rate table. Sage HRMS returns you to the Benefit Rate Table Setup page. Notice the GTL-MO plan has been added to your list of rate tables.
6. Click OK to save the rate table.
7. Now that you've set up your rate table, you're ready to add the benefit plan.

Published: May 17, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks