How to generate the 75% Canada Emergency Wage Subsidy (CEWS) report

How to generate the 75% Canada Emergency Wage Subsidy (CEWS) report

Before following the steps in this article, ensure that you've read the Government of Canada's latest updates on the Canada Emergency Wage Subsidy program. Your eligibility may have changed.
The Government of Canada continues to support Canadians businesses facing hardship due to the global COVID-19 outbreak. With the Canada Emergency Wage Subsidy (CEWS), eligible employers can apply for a wage subsidy of up to 75% of their employee wages retroactive from March 15, 2020 to December 2020. 

To prepare your claim period data for the Canada Revenue Agency (CRA), our CEWS report helps you gain access to subsidy information per pay run and employee. Along with this report, you’ll need to provide a list of eligible employees on leave with pay, your financial statement information, net loss calculation and other documentation. For additional information from the government of Canada, visit Emergency Wage Subsidy (CEWS).

Please note that if you’re eligible for both CEWS and the 10% Temporary Wage Subsidy for Employers (TWS) and participate in both programs, you can only claim a maximum cumulative subsidy of 75% of the eligible remuneration paid to employees during this claim period. This means you must reduce your CEWS claim by all amounts you claim under the TWS for pay dates in a specific CEWS claim period. For more information on both programs, visit How the TWS and the CEWS work together

Before you begin, we highly recommend that you read the latest CRA CEWS press release from August 17, 2020 to familiarize yourself with the latest changes and eligibility requirements.

1. Navigate to Payroll, then click Reports on the left-hand menu.

2. Under Reports, click on the Custom Reports tab, then scroll down to the Payroll Reports section.

3. Under the Payroll Reports section, click on 2020 75% Canada Emergency Wage Subsidy (CEWS).

4. To select the applicable CEWS claim period, enter the start and end date as DD/MM/YYYY or use the calendar icon to choose specific dates.

You can check the specific claim periods you can apply for on Canada Emergency Wage Subsidy (CEWS).

5. Once you’re done, click the Submit button.

While both gross taxable earnings and benefits are eligible for the CEWS wage subsidy, it’s important to review the CRA documentation to ensure you’re including all eligible earnings as each company’s situation varies.
For each pay date within the claim period you've selected, you’ll generate a downloadable report for each employee showing the following:

Column name 
Organization Name
The organization the report is being run for
Business Number 
The business number the employee is being paid under
Pay Run 
Pay run identifier for the current row
Pay Date 
Pay date of the pay run for the current row
Pay Run Status 
The status of the current pay run
Employee Name 
Employee name for the current row
Employee Code 
Employee code for the current row
Current Gross Pay
Gross pay for employee for the current pay run being reported (this amount will include all taxable earnings and benefits)
Current Gross Pay
Current employee remuneration up to the $58,700 maximum
YTD Gross Pay (Capped) 
Total employee remuneration up to the $58,700 maximum
Current 75% 
75% of the current employee’s capped remuneration
YTD 75% 
75% of the employee’s capped remuneration

6. You can download and save the CEWS report as an Excel file, CSV file or PDF. 

7. You can use this CEWS report for this claim period as part of your CRA application to receive the CEWS wage subsidy.

For more information on how to submit your monthly claim, visit the official Apply for CEWS page.
If you have any questions related to CEWS eligibility requirements, calculations, the application or other related topics, please contact the CRA directly by calling 1-833-966-2099. 
Here are additional CEWS resources from CRA:

    • Related Articles

    • How to generate the Temporary 10% Wage Subsidy Report

      To view and generate the 10% Temporary Wage Subsidy Report, follow the below steps: 1. Select Reports from the side menu and click on Custom Reports. 2. Under Payroll Reports, select 2020 10% Temporary Wage Subsidy report. 3. 2020 10% Temporary Wage ...
    • COVID-19 What you need to do if you are eligible for the Temporary Wage Subsidy for Employers

      The federal government has announced the Temporary Wage Subsidy for Employers to help Canadian businesses keep employees and to recall those who were laid off. The subsidy is equal to 10% of the remuneration you pay from March 18, 2020 to June 20, ...
    • COVID-19 resources

      To ensure that you're able to access all of our documentation with what you need to know during the COVID-19 pandemic, we have catalogued the following links for your reference. COVID-19 What you need to do if you are eligible for the Temporary Wage ...
    • How do I update employee contact information?

      1. Navigate to the employee's payroll profile. For more information, check out our article on How do I access an employee file. 2. On the employee's payroll profile, select the Contact Points tab. 3. Click Edit on a pre-existing entry, or click Add ...
    • What are these reporting functions?

      How to customize a Custom Report Custom reports provide a large amount of information, and there are functions provided to help narrow down the report to just the data required. We highly recommend using the functions available to make the ...