Employees … April 16, 2020 update: CRA’s plan is to open the portal for the Canada Emergency Wage Subsidy on April 27. There are a lot.To perform the calculations, we’ll need the following data from our payroll system:First, we need to build a list of employees who were employed during the claim periods (from March 15 to June 6, 2020).

This equates to a maximum weekly base subsidy of $677. This requirement is eliminated effective July 5, 2020 for Period 5 and beyond.The CEWS is available in respect of “eligible remuneration paid” to employees with respect to any of the weeks in the applicable claim period, capped at $1,129 per week. On July 17, the government announced proposed changes to the CEWS. Books and records should clearly support the employer’s eligibility for the wage subsidy in a given qualifying period.To support an employer’s claim that the revenue has declined, adequate calculations should generally be prepared and maintained. When EBL uses the spreadsheet calculator it shows a CEWS amount of $225 (75% of $300) for Mary. Use the calculator only for eligible employees.

However, the total of those two amounts ($750 + $225) is $975 – which exceeds the maximum of $847 by $128.The claim amount of WRL or EBL will need to be manually reduced by a total of $128 so that the total CEWS amount related to Mary does not exceed the $847 maximum for that week.As part of the CEWS, employers can claim a 100% refund for the employer-paid part of contributions made on behalf of eligible employees who are furloughed (on Indicate the total amount of premiums or contributions during the selected period. But, until then, we’ll be using our template.Dave is a Partner at LiveCA, overseeing the Finance and Strategy Operations at the firm. See the CRA FAQ on the Temporary Wage Subsidy for Employers for more information. Large employers should not expect to receive such leniency.A signed attestation and record of any elections made for the purposes of determining “qualifying revenue” must also be maintained and made available to the CRA upon request.Employers are expected to report the eligible remuneration paid to each employee in respect of the qualifying periods using a new code in the “Other Information” section at the bottom of employees’ T4 slips. The CRA will require you to fill out a self-identification form, that will be published in the coming months, in order for us to credit your payroll program account by the amount of the subsidy. If an employee works for more than one related employer, the total amount of the subsidy received by those employers cannot exceed the amount of the subsidy calculated as if the employee had only worked for one of the employers. Wagepoint’s Employee Details Report contains After creating a new Google Sheets file, in a tab named Same thing with eligible premiums, which are used in section 3 of the CRA’s online calculator:We’ll then pull the total of the eligible remuneration element types for each employee for each semi-monthly pay period.

The government has announced the program will be extended to December 19, 2020, but has not provided details of the revenue reduction conditions that will be applicable to that period.To be eligible for a four-week qualifying period under the CEWS, an eligible employer must file an application prior to February 2021, provide an attestation signed by the individual who has the principal responsibility for the employer’s financial activities that the application is “complete and accurate in all material respects,” and have a Canada Revenue Agency (CRA) payroll account on March 15, 2020. On May 15, 2020, the federal government The CEWS is designed to provide a subsidy in respect of four-week claim periods (each referred to in the [The Tables in this publication have been reproduced or adapted from the following government websites The rules applicable to Periods 1 through 4 are the same as those reported in our prior publications. My formula covers up to 30 possible element types, which is very likely overkill:We’ll also calculate the number of days each employee was employed for during each semi-monthly pay period:And the number of days each employee was employed for during each week:Using these numbers, we can calculate the average weekly gross pay between January 1 and March 15, 2020, which is factored into the eligibility calculations later on:Finally, we have what we need to calculate the weekly gross pay.As briefly discussed above, we need to factor in the following for each week:With all those factors considered, we can calculate each week’s gross pay (with what is likely a very long formula for the weeks that span multiple pay periods — or, alternatively, by breaking out all 84 days contained in the claim periods to individual columns and then adding those up):Lastly (for this tab), I like to add a check figure to compare our “Data for CRA Calculator” section with the “Data from Wagepoint” section to make sure everything’s calculating correctly:We can duplicate this tab and use it as a base for our CPP/QPP and EI/QPIP calculations.

It has not released a detailed number for this part of the calculation.Amounts paid to non-arm’s length employees may be eligible for subsidization through the CEWS, provided that such employees have baseline remuneration.For Periods 1 to 4, the subsidy for non-arm’s length employees is based on the total amount of eligible remuneration paid to the eligible employee, to a maximum of $847/week, or 75% of the employee’s “baseline remuneration”, whichever is less.