Skip to main content

Export trial balance data to Excel

Use the financial audit Excel add-in to copy trial balance values

Overview

You can export trial balance data in multiple ways:

  • Fieldguide's Excel add-in (recommended)

  • The Export sheet function inside your Fieldguide sheet

This page explains how to export a static copy of the trial balance data. If you're looking to add live, dynamic references to the data, use Fieldguide's Excel functions and formula builder, instead.

Export trial balance using the Excel add-in

You can use Fieldguide's Excel add-in to insert a copy of a trial balance's data into an Excel file. This is the recommended option for exporting trial balance data.

To insert a copy of the trial balance data into an Excel file:

  1. Select the engagement in the add-in's Setup menu.

  2. Open the add-in's Trial balance export menu.

  3. Select the desired columns from the trial balance dropdown.

  4. Click Insert. The data will be inserted into a new tab.

Export trial balance using the export sheet function

Fieldguide offers a general sheet export functionality that can also be used on trial balances. This export format is less optimized for the trial balance layout.

Did this answer your question?