SE
SmartEngagement
Working Papers
CaseWare Working Papers
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests
Audit International
CaseWare  Audit International
SE
SmartEngagement
Working Papers
CaseWare Working Papers
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  Cloud Provided by Client Requests
Audit International
CaseWare  Audit International

View the client's trial balance data in the Data page

Once you’ve received and successfully imported your client’s trial balance data, you can view accounts and groups using the left panel on the Data page.

View accounts

The Accounts view option at the left panel displays your client’s accounts data. It mainly shows account numbers, names, preliminary balances (imported balances), final balances (after adjustments, rounding, etc.) and previous (prior year) balances.

Note: Based on your product setup, the Preliminary and Final column titles may be different.

If the trial balance is unbalanced, the Out of balance () indicator displays at the top of the page. The amount by which the data is out of balance also displays at the top.

You can sort the data in each column in an ascending order or a descending order by selecting the column. An upward arrow () or a downward arrow () displays on the page to indicate whether the data is sorted ascendingly or descendingly.

Data sorted in an ascending order by Account Name.

The drop-downs at the top of the Accounts view allow you to include more columns or indicators in the page and filter the data.

To view additional data in the Accounts view:

  1. Select the Columns drop-down.

  2. A list of the available columns displays.

  3. Select the check box next to the column you want to view.

  4. Available options include:

    • Variance
    • Variance percentage
    • Area
    • Cycle
    • Tax adjustments
    • Tax code

To include additional indicators in the Accounts view:

  1. Select the Indicators drop-down.

  2. A list of the available indicators displays.

  3. Select the check box next to the indicator you want to view.

  4. Available options include:

    • Issues
    • Annotations
    • Materiality

You can also search the page by entering keywords in the Search field at the top. Matching results are highlighted and displayed once you start typing.

How to search accounts data using the Search field at the top.

You can also filter the data on the page as desired. Select the Filters drop-down to specify a filter option:

  • At Amount, you can enter a range for the balances (From and To) so you only view account balances within that range. You can also use the slider to specify the range.

  • At the Cycles drop-down, you can filter the displayed accounts based on the selected cycle.

  • At the Areas drop-down, you can filter the displayed accounts based on the selected area.

  • You can select the Material check box to only display material accounts.

  • You can select the With issues check box to only display accounts with recorded issues.

The Filters drop-down.

You can also view transactions for each account. To learn more, see View account transactions.

View groups

Three main group views can be available to you at the left panel:

  • FINANCIAL GROUPS - displays the Financial groupings and subsequent accounts. This is the default grouping structure that the client’s trial balance data is mapped into. This group view is always available to you once you import the client’s data.

  • TAX GROUPS - displays the Tax Code groups and subsequent accounts. This group view is only available on the page if the Tax Code grouping structure is used in your product.

  • PRESCRIBED GROUPS - displays the Prescribed groups and subsequent accounts. This group view is only available on the page if a standard Chart of Accounts is used in your product.

Note: FINANCIAL GROUPS view is always available on the page. TAX GROUPS and PRESCRIBED GROUPS are only available on the page if Tax Code or Chart of Accounts grouping structures are enabled in your product.

Notice how group names display in blue while account names display in black.

Grpup names are in blue, while account names are in balck.

If the trial balance is unbalanced, the Out of balance () indicator displays at the top of the page. The amount by which the data is out of balance also displays at the top.

The drop-downs at the top of the group views allow you to include more columns or indicators in the page.

To view additional data in the group views:

  1. Select the Columns drop-down.

  2. A list of the available columns displays.

  3. Select the check box next to the column you want to view.

  4. Available options include:

    • Variance
    • Variance percentage
    • Area
    • Cycle
    • Tax adjustments
    • Tax code

To include additional indicators in the group views:

  1. Select the Indicators drop-down.

  2. A list of the available indicators displays.

  3. Select the check box next to the indicator you want to view.

  4. Available options include:

    • Issues
    • Annotations
    • Materiality

To hide the accounts and display groups only, disable the Accounts option.

How to disable the Accounts option to view only groups.

The groups that show on the page by default are based on your product setup. If no default groups have been set up in your product, the page displays all groups in the hierarchy.

If you have default groups defined in your product, you can view the parent groups for the default groups by enabling the Parent Groups option.

For example, in the below figure, default groups have been set up in the product, so the page displays the following groups by default.

Default groups display on the page (if the default groups are defined in your product).Otherwise, all trial balance groups display.

If you enable the Parent Groups option, the page displays all levels above the default group in the hierarchy (that is, the parent groups for each default group). Note that if you no default groups are defined, enabling this option has no effect on the page.

Enabling the Parent groups option dislpays the parent groups for each default group (if no default groups are defined in your product, enabling this option has no effect on the displayed data).

You can also select a specific group to view a drill-down of its subsequent groups only on the page. For example, you can select Current assets to view its subsequent groups only on the page. Notice how a navigation path displays at the top of the page so you can easily navigate to parent groups.

Naviagtion path shows at the top as you drill-down the groups hierarchy.

Was this helpful?

Yes
No
This content is exclusively related to Rct,auditint and has been filtered out. Select the PRODUCTS dropdown in the top navigation to modify your filter settings.

Stay Connected

Subscribe to receive updates on the latest articles and news for CaseWare products.

Your download will start immediately after you subscribe.

Please enter a valid email.
No thanks, I just want the file.