This website uses cookies to improve your online experience. By clicking "I understand" or by continuing to use our website, you agree to cookies being set on your device. If you do not want cookies to be stored, you may change your settings through your browser.   Find out more. I understand
Date: 2016-Mar.-10
GIFI – Importing a Microsoft Excel™ File


To import data from an Excel file, proceed as follows:

  1. Download the following file: Index-TF.xls (708 Kb).

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

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

  4. In the Index-TF.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 client file in Taxprep Forms and, in the File menu, click Import Data, and then Microsoft Excel Workbook (*.xls).

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

Microsoft and Excel are registered trademarks of Microsoft Corporation.