Facebook tracking

Canada Emergency Wage Subsidy, Canada Hiring Recovery Program, & Canada Emergency Rent Subsidy

Claim CEWS/CRHP and CERS for one Qualifying Entity

In response to Bills C-20, C-9, and C-30, Tax Templates Inc. built a Canada Emergency Wage Subsidy and Canada Recovery Hiring Program (CEWS/CRHP) and a Canada Emergency Rent Subsidy (CERS) worksheet to help businesses and their advisors calculate their claims.

The CEWS worksheet is filled with features, including: 

◦   All calculations managed in one well-designed and integrated worksheet (video overview)

◦   Optimization of the “CEWS 2.0” for each employee for each week to receive the maximum benefit available

◦   Maximizing CEWS & CRHP for each qualifying period to maximize the subsidy available for periods 17+

◦   Macro to automatically import data from prior CEWS worksheets (video instructions)

◦   Built-in deeming provisions to automatically claim CEWS based on prior period qualifying revenues

◦   Built-in deeming provisions to help maximize the revenue reduction percentage for each qualifying period

◦   Built-in deeming provisions to help maximize the top-up percentage for Period 8 through Period 10

◦   Maximizing the “pre-crisis” baseline remuneration for each employee based on all four period options

◦   Determining if any employee is without remuneration for 14 consecutive days

◦   Flexibility to choose between the “General” and the “Alternative” baseline revenue approach

◦   Flexibility to choose the Period 4 revenue drop percentage to be used in Period 5 (video overview)

◦   Calculate claims from Mar 15, 2020 to Nov 20, 2021

◦   Wage subsidy amounts for both active and paid-leave employees

◦   Supports payroll frequency of weekly, biweekly, semi-monthly, and monthly (or enter daily amounts)

◦   Support for entities with two payroll frequencies (e.g. bi-weekly and monthly together)

◦   Summary reconciliations for employees to streamline 2020 T4 reporting

◦   Built-in filing deadlines and applicable tax elections

◦   Include up to 1,000 employees

The CERS worksheet has the features you need, including: 

◦   All calculations managed in one well-designed and integrated worksheet (video overview)

◦   Built-in deeming provisions to maximize the revenue reduction percentage for each qualifying period

◦   Flexibility to choose between the general and the alternative baseline revenue approach

◦   Support for claims from Sep 27, 2020 to Nov 20, 2021

◦   Include up to 50 properties

Our detailed walkthrough videos show you how to complete every step with confidence.

15 videos totalling about 30 minutes explain each step of the calculation, and how to enter the necessary data correctly: revenues, employees, baseline remuneration, payroll data, and rent data.

Additional 30 minute webinar recording with client Q&A recorded in Feb 2021.

Outputs are easy to review, and reconcile to your records to help ensure data correctness.

What you’ll need to start

◦   Payroll information since Mar 2019

◦   Rental information since Sep 2020

◦   Monthly revenues since Jan 2019

◦   Microsoft Excel 2010 (or later)

What your licence includes

◦   Use of TTI’s CEWS worksheet for one entity

◦   Use of TTI’s CERS worksheet for one entity

◦   Technical support by email*

◦   Email notifications of worksheet updates

Click here to license a Qualifying Entity ($500)

If you are a preparing CEWS/CRHB and CERS calculations for multiple entities, please click here. All licences are subject to TTI’s Licence AgreementIf you have any product questions, please email sales@taxtemplates.ca before purchasing.

*If you need a tax/legal opinion for your exceptional situation, we’re happy to introduce you to a qualified tax law firm.

TTI helps me show the value of our tax planning strategies to clients.
More than just an average tax rate, they can see precisely where each dollar ends up using easy to understand charts.

David T. Lloyd, CPA, CA

Co-Founder & Chief Wealth Management Officer, Newport Private Wealth