Skip to main content
Sparkrock's Customer Success Center

How to Setup Tax Year Changes

The instances below are sample instructions you can follow in case there are setup changes in the new tax year.  All of the following content is for illustration purposes alone. For the current year numbers please refer to 2018 Payroll Tax Update Canada.

Brackets

The majority of tax related information is stored in Brackets used in the calculation of payroll controls.

  1. Open Brackets, using the NAV Search bar and begin typing Bracket
  2. In all cases, you will use the Copy function from the Actions ribbon to create new records and the Details button from the Navigate ribbon to update the rates, limits and amounts as they apply to the new taxation year.

    Note: These images are from version 2016 and the form layout may vary from your version of the product.

Copying an Existing Bracket

  1. From the Brackets form, highlight the bracket you wish to modify (based on the list of affected brackets).
  2. If you find more than one bracket with the same Code, select the Code with the most recent Effective Date.
  3. With the desired line highlighted, choose the Copy button.
  4. On the Copy Bracket form, enter the Effective Date of the new bracket.
  5. Choose OK on the Copy Brackets form.
  6. From the Brackets form, highlight the new line with the Code and Effective Date used in the above steps.
  7. Choose the Details button.
  8. Complete the Bracket Details form using the descriptions included in federal and provincial table amounts for the taxation year.
  9. Close the Bracket Details form when completed.
  10. From the Brackets form, choose the next Code and repeat steps 2 through 10.

Example using CPP LIMITS:

  1. Once the Brackets form is open, select the existing relevant record and click Copy.
  2. Enter the New Effective Date and click Ok.

    Note: This image is a sample, and is for illustration purposes only. Please refer here for current values.

    Note: This image is a sample, and is for illustration purposes only. Please refer here for current values.
  3. Change the values as required using the detail in the following Federal and Provincial tables.

    Note: This image is a sample, and is for illustration purposes only. Please refer here for current values.

Base Amount Changes

  1. If there has been a change to the definition of taxable, pensionable or insurable earning you will need to revise the Base Amount used in the calculation of the tax deduction.
  2. For example, the Employer paid premiums for AD&D became a taxable benefit for the 2013 tax year and were included in the CPP and income tax calculation. 

Calculation Method Changes

You may use the following steps to perform method changes setup.
Note: The content and images below are a sample for ON TAX, and is for illustration purposes only. Please refer here for current changes.

  1. From the Payroll Control list, select the ON TAX code and choose Calc. Method from the Navigate page ribbon.
  2. From the Payroll Calc. Method page, select the bottom line and choose Copy from the Home page ribbon.
  3. From the Copy Payroll Control Calc. Method page, set the new effective date value such as: 01/01/18 and choose OK to close the page.
    Note: Enter the date when the new version becomes effective.
  4. From the Payroll Calc. Method page, select the new line and choose Steps from the Home page ribbon.
  5. Select the line with the method step code APPLY SURTAX and choose Delete from the Home page ribbon.

    Calc Method Copy example 1-pp.png 
    Note: This image is a sample, and is for illustration purposes only. Please refer here for current values.
    Calc Method Copy example 2-pp.png 
    Note: This image is a sample, and is for illustration purposes only. Please refer here for current values.
  6. Select OK to close all pages.

Undo Calculation Method Changes

You may use the following steps to undo method changes setup and restore the prior formula if you did any changes as per Step 5 of Calculation Method Changes section above, and need to undo them.
Note: The content and images below are a sample for restoring ON TAX, and is for illustration purposes only. Please refer here for current changes.

  1. From the Payroll Control List, select the ON TAX code and choose Calc. Method from the Navigate ribbon.
  2. From the Payroll Calc. Method page, select the line with the effective date such as: BEFORE 07/01/18 and choose Copy from the Home ribbon.
    Note: Enter the date when the new version becomes effective.
  3. From the Copy Payroll Control Calc. Method page, set the new effective date value such as: 07/02/18 and choose OK to close the page.
    Note: Enter the date when the new version becomes effective.

TD1 Amount Changes

When changes are made to the Federal and Provincial TD1 amounts, these amounts will affect the Total Credits Claimed field of the Employee Tax Auth. Info. Setup.
Note: Additional TD1 information is included below for reference purposes. Please refer here for current values.

For Individual Employees:

  1. To perform a Search, go to the NAV Search bar and typing hr emp. 
  2. From the short list, select HR Employees.
    Altus8.png
  3. Select your employee and click on Tax Auth. Info numerical link found in the Payroll Factbox.
  4. You can manually change the values in this page.
    NOTE: We recommend using the mass process. 

To perform a Mass Search:

  1. Go to the NAV Search bar and begin typing mass employee.
  2. From the short list, select Mass Employee Tax Info Update.
    Altus9.png
  3. Enter the new effective date.
  4. Enter the Federal old and new TD1 Amount.
  5. Enter the Provincial Reporting Authority old and new TD1 amounts.
  6. The process will also perform a search for employees with the old value and will insert a new entry with the new effective date in the Employee Tax Authority Info table.
  7. Both Print and Preview will give you a view of what will be changed.
    Note: To view only (before executing changes), keep the checkmark in the Test Print field.
  8. To execute the changes, you must remove the checkmark from the Test Print field.
    Altus10.png
    Note: This image is a sample, and is for illustration purposes only. Please refer here for current values.
  • Was this article helpful?