The Canada Emergency Wage Subsidy will provide 75% of your eligible remuneration paid to employees, up to a limit, for qualifying employers.
- If you're looking for information on the 10% Temporary Wage Subsidy, read this Help Centre article;
- We are providing this report to help you gather the numbers you will need to assess your eligibility;
- We have also included a step-by-step guide on inputting the data from this report into the CRA calculator;
- For an in-depth understanding of the CEWS, please read the CRA's application guide.
Download and Import the Report
- Download & save the .ardx file to an accessible location;
- Open the Report Designer>Report Definitions screen;
- Go to File>Import, browse to the file;
- Give it a Definition Name (ID), then you can open, edit, & run it.
Please Note: Due to the presence of SQL formulas, the user that runs this report MUST have access to ALL Pay Groups. If this will not be possible for your organization, please contact Client Care.
- Download the visual guide or continue reading to learn how to use this report
- Download this sample report CSV for additional reference
- For additional information on determining eligible remuneration, go here
The report is set to automatically gather and calculate the pre-crisis average per pay period earnings, and convert them to a weekly value. It will account for periods with no earnings, and exclude from the average. This happens in column 6.
*this prints in green
Run the report for the desired group of employees for the desired eligible date range - make sure that the History option is by Cheque Date, as the Federal Government is requesting this by paid dates.
- Columns 8 & 9 track the paid remuneration per period, by period.
- Column 10 converts this to 75% of a weekly value, and applies the weekly limit.
- Column 11 applies the 75% and limit to the pre-crises average from column 6.
- Column 12 applies the formula to take the greater of 75% actually paid (to the limit), or 75% of the pre-crisis average.
For example, if you are paying 50% of the pre-crisis amount, it will show what was paid, if you are paying more than the pre-crisis average, it will show 75% of what you paid, up to the limit.
*prints in blue
Column 13 converts back to a per period amount. The total of Column 13 should be the amount that you can claim.
*prints in red
This report has filters set for excluding non-taxable earnings and benefits, as well as excluding some exempt earnings (such as Stock Options). This filter assumes correct T4 box coding in the Earning and Benefits codes - please double check these if you have added or changed codes since you last extracted T4s. You may need to add to the filter to remove any additional earnings or benefits that are taxable/reported to box 40 or 14 that are considered exempt - such as personal use of an employer's vehicle.
There are two places that this will need to be entered into the report, the Data Filter, and the Formula on Column 6.
Under Data Filters, you will need to add a "Not In" filter for the codes to be excluded from the Earning Codes and the Deduction/Benefit Codes.
In the below example, we are assuming that Earnings 205 & 301 are not to be included in these calculations, as well as Benefit amounts from codes 631 & 725.
Please Note: you can type in the list of codes, separated by commas, with no quote marks - Earning Codes must be 3 digits, with leading zeroes e.g. 001 or 026
For the Earning Codes:
For the Deduction/Benefit Codes:
In the Formula in Column 6, you will need to add the Earning Codes to the end of line F1, and the Benefit Codes to the end of line F2. Replace the '000' in the bracketed section at the end as per below.
Please Note: the codes need to be in single quotes, and separated by commas
Here's a step-by-step guide on inputting your report data into the CRA calculator. You'll be referring to the CEWS report you just built and your Avanti Remittance report, so have them handy!
1) Claim period
Select your claim period.
2c) Gross payroll for eligible employees
- Total number of eligible employees can be found at the bottom of CEWS report.
- Total eligible remuneration paid to these employees during the claim period will be the total of Column 8 plus column 9 in the CEWS report.
- Total basic CEWS for these employees during this claim period will be the total of column 13 in the CEWS report.
3) Premiums and contributions
Total EI, QPIP, CPP and QPP contributions (for the claim period) can be found in your Avanti Remittance Report
If you previously claimed the 10% wage subsidy you will enter the total claimed here.
All the downloads referenced in this article can be found at the attachment links below. Need to find your back up to where you were?