How to: Export Balance Information by Using GIFI Codes
You can export balance information using General Index of Financial Information (GIFI) codes and save the exported file in a Microsoft Excel workbook. You can modify, save, or delete the file. You can use the file to transfer information to your tax preparation software.
To export balance information using GIFI codes
In the Search box, enter Export GIFI Info. to Excel, and then choose the related link.
In the Export GIFI Info. to Excel window, on the Options FastTab, fill in the fields as described in the following table.
Field Description Balance As Of Date
The balance as of the specified date.
Use Add. Rpt. Currency
Select to display the amounts in additional reporting currency.
Include GIFI Name
Select to include the GIFI name in the file.
Include Unused Codes
Select to include the unused codes in the file.
On the G/L Account FastTab, select the appropriate filters.
To export the file to Excel, choose the OK button.
In the Excel file, the balance is rounded to the nearest percentage, but the cell value maintains the same percentage as it does in the general ledger.
See Also
Tasks
How to: Set Up GIFI Codes
How to: View Account Balances by Using the GIFI Code Report
How to: Associate GIFI Codes with Chart of Accounts
Reference
GIFI Code
Account Balances by GIFI Code
Export GIFI Info. to Excel