Open navigation

2020 Federal TD1 Settings

If you choose to go with the TD1 Federal Basic Personal Amount of $13,229, rather than $12,298, please run the below Script.

To run the Script, save the file to an accessible location, then, from within Avanti, go to:
System Administration>Database Functions>Run SQL Script


From the "Script File" drop down, browse to, and select, the .sql script file you just downloaded/saved, and click "Run".

The Script Result pane will indicate afterwards how many lines were affected. This number may exceed your current active employee count - inactive employees will also be updated, as well as Spousal & dependent amounts, where applicable.

This script will update all base personal amounts from $12,298 to $13,229.  Where base personal amounts were not equal to $12,298 (e.g, 0 for claim for a second job), the basic claim will not be affected. All changes will be properly change logged.


For further details, please check out our 2020 TD1 details article here: https://help.avanti.ca/support/solutions/articles/36000205448-2020-td1-aditional-details 




PLEASE NOTE that as everything is presently set in Avanti, all new hires after this UpdateFedT1Values.sql script is run will default to a base personal amount of $12,298 and this will need to be changed manually.

 

If you are using Avanti’s On-Boarding Tool, you have no need to worry, as all employees complete their TD1 as required when they are on boarded.

 

If you are not using Avanti’s On-Boarding tool and desire to have all new hires going forward set with the base personal amount of $13,229, we have a second SQL script that can be run. If you would like to have this script, please reach out to our Client Care team at  Care@Avanti.ca and we would be happy to provide it to you. After this second script is run, all new hires will default to the base personal amount of $13,229. 

C
Charles 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.