Chat with our virtual assistant
Hot topics - Week of September 1st, 2024
New telephone schedule for our teams

Monday to Wednesday
8:30 a.m. to 6 p.m. (ET)

Register with our Support Platform to contact us by creating a web ticket. Web tickets can be submitted via the Support Platform 24/7, as well as by live chats, which are handled live by our support agents from Monday through Friday, between 8:30 a.m. and 6:00 p.m. ET.
Note: Cantax, CCH AnswerConnect, AliForm, CCH Engagement, CCH Practice Management, CCH Scan and CCH Site Builder products are now only supported by web tickets.
This week's most consulted articles from our Knowledge Base
  1. How to enter capital gain with the new inclusion rate of 66.66% in T1, T2 and T3?
  2. How to add a licence or security role in CCH iFirm
  3. How to print the CRA/government copy in Cantax t2?
  4. T3 - can we e-file Form T1135?
  5. How do I Import a GIFI file into CCH iFirm Taxprep T2?
  6. How do I prepare an amended T2 return for EFILE?
  7. Multi-factor authentication (MFA) – I am unable to see the MFA “E-mail to” option after I reset my password
  8. How do I register to the ''support.cch.com/oss/canada'' Support Platform?
  9. How do I update my support case on the ''support.cch.com/oss/canada'' Support Platform?
  10. T2 error Code 321
  11. How to reset the admin password in CCH iFirm
  12. The message "Please enter the NAICS code" when trying to print the bar code in PDF in Cantax T2.
  13. Error code 92124 for CPP overpayment
  14. How to configure the EFILE identification in CCH iFirm Taxprep?
  15. How do I transmit authorization documents for one client at a time in CCH iFirm Taxprep T1 or T2?
  16. The federal T2 return is rejected with error code 364 or 864 saying the name does not match CRA’s records
  17. EFILE ERROR - 2123 – The federal T1 return is rejected by the CRA with error code 2123.
  18. What are the special characteristics when filing an income tax return for the year of incorporation.
  19. How do I verify or manage subscriptions available to a AnswerConnect User Profile?

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.