Overview
A consolidated trial balance combines the trial balances of several entities or funds into one. You build the structure inside a single engagement. Then you upload a trial balance to each entity at the lowest level of the structure. Fieldguide calculates a consolidated trial balance for every level above it.
For the concepts, limits, and terms, see Multi-tier consolidation overview.
Before you begin
Set up the consolidation before you import any trial balance into the engagement. The current period trial balance of an engagement is either a single trial balance or a consolidated trial balance. After you import a single trial balance or a prior period trial balance, the option to create a consolidated trial balance no longer appears.
An engagement holds one consolidated trial balance. If the entities are separate audits rather than a parent and its subsidiaries, use a separate engagement for each audit.
Prepare one trial balance file for each entity at the lowest level of your structure. Each file uses the same format as a single trial balance. See Import a trial balance.
Choose how to consolidate:
Account matches accounts across entities by account number. Each account number gets its own row in the consolidated trial balance.
Group adds up the accounts that each entity mapped to the same group in your chart of accounts. Each group gets one row. Use this option when entities number their accounts differently.
After you finish setup, you can't change the consolidation method or the consolidation dates in the setup steps. If the dates are wrong, see The consolidated trial balance has the wrong period dates.
Create the consolidation
To create a consolidated trial balance:
In your engagement, open the Sheets tab and open the trial balance placeholder.
Click Create Consolidated Trial Balance. If your firm uses fund accounting, this button is labeled Create Consolidation or Fund. If the setup doesn't open on the Set Details step, contact support.
On the Set Details step, enter these details:
Type: Select Consolidation or Fund. This field only appears if your firm uses fund accounting.
Consolidate by: Select Account or Group.
Start date and End date: Enter the current period dates.
Click Next: Add Structure.
On the Add Structure step, click Add and add each entity:
Add Entity adds an entity inside this engagement.
Link Entity from another engagement brings in an entity that has its own engagement. To nest entities, add an entity under another entity. For funds, use Add Fund and Add Fund Type.
Click Next: Add Trial Balances.
For each entity at the lowest level, click Add > Current, then click Upload Trial Balance or Add from Documents. Complete the import the same way as a single trial balance: check the preview, confirm the dates, map the accounts, and click Finalize Import.
To add prior-year comparatives for an entity, click Add > Additional on that entity. See Add a prior-year trial balance.
Click Finalize. At least one entity needs a Standard (unlabeled) trial balance before you can finalize.
The consolidated trial balance appears on the Sheets tab. Each entity's trial balance is saved in the Trial Balances folder on the Documents tab.
Update a consolidation
To change the structure or an entity's trial balance after setup:
On the consolidated trial balance, click Utilities > Manage Trial Balances.
Click Manage Consolidation. If your firm uses fund accounting, this button is labeled Manage Consolidation or Fund. The setup steps open again. If you don't see Manage Trial Balances or Manage Consolidation, contact support.
Make your changes. To replace an entity's trial balance, go to Add Trial Balances, open that trial balance's actions menu, and click Replace Trial Balance.
Click Finalize.
When you change an entity's trial balance, open the consolidated trial balance and click Sync trial balance to pull in the changes.
Switch a single trial balance to a consolidated setup
If you imported a single trial balance and need a consolidated setup, the placeholder trial balance has to be restored so you can start again. You can't convert a single trial balance to a consolidated trial balance.
Restoring the placeholder deletes every trial balance in the engagement and all of its data, including mappings and adjustments. This can't be undone.
To switch to a consolidated setup:
Export anything you want to keep from the engagement's trial balances. See Export adjustments.
Contact support and ask them to restore the placeholder trial balance. Include a link to the engagement.
After support confirms the restore, follow the steps in Create the consolidation.
The placeholder can't be restored on an archived engagement or on an engagement template.
Troubleshoot common problems
I need to reset my engagement from a single trial balance to a consolidated trial balance
To resolve this: Contact support to restore the placeholder trial balance, then create the consolidation. See Switch a single trial balance to a consolidated setup.
I imported one trial balance without selecting the consolidated option, and I want to delete it
You can't delete the current period trial balance on its own.
To resolve this: Contact support to restore the placeholder trial balance. This deletes every trial balance in the engagement.
We're trying to build a consolidated trial balance by entering the prior-year ending balances
Don't enter prior-year ending balances as the current period. Each entity's current period trial balance holds current-year balances, and prior-year balances go in an additional trial balance for that entity.
To resolve this:
On the Add Trial Balances step, add each entity's prior-year trial balance with Add > Additional.
If you don't have current-year balances yet, import a current period file with placeholder values. Replace it when the client sends the current-year trial balance.
The Create Consolidated Trial Balance button doesn't appear
The engagement already has a trial balance.
To resolve this: Contact support to restore the placeholder trial balance, then create the consolidation.
The consolidated trial balance has the wrong period dates
To resolve this: Open the consolidated trial balance and click Utilities.
If you see Manage Consolidated Trial Balance, click it. Change the Start date and End date, then click Update Consolidated Trial Balance.
If you don't see Manage Consolidated Trial Balance, contact support.
I can't add an account to an adjustment on the consolidated trial balance
To resolve this: Add the account to the entity's trial balance, then sync the consolidated trial balance. See Post adjusting journal entries to a trial balance.
Contact support
Contact support if you need to reset the engagement's trial balances, if you don't see the Set Details step or Manage Consolidation, or if you need to change the consolidation method of a consolidated trial balance. For wrong dates, see The consolidated trial balance has the wrong period dates.
See also
Import a trial balance
Add a prior-year trial balance
