You are here: Help Topics > Setup > Document management > Create a materiality document

Create a materiality document

If you are not using CaseWare Audit, you can create your own materiality document using CaseView.

A sample CaseView document displaying the each materiality type with preliminary and final values

Start by creating a new CaseView document in Working Papers from Document | New | CaseView. In the CaseView document, you must designate the name of each materiality type, and the value of each type's preliminary and final materiality. These values are designated through a cell calculation that writes the entered value to the CaseView database.

When designating the name of each materiality type, you can use the default name (Overall, Performance, Adjusted performance), or you can customize the name if your materiality guidelines contain organization specific terminology. The name you enter into the cell changes the name of the materiality type across the engagement.

To name a materiality type from a cell:

  1. On the ribbon, click Insert | Cell. Enter a cell number and click OK.
  2. In the New Cell dialog, set the Cell Type to Alphanumeric. In the Calculation Properties group, select Input Cell and External Data Access.
  3. Click the External Data tab.
  4. In the Data Type drop-down menu, select Global Cell Data (Long ID).
  5. In the Global Cell Data group, complete the Identifier field with the value required:

    Materiality Type Identifier Value
    Overall

    FREEZE_OVRALL

    Performance

    FREEZE_PERF

    Adjusted performance

    FREEZE_ADJ

    Click OK.

An editable cell displays in your materiality document. In Form Mode, double-click the cell to modify the text. Enter the default or customized name of the materiality type. Repeat the procedure for each materiality type.

You can now designate the preliminary and final materiality values for each materiality type. These values are specific to your organization.

To designate a preliminary or final materiality value from a cell:

  1. On the ribbon, click Insert | Cell. Enter a cell number and click OK.
  2. In the New Cell dialog, set the Cell Type to Numeric. In the Calculation Properties group, select Input Cell and External Data Access.
  3. Click the External Data tab.
  4. In the Data Type drop-down menu, select Form Cell Data (Long ID).
  5. In the Form Cell Data group, complete the Group, Form, and Identifier fields with the values required:

    Materiality Type Value (Preliminary) Value (Final)
    Overall

    Group: WPG

    Form: MATERIAL

    Identifier: VALUE

    Group: WPG

    Form: MATERIAL

    Identifier: FINAL

    Performance

    Group: WPG

    Form: PMATERIAL

    Identifier: VALUE

    Group: WPG

    Form: PMATERIAL

    Identifier: FINAL

    Adjusted performance
    (Requires Audit 20.00 or later)

    Group: FSA

    Form: Group name (e.g. GRP1)

    Identifier: Group number (e.g. 1.A)

    Group: FSA

    Form: Group name (e.g. GRP1)

    Identifier: Group number (e.g. 1.A)

    Trivial

    Group: WPG

    Form: TRIVIAL

    Identifier: VALUE

    -

    Note: Adjusted performance is specific to the automatic document (Leadsheet/Grouping documents only). Each leadsheet can have a unique adjusted performance value.

    Click OK.

An editable cell displays in your materiality document. In Form Mode, double-click the cell to modify the text. Enter the preliminary or final materiality value for the materiality type. Repeat the procedure for each preliminary and final materiality value.

When complete, you can view your materiality values in the header of applicable automatic documents.