Skip to main content

Map trial balance accounts to groups

Map each client account to a group in your firm's chart of accounts, fix accounts in the wrong group, and see where mapped accounts appear.

Overview

Each client account in a trial balance maps to a group, or a subgroup, in your firm's chart of accounts. The mapping decides:

  • Which section of the trial balance the account appears in.

  • Which rows the account feeds in linked sheets, such as lead sheets.

  • Where the account's balance lands in financial statements.

You map accounts during the import. You can change mappings at any time after that.

Map accounts during an import

When you import a trial balance, the Standardize Accounts step lists each account that needs a group. Fieldguide AI suggests a group for each account in the Mapped Group column.

To review the suggested mappings:

  1. Check each account in the Mapped Group column. Change any group that isn't correct.

  2. To change several accounts at once, select their checkboxes and use the bulk-edit toolbar.

  3. Click Yes, I've reviewed, then click Finalize Import.

Finalize Import stays disabled until every account has a group. Accounts that already exist in the engagement keep their mappings, so you only map accounts that aren't in the engagement yet.

Change account mappings

Firm users can change mappings. If you're a Firm Member, your engagement role also needs Sheets set to Full Access. Client users can't change mappings. You can't change mappings in an archived engagement.

To change mappings after an import:

  1. Open the current period trial balance on the Sheets tab.

  2. Click Utilities (the wrench icon), then click Manage Groups and Accounts.

  3. Find the accounts you want to change. Use the search bar, the column filters, or Hide Empty Accounts to narrow the list.

  4. Click a cell in the Mapped To column, then select a group or subgroup. Subgroups appear under their groups.

  5. To change several accounts at once, select their checkboxes and use the bulk-edit toolbar.

  6. Click Update Mappings.

When you change mappings on the current period trial balance, Fieldguide also updates the prior-year trial balances for the same entity and refreshes linked sheets, such as lead sheets.

On a consolidated trial balance, Manage Groups and Accounts only appears when the consolidation is by account. For a consolidation by group, change mappings on each entity's trial balance, then click Sync trial balance on the consolidated trial balance.

Add an account

To add an account that isn't in the trial balance:

  1. In Manage Groups and Accounts, click Add Account.

  2. In the Create New Account dialog, enter the Framework mapping, Account name, Account number, and Account type.

  3. Click Create Account.

Add Account doesn't appear on a consolidated trial balance. Add the account to the entity's trial balance instead.

Where mapped accounts appear

  • The trial balance: Accounts appear under the section for their group.

  • Linked sheets: Sheets that use the trial balance accounts, such as lead sheets, show accounts by group. See Add financial accounts to another sheet.

  • Financial statements: Statement line items pull balances from the accounts mapped to them. See Financial statements overview.

Troubleshoot common problems

I want to remove the Uncategorized accounts

Uncategorized is a default group in your firm's chart of accounts. Accounts in that group still need a mapping to the correct group.

You can't delete an account from a trial balance.

To resolve this: In Manage Groups and Accounts, type Uncategorized in the search bar and select the Uncategorized group. Only the accounts in that group appear. Select the accounts, map them to the correct group, and click Update Mappings.

The Uncategorized section stays in the trial balance after you move its accounts, with no accounts in it. You can't delete sections from a trial balance.

Accounts appear under Unmapped Accounts

Accounts appear under Unmapped Accounts in Manage Groups and Accounts when their group is no longer part of your firm's chart of accounts.

To resolve this: Map each account to a group that's in the chart of accounts, then click Update Mappings.

Accounts are missing

Check these causes:

  • Hide Empty Accounts is on in Manage Groups and Accounts. Click Show Empty Accounts to see accounts with a value of 0.

  • A column filter is hiding the accounts. Clear the filters.

  • The account is only in another period's trial balance. It appears in the current period trial balance with a value of 0.

  • The account is missing from a lead sheet created from a sheet template. The sheet only shows accounts in groups that the template includes.

To resolve this: If the account isn't in the trial balance at all, add it with Add Account, or replace the trial balance with a file that includes it.

I mapped accounts on the prior-year trial balance, and I don't see the changes

Mapping changes on a prior-year trial balance only apply to that trial balance.

To resolve this: Make mapping changes on the current period trial balance. Those changes carry to the prior-year trial balances for the same entity.

Finalize Import is disabled

To resolve this: Map every account in the Mapped Group column and click Yes, I've reviewed.

Contact support

Contact support if accounts stay in Uncategorized or Unmapped Accounts after you update their mappings, or if you need to change mappings on a consolidation by group and can't do it from the entity trial balances.

See also

Did this answer your question?