Re-Importing Trial Balance Data
You might need to re-import the trial balance to get current account balances if an engagement has been rolled forward, changes have occurred on the books since the initial import, or if the wrong trial balance was imported initially.
Warning! The re-import process is irreversible.
To re-import the trial balance:
-
Do one of the following:
-
For a non-consolidated engagement, click on the navigation bar and select Trial Balance.
-
For a consolidated engagement, click on the navigation bar and select Trial Balance. Then, click to open the drop-down menu and select the subsidiary entity you want to work with.
-
-
To use the Data Import Wizard (identified by steps 1 to 4 at the top of the screen), upload an Excel® or CSV file.
-
To use Import Trial Balance, click Import from QuickBooks Online.
Note: Depending on the type of engagement, you may be navigated directly to Import Trial Balance. If the option is available, you can use the Data Import Wizard by clicking Try new import experience.
Re-importing using Data Import Wizard
This is the standard import process for Microsoft® Excel® and CSV files.
New trial balance data is appended to the existing trial balance data as follows:
-
Existing account names are updated, if applicable.
-
New accounts are added where required.
-
For any mapped balance columns, including current and prior periods, existing balances are zeroed out before importing the new balances.
-
Existing journal entries are left intact.
-
If groups, sub-groups, or tax groups are mapped, these will replace existing group assignments.
-
If groups, sub-groups, or tax groups are not mapped, existing accounts stay assigned to the same group, sub-group, property, type, and classification on both the Financial and Tax trial balance tabs. New accounts are automatically assigned both financial and tax groups, or left Unassigned if no match is found during mapping.
Re-importing using Import Trial Balance
This is the standard import process for QuickBooks® Online, or Xero™. It can also be used for pre-formatted Microsoft® Excel® files.
New trial balance data is appended to the existing trial balance data as follows:
- Existing account names are updated, if applicable.
- Existing current period balances are zeroed out before importing the new balances.
- Prior period balances are left intact and not re-imported.
- Existing journal entries are left intact.
- Existing accounts stay assigned to the same group, sub-group, property, type and classification on both the Financial and Tax trial balance tabs.
- New accounts are automatically assigned both Financial and Tax groups, or left Unassigned if no match is found during mapping.
To re-import the trial balance:
-
Do one of the following:
-
For a non-consolidated engagement, click on the navigation bar and select Trial Balance.
-
For a consolidated engagement, click on the navigation bar and select Trial Balance. Then, click to open the drop-down menu and select the subsidiary entity you want to work with.
-
-
Click Import TB on the toolbar.
-
Click Confirm.
-
Click Microsoft Excel, QuickBooks Online, or Xero.
-
Follow the import procedures that corresponds with the type of source file you are importing from in the topic Importing Trial Balance Data.