Facebook tracking

The TTI Suite – Tax Accounting

Designed to make difficult or tedious calculations easy, and minimize the WIP during all stages of your workflow.
Wage Subsidies

In response to Bill C-30, Bill C-20, and Bill C-9, Tax Templates Inc. has built a Wage Subsidies worksheet to help businesses and their advisors calculate their claims.

This worksheet is filled with features, including:

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

◦   Optimization of the CEWS 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 Jul 31, 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


Rent Subsidies

In response to Bill C-30 and Bill C-9, Tax Templates Inc. has built a Rent Subsidies worksheet to help businesses and their advisors calculate their claims.

This worksheet is filled with features, 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


Investment Bookkeeping

Having been requested by tax professionals across the country, the Investment Bookkeeping worksheet is about to streamline the way you journalize your corporate and personal investments.

Supporting several accounts and a full portfolio of assets, this worksheet cleanly and expertly summarizes investment transactions for tax and accounting purposes.

The worksheet supports a broad scope of components, such as a built-in cash reconciliation, journal entry outputs, and support for foreign currency gains and losses. It also provides tax features such as the T1135, and superficial loss rules.


Corporate Tax Continuity

This worksheet reconciles CRA (re)assessments to journalized tax amounts, and determines the current tax provision.

Reconciling financial statements to filed tax returns to assessments can be a complex exercise. This is even more difficult when there are multiple (re)assessments, interest, penalties, and prior year balances.

Using straightforward inputs, this worksheet calculates under or over accruals, provides journal entries to book in the financial statements, reconciles the financial statement accounts, and more.

To best meet your specific requirements, you can take advantage of the different worksheet flavours that include calculations for R&D, and refundable taxes for Canadian-controlled investment corporations.


Safe Income

This worksheet is used to calculate the safe income on hand for a class of shares, and allocate this balance to shareholders. We’ve found a way to make this challenging calculation clear and user friendly.

Our fresh approach allows you to reconcile your adjustments to tax returns and financial statements. You have easy options to customize your solution in response to changing legislation, CRA policies, and court opinions.

This worksheet is a powerful tool, purpose-built to meet the needs of professional tax advisors.


Simplified or Quick (T2125, HST)

This worksheet supports the integrated completion of the T2125 – Statement of Business or Professional Activities, and GST-HST return using the Simplified or Quick methods. Regardless of the GST-HST method used, or the information source (summaries, financial statements, “shoeboxes”), you can quickly calculate the amounts needed, and complete your returns with confidence.

The template is built to meet your real-world needs, such as translation between currencies, part-year registrations, and varying rates within a tax year (e.g. rate changes, harmonization).



This worksheet supports foreign currency translations using Bank of Canada rates. It provides rates for the usual periods (day, month, year), custom periods, as well as special periods often used by professional advisors (month ended, quarter ended, year ended).

Easily translate amounts to or from popular foreign currencies regardless of the rate needed – with data going as far back as 1951!

With a foolproof interface and convenient referencing, this worksheet will integrate seamlessly into your workflow.


Look no further. Get started today!