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
|
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.