Open navigation

Review Formulas for the New Payroll Year

Anytime after the final pay of 2022 but before the first pay of 2023, 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:

  • 2022

  • 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:

  • 2022

  • V13

  • V28

  • @DATE()

  • @DATEFROM()

  • The number of weeks in the year

  • Limit amounts, commonly found in pension formulas

  • Formulas based on pay periods