(CAN) General Index of Financial Information (GIFI) codes for Canadian financial statements
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
The General Index of Financial Information (GIFI) is a list of accounts and information that are found on financial statements. Each item on the GIFI account list has a unique code that you can match with ledger account numbers from your chart of accounts. For example, the GIFI code for cash is 1001.
You must use GIFI codes when you submit financial statement information to the Canada Revenue Agency (CRA) in both paper and electronic returns.
Note
For current information and regulations, visit Canada Revenue Agency.
You must complete the following tasks before you begin to use GIFI codes:
Set up dimensions based on your general ledger accounts by using the Financial dimension sets form. For more information, see Financial dimension sets (form).
Create a row definition for your company financial statement. For more information, see Design the row structure of a traditional financial statement.
Set up financial statement information for your company by using the Financial statement form.
Download the binary file of GIFI codes from CustomerSource.
Use the following procedures to import GIFI codes into Microsoft Dynamics AX, and then use them for financial reporting.
Import GIFI codes from the binary file
Download the binary file of GIFI codes to your computer hard disk.
In the Microsoft Dynamics AX list page, press CTRL+D to open the AOT.
Expand the Classes node to select GIFICodesToFinancialStatmentTemplate.
Right-click GIFICodesToFinancialStatmentTemplate, and then select Open to open the Import GIFI codes form.
In the File name field, browse to the binary file of GIFI codes that contains the data to be imported.
In the Dimension set field, select the financial dimension set that you set up for GIFI codes in the Financial dimension sets form.
In the Row definition field, select the code for a financial statement row definition.
Click OK to close the Import GIFI codes form.
Click General ledger > Setup > Financial statement (traditional) > Row definition.
Select the row definition that you created, and then click Structure designer to open the Structure designer form.
In the Structure designer form, view the newly imported GIFI codes.
Close the forms to save your changes.
Link ledger accounts to GIFI codes
In the Structure designer form, select ledger accounts to link to GIFI codes. For information about linking ledger accounts to GIFI codes, see Structure designer (form).
When you have finished linking accounts to GIFI codes, close the Structure designer form.
Create row definitions for financial statements that include GIFI codes
You must set up a row definition for each set of GIFI codes that you plan to use for financial statements. For example, to print a balance sheet that includes GIFI codes for ledger accounts, you must set up a definition with GIFI codes for the balance sheet. To print a profit and loss statement that includes GIFI codes, you must set up a definition with GIFI codes for the profit and loss statement.
Use the Row definition form to create row definitions for a financial statement that includes GIFI codes.
Note
You must also import GIFI codes from the binary file and link them to your ledger accounts. For more information, see the Link ledger accounts to GIFI codes section.
In the Row definition form, click Print to print a row definition structure report.
Verify the general ledger accounts and GIFI codes.
Repeat steps 1 through 3 for each financial statement that includes GIFI codes.
Create and print financial statement reports that include GIFI codes
Note
For general information about creating and printing financial statements, see Generate, print, and export a traditional financial statement.
Click General ledger > Reports > Transactions > Financial statement (traditional).
Select a financial statement.
Select a GIFI row definition in the Primary dimension set field for the financial statement.
Enter additional information, as needed.
Click OK .
Verify the information in the financial statement.
Repeat steps 1 through 6 for each financial statement that includes GIFI codes.
Export a financial statement that includes GIFI codes to Microsoft Excel
You can create a Microsoft Excel worksheet to submit reports that include GIFI codes to the CRA. You can also submit a paper copy, or you can enter information from the worksheet on the CRA website. If you or your tax accountant uses tax software, refer to the software documentation for instructions about submitting financial statements.
Click General ledger > Reports > Transactions > Financial statement (traditional).
Enter GIFI code information in the Financial statement and Primary dimension set fields.
In the Output type field, select Export to.
Click the Export to tab, and then click Setup.
In the Available column, select CA_GIFI, and then move it into the Selected column.
Close the File format for the export of the financial statement form.
On the Export to tab, enter the export location and the name of the export file, such as C:\CA_GIFI Excel export.
In the File format field, select CA_GIFI.
Click OK to close the form.