Open navigation

Review Formulas for the New Payroll Year

Anytime after the final pay of 2021 but before the first pay of 2022, you should review your earning, deduction and benefit codes to confirm whether they have formulas that need to be updated. You may need to update a formula if it contains:

  • 2021

  • V13

  • V28

  • @DATE()

  • @DATEFROM()

  • The number of weeks in the year

  • Limit amounts, commonly found in pension formulas

  • Formulas based on pay periods

How to Review your Formulas on Earning Codes

Step 1: Open Earning Codes in the Avanti Desktop Application.
By default, this can be found in Canadian Payroll >> Employer Payroll Tables.

Step 2: Select Print.

Step 3: Select Print Preview to display the Results.

Additional Information
If Print Preview is not displayed, go to the Printer Setup tab and select Printer for Destination. Now Print Preview will show.

Step 4: Confirm whether the formula on the earning code needs to be updated. You may need to update a formula if it contains:

  • 2021

  • V13

  • V28

  • @DATE()

  • @DATEFROM()

  • The number of weeks in the year

  • Limit amounts, commonly found in pension formulas

  • Formulas based on pay periods

Step 5: If the formula needs to be updated, note the earning code.

Step 6: Repeat Step 4 - 5 for each earning with a formula.

Step 7: Close Print Preview, then select Cancel to close the print.

Congratulations! You have finished reviewing the formulas for Earning Codes.

Update the Earning Code Formula

Step 1: Open Earning Codes in the Avanti Desktop Application, if it’s not already open.
By default, this can be found in Canadian Payroll >> Employer Payroll Tables.