Updated as of November 13, 2020:
The latest word from Microsoft
Microsoft has indicated that they will provide us the ability to add the four new boxes to our T4 Edit window. This is not the best solution, as next year when you run your T4s this information will be over-written.
Where will you get your numbers from?
- SSRS Report: We have written an SSRS report that will provide you with this information. It will give you a breakdown Employee by Employee and what amounts belong in which code. These amounts will be divided by province to accommodate employees with T4s in more than one province. In addition, this SSRS report will provide you the ability to drill into these amounts to acquire a more detailed view of what is included in each amount.
- Smart List Report: We are currently working on a SmartList that can be exported to Excel, or (better yet) published to an excel refreshable report. This SmartList will be a list of details that you can organize into any format you need.
How will you get those numbers into GP for a large number of employees?
- App or add-on to be created that will automate the calculation and entry into the T4 Edit window.
We are looking into a couple possibilities. Either Encore or another company will determine if something can be developed to help in this area.
- Script that can be run in SQL to update the T4 Edit window.
We are looking into developing these scripts. However, you will need to ensure you run adequate T4 reports as this data will disappear after the scripts are run.
How much will this cost?
- We will keep you posted of our offerings!
- We don’t have this information yet, but when we do, either your Client Representative will call you or you can call them for further details.
- You can also watch for our blogs and emails.
Updated as of October 26, 2020:
CRA has released a new T4, it does not offer specific boxes for the new codes. There are some text changes, but no NEW boxes. The back page offers the new descriptions. This means we will need to find a way to populate them!
- Code 57: Employment income – March 15 to May 9
- Code 58: Employment income – May 10 to July 4
- Code 59: Employment income – July 5 to August 29
- Code 60: Employment income – August 30 to September 26
We’re still waiting for Microsoft to tell us how they will be handling this.
It appears, to accommodate CRA’s ability to validate payments for the Canada Wage Subsidy (CEWS), the Canada Emergency Response Benefit (CERB), and the Canada Emergency Student Benefit (CESB), CRA is adding four Codes. These Codes will divide employment income, already reported in box 14 or Code 71, into four reporting periods:
- Code 57: Employment income – March 15 to May 9 (8 weeks)
- Code 58: Employment income – May 10 to July 4 (8 weeks)
- Code 59: Employment income – July 5 to August 29 (8 weeks)
- Code 60: Employment income – August 30 to September 26 (4 weeks)
The reporting period is the pay date, not the dates worked.
It is not clear if CRA will be releasing a new T4. It appears the information may need to be added to the existing boxes at the bottom of the T4. Currently there are six boxes. If you need to use more than six boxes, this information should spill onto a second T4.
We haven’t confirmed this yet, the current information is ambiguous.
Currently, if you tried to manually add these boxes to the T4 Edit window, it will not let you as those are not valid Codes. I am sure Microsoft will fix that.
What we don’t know yet, is how these values will be calculated. Best case scenario: Microsoft will calculate this for us, using the existing data in the tables. Worst case scenario; we will need to design a report that will pull this information for you and you will need to manually enter it.
We are watching every day for new information and will let you know as soon as we hear anything. Please get in touch if you have further questions.
Is Your ERP Software Hurting Your Business?
Discover 15 real-world inventory, accounting, and process red flags that indicate your ERP software is hurting your business.Get The White Paper