SE
SmartEngagement
Working Papers
CaseWare Working Papers
Analytics
CaseWare Cloud Analytics
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  PBC
SE
SmartEngagement
Working Papers
CaseWare Working Papers
Analytics
CaseWare Cloud Analytics
AnalyticsAI
CaseWare AnalyticsAI
Time
CaseWare Cloud Time
PCR
OnPoint PCR (Preparation Compilation Review)
RCT
CaseWare  ReviewCompTax
PBC
CaseWare  PBC

Collect data for your engagement

This feature is only available with products on the CaseWare Cloud Engagements platform. Available products include OnPoint PCR, PBC Requests and CaseWare ReviewCompTax.

Once the client has returned the signed engagement letter and the terms of the engagement have been finalized, you are ready to add the client's financial data to the engagement file.

Request the client's trial balance

You can submit a client request directly to the client, asking them to attach a file that includes the trial balance data for their engagement.

To add a client request to the engagement file:

  1. From the top menu, select Documents.

  2. Select the Add Document icon (), then select Query.

  3. Select a query type, and enter a name.

  4. Note: Available query types will differ depending on your Smart Engagement product.

  5. Select Create Query.

A new client request is added to your engagement file in your chosen folder. Some online engagement products have templates that include a trial balance request.

A client request that prompts the client to upload their trial balance.

Note: If you need more information about how to create a new client request from scratch, see Customize a client request.

Once the client request is ready, you can send the client request to your client.

To send a client request:

  1. Open a client request.

  2. Select SEND.

  3. The Open Query dialog displays.

  4. Select a due date for the client response in the Query Due Date field.

  5. Select a client contact from the Assignees drop down list.

  6. You can select more than one contact or select the Assign to all contacts check box to send the request to all client contacts.

  7. Add a message in the Email Body text box to be included in the notification email.

  8. Select OK to send the client request.

The client will attach the requested trial balance file and mark the request as responded. You can review the attachment, and if the trial balance file has all of the expected information, you can accept the response and complete the query.

Import the trial balance

Once you have your client's trial balance file, you can import it into the online engagement. By importing the trial balance, the client's financial data is automatically incorporated into the financial statements and into the analysis sections of other documents.

To import client data from Excel/CSV:

  1. From the top menu, select Trial Balance.

  2. On the trial balance page, choose a trial balance grouping structure from the drop-down menu at the top of the page.

    The following options are available:

    • Financial
    • Tax Code
    • Chart of Accounts
  3. Under Import from, select Excel or CSV. In the upload dialog, drag and drop an Excel file or a CSV file into the gray upload area, browse for the file on your local device storage or select the file from the engagement if you have already uploaded it.

    The upload dialog for Excel and CSV files.

  4. Map the columns in the import file by choosing the field that best matches the data from the Import as drop-down menu. If you don’t want to import a column, select Do not import to exclude it.

    Mapping columns using import data.

  5. Select Import.

Your imported data populates the trial balance.

Assign accounts to groupings

When you import the trial balance file from your client, the online engagement will automatically map as many of the accounts as possible to appropriate groups in the trial balance. However, if an account cannot be automatically mapped, you will need to assign it manually.

To assign an account to a group:

  1. From the top menu, select Trial Balance.

  2. Select the grouping menu and choose one of the available grouping structures.

    The available groupings are:

    • Financial
    • Tax Code
    • Chart of Accounts
    • GIFI (only available for CaseWare RCT)
  3. Select the Assign Accounts icon ().

    Tip: If there are unassigned accounts in the data, the icon shows the number of unassigned accounts in a red badge. For example, if there is one unassigned account, the icon displays the number 1 in a red badge ().

  4. Select the account from the Unassigned column.

    The account now displays in the Selected Accounts column. The application may also display grouping suggestions under Suggestions.

  5. Select a group to assign the selected account to that group.

    Tip: You can also drag the account from the Unassigned column and drop it in a group to assign. You can also search groups using the search field. Note that you need to enter at least 3 characters in the search field for the matching results to display.

    Search and assign accounts

The account is now assigned, and it will be included in your trial balance and in other documents in the online engagement.

View material accounts and groups

While working on some engagements, you may need to consider material amounts for misstatements in the client file. Some online engagement products include a materiality document that can help you assess materiality as you work on the engagement. To learn more, see Define materiality.

If materiality values are defined in the engagement, the materiality values are displayed in the top menu. If you enable materiality indicators on the trial balance, the green (M) mark displays in accounts and groups as a visual indicator that they are material.

Material groups are marked with a green and white M icon.

Was this helpful?

Yes
No
This content is exclusively related to Se,rct,pcr 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.