Overview
Add a prior-year trial balance to show prior-year comparatives next to the current period. You can also use additional trial balances for interim periods or budgets.
Each additional trial balance is saved in the Trial Balances folder on the Documents tab. Its account values appear as a column on the current period trial balance.
Before you begin
If the engagement needs a consolidated trial balance, set up the consolidation first. Add prior-year trial balances inside the consolidation, one for each entity. See Set up a consolidated trial balance.
Prepare the prior-year file in the same format as a current period file. See Import a trial balance.
Add a prior-year trial balance
To add a prior-year trial balance:
Open the current period trial balance on the Sheets tab.
Click the Utilities icon (wrench), then click Manage Trial Balances.
Click Add, then choose one of these options:
Add from Documents to select a file that's already in the engagement's Documents tab.
Upload file to upload a file from your computer.
Select your file. The Preview Trial Balance drawer opens.
Check the Start Date and End Date. Fieldguide fills in dates one year before the current period. Change them if they don't match the prior-year period.
Leave Trial Balance Label set to Standard. Lead sheets only use Standard trial balances for prior-year comparatives. Choose another label only for a trial balance you want to keep separate from prior-year comparatives, such as a budget. Firm admins manage the label options in Settings > Trial Balance Labels.
Click Next: Map new Accounts. You only need to map accounts that aren't already in the engagement. Click Yes, I've reviewed.
Click Finalize Import.
If the prior-year file has accounts that aren't in the current period trial balance, Fieldguide adds those accounts to the current period trial balance with a value of 0.
If you haven't imported the current period yet, you can add the prior-year trial balance from the placeholder. Click Upload Trial Balance > Prior Period. Don't use this option in an engagement that needs a consolidated trial balance.
Change or delete a prior-year trial balance
To change a prior-year trial balance, open Utilities > Manage Trial Balances, open the trial balance's actions menu, and click one of these options:
Replace to import a corrected file or to correct the period dates.
View to open the trial balance.
Delete to remove the trial balance. This can't be undone.
Delete doesn't appear for the current period trial balance, or in an engagement that has a consolidated trial balance.
Troubleshoot common problems
I imported the prior-year trial balance and mapped accounts, and I can't find it
The prior-year trial balance isn't on the Sheets tab. It's saved in the Trial Balances folder on the Documents tab. Its values appear as a column on the current period trial balance.
Mapping changes work differently depending on where you make them:
Changes on the current period trial balance also apply to the prior-year trial balances for the same entity.
Changes made directly on a prior-year trial balance only apply to that trial balance.
To resolve this: Open the prior-year trial balance from the Trial Balances folder to review it. Make future mapping changes on the current period trial balance.
We're trying to build a consolidated trial balance by entering the prior-year ending balances
To resolve this: Add prior-year balances as an additional trial balance for each entity in the consolidation. See Set up a consolidated trial balance.
The prior-year trial balance has the wrong dates
To resolve this: Replace the prior-year trial balance with the same file and enter the correct Start Date and End Date.
I need to delete a prior-year trial balance, but Delete doesn't appear
The engagement has a consolidated trial balance.
To resolve this: Delete the trial balance from the consolidation instead:
Open Utilities > Manage Trial Balances, then click Manage Consolidation.
Go to the Add Trial Balances step.
Open the trial balance's actions menu and click Delete Trial Balance. This can't be undone.
If the trial balance is linked from another engagement, click Remove Trial Balance instead. This unlinks it from the consolidation but doesn't delete it.
If you don't see Manage Consolidation or these options, contact support.
Contact support
Contact support if you need to delete a prior-year trial balance in a consolidated engagement and can't remove it from Manage Consolidation.
See also
Import a trial balance
Map trial balance accounts to groups
Set up a consolidated trial balance
