Calculate your wage subsidy amount
Disclaimer
We do not guarantee the accuracy of this copy of the CRA website.
Scraped Page Content
COVID-19 wage and rent subsidies for businesses
Calculate your wage subsidy amount
On this page
When to use the calculator
Use this calculator to verify applications you made before the subsidy program ended.
- Calculate amounts for:
- Tourism and Hospitality Recovery Program Wage subsidy (THRP - Wage) - claim periods 22 to 28
- Hardest-Hit Business Recovery Program Wage subsidy (HHBRP - Wage) - claim periods 22 to 28
- Canada Recovery Hiring Program (CRHP) - claim periods 17 to 28
- Canada Emergency Wage Subsidy (CEWS) - claim periods 1 to 21
- See which subsidy gave you the higher amount, so you can determine which you should have applied for
- Get the line-by-line amounts you needed to enter in the application form
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 RP account
Calculation spreadsheet
All claim period spreadsheets now include every calculation field that was used in the application form.
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 22 to 28 (Excel)
Current version: 2022-11
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2022-05-27 13:30:00 (ET) |
Version 2022-11 |
|
| 2022-05-06 12:00:00 (ET) |
Version 2022-10 |
|
| 2022-04-26 15:00:00 (ET) |
Version 2022-9 |
|
| 2022-04-14 10:00:00 (ET) |
Version 2022-8 |
|
| 2022-03-29 06:00:00 (ET) |
Version 2022-7 |
|
| 2022-02-17 06:00:00 (ET) |
Version 2022-6 |
|
| 2022-02-07 06:00:00 (ET) |
Version 2022-5 |
|
| 2022-01-05 06:00:00 (ET) |
Version 2022-3 |
|
| 2021-12-24 12:00:00 (ET) |
Version 2021-2 |
|
| 2021-12-21 06:00:00 (ET) |
Version 2021-1 |
|
Download the spreadsheet for periods 17 to 21 (Excel)
Current version: 2021-14
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2022-02-07 07:00:00 (EST) |
Version 2021-14 |
|
| 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: 2022-4
Version updates
| Release date |
Version | Description |
|---|---|---|
| 2022-11-08 14:00:00 (EST) |
Version 2022-4 |
|
| 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 who also works for a related eligible employer
If you have an employee who 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.
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 wage and payroll support 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 your online wage and hiring calculation
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
- 12-month average revenue drop: 0.00%
- THRP and HHBRP eligibility: IneligibleTHRP (Lockdown)THRPHHBRP
- CRHP base period remuneration (March 14 to April 10): Ineligible$0.00
- 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%
- 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%, not 75% + 10%. If you are eligible for both wage subsidies for a claim period, any amount you calculate under 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.
Qualifying public health restriction
Active employees and employees on leave with pay
Print preview for CEWS statement
- Print this statement
- Close overlaybeneath the summary
Print preview for CRHP statement
- Print this statement
- Close 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 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
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)
Page details
- Date modified:
- 2022-10-27