Generated by All in One SEO v4.8.8, this is an llms.txt file, used by LLMs to index the site.

# Tax Templates Inc.

Canadian Tax Planning and Tax Accounting worksheets

## Sitemaps

- [XML Sitemap](https://www.taxtemplates.ca/sitemap.xml): Contains all public & indexable URLs for this website.

## Pages

- [Home](https://www.taxtemplates.ca/) - TTI develops industry-leading tax worksheets that integrate seamlessly into your workflow. Our Excel-based solutions meet the needs of professionals.
- [Canadian Income Tax Tables](https://www.taxtemplates.ca/tax-tables/) - TTI's free Canadian Tax Tables are the product of our state-of-the-art tax Tax Planning engines
- [Package](https://www.taxtemplates.ca/download/)
- [Worksheet - Personal Tax Scenario](https://www.taxtemplates.ca/personal-tax-scenario/) - TTI's Personal Tax Scenario worksheet provides comprehensive net cash results calculated with bleeding-edge tax rates
- [Subscribe to TTI - Sole Proprietor](https://www.taxtemplates.ca/subscribe-sole-proprietor/) - This pricing is for sole proprietors (only)
- [Subscribe to TTI](https://www.taxtemplates.ca/subscribe/) - License TTI's Canadian Tax Planning and Tax Accounting worksheets here
- [Subscribe to TTI - CPA Canada](https://www.taxtemplates.ca/subscribe-to-tti-cpa-canada/) - [et_pb_section fb_built=”1″ fullwidth=”on” admin_label=”section” _builder_version=”4.27.3″ background_color=”#FFFFFF” background_enable_image=”off” parallax=”on” min_height=”448.2px” custom_padding=”0px||0px||false|false” border_width_all=”1px” border_color_all=”#000000″ global_colors_info=”{}”][et_pb_fullwidth_header title=”Welcome, CPA Canada Member!” subhead=”The pricing below includes your 15% discount” text_orientation=”center” logo_image_url=”https://www.taxtemplates.ca/wp-content/uploads/CPA-Canada_Canada-legalA_EN-FR-logo_color-RGB_1000x400.png” title_font_color=”#ffffff” subhead_font_color=”#e8e8e8″ _builder_version=”4.27.3″ title_font=”|600|||||||” title_text_align=”center” title_text_color=”#012248″ title_font_size=”50px” content_font_size=”13px” subhead_text_color=”#012248″ subhead_font_size=”22px” subhead_line_height=”2em” background_color=”rgba(255, 255, 255, 0)” custom_margin=”0px|0px|0px|0px|false|false” custom_padding=”0px|0px|0px|0px|false|false” title_font_size_tablet=”” title_font_size_phone=”45px” title_font_size_last_edited=”on|phone” global_colors_info=”{}” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off”
- [Worksheet - Other Tax Accounting](https://www.taxtemplates.ca/other-tax-accounting/) - These are the other Tax Accounting worksheets offered by Tax Templates Inc.: Corporate Tax Continuity, Simplified or Quick (T2125, HST), and Forex
- [Worksheet - Corporate Tax Scenario](https://www.taxtemplates.ca/corporate-tax-scenario/) - TTI's Corporate Tax Scenario worksheet helps you understand the net cash and tax balances of income and payments
- [Contact Us](https://www.taxtemplates.ca/contact-us/) - Contact TTI by email or using this form
- [Canadian Income Tax Tables - Download PDFs](https://www.taxtemplates.ca/tax-tables-pdf/) - Download free Canadian Tax Tables here.
- [About Us](https://www.taxtemplates.ca/about-us/) - Learn about Tax Templates Inc., Jay Goodis, and Andrew Skujins
- [Welcome New TTI User](https://www.taxtemplates.ca/welcome/) - Thank you for licensing TTI's solutions
- [Worksheet - Investment Bookkeeping](https://www.taxtemplates.ca/investment-bookkeeping/) - TTI's Investment Bookkeeping worksheet calculates and reconciles gains/losses on investments and cash
- [Worksheet - Salary vs Dividend](https://www.taxtemplates.ca/salary-vs-dividend/) - TTI's Salary vs Dividend worksheets are Canada's leading tools to optimize corporate remuneration to shareholders
- [Worksheet - Safe Income](https://www.taxtemplates.ca/safe-income/) - TTI's Safe Income worksheet sets the standard for reliable and easy to use Safe Income calculations
- [FAQs](https://www.taxtemplates.ca/faqs/) - Here are some common questions about using TTI in your practice
- [Testimonials](https://www.taxtemplates.ca/testimonials/) - See who uses TTI and what their experience has been
- [Media](https://www.taxtemplates.ca/media/) - Here are some webinars and articles that TTI and its team have been involved in

## Support

- [How do I download TTI files?](https://www.taxtemplates.ca/support/how-do-i-download-tti-files/) - TTI files are delivered to you via Google Drive. Your download link is private to you, and does not require any sign in. 1) After opening the link, you should see the collections you are subscribed to: 2) Download your file(s) using the down-arrow buttons: 3) Open your downloaded files. In your browser, you can
- [How do I change the name of an investment asset in the Investment Bookkeeping worksheet?](https://www.taxtemplates.ca/support/how-do-i-change-the-name-of-an-investment-asset-in-the-investment-bookkeeping-worksheet/) - Using the built-in combination of "Disposition/Swap" to remove the asset under the old name, and a "Purchase/Swap" to add the asset with the new name. The ACB will need to be entered manually to balance the transaction.
- [What resources may be relevant to the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/what-resources-may-be-relevant-to-the-simplified-or-quick-method-worksheet/) - The following resources may be relevant when using the T2125 GST-HST Worksheet: CRA Guide T4002 - Business and Professional IncomeCRA Guide RC4022 - General Information for GST/HST RegistrantsCRA Guide RC4058 - Quick Method of Accounting for GST/HSTCRA GST/HST Memorandum 8-2 - General Restrictions and Limitations
- [What is the purpose of the Investment Bookkeeping Worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-investment-bookkeeping-worksheet/) - The Investment Bookkeeping worksheet summarizes capital transactions and investment income for tax and accounting purposes. It supports foreign exchange, the T1135, and tax rules applicable to the calculation of capital gains.
- [What is the purpose of the "s" column on the Safe Income worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-s-column-on-the-safe-income-worksheet/) - Where a Schedule 1 item has been marked with “s” on the Safe Income worksheet, it is assumed to impact the safe income balance in the year the expense is incurred. Professional judgment is required for each possible adjustment.
- [What is the purpose of the Safe Income worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-safe-income-worksheet/) - The purpose of the Safe Income worksheet is to calculate the safe income on hand for a class of shares, and allocate this balance to a shareholder.
- [What is the purpose of the "r" column in the Safe Income Worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-r-column-in-the-safe-income-worksheet/) - Where an adjustment to the safe income calculation has been marked with “r” on the Safe Income Worksheet, the amounts will be reversed to reconcile the ending retained earnings.
- [What is the purpose of the Corporate Tax Scenario Worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-corporate-tax-scenario-worksheet/) - The purpose of the Corporate Tax Scenario Worksheet is to project corporate tax outcomes for CCPCs or other private corporations. This worksheet accommodates most situations and supports many key balances such as GRIP, RDTOH, non-capital losses, net capital losses, and donations.
- [What is the purpose of the Prescribed Loan worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-prescribed-loan-worksheet/) - The purpose of the Prescribed Loan Worksheet is to project the net tax savings available using a prescribed rate loan to earn investment income. The worksheet will calculate the results of earning income in the hands of a lower marginal rate taxpayer while also considering the impact of loan interest to both parties. This worksheet accommodates
- [What is the purpose of the Personal Tax Scenario Worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-personal-tax-scenario-worksheet/) - The purpose of the Personal Tax Scenario Worksheet is to evaluate the tax effects of income, deduction, and tax credits situations. This worksheet solves various tax scenarios such as comparing different forms of income on an after-tax basis, the impact of tax rates between tax years, or how earning income in a different province affects
- [What is the purpose of the Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-tax-continuity-worksheet/) - The purpose of the Tax Continuity Worksheet is to reconcile the CRA (re)assessments to the journalized taxes receivable/payable, and to record the current year tax provision. This worksheet assumes that the client has booked all Federal and Provincial corporate income tax transactions to the Income tax receivable (payable) account or the R&D receivable (payable) account. Where
- [What is the purpose of the mileage reasonability in the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-mileage-reasonability-in-the-simplified-or-quick-method-worksheet/) - This section uses two independent calculations to extrapolate or estimate the total number of kilometres driven based on the following: Repair records that contain odometer readingsAverage fuel costs and actual fuel consumption
- [What is the purpose of the Forex Worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-forex-worksheet/) - The purpose of the Forex Worksheet is to support foreign currency translations using the Bank of Canada rates, enabling convenient access to all available rate data, and calculating rates for popular periods.
- [What is the purpose of the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/what-is-the-purpose-of-the-simplified-or-quick-method-worksheet/) - The purpose of the Simplified or Quick Method Worksheet is to support integrated completion of the T2125 – Statement of Business or Professional Activities, and GST/HST return using the Simplified or Quick methods (as required). This worksheet supports input from summaries, financial statements, and shoeboxes.
- [How should I use the Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/how-should-i-use-the-tax-continuity-worksheet/) - Please ensure that the following are correctly specified: The current tax year endedThe opening tax receivable (payable) balance for each applicable tax yearAll amounts per the Notices of (re)assessments in the defined cells for each applicable year to reconcile the prior year(s) provisionsAll refunds and/or payments to the CRA for each applicable yearAll amounts from
- [How to determine the input into the the "Part IV tax - connected” in the Corporate Scenario Worksheet?](https://www.taxtemplates.ca/support/how-to-determine-the-input-into-the-the-part-iv-tax-connected-in-the-corporate-scenario-worksheet/) - If Holdco is a connected corporation and is not the only shareholder that receives taxable dividends from Opco, Holdco's Part IV tax would be a percentage of Opco's dividend refund. For example, let's assume that Opco paid $6,000 of dividends to HoldcoA and $4,000 of dividends to HoldcoB. Upon paying these dividends, let's assume that
- [What additional inputs are required to ensure the reconciliation in the Simplified or Quick Method Worksheet matches the personal tax return?](https://www.taxtemplates.ca/support/what-additional-inputs-are-required-to-ensure-the-reconciliation-in-the-simplified-or-quick-method-worksheet-matches-the-personal-tax-return/) - There are a few cells within the Simplified or Quick Method Worksheet that should be entered from the T2125 to this worksheet in the designated cells in order to provide a complete integration including: CCA / ECP / Recapture / Terminal Losses claimedBusiness use of home carryforwardsPartnership adjustments
- [How should I start using the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/how-should-i-start-using-the-simplified-or-quick-method-worksheet/) - Please ensure that the following are correctly specified: Client Name Tax Year Ended GST / HST Calculation MethodApplicable sales tax rates We also recommend using the built-in Completion Guide.
- [How does the worksheet support amalgamations?](https://www.taxtemplates.ca/support/how-does-the-worksheet-support-amalgamations/) - Below lists the steps for best practices with an amalgamation when calculating safe income: 1) Calculate the SIOH for Corp #1 by shareholder (Stand alone worksheet)2) Calculate the SIOH for Corp #2 by shareholder (Stand alone worksheet)3) Calculate the SIOH for Amalco using a new worksheet from the date of amalgamation.4) Include the opening balances
- [How is GST/HST handled on bad debts in the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/how-is-gst-hst-handled-on-bad-debts-in-the-simplified-or-quick-method-worksheet/) - If your client is using the Simplified Method, GST/HST amounts on bad debts can be specified in their designated columns on the main tab, and will carry through to line 108 on the GST/HST return If your client is using the Quick Method, manually specify any applicable amounts on the GST/HST return using the other adjustments
- [How should I enter dates in TTI worksheets?](https://www.taxtemplates.ca/support/how-should-i-enter-dates-in-tti-worksheets-2/) - In Excel, date formats are specified by the host operating system (e.g. Windows). The Windows defaults do not correspond to Canadian/CRA/worldwide standards (ISO 8601). Short dates are recommended to be set as "yyyy-mm-dd". Control Panel > Region and Language > "Short date:"
- [How do I enter the opening receivable (payable) balance in the Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/how-do-i-enter-the-opening-receivable-payable-balance-in-the-tax-continuity-worksheet/) - For optimal use, it is recommend that you understand the composition of the opening tax receivable (payable) accounts, and allocate them by applicable tax year end. If you cannot determine the balance allocated by tax year end, estimate the opening balances by year. The worksheet will correct any discrepancies after reconciling the prior year provisions
- [How do I claim ITCs on capital assets in the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/how-do-i-claim-itcs-on-capital-assets-in-the-simplified-or-quick-method-worksheet/) - Depending on the applicable method, ITCs (or GST/HST collected) relating to capital assets may be calculated in either the "Capital Asset" section or the "Allowable Motor Vehicle ITCs based on CCA" section
- [How do I adjust for non-capital losses in the Safe Income Worksheet?](https://www.taxtemplates.ca/support/how-do-i-adjust-for-non-capital-losses-in-the-safe-income-worksheet/) - If you are looking to adjust the non-capital losses, in the "Calculation of safe income on hand" section, you can use the "Other adjustments" rows to do either of the following: a) Increase the safe income on hand balance by current year losses b) Reduce the safe income on hand balances by the non capital
- [How do I accommodate unique GST/HST situations in the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/how-do-i-accommodate-unique-gst-hst-situations-in-the-simplified-or-quick-method-worksheet/) - The ITCs calculated in the designated columns can be changed by: Modifying the sales tax rates by column for the income and expense itemsOverriding default calculations with known numbers, calculated values, or nil amounts
- [How do I reconcile the prior year tax balances where R&D credits reduce income taxes payable?](https://www.taxtemplates.ca/support/how-do-i-reconcile-the-prior-year-tax-balances-where-rd-credits-reduce-income-taxes-payable/) - Where R&D tax credits reduce income taxes payable, you must update both the "Total amount paid (refunded)" of the "Income tax receivable (payable)" and the "R&D receivable (payable)". For example, If the income taxes payable totalled $10,000 and the R&D credits totalled $8,000 and the $2,000 payment was paid to the applicable agency, the following
- [Can you provide any useful references for the Safe Income calculation?](https://www.taxtemplates.ca/support/can-you-provide-any-useful-references-for-the-safe-income-calculation/) - Legislation Section 55 of the Income Tax Act (Canada) CRA Technical News Income tax Technical News No 33Income tax Technical News No 34Income tax Technical News No 37 Court cases The Queen v. Kruco Inc.Brelco Drilling Ltd. v The Queen454538 Ontario Limited et al. v. M.N.R.Gestion Jean-Paul Champagne v. M.N.R.Trico Industries Ltd. v. M.N.R.Lamont Management
- [How are currency gains (losses) determined in the Investment Bookkeeping worksheet?](https://www.taxtemplates.ca/support/how-are-currency-gains-losses-determined-in-the-investment-bookkeeping-worksheet/) - Currency gains (losses) occur in two situations. You have [USD] cash, and spend it: You deposit $100 USD to an account when the forex rate is 1.5 CAD:1.0 USD. When you spend the $100 USD, if the current forex rate is 2.0 CAD:1.0 USD, a $50 (CAD) gain is realized. A You have [USD] debt,
- [How are GST/HST amounts calculated in typical situations in the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/how-are-gst-hst-amounts-calculated-in-typical-situations-in-the-simplified-or-quick-method-worksheet/) - Default ITCs are calculated using the simplified method - e.g. ((expense/1.13)*0.13) Exceptions are items with personal use components, in which case the personal portion of the GST/HST paid is not claimed as an ITC, nor deducted as a business expense.
- [How are refunds held back (unpaid amounts) reconciled in the Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/how-are-refunds-held-back-unpaid-amounts-reconciled-in-the-tax-continuity-worksheet/) - The refunds held back (unpaid amounts) are to identify any amounts included in the "opening receivable (payable)" that arose from a (re)assessment in a prior year, and the refund (payment) transaction was pending. Situations where this may apply include: A refund held back due to an outstanding return not filed, and the CRA is awaiting
- [How can I claim [Meals and Entertainment] at custom business use rates in the Simplified or Quick Method Worksheet?](https://www.taxtemplates.ca/support/how-can-i-claim-meals-and-entertainment-at-custom-business-use-rates-in-the-simplified-or-quick-method-worksheet/) - The fixed Meals and Entertainment section calculates expenses and ITCs at 50%, and cannot be used without overrides. Using an 'Other Expenses' row, enter the business portion of expenses and ITCs to be claimed. When complex conditions apply, verify the ITCs being calculated.
- [How can I book an accrual in the Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/how-can-i-book-an-accrual-in-the-tax-continuity-worksheet/) - Any accruals or other adjustments for the current year can be completed in the “tax provision (recovery)” section of the worksheet. Any accruals or adjustments for other tax years can be completed in the “tax receivable (payable) from loss carry-backs or other adjustments” section of the worksheet.
- [How are unrealized events reconciled in the Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/how-are-unrealized-events-reconciled-in-the-tax-continuity-worksheet/) - Unrealized events journalized in a prior year that are included in the "opening receivable (payable)" balances that have not been resolved in the current year (e.g. a journalized payable as a result of an ongoing audit still pending resolution) will be included in the tax year ending receivable/payable balance to be reconciled in future years
- [How are the rates determined with the Forex Worksheet?](https://www.taxtemplates.ca/support/how-are-the-rates-determined-with-the-forex-worksheet/) - The Bank of Canada daily noon rates are used to derive all periods. The "period" input simply manipulates the days included. "Average for day" will provide the day's noon rate. "Average for month" will provide the average of ~30 noon rates. This is the same method used by the Bank of Canada to provide monthly
- [What are the best practices for downloading the TTI Suite?](https://www.taxtemplates.ca/support/what-are-the-best-practices-for-downloading-the-tti-suite-2/) - Our suggested practice would be that one person (and one backup) receive the updates, and make them available within your firm. This is normally done by extracting the package to a shared network drive. Depending on the software you use, you may also update client templates in your document management software. Beyond extracting the worksheets
- [What is the difference between "Average for month" and "Month ended" in the Forex Worksheet?](https://www.taxtemplates.ca/support/what-is-the-difference-between-average-for-month-and-month-ended-in-the-forex-worksheet/) - The difference between "Average for month" and "Month ended", is the flexibility of days. If using the last day of the month (e.g. June 30), the rate will be the same, but "Month ended" would allow you to use May 16 - June 15, for example.
- [What is the difference between "Average for year" and "Year ended" in the Forex Worksheet?](https://www.taxtemplates.ca/support/what-is-the-difference-between-average-for-year-and-year-ended-in-the-forex-worksheet/) - The difference between "Average for year" and "Year ended", is the flexibility of days. If using the last day of the year (i.e. Dec 31), the rate will be the same, but "Year ended" would allow you to use Oct 1 - Sept 30, for example.
- [What is the difference between the Asset Type "Shares" and "Shares - SBC" in the Investment Bookkeeping Worksheet?](https://www.taxtemplates.ca/support/what-is-the-difference-between-the-asset-type-shares-and-shares-sbc-in-the-investment-bookkeeping-worksheet/) - The Asset Type "Shares - SBC" identifies all losses as Allowable Business Investment Losses, whereas the Asset Type "Shares" identifies all losses as capital losses.
- [What are the system requirements?](https://www.taxtemplates.ca/support/what-are-the-system-requirements-2/) - TTI worksheets are built and tested using the latest Windows "desktop" version of Microsoft Excel 2019. Use of the TTI Suite in a Microsoft Windows environment requires "desktop" Microsoft Excel 2010, 2013, 2016, or 2019. (Office 365 subscribers will always have the latest version available.) Use of the TTI Suite in a Mac environment requires "desktop" Microsoft Excel 2016
- [What is the source of foreign exchange rates?](https://www.taxtemplates.ca/support/what-is-the-source-of-foreign-exchange-rates/) - All TTI worksheets with foreign exchange rates use the average of the applicable Bank of Canada daily “noon rates” for which data exist. This is the same method used by the Bank of Canada to determine official monthly and annual rates. Due to rounding methods used by the Bank of Canada for select currencies, TTI
- [Where should I record a tax refund applied against other tax balances in the Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/where-should-i-record-a-tax-refund-applied-against-other-tax-balances-in-the-tax-continuity-worksheet/) - All refunds received, regardless of their form, should be included in the “total amount paid (refunded)” under the “reconciliation of prior year tax balances” section of the worksheet
- [Why are there different flavours of the Corporate Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/why-are-there-different-flavours-of-the-corporate-tax-continuity-worksheet/) - There are three different flavours of the Corporate Tax Continuity Worksheet which include: StandardAssessments OnlyR&D The purpose of the different flavours is to promote efficiency for easier files and to support complexity for complex tax situations.
- [Why does the result in the Forex Worksheet indicate "No Rate"?](https://www.taxtemplates.ca/support/why-does-the-result-in-the-forex-worksheet-indicate-no-rate/) - Examples where the solution results "No Rate" include: The date may be a statutory holiday (“Average for day” only)The Bank of Canada does not have official data for this time-frame (e.g. EUR before 1999)
- [Will the worksheet provide the “optimum income split” to minimize taxes?](https://www.taxtemplates.ca/support/will-the-worksheet-provide-the-optimum-income-split-to-minimize-taxes/) - Determining the optimal allocation for multiple individuals is extremely complex, but it is a solution we are working towards for many of our current and future solutions. To navigate towards the optimal answer, I recommend ensuring all individuals are in the same tax bracket (both Federally and provincially) and are taxable (i.e. all credits have
- [How do I transfer shares from Canadian dollars into US dollars?](https://www.taxtemplates.ca/support/how-do-i-transfer-shares-from-canadian-dollars-into-us-dollars/) - To complete this scenario you can use the "Swap" transaction supported in the worksheet. This transaction is used where the ACB of an asset is reduced according to the quantity of shares (usually all of them) and "purchased" as a net asset without any cash effect. The first "Swap" transaction must be the shares transferred
- [How do I start using a TTI worksheet?](https://www.taxtemplates.ca/support/how-do-i-start-using-a-tti-worksheet/) - Each worksheet includes a link to TTI's YouTube channel which provides training videos on how to use that specific worksheet. In addition, each TTI worksheet includes a built-in wizard which we call the "Completion Guide" which will take you step by step through each workbook. An overview of the "Completion Guide" is available here. We
- [How do I complete cash transfers with the Investment Bookkeeping worksheet?](https://www.taxtemplates.ca/support/how-do-i-complete-cash-transfers-with-the-investment-bookkeeping-worksheet/) - Foreign cash is converted using Bank of Canada forex rates as a starting point. When increasing USD you can make required adjustments to the ACB of the USD. When you are decreasing USD, you can make required adjustments to the realized gain/loss.All cash transfers between accounts not included on the worksheet are balanced manually on
- [Will any personal information of the purchaser's employees or clients be accessible to TTI?](https://www.taxtemplates.ca/support/will-any-personal-information-of-the-purchasers-employees-or-clients-be-accessible-to-tti/) - Once any of the files are downloaded by the purchaser, they are static, standalone files local to the user’s environment. They do not require any Internet connection, and no information concerning their usage is accessible by TTI.
- [Why is there an (8) in the title of the Salary vs. Dividend (8) worksheet?](https://www.taxtemplates.ca/support/why-is-there-an-8-in-the-title-of-the-salary-vs-dividend-8-worksheet/) - This worksheet supports the Salary vs. Dividend calculation for up to eight (8) shareholders.
- [Why is there a (1) in the title of the Salary vs. Dividend worksheet?](https://www.taxtemplates.ca/support/why-is-there-a-1-in-the-title-of-the-salary-vs-dividend-worksheet/) - This worksheet supports the calculations of Salary vs. Dividend for one (1) shareholder.
- [What do I do with the old package of TTI Worksheets when I receive an update?](https://www.taxtemplates.ca/support/what-do-i-do-with-the-old-package-of-tti-worksheets-when-i-receive-an-update/) - With each new update we provide a new and complete package of all worksheets to subscribed users. We recommend downloading and using the latest package to ensure you have access to the latest tax rates, optimizations, and features. The old package may be deleted.
- [What are the best practices for downloading the TTI Suite?](https://www.taxtemplates.ca/support/what-are-the-best-practices-for-downloading-the-tti-suite/) - The download of the TTI Suite is a zip file and generally only takes 1 to 2 minutes. Detailed download instructions are available here. Beyond extracting the worksheets after download, no installation is needed. Our suggested practice would be that one person (and one backup) receive the updates, and make them available within your firm. This
- [Is it best to use separate worksheets for separate currency accounts?  For example, if a client has both a US account with US transactions and a Canadian account with Canadian transactions, should you use two worksheets?](https://www.taxtemplates.ca/support/is-it-best-to-use-separate-worksheets-for-separate-currency-accounts-for-example-if-a-client-has-both-a-us-account-with-us-transactions-and-a-canadian-account-with-canadian-transactions-should-you/) - It's perfectly fine to split the transactions into two files according to currency if that fits into your file structure, however, TTI's worksheet supports multiple currencies to complete all transactions in one worksheet (unless your client has more than eight accounts). If cash is transferred between the currencies, it's generally easier to manage the journal entry
- [If I download a CSV/Excel report from the investment account, can the information be copied into TTI's Investment Bookkeeping worksheet?](https://www.taxtemplates.ca/support/if-i-download-a-csv-excel-report-from-the-investment-account-can-the-information-be-copied-into-ttis-investment-bookkeeping-worksheet/) - Many of the columns can be copied and "pasted as values" into TTI's Investment Bookkeeping worksheet from the data provided. Example columns would include the "Quantity increase (decrease)", "Description", and "Amount in Native Currency". For columns such as the "Date" and "Type", they may require some organization in the original document before copying and "pasting
- [I would like to try out your product. Do you offer a free trial?](https://www.taxtemplates.ca/support/i-would-like-to-try-out-your-product-do-you-offer-a-free-trial/) - We have a variety of YouTube videos that actively demonstrate our product. We also run a number of live webinars that you are invited to attend to see if our products are right for your practice. Due to the nature of our products we are unable to offer a free trial. If you have any
- [Does Tax Templates offer promotions or discounts on pricing?](https://www.taxtemplates.ca/support/does-tax-templates-offer-promotions-or-discounts-on-pricing/) - The TTI Suite is priced to provide TTI clients with significant value. To ensure price consistency regardless of when you subscribe, Tax Templates does not provide discounts and/or promotions. Sole proprietor pricing is available here to help new businesses. We will verify your practice prior to charging your payment.
- [How should I enter dates in TTI worksheets?](https://www.taxtemplates.ca/support/how-should-i-enter-dates-in-tti-worksheets/) - We have a short instructional video available on our YouTube channel. In Excel, date formats are specified by the host operating system (e.g. Windows). The Windows defaults do not correspond to Canadian/CRA/worldwide standards (ISO 8601). Short dates are recommended to be set as "yyyy-mm-dd". Control Panel > Region and Language > "Short date:"
- [How often do you update your rates?](https://www.taxtemplates.ca/support/how-often-do-you-update-your-rates/) - The foreign exchange rates in the "Forex" and "Investment Bookkeeping" worksheets are updated every Monday and are available for download from your download link. The latest foreign exchange rates are also included in regular TTI updates.
- [How do I use the Salary vs. Dividend (8) worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-salary-vs-dividend-8-worksheet/) - There are a series of short instructional videos available on our YouTube channel.
- [How do I use the Salary vs. Dividend (1) worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-salary-vs-dividend-1-worksheet/) - We have a series of short instructional videos available on our YouTube channel.
- [How do I upgrade my subscription to add additional users or to add a second collection?](https://www.taxtemplates.ca/support/how-do-i-upgrade-my-subscription/) - You can upgrade your subscription at any time! Just send an email to support@taxtemplates.ca and we are happy to update your account.
- [Does Tax Templates offer webinar training?](https://www.taxtemplates.ca/support/do-you-offer-webinar-training/) - Yes! We offer live webinars for all of our users as well as anyone wishing to learn more about our product. You can register for any of our upcoming webinars or view recordings of past webinars here.
- [How do I use the Simplified or Quick (T2125, HST) worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-simplified-or-quick-t2125-hst-worksheet/) - There is a series of short instructional videos available on our YouTube channel.
- [I feel lost, where do I start?](https://www.taxtemplates.ca/support/i-feel-lost-where-do-i-start/) - We appreciate how important implementation is with any new software and we are here to help with your firm implementation. We have an extensive library of short how-to videos available on our YouTube channel. All of these instructional videos have the ability to enable closed captioning. We recommend the "Getting Started" playlist which also explains our "Completion Guide".
- [Can the worksheet generate a summary for each individual investment?](https://www.taxtemplates.ca/support/can-the-worksheet-generate-a-summary-report-for-each-individual-investment-specifically-for-clients-that-want-to-know-the-irr-on-their-investments/) - You can see a list of transactions for any asset (or account, or date range, etc.) by using the built-in filters on the Worksheet tab.
- [How do I use the Safe Income worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-safe-income-worksheet/) - There is a short instructional video available on our YouTube channel.
- [How do I use the Prescribed Loan worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-prescribed-loan-worksheet/) - There are a series of short instructional videos available on our YouTube channel.
- [How do I use the Investment Bookkeeping worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-investment-bookkeeping-worksheet/) - There are a series of instructional videos available on our YouTube channel.
- [How do I use the Forex worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-forex-worksheet/) - We have a short instructional video available on our YouTube channel.
- [How do I use the Corporate Tax Scenario worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-corporate-tax-scenario-worksheet/) - We have a series of short instructional videos available on our YouTube Channel.
- [How do I use the Corporate Tax Continuity Worksheet?](https://www.taxtemplates.ca/support/how-do-i-use-the-corporate-tax-continuity-worksheet/) - We have a short instructional video available on our YouTube channel.
- [How can I use foreign exchange rates in TTI worksheets?](https://www.taxtemplates.ca/support/how-can-i-use-foreign-exchange-rates-in-tti-worksheets/) - In TTI worksheets where foreign exchange applies, annual average rates are provided for multiple currencies. To use this function, include a supported currency code in your calculation (e.g. =100*USD). Other rates can be specified within calculations manually (e.g. =100*1.1015). Worksheets support the Australian Dollar (AUD), European Euro (EUR), Hong Kong Dollar (HKD), Japanese Yen (JPY), United
- [How do I use Personal Tax Scenario?](https://www.taxtemplates.ca/support/how-do-i-use-personal-tax-scenario/) - We have a series of short instructional videos available on our YouTube Channel.
- [What is the “TTI Suite” and how does it work?](https://www.taxtemplates.ca/support/what-is-the-tti-suite-and-how-does-it-work/) - The TTI Suite consists of a "Tax Accounting" collection and a "Tax Planning" collection. We have video walk-throughs of every TTI worksheet on our YouTube Channel.The Tax Accounting collection includes many popular worksheets to assist with compliance such as: CEWS, Investment Bookkeeping, Simplified or Quick, and Safe Income.The Tax Planning collection includes solutions such as:

## Docs Categories

- [Tax Planning](https://www.taxtemplates.ca/support-category/tax-planning/)
- [Tax Accounting](https://www.taxtemplates.ca/support-category/tax-accounting/)
- [General](https://www.taxtemplates.ca/support-category/general/)
- [Salary vs Dividend (1)](https://www.taxtemplates.ca/support-category/svd-1/)
- [Corporate Tax Continuity](https://www.taxtemplates.ca/support-category/tax-continuity/)
- [Forex](https://www.taxtemplates.ca/support-category/forex/)
- [Investment Bookkeeping](https://www.taxtemplates.ca/support-category/investment-bookkeeping/)
- [Safe Income](https://www.taxtemplates.ca/support-category/safe-income/)
- [Simplified or Quick (T2125, HST)](https://www.taxtemplates.ca/support-category/t2125/)
- [Prescribed Loan](https://www.taxtemplates.ca/support-category/prescribed-loan/)
- [Salary vs Dividend (8)](https://www.taxtemplates.ca/support-category/svd-8/)
- [Corporate Tax Scenario](https://www.taxtemplates.ca/support-category/corporate-tax-scenario/)
- [Personal Tax Scenario](https://www.taxtemplates.ca/support-category/personal-tax-scenario/)
- [Getting Started](https://www.taxtemplates.ca/support-category/getting-started/)
- [Licencing](https://www.taxtemplates.ca/support-category/licence/)