Exporting trial balance data

Alerts and notices

To export trial balance data from the Trial Balance workspace as an Excel file or tax export file, follow these steps.

  1. Click the Trial Balance tab.
  2. Click the Export button in the ribbon.
  3. In the Export Data dialog, select Trial Balance from the Type drop-down list.

    Note: If your firm uses either ProSystem fx Tax or Lacerte Tax as a tax vendor for the current trial balance, you can select either of these products from the Type drop-down list 

  4. Choose either the appropriate view or the applicable file detail settings for the data type you selected in step.
  5. Click Ok. 
  6. Choose the applicable save options and save the Excel or tax export file to your local machine or to a location on your firm's network.


    • You also have the option to open the file, which may be appropriate if you are creating an Excel file for the trial balance.
    • To create a static trial balance workpaper for the current engagement, export the trial balance to an Excel file as described above, save and close the Excel file, and drag the file into the Workpapers tab for the current engagement. This copy of the trial balance will not be updated with any subsequent changes that are made in the Trial Balance tab for the engagement.