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.
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 |
---|---|---|
Version 2022-11 |
|
|
Version 2022-10 |
|
|
Version 2022-9 |
|
|
Version 2022-8 |
|
|
Version 2022-7 |
|
|
Version 2022-6 |
|
|
Version 2022-5 |
|
|
Version 2022-3 |
|
|
Version 2021-2 |
|
|
Version 2021-1 |
|
Download the spreadsheet for periods 17 to 21 (Excel)
Current version: 2021-14
Version updates
Release date |
Version | Description |
---|---|---|
Version 2021-14 |
|
|
Version 2021-13 |
|
|
Version 2021-12 |
|
|
Version 2021-11 |
|
|
Version 2021-10 |
|
|
Version 2021-9 |
|
|
Version 2021-8 |
|
|
Version 2021-7 |
|
|
Version 2021-6 |
|
|
Version 2021-5 |
|
|
Version 2021-4 |
|
|
Version 2021-3 |
|
|
Version 2021-2 |
|
|
Version 2021-1 |
|
Download the spreadsheet for periods 11 to 16 (Excel)
Current version: 2021-7
Version updates
Release date |
Version | Description |
---|---|---|
Version 2021-7 |
|
|
Version 2021-6 |
|
|
Version 2021-5 |
|
|
Version 2021-4 |
|
|
Version 2021-3 |
|
|
Version 2021-2 |
|
|
Version 2021-1 |
|
Download the spreadsheet for periods 9 to 10 (Excel)
Current version: 2022-4
Version updates
Release date |
Version | Description |
---|---|---|
Version 2022-4 |
|
|
Version 2020-3 |
|
|
Version 2020-2 |
|
|
Version 2020-1 |
|
Download the spreadsheet for periods 7 to 8 (Excel)
Current version: 2020-6
Version updates
Release date |
Version | Description |
---|---|---|
Version 2020-6 |
|
|
Version 2020-5 |
|
|
Version 2020-4 |
|
|
Version 2020-3 |
|
|
Version 2020-2 |
|
|
Version 2020-1 |
|
Download the spreadsheet for periods 5 and 6 (Excel)
Current version: 2020-5
Version updates
Release date |
Version | Description |
---|---|---|
Version 2020-5 |
|
|
Version 2020-4 |
|
|
Version 2020-3 |
|
|
Version 2020-2 |
|
|
Version 2020-1 |
|
Download the spreadsheet for periods 1 to 4 (Excel)
Current version: 2021-10
Version updates
Release date |
Version | Description |
---|---|---|
Version 2021-10 |
|
|
Version 2020-9 |
|
|
Version 2020-8 |
|
|
Version 2020-7 |
|
|
Version 2020-6 |
|
|
Version 2020-5 |
|
|
Version 2020-4 |
|
|
Version 2020-3 |
|
|
Version 2020-2 |
|
|
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.
Privacy statement: This calculator does not collect or store your information
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.
Page details
- Date modified: