Skip to main content

Add trial balance accounts to another sheet

Add a trial balance's accounts and values to a workpaper or analysis sheet, including one entity in a consolidated engagement.

Overview

You can add the accounts and balances from a trial balance to other sheets in the same engagement. Use this for workpapers, analytics, or a view of a single entity. Fieldguide adds a row for each account and keeps the values in sync with the trial balance.

Before you begin

The Trial Balance Values column type only appears when all of these are true:

  • The engagement uses a financial or tax framework.

  • The engagement has a trial balance.

  • The sheet was created from a sheet template that is connected to a financial or tax framework. A sheet created from scratch doesn't show this option. See Create a sheet and Sheet templates.

  • You are a firm user with permission to edit sheets.

You can't add columns to a trial balance sheet itself. Add them to a separate sheet instead.

Lead sheets already include trial balance values, so you don't need to add them.

Add accounts to a sheet

To add trial balance accounts to a sheet:

  1. Open the sheet and click ➕ in the top-left corner of the sheet.

  2. Click Add column.

  3. Select Trial Balance Values as the column type.

  4. If you see an Entity field, select the entity whose accounts you want. The default is the top-level entity.

  5. Under Select Columns to Display, choose the trial balance columns you want. Columns are grouped by trial balance, so you can pick from the current period and prior periods together. Account Number and Account Name are always included.

  6. Click Add columns.

Fieldguide adds a row for each account in the entity's trial balance, plus the columns you selected. If accounts are added to the trial balance later, they're added to this sheet automatically.

Change the columns on a sheet

To add or remove trial balance columns later, repeat the steps above. The columns already on the sheet are selected in Select Columns to Display.

After a sheet is linked to an entity, the Entity field is locked. To show a different entity, create another sheet.

See one entity in a consolidated engagement

In a consolidated engagement, each entity has its own trial balance. Each one is saved in the Trial Balances folder on the Documents tab. Open an entity's trial balance to see its unadjusted, adjustment, and adjusted values for that period.

The consolidated trial balance shows each entity as a separate column, next to the consolidated totals. A sheet view can hide the other entities' columns, but it can't show one entity's adjustments or adjusted balances.

To see one entity's balances across periods on one sheet:

  1. Create a sheet from a sheet template connected to your financial framework.

  2. Follow the steps in Add accounts to a sheet above and select the entity under Entity.

  3. Under Select Columns to Display, choose columns from each of that entity's trial balances. For example, choose Dec 2024 Adjusted, Dec 2025 Unadjusted, and Dec 2025 Adjusted.

All the columns on one sheet must come from the same entity.

Troubleshooting

I don't see Trial Balance Values as a column type

The sheet probably wasn't created from a sheet template connected to a financial or tax framework. Create the sheet from a template that has a framework, then add the column. Also check that the engagement has a trial balance.

I don't see the ➕ button

You're probably on a trial balance sheet. You can't add columns to a trial balance. Open or create a separate sheet.

I want to pull trial balance values with shared columns

Trial balance sheets can't be a source for shared columns. Use the Trial Balance Values column type instead.

See also

Did this answer your question?