Managing the Display of Your Trial Balance

To help you work more efficiently with the trial balance, you can change several aspects of how the trial balance displays. The changes you make to the trial balance are retained while you are working within the engagement and are only visible to you. If you leave the engagement and later reopen it or manually refresh, the trial balance is returned to its original state.

To change the display of your trial balance you can:

• Sort the trial balance. Click on a column header to sort the column in ascending or descending order. Click the column again to reverse the sort order.
• Change the width of a column. Click and drag a separator line between columns in the header row to resize the columns.
• Reorder the columns. Click and drag a column header to a new location in the header row to change the order of the columns.
• Pin or unpin a column. Pinned columns remain visible even when you scroll to the right in the trial balance. By default, the Account Name and Account Number columns are pinned. To pin additional columns, click and drag a column header to the left of the column divider line that extends to the top of the trial balance. To unpin a column, click and drag the column header to the right of this line.
• Filter a Column. Columns within the trial balance can be filtered to provide a more granular view.

• Note: See Applying Filters for more information on filtering trial balance.

• Show me how to create a trial balance view. You can add, update, and delete trial balance views while in an engagement and viewing the trial balance. Exporting the trial balance will ONLY export the default trial balance views.

  1. Note: See View trial balance for more information on setting up trial balance views.

• Show or hide columns in a trial balance. This option is not available in the consolidated view for consolidated engagements at this time. To choose which columns display in the trial balance, do the following:
  1. Click the engagement on the Engagement List page.

     Note: See Using the Engagement List Page for information about using the pagination and search features to find an engagement in the list.

  2. Click on the navigation bar and select Trial Balance.
  3. Click the tab for the trial balance you want to change.
  4. Hover your pointer over a column header until the icon displays, and then click the icon.
  5. Select the check box for each column you want to display in the trial balance. Clear the check box for each column that you want to hide.

     Note: The account number and account name columns cannot be hidden.

  6. Click outside the list of columns to close the columns window.

Show me all the available columns for trial balances.

Column	Financial Trial Balance	Tax Trial Balance
			Notes
Account number	x	x	Account number is optional
Account name	x	x
Group	x	x	Displays "Unassigned" if no group name is assigned
Sub-group	x	x	If assigned
Property number		x	If a property group (rental, farm, or business) is selected
Type	x	x
Class	x
Unadjusted (current year)	x	x
AJEs (current year)	x	x
Adjusted (current year)	x	x
RJEs (current year)	x	x
Final > Balance (current year)	x	x
Final > Workpaper reference (current year)	x	x	If no workpaper is linked, a gray icon displays in this column. Click this icon to add a workpaper reference. If a workpaper is linked, a blue icon displays. Click this link to open the referenced workpaper. See Referencing Workpapers from the Trial Balance for more information.
Final (prior year)	x
TJEs		x
Tax > Balance (current year)		x
Tax > WP Ref (current year)		x	If no workpaper is linked, a gray icon displays in this column. Click this icon to add a workpaper reference. If a workpaper is linked, a blue icon displays. Click this link to open the referenced workpaper. See Referencing Workpapers from the Trial Balance for more information.
Tax (prior year)		x
Variance columns	x	x

Show me the columns that are available for the financial trial balance for consolidated engagements.

Column	Financial Trial Balance
	Consolidated view	Subsidiary view	Notes
Subsidiary ID	x
Subsidiary name	x
Group/Sub-group ID	x
Group/Sub-group name	x	x	Displays "Unassigned" if no group name is assigned
Account number		x	Account number is optional
Account name		x
Account type	x	x
Class	x	x
Unadjusted balance (current year)	x	x
AJEs (current year)	x	x
Adjusted balance (current year)		x
RJEs (current year)	x	x
Final balance (current year)	x	x
Final (prior year)		x
Sum of EJEs (current year)	x
Consolidated final balance (current year)	x
Consolidated final balance (prior year)	x

$ Var (both financial and tax) Notes: Displays the dollar variance between the current and prior year final balance on the financial trial balance and the tax balance on the tax trial balance.

% Var (both financial and tax) Notes: Displays the percentage variance between the current and prior year final balance on the financial trial balance and the tax balance on the tax trial balance.