View the client's trial balance data

After you successfully import your client's trial balance data, you can view the trial balance from the Accounts and Financial Groups tabs in the left panel of the Data page.

Switch between planning and final balances

If planning balances are enabled, you can switch the engagement between planning and final balances. The mode selector appears at the bottom of the left panel on the Data page.

To switch balance modes:

On the Data page, go to the mode selector at the bottom of the left pane.
Select Planning or Final.
In the confirmation dialog, select Continue.

The page refreshes and displays the selected balance mode.

You can use this selector to correct the balance mode if the engagement remains in Planning mode after you import balances or update accounts.

Customize the view

The following options apply to the trial balance on both the Accounts and Financial Groups tabs.

Column customization

Your column layout preferences are saved across sessions.

Pin and unpin columns

Pinned columns remain visible on the left while you scroll horizontally through the trial balance.

To pin a column:

Hover over the column header.
Select the Pin column [] icon in the top-right corner of the column header. The column moves to the left section of the trial balance.

To unpin a column:

Hover over the pinned column header.
Select the Unpin column [] icon. The column returns to the scrollable section of the trial balance.

Note: The More Actions column remains pinned to the right side. You can't move, unpin or hide this column.

Reorder columns

You can change the column order to compare balances or periods side by side.

To reorder a column:

Drag the column header to the required position.

When you move the Variance column, its currency and percentage subcolumns move with it.

Resize columns

You can resize columns to change the amount of information visible in the trial balance.

To resize a column:

Drag the edge of the column header to the required width.

Show or hide columns

The Columns drop-down menu controls which columns appear in the trial balance.

To show or hide columns:

Select Columns.
Select the check box for each column you want to show.
Clear the check box for each column you want to hide.
Select outside the menu or press the Esc key to close it.

An example of the Columns drop-down:

Change which accounts appear

The Options drop-down menu includes options for changing which accounts appear in the trial balance.

Hide zero-balance accounts

The Suppress Zero Balances toggle appears when the trial balance contains accounts with zero balances.

To hide zero-balance accounts:

Select Options.
Select the Suppress Zero Balances toggle. Accounts with zero balances no longer appear in the trial balance.

The option doesn't appear when the trial balance has no zero-balance accounts.

Combine accounts with the same account number

In consolidated engagements, the same account number can appear on separate rows for different entities.

You can combine these accounts to review the account number across entities in 1 row.

To combine accounts with the same account number:

Select Options.
Select Collapse Same Account Numbers.

Accounts with the same account number appear in 1 row across the consolidated entities.

View additional indicators

You can display additional indicators in the trial balance.

To show additional indicators:

Select Indicators.
Select the check box for each indicator you want to show.

Available indicators include:

Issues
Annotations
Materiality

Out-of-balance warning

If the trial balance is unbalanced, the Out of balance warning appears at the top of the page. The out-of-balance amount also appears.

Control variance signs for credit and debit accounts

You can display amount or percentage variance columns on the Data page. The variance setting controls how positive and negative amounts appear for debit and credit accounts.

The default setting is Ignore Credit/Debit. With this setting, increases in credit-balance accounts can appear as negative variances.

To change the variance sign behavior:

Select Variance.
Select an option:
- Absolute Variances displays variance amounts as positive.
- Ignore Credit/Debit calculates variance signs without considering the account's normal debit or credit balance. This is the default.
- Follow Credit/Debit adjusts variance signs based on the account's normal balance. Increases in credit-balance accounts display as positive.

Your selection is saved automatically and applies to exports, printing and saved views.

Sort trial balance data

To sort trial balance data:

Select a column header to sort the data in ascending or descending order. An upward or downward arrow indicates the sort order.

Search trial balance data

To search trial balance data:

Enter a keyword in the Search field. Matching results are highlighted as you enter text.

Filter trial balance data

To filter trial balance data:

Select Filters.
Specify one or more filters:
- At Amount, enter values in From and To, or use the slider to specify a balance range.
- At Cycles, select a cycle.
- At Areas, select an area.
- Select Material to display material accounts.
- Select With issues to display accounts with recorded issues.

You can also view transactions for each account. To learn more, see View the client's transactions.

Save a trial balance view

If you've customized a view to display a specific set of data that you wish to revisit, you can save the view.

To save a view:

On the Data page, select the Save views icon []. A list of previously saved views displays.
Select Save current view.
Enter a name for the new view.
Select Save.

You can now select and manage your saved view from the list under the Save views icon [].

Navigate trial balance data levels

As you scroll through the trial balance, your position remains visible in the grouping hierarchy. This keeps the relevant grouping context visible while you review lower-level groups.

View accounts

The Accounts tab displays your client's trial balance by account. You can review account numbers, names, preliminary balances, final balances and prior-year balances.

Note: The Preliminary and Final column names can vary based on your product setup.

Cloud Engagements Data page, Trial Balance – Accounts tab, listing accounts with preliminary, adjustment and final balances, with Planning and Final balance mode buttons at the bottom of the left panel.

View financial groups

Financial grouping structures organize trial balance accounts for financial reporting, tax preparation and regulatory filings. They map client account numbers to a consistent hierarchy of financial groups.

If your engagement doesn't close current-year net income to equity, the Out of balance message can appear on the Financial Groups tab even when the trial balance is correct.

Authors can change the out-of-balance check to use the full trial balance, including both Balance Sheet and Income Statement groupings. This prevents the false message. To learn more, see Use the full trial balance for the out-of-balance check.

Grouping structure and financial group

Caseware uses grouping structure to describe the complete hierarchy and financial group to describe an individual group within that hierarchy. This distinction helps identify whether you're working with the structure or a specific group.

A financial grouping structure is a hierarchy of groups used to organize accounts in the trial balance or financial statements.
A financial group is an item within a grouping structure, such as Revenue or Current Assets.

Available grouping structures appear in the left panel on the Data page. The primary structure is Financial Groups, which displays the client's trial balance according to the default financial grouping structure.

Depending on your product template, other grouping structures can also appear. These can include Tax Grouping for tax categorization and Prescribed for regulatory or jurisdictional filings.

Firm authors, enterprise authors and end users can also be enabled to add and manage custom grouping structures.

Group names appear in blue and account names appear in black.

Collapse and expand groups

You can collapse and expand groups using the Collapse [] and Expand [] icons. When all subgroups at the same level are collapsed, you can rearrange them using the Rearrange [] icon.

You can use Collapse All or Expand All at the top of the trial balance to hide or show all subgroups within groups.

Filter financial groups by dimension

The Dimension menu lets you filter financial groups by dimension.

To filter financial groups by dimension:

Select Dimension.
Select the dimension you want to view.

You can also enter a dimension in the Search field to find it in the list.

Show financial groups only

You can hide accounts to display financial groups only.

To show financial groups only:

Select Options.
Clear the Accounts toggle.

View default and parent groups

The financial groups displayed by default depend on your product setup. If your product doesn't define default groups, all groups in the hierarchy appear.

If your product defines default groups, you can also display their parent groups.

To show parent groups:

Select Options.
Select the Parent Groups toggle.

All hierarchy levels above each default group appear.

If your product doesn't define default groups, selecting Parent Groups doesn't change the displayed data.

You can select a financial group to drill down into its subgroups. A navigation path appears at the top of the trial balance to show your position in the hierarchy.

To learn more, see:

Financial grouping structures for an overview of grouping structures.
Customize financial groups to add, edit, reorder or delete groups.
Assign accounts to groups to assign accounts to financial groups.

View tax adjustment columns

By default, all tax adjustments accumulate in a single Tax adjustments column.

If your product displays separate tax adjustment columns, individual columns replace the Tax adjustments column. Incremental subtotal columns show the cumulative effect of the adjustments.

This applies to the current year only.

The following columns can appear:

Column	Displays
Tax - Federal	Federal tax adjustments only
Tax Federal Final	Final balances plus federal tax adjustments
Tax - State	State tax adjustments only
Tax Federal + State Final	Final balances plus federal and state tax adjustments
Tax - City	City tax adjustments only

The subtotal columns show the cumulative effect at each stage. These columns also appear in CSV, PDF and Tabular Excel exports.

View adjustment details

If adjusting entries are posted to financial groups or accounts, you can open the corresponding entry on the Adjustments page.

Note: The Adjustments column must be visible on the Data page. Select Adjustments from Columns if the column isn't visible.

If Split Adjustments is available in your product, select it to display normal and reclassifying adjustments in separate columns.

To view adjustment details:

In the Adjustments column, select the adjustment you want to view. The Adjustments page opens and displays the selected adjusting entry. A blue vertical bar identifies the selected entry.