Canada Emergency Wage Subsidy & Canada Emergency Rent Subsidy

Claim CEWS and CERS for one Qualifying Entity

In response to Bill C-20 and Bill C-9, Tax Templates Inc. built a Canada Emergency Wage Subsidy (CEWS) 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

◦   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 Dec 19, 2020

◦   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

◦   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 to Dec 19

◦   Include up to 50 properties

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

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

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*

◦   Updates for future periods

Click here to license a Qualifying Entity ($400)

If you are a preparing CEWS 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