Hot topics - Week of February 23, 2025
NEW! Taxprep Forms and Cantax FormMaster 2024 v. 2.1 now available for download
Versions 2.1 of Taxprep Forms and Cantax FormMaster 2024 are fully approved for the forms relating to the T5013 return, its schedules, the T5013 slip, the T5013 Summary, as well as for the electronic transmission of the T5013 return and slip. Click here to download. CRA late-filing penalty relief for information returns
Given ongoing challenges faced by some filers, the Canada Revenue Agency (CRA) will grant relief in respect of late-filing penalties for information returns filed on or before March 7, 2025, for those information returns normally due on February 28, 2025. See this acrticle for more details. This week 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.