Skip to main content

Replace a trial balance

Update a trial balance with a new version

Overview

Replace a trial balance when the client sends an updated file, for example after you imported a preliminary trial balance. You can also replace it with the same file to correct the period dates.

Can I edit a trial balance?

Not directly. The values on a trial balance are read-only and you can't type into its cells. That's true whether or not you've finished importing it, and it isn't a permissions setting, so a firm admin can't type into them either.

There are two ways to change the numbers:

  • Post an adjustment. Use this for corrections and year-end entries. The original value stays, and the adjusted value is recalculated. See Add adjustments to a trial balance.

  • Replace the trial balance with a corrected file, using the steps below. Accounts that are in both files keep their existing mappings.

To change how accounts are grouped rather than what they're worth, see Map trial balance accounts to groups.

Before you begin

Prepare the replacement file the same way you would for a new import. For the template and formatting rules, see Prepare your import file.

To replace a trial balance, you need Full Access to Sheets. You can't replace a trial balance in an archived engagement.

Replace a trial balance

To replace a trial balance:

  1. Open the trial balance sheet. In the sheet toolbar, click the Utilities (wrench) icon > Manage Trial Balances.

  2. Find the trial balance you want to replace. Open its actions menu and click Replace. If the engagement has a consolidated trial balance, this option is labeled Replace Trial Balance.

  3. Select the replacement file.

  4. Set the Start Date and End Date.

  5. Click Next: Map new Accounts. Accounts that already exist in the trial balance keep their mappings. Map any accounts that are only in the replacement file, then click Yes, I've reviewed.

  6. Click Finalize Import.

To replace an entity's trial balance in a consolidated trial balance, see Update a consolidation.

What happens to the accounts

Here's what happens to the accounts when you replace a trial balance:

  • An account in both files gets the value from the replacement file.

  • An account only in the replacement file is added to the trial balance.

  • An account only in the original file stays in the trial balance with a value of 0.

The trial balance name and its period column headings update to match the dates you entered. Adjustments stay on the trial balance, and each account's adjusted value is recalculated from its new value.

See also

Did this answer your question?