Hot Topics - Week of March 25, 2024
Support Centre open every Saturday until April 27
During the personal tax season, the Support Centre will be open every Saturday from 10:00 a.m. to 5:00 p.m., ET, until the end of April to handle requests submitted by web tickets and live chats. Connect to our Support Platform to consult our virtual assistant, submit your requests and chat live with an agent! Release dates calendar
Please consult our product calendar for release dates of all our software. Most Consulted Articles in the Knowledge Base (as of March 28, 2024)
|
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:
Microsoft and Excel are registered trademarks of Microsoft Corporation.
INSTRUCTIONS FOR IMPORTING DATA FROM AN EXCEL™ FILE
To import data from an Excel file, proceed as follows:
-
Download the following file: Index-T2.xls
(725 Kb).
- Open the Index-T2.xls file with Excel or another spreadsheet program.
- Open one of your .xls files containing corporate financial statements.
-
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.
-
Open a tax return with Corporate Taxprep and, in the File
menu, click Import Data, and then Microsoft Excel Workbook (*.xls*).
- 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.