Chat with our virtual assistant
Hot topics - Week of April 20, 2025
NEW: Beginning March 24, 2025, the CRA will no longer accept direct deposit updates or changes submitted via EFILE
Consult this article for more details on this matter.
End of Phone Support: Benefit from our Advanced Virtual Agent 24/7!
Since January 1, 2025, the customer support teams offers its high-quality service exclusively through digital channels, and no longer offers incoming phone support. Click here for more details on this matter.
Register for our support platform and log in to our virtual agent to find answers, submit a support ticket or chat with a live agent.

Watch videos to find out everything you need to know about the support platform:
This week most consulted articles from our Knowledge Base
  1. Cannot log in to the ''support.cch.com/oss/canada'' Support Platform
  2. CRA FORMS: Can I transmit slips and T5013 returns using the federal transmitter number MM for 2023 and prior years?
  3. How to resolve the capital gain diagnostics E780, E1546 and E1547 concerning the periods when the slips do not provide the details?
  4. How do I register for the ''support.cch.com/oss/canada'' Support Platform?
  5. T1-EFILE Diagnostic #002330
  6. How do I reset my password on the ''support.cch.com/oss/canada'' Support Platform?
  7. The federal T1 return is rejected by the CRA with error code 43 in Taxprep or CCH iFirm Taxprep T1.
  8. How do I attach files to my case on the ''support.cch.com/oss/canada'' Support Platform?
  9. CCH iFirm Tax: How to send a return to Support
  10. Reviewing Returns: How to review tax returns using diagnostics

Products Support

Knowledge Base Video Library My support cases Latest News System Requirements
Date: 2017-May-23
GIFI - Importing a Microsoft Excel™ File

INSTRUCTIONS FOR IMPORTING DATA FROM AN EXCEL™ FILE
To import data from an Excel file, proceed as follows:

  1. Download the following file: Index-T2.xls (725 Kb).

  2. Open the Index-T2.xls file with Excel or another spreadsheet program.

  3. Open one of your .xls files containing corporate financial statements.

  4. In the Index-T2.xls file, create references to the cells using your corporate financial statement file.
    Tip: We strongly recommend that you keep a backup copy of your .xls files before you modify them.

  5. Open a tax return with Corporate Taxprep and, in the File menu, click Import Data, and then Microsoft Excel Workbook (*.xls*).

  6. In the Import dialog box, select the Index-T2.xls file and click Open to begin the import procedure in the GIFI schedules.

Microsoft and Excel are registered trademarks of Microsoft Corporation.