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

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

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. Log into Payroll, then click Reports on the left-hand menu.



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



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


  1. 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. 


Note: 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. 

Note: 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 

Description

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

(Capped)

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 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, ...
    • How to run the journal entry utility

      The first time: Download the Microsoft Toolkit Download this file before opening the Utility : http://download.microsoft.com/download/xml/Install/3.0/W982KMeXP/EN-US/SoapToolkit30.EXE Running the Journal Entry Utility: 1. Open the Utility and save ...
    • 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 ...
    • How do custom reports work?

      Opening a custom report Select Reports on the side menu and choose the Custom Reports tab. Click on any custom report to view or edit. To see a detailed list of which data is included in each report, check out our article on What information is in ...