Skip to main content

Import a trial balance

Import your client's trial balance into a financial audit engagement, set the period dates, and map each account to your firm's chart of accounts.

Overview

Every financial audit engagement has a placeholder trial balance sheet on the Sheets tab. To fill it in, import a file with your client's accounts and balances. During the import, you set the period dates and map each client account to a group in your firm's chart of accounts.

You can replace the trial balance later with an updated file. Replacing is also how you correct the period dates after an import.

Before you begin

  • Decide whether the engagement needs a single trial balance or a consolidated trial balance. If the client has more than one entity or fund that you need to roll up, don't use these steps. Follow Set up a consolidated trial balance instead. After you import a single trial balance as the current period, you can't convert the engagement to a consolidated setup without deleting every trial balance in it.

  • If the placeholder shows No Trial Balance Uploaded and no upload button, you don't have permission to update sheets in this engagement. To upload a trial balance, your role needs Full Access to Sheets. Ask your firm admin to check your role. Sheets in archived engagements are read-only for everyone.

Prepare your import file

Download the trial balance import template and use it as your starting point. To get the template, click Upload Trial Balance > Current Period > Upload file on the trial balance sheet, then click Download Template in the Import Trial Balance dialog.

Save the file as an Excel workbook (.xlsx) or a CSV file. Add each account as its own row, with these columns:

  • Account Number: The client's account number. Each account number must be unique.

  • Account Name: The client's account name.

  • Account Value: The account balance for the period.

  • Account Type: One of Asset, Liability, Equity, Income, or Expense. Capitalize the first letter.

Column headings aren't case sensitive. You can also use Name, Value, and Type without the word "Account".

Your file also needs to meet these rules:

  • The values of all accounts add up to 0. If they don't, the preview shows Unbalanced and a SUM total other than 0. You can still import an unbalanced trial balance, so check the total before you continue.

  • The file has 6,000 rows or fewer, unless your firm has a higher limit.

  • Optionally, add a Group Number column to map accounts to groups in your chart of accounts before you import.

Import the trial balance

To import a trial balance:

  1. In your engagement, open the Sheets tab and open the trial balance sheet.

  2. Click Upload Trial Balance > Current Period. 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.

  3. Select your file. The Preview Trial Balance drawer opens and lists the accounts in your file. If the file has errors, Fieldguide flags the rows to fix.

  4. Set the Start Date and End Date for the trial balance period. The end date must be after the start date.

  5. Click Next: Map new Accounts. Fieldguide AI suggests a group from your firm's chart of accounts for each account.

  6. Review each account in the Mapped Group column and change any mapping that isn't correct. Then click Yes, I've reviewed.

  7. Click Finalize Import.

The trial balance appears on the Sheets tab, with accounts grouped by their mapped group. To change mappings later, see Map trial balance accounts to groups.

Replace or re-import a trial balance

Replace the trial balance when the client sends an updated file, or when you need to correct the period dates. You don't need a different file to change the dates. Replace the trial balance with the same file and enter the correct dates.

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.

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.

You can't delete the current period trial balance. You can only replace it. To start over completely, a firm admin can restore the placeholder trial balance. That deletes every trial balance in the engagement. For details, see Set up a consolidated trial balance.

Troubleshoot common problems

I imported a trial balance and can't correct the period end date

You can't edit the period dates of a single trial balance on the sheet or in Manage Trial Balances.

To resolve this: Replace the trial balance with the same file and enter the correct Start Date and End Date. See Replace or re-import a trial balance.

If the trial balance with the wrong dates is a consolidated trial balance, the dates can't be changed this way. Contact support.

I need to change my trial balance import

To resolve this: Replace the trial balance with a corrected file. Your mappings stay in place for accounts that are in both files.

The preview shows "Trial Balance invalid. Fix the issues and upload a new Trial Balance."

The file has at least one row that Fieldguide can't import. Check the flagged rows for these common causes:

  • A required column is missing, or its heading doesn't match the template.

  • The account type isn't Asset, Liability, Equity, Income, or Expense.

  • Two or more rows have the same account number.

  • A required cell is blank.

To resolve this: Fix the file, upload it again, and restart the import.

The import fails with "Import limit exceeded"

The file has more rows than your firm's import limit. The limit is 6,000 rows unless your firm has a higher limit. The error message shows the limit that applies to you.

To resolve this: Remove blank or summary rows from the file so it's within the limit. If the client's trial balance has more accounts than the limit, contact support.

Finalize Import is disabled

To resolve this: Make sure every account has a group in the Mapped Group column, and click Yes, I've reviewed.

I imported a single trial balance but needed a consolidated trial balance

To resolve this: See Switch a single trial balance to a consolidated setup in Set up a consolidated trial balance.

Contact support

Contact support if you need to change the dates of a consolidated trial balance, or if you need to start over and don't see Restore Placeholder Trial Balance in the Utilities menu.

See also

Did this answer your question?