Calculate your CEWS or CRHP amount
Disclaimer
We do not guarantee the accuracy of this copy of the CRA website.
Scraped Page Content
Calculate your CEWS or CRHP amount
When to use the calculator
Use this calculator to:
- calculate amounts for both the Canada Emergency Wage Subsidy (CEWS) and the Canada Recovery Hiring Program (CRHP)
- see which subsidy gives you the higher amount, so you know which one to apply for
- get the line-by-line amounts you will need to enter in the application form
Before you start the calculation
Check these boxes to confirm you are prepared before you start your calculations:
- You are an eligible employer during this claim period
- Both of the following apply:
You know which of your employees are eligible for this claim period
You have access to their pay information
- Both of the following apply:
You know if you had any eligible employees on leave with pay for any full weeks during the claim period
You have calculated the employer portion of their EI, QPIP, CPP and QPP contributions during the claim period
- You have your monthly eligible revenue amounts from the current period and prior to March, 2020
- One of the following applies:
You know the total amount your eligible employees received under the Work-Sharing benefit program through Employment Insurance for this claim period
You did not participate in the Work-Sharing program (enter $0)
Before you proceed
You should understand the definitions and gather all the necessary information before you calculate your claim.
Choose your calculator
Option 1 of 2, You may prefer the online calculator if you:
- can enter employee pay on a weekly basis, and
- expect to complete your calculation now
Option 2 of 2,Choose the spreadsheet if you:
- want to enter pay on a bi-weekly basis, or
- want to save your calculation and come back to it later
- have more than one payroll (RP) account
Calculation spreadsheet
All claim period spreadsheets now include every calculation field needed to proceed directly to the application form. Using the online calculator after you use the spreadsheet to finalize your claim amount is no longer required.
Please check that you made your calculations with the most recent version.
Download the spreadsheet (Excel)
Please select a claim period to download the spreadsheet
Download the spreadsheet for periods 17 to 20 (Excel)
Current version: 2021-13
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2021-10-22 15:00:00 (EST) |
Version 2021-13 |
|
| 2021-10-08 13:35:00 (EST) |
Version 2021-12 |
|
| 2021-10-08 03:00:00 (EST) |
Version 2021-11 |
|
| 2021-09-29 10:55:00 (EST) |
Version 2021-10 |
|
| 2021-08-13 14:00:00 (EST) |
Version 2021-9 |
|
| 2021-07-30 10:20:00 (EST) |
Version 2021-8 |
|
| 2021-07-26 13:10:00 (EST) |
Version 2021-7 |
|
| 2021-07-12 07:46:00 (EST) |
Version 2021-6 |
|
| 2021-07-09 11:40:00 (EST) |
Version 2021-5 |
|
| 2021-07-08 12:15:00 (EST) |
Version 2021-4 |
|
| 2021-07-08 11:20:00 (EST) |
Version 2021-3 |
|
| 2021-07-07 15:00:00 (EST) |
Version 2021-2 |
|
| 2021-06-30 06:00:00 (EST) |
Version 2021-1 |
|
Download the spreadsheet for periods 11 to 16 (Excel)
Current version: 2021-7
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2021-06-30 6:00:00 (EST) |
Version 2021-7 |
|
| 2021-04-30 15:00:00 (EST) |
Version 2021-6 |
|
| 2021-04-14 10:00:00 (EST) |
Version 2021-5 |
|
| 2021-03-26 03:00:00 (EST) |
Version 2021-4 |
|
| 2021-02-08 09:00:00 (EST) |
Version 2021-3 |
|
| 2021-01-20 14:05:00 (EST) |
Version 2021-2 |
|
| 2021-01-17 06:00:00 (EST) |
Version 2021-1 |
|
Download the spreadsheet for periods 9 to 10 (Excel)
Current version: 2020-3
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2021-06-30 06:00:00 (EST) |
Version 2020-3 |
|
| 2020-12-22 08:45:00 (EST) |
Version 2020-2 |
|
| 2020-11-30 06:00:00 (EST) |
Version 2020-1 |
|
Download the spreadsheet for periods 7 to 8 (Excel)
Current version: 2020-6
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2021-06-30 06:00:00 (EST) |
Version 2020-6 |
|
| 2020-11-30 06:00:00 (EST) |
Version 2020-5 |
|
| 2020-11-25 08:30:00 (EST) |
Version 2020-4 |
|
| 2020-11-23 06:00:00 (EDT) |
Version 2020-3 |
|
| 2020-10-28 06:00:00 (EDT) |
Version 2020-2 |
|
| 2020-09-23 11:30:00 (EDT) |
Version 2020-1 |
|
Download the spreadsheet for periods 5 and 6 (Excel)
Current version: 2020-5
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2020-08-21 11:00:00 (EDT) |
Version 2020-5 |
|
| 2020-08-19 12:30:00 (EDT) |
Version 2020-4 |
|
| 2020-08-17 17:30:00 (EDT) |
Version 2020-3 |
|
| 2020-08-13 10:00:00 (EDT) |
Version 2020-2 |
|
| 2020-08-11 08:00:00 (EDT) |
Version 2020-1 |
|
Download the spreadsheet for periods 1 to 4 (Excel)
Current version: 2021-10
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2021-10-15 09:00:00 (EDT) |
Version 2021-10 |
|
| 2020-08-19 12:30:00 (EDT) |
Version 2020-9 |
|
| 2020-08-14 11:45:00 (EDT) |
Version 2020-8 |
|
| 2020-08-13 10:00:00 (EDT) |
Version 2020-7 |
|
| 2020-08-11 08:00:00 (EDT) |
Version 2020-6 |
|
| 2020-06-25 17:30:00 (EDT) |
Version 2020-5 |
|
| 2020-04-27 16:15:00 (EDT) |
Version 2020-4 |
|
| 2020-04-24 19:15:00 (EDT) |
Version 2020-3 |
|
| 2020-04-22 12:45:00 (EDT) |
Version 2020-2 |
|
| 2020-04-21 09:30:00 (EDT) |
Version 2020-1 |
|
Spreadsheet software compatibility
If you don't have Excel 2007 or newer, you can edit the spreadsheet in free solutions like Google Sheets, Numbers or OpenOffice.
- The spreadsheet is not compatible with Excel 1997-2003.
- There is a 5-10 minute delay when opening it in Numbers for the first time, as Numbers converts the formulas.
- You must upload the spreadsheet to Google drive to then open it in Google sheets.
- The p17-21 sheet is no longer compatible with Numbers and OpenOffice, but will still work with Google Sheets or Excel 2007 (and newer).
Note: If you have an employee that also works for a related eligible employer, you may need to manually adjust the information you enter in the spreadsheet. The combined total CEWS or CRHP amount that can be claimed for an employee between you and any related eligible employers for each week can't exceed the maximum amount for an employee. A related eligible employer is any eligible employer that you do not deal with on an arm’s-length basis.
Example of an adjustment for an employee working for related entities
Westside Restaurant Ltd. (WRL) and Eastside Bar Ltd. (EBL) are both owned by the same person. Mary works full time at WRL but also works weekends at EBL. Mary earns $1000 per week at WRL and another $300 per week at EBL.
Using the calculation spreadsheet, WRL determines the CEWS amount related to Mary for the week is $750 (75% of $1000). When EBL uses the calculation spreadsheet it shows a CEWS amount of $225 (75% of $300) for Mary. 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.
How to apply
Once you have completed the spreadsheet calculations and have determined which subsidy to apply for:
The CRA is not collecting or retaining any of the information you enter on this page or in the calculation spreadsheet. These amounts are only used to help you determine the amount of CEWS or CRHP you may be eligible to claim. You may be required to provide a full list of your employees and their Social Insurance Numbers (SIN) for verification after you apply.
Warning: This is an online calculator estimator, not the application. This page does not save any data, so if you leave or refresh the page you may need to enter the information again.
Summary of online CEWS and CRHP calculator
Line numbers refer to comparable lines you must fill out in the application form.
All amounts are for the claim period unless otherwise noted.
- Claim period: default
- Revenue drop
- Previous period (Line c0): 0.00%0.00%
- Current period (Line c1): $0.00$0.00
- Average revenue drop for previous three months (Line c2): $0.00$0.00
- Rates (based on the higher revenue drop)
- Base rate: 0.00%0.00%
- Top up rate: 0.00%0.00%
- Overall CEWS rate (Line c3): 0.00%0.00%
- Remuneration for the CRHP base period (March 14 to April 10): Ineligible$0.00
- Employees
- Eligible employees (Line A):
- Active eligible employees (Line A):
- Eligible employees on leave with pay (Line AA):
- Eligible remuneration paid (Line B):
- Basic CEWS (Line C):
- Premiums and contributions
- EI and QPIP premiums payable (Line D):
- CPP and QPP premiums payable (Line E):
- Deductions
- 10% TWS reduction (Line F):
- Work-sharing benefits received (Line G):
Further explanations will be in the summary review before the final calculation.
Arm's length and non-arm's length
Lines D and E - Employer’s EI, QPIP, CPP, and QPP premiums payable on salary paid to employees on leave with pay
10% Temporary Wage Subsidy for Employers reduction
Line F –10% Temporary Wage Subsidy for Employers reduction
For claim periods 5 and later, the amount for this line will be 0.
For periods 1 to 4, you will need to calculate the amount of your 10% Temporary Wage Subsidy (a separate program) that applies to this CEWS claim period before you enter it at Line F.
Generally, the 10% Temporary Wage Subsidy for Employers is equal to:
10% of the remuneration you paid from March 18 to June 19, 2020, up to $1,375 for each eligible employee
The total maximum of the temporary subsidy is $25,000 per employer.
CEWS and the 10% Temporary Wage Subsidy for Employers are intended to provide total support of up to 75%, the 10% Temporary Wage Subsidy for Employers in the period will reduce the amount available for you to claim under the CEWS in that same period.
You may choose to have the 10% Temporary Wage Subsidy be less than 10% of the remuneration you paid so that you can receive a higher amount of Canada Emergency Wage Subsidy. If you enter 0 as your amount for the 10% Temporary Wage Subsidy for Employers in your CEWS application, the CEWS will be determined as if you are electing 0% as the prescribed percentage for 10% Temporary Wage Subsidy for Employers, and are requesting the maximum amount of CEWS instead.
Read more: Temporary Wage Subsidy for Employers
Line G - Amounts received by eligible employees under ESDC's Work-Sharing benefit program
Enter the total amount received under the Work-Sharing program by your eligible employees during the period covered by this claim in the box for line G.
Active employees and employees on leave with pay
Print preview for CEWS statement
- Print this CEWS statement
- Close overlay
Print preview for CRHP statement
- Print this CRHP statement
- Close CRHP overlay
CRHP base period remuneration
Eligible remuneration paid to active employees between March 14 to April 10, 2021
We need the amount you paid your employees during the base period (CRHP base period remuneration) to calculate how much the amount you pay eligible employees has increased since then.
The CRHP base period remuneration is:
- the total eligible remuneration paid to all your active employees (i.e. not on leave with pay)
- paid from March 14 to April 10, 2021 (the same dates as CEWS period 14)
- limited to $1,129 per week, per employee (non-arm's-length employees are further limited to the lower of their weekly or pre-crisis remuneration)
This is not the same as the CEWS total remuneration and was not provided as part of your CEWS period 14 summary, unless you calculated for period 14 after the latest update on June 30, 2021.
Calculate your CRHP base period remuneration (opens in new window)
Compare the pre-crisis revenue options
Pre-crisis revenue and prior reference period options
Example: Choosing a revenue comparison option
Pre-crisis pay (baseline remuneration)
Claim period pay per week and active employees or employees on leave with pay
Claim period pay per week
Eligible revenue
These months are needed to calculate your revenue drops for the current period, prior period, and top-up period, using your chosen baseline.
Read more about eligible revenue (opens in new window)
- Date modified:
- 2021-12-03