Overview
A blank trial balance (TB) sheet will be automatically added to the Sheets tab of financial audit engagements. You can add data by importing your client's accounts for the audit period.
Import data into the trial balance
To import data into the trial balance:
Download the template and open it in Excel. To create your import file, populate this spreadsheet with your accounts data. See below for tips on formatting your import file.
Upload the your populated import file to your engagement's Documents.
Open the trial balance sheet and click Import Trial Balance. Select your populated import file.
Set the period start and end dates. These typically match your engagement period.
Click Next: Map new accounts. Fieldguide AI will analyze the account names in your import file and your chart of accounts to automatically select a firm account for each client account.
Review the suggested mappings and adjust manually, if needed. Click Yes, I've reviewed to confirm that all mappings are accurate.
You can change these mappings later, if you need to.
Click Finalize import to complete the import.
Populating the import file
Each account should be added as a row in your import file. Every row must have an:
Account number
Account name
Account value
Account type
The account type must match one of these options:
Asset,Liability,Equity,Income, orExpense. Capitalize the first letter of the account type in your import file to avoid errors.
You import file must also follow these rules:
The first row of your import file is a header, and must match the header provided on the import template exactly.
Account numbers must be unique. No two accounts can have the same account number.
The values of all accounts must be balanced (add up to 0).
Here's an example of how your populated import file should look:
