Export GIFI from QuickBooks®

Updated: 2020-10-22

How to Export a GIFI from QuickBooks® Online Accountant

As an accountant, you can export a GFI file from QuickBooks® Online Accountant (QBOA), within the Workpapers feature.

  1. Sign into QBOA.
  2. On the left, click Clients to view your list of clients.
  3. In the row for the client for whom you want to export GIFI, click the link the Workpapers column to open to their Workpapers.
  4. Click the Working Trial Balance tab and review the amounts to make sure they are ready for export.
  5. Click the GIFI Mapping tab and check that all accounts have assigned GIFI codes. If a GIFI code is missing, click the Assign GIFI code at the right of the row and choose the appropriate code. Make sure all accounts have codes before you continue.
  6. At the top right of the window, click the Save GIFI codes button. This will download a GFI file.
  7. Import the GFI file into TaxCycle.

How to Export a GIFI from QuickBooks® Desktop

Unlike other accounting packages, QuickBooks® Desktop does not offer a standard GIFI export (the online version exports GFI files). Instead, you must export a CSV copy of the Income Tax Summary report.

  1. Open the company file in QuickBooks® Desktop.
  2. Under the Reports menu, expand the Accountant & Taxes section and then open the Income Tax Summary report.
  3. At the top of left of the report, select the tax year for the report.
  4. Double check that there aren't any accounts with Unassigned tax lines in the report. If there are, fix these by assigning tax lines to the accounts in QuickBooks® Desktop.
  5. Click the Excel button at the top of the report and select Create a new worksheet. (In older versions of QuickBooks, this button might be called Export.)
  6. On the Export Report dialog box, choose the option to Create a comma separated values (.csv) file.
  7. Click the Export button.
  8. Save the exported file to a location you will remember.
  9. Import the CSV file into TaxCycle.