Open navigation

The Canada Emergency Wage Subsidy Report

The Canada Emergency Wage Subsidy will provide 75% of your eligible remuneration paid to employees, up to a limit, for qualifying employers.

Download and Import the Report

  1. Download & save the .ardx file to an accessible location;
  2. Open the Report Designer>Report Definitions screen;
  3. Go to File>Import, browse to the file;
  4. Give it a Definition Name (ID), then you can open, edit, & run it.

Use this Report to Determine Your Eligibility

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.

  1. Download the visual guide or continue reading to learn how to use this report
  2. Download this sample report CSV for additional reference
  3. 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

How to Determine Eligible Remuneration

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

Calculate Your Subsidy Amount

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.

A screenshot of a cell phone

Description automatically generated

A close up of a sign

Description automatically generated

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.

A close up of a logo

Description automatically generated

A screenshot of a cell phone

Description automatically generated

  • Total basic CEWS for these employees during this claim period will be the total of column 13 in the CEWS report.

A screenshot of a cell phone

Description automatically generated

3) Premiums and contributions

Total EI, QPIP, CPP and QPP contributions (for the claim period) can be found in your Avanti Remittance Report

A close up of a logo

Description automatically generated

A screenshot of a cell phone

Description automatically generated

4) Deductions

If you previously claimed the 10% wage subsidy you will enter the total claimed here.

 A screenshot of a cell phone

Description automatically generated

You should now be able to apply for CEWS, for all the details on how to apply, learn more from CRA 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?

  1. How to Use the Report to Determine Your Eligibility
  2. Calculate Your Subsidy Amount
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.