Firm settings - Sherlock Starter

This topic applies to Caseware Sherlock.

Learn more about Caseware Sherlock

Processing Messages

The Processing Messages report displays information about the numerous data extraction processes that occur each day.

To view the Processing Messages report:

  1. Ensure that you have the Settings Admin role or equivalent privileges.

  2. Open the Cloud menu () and select Settings.

  3. Select Sherlock Starter | Processing Messages.

  4. The Processing Messages report loads a list of historical data extraction processes the first time it is opened.

    • (Optional) Use the refresh icon () to reload the Processing Messages report.

    • (Optional) Use the search bar or filter () to narrow the report results to those that match the specified properties.

      Property Description
      Status icons (,) Displays at a glance whether the extraction was a success () or failure ().
      Extraction Time The time when the extraction attempt was performed.
      Entity The name of the entity where the file is located.
      File The engagement file name.
      Last Modified The date when the engagement file was last modified.
      Status Displays whether the extraction was a success or failure.
  5. Select a data extraction process from the list to view more details, including the full error message for failed extractions.

Gold Standard Mapping

If your firm has custom Audit templates, you can use Gold Standard Mapping to map the risks, controls and reportable items in your templates to match the Caseware "gold standard". As a result of this mapping process, Sherlock can retrieve the risks, controls and reportable items from engagement files that are based on the firm template.

To configure Gold Standard Mapping:

  1. Ensure that you have the Settings Admin role or equivalent privileges.

  2. Open the Cloud menu () and select Settings.

  3. Select Sherlock Starter | Gold Standard Mapping.

  4. Select the Add Mapping Rule () icon below the applicable mapping type to create a new mapping rule, or the Edit () icon next to an existing rule.

    Note: You cannot edit mapping rules with the ACTIVE status.

  5. On the Select Source page, select a Working Papers file from the 20 most recent files. CaseView database information loads from the selected file. Select up to 3 applicable groups and a form.

    Select Next.

  6. On the Map IDs to Targets page, you can establish relationships by mapping IDs to targets. Select the Add ID () icon to the right of a target, then on the Add IDs page, select the applicable IDs to map to the target.

    The number next to each ID indicates how many times it has been mapped to a target. Select Add to map the IDs.

    • (Optional) Select Assign next to a specific target to assign a value transformation rule. On the Assign Value to Transform page next to the applicable ID, select an existing rule from the drop-down menu, select the Edit () icon to edit an existing rule, or select the Add Transformation Rule () icon to create a new rule. For example:

    When complete, select Next.

  7. The Summary page displays an overview of the mapping rule. If the mapping rule is complete, select Finish.

  8. The mapping rule is saved as a draft. Select the Edit () icon to continue editing the rule, or select ACTIVATE above the mapping type to enable the rule.


    • If there are two rules in the DRAFT status for a particular mapping type, selecting ACTIVATE will enable both rules.

    • Once active, you can no longer edit or delete a mapping rule.

    • Each Control, Risk or Management Letter Point can have up to 2 mapping rules.