Overview
You can replace a trial balance sheet with a new version using the Replace trial balance utility. You may want to do this if you previously uploaded a preliminary trial balance and the client has provided an updated version.
How it works
Here's what happens to the accounts when you replace a trial balance:
If an account exists in both the previous and the new trial balance: | The account's value will be updated to the new value in the trial balance. |
If an account exists in the new trial balance, but not the previous one: | The new account will be added to the trial balance. |
If an account exists in the previous trial balance, but not the new one: | The account will remain in the trial balance and its value will be set to 0. |
Replace a trial balance
To replace a trial balance sheet:
Download the template and open it in Excel. To create your import file, populate this spreadsheet with your accounts data. More information on formatting your import file.
Upload your populated import file to your engagement's Documents.
Navigate to and view the trial balance you want to replace. Your current period trial balance will be in the Sheets tab, and your other trial balances will be in the Documents tab in the "Trial Balances" folder.
Open the sheet Utilities menu and click Replace trial balance.
Select the new trial balance file.
Set the period start and end dates.
Review the mappings of the trial balance accounts and adjust, if needed. Set mappings for any new accounts. Fieldguide will keep the previous mappings for any existing trial balance accounts. Click Yes, I've reviewed to confirm.
Click Finalize Import.
See also
Set up a trial balance sheet: See this article for more detailed instructions on setting up a trial balance and mapping accounts.