SOX Storyboard Toolkit

Monitoring and reporting progress is key to the success of a SOX program. In this article, we discuss using the pre-configured SOX Storyboard Toolkit to monitor the progress of your SOX program.

What is the SOX Storyboard Toolkit?

A toolkit that deploys a set of pre-built SOX storyboards to help monitor and manage your SOX program, and effectively communicate progress to executive stakeholders. Deploying the toolkit is quick and can be completed in five steps.

Note

The SOX Storyboard Toolkit is a starter toolkit. You can further configure the storyboards to suit your requirements. Diligent does not provide support for any customizations you make.

What is included in the toolkit?

The toolkit contains the following:

  • 2 pre-built storyboards
  • 5 pre-built data analysis tables
  • 1 robot

Limitations

  • The toolkit is optimized for SOX projects that leverage the Sarbanes-Oxley Review project type in Diligent One and is not compatible with archived projects.
  • For all the projects combined, the number of data records must not exceed 100,000.
  • If a field in any of the source tables contains more than 16,000 characters, the robot fails to import the table.

Overview of steps

You can have the SOX Storyboard Toolkit quickly up and running in your organization in five steps.

Prerequisites

  • You must have a System Admin user type in Diligent One to install the toolkit.
  • You must have a HighBond API token generated to authorize the robot task.

Step 1: Install the toolkit

When you install the SOX Storyboard Toolkit, it creates related storyboards, supporting data tables, and a SOX Storyboard Tables robot.

Note

You must have a System Admin user type in Diligent One to install the toolkit.

Uninstalling the toolkit

If you need to uninstall the SOX Storyboard Toolkit, use the Delete button on the Installed Toolkits tab. Do not delete the individual storyboards, tables, or robot.

Step 2: Create and schedule a task in the robot

The SOX Storyboard Tables robot created by the toolkit allows you to specify the SOX program(s) that must be reported in the pre-built storyboards and also set up how often data must be refreshed. To automate the process of importing data and refreshing your SOX storyboards, you must create and schedule a task in the robot.

Note

The toolkit installs a robot script in development mode. A best practice is to create a task and run the script once in development mode before activating the script to production mode. Running the script in development mode allows you to review the results and determine if any adjustments are needed before activating the script to production mode.

Step 3: Upload the SOX Field Configuration file and run the task

The SOX Field Configuration file is an Excel file that contains worksheets:

  • to obtain additional required information to prepare your SOX tables, based on your SOX project configurations
  • that provide options to further configure field names of custom attributes and numeric field conversions. For more information, see (Optional) Configuring pre-built SOX data tables.

Note

Do not add, delete or modify the names of any worksheets or columns in this file. Any modifications may result in failures when the robot task runs.

Step 4: Review the storyboards

Once the task runs successfully, it pulls data from the specified SOX project(s) and presents results in the SOX Storyboard [pre-built] and SOX Controls Storyboard [pre-built] storyboards. Review the storyboards.

(Optional) Configuring pre-built SOX data tables

After reviewing your pre-built SOX storyboards, you may want to customize the pre-built SOX data tables to tailor data to your requirements. Use your local copy of the SOX Field Configuration file to update the data tables. Delete the copy of the file from the Input/Output tab in the robot, and then upload the updated copy of the file.

  • Use the configurable_fields worksheet to override the out-of-the-box custom attribute field names with the configured field names that are set in Project Types. In the Custom Name column, provide any custom names configured through Project Types.

    Note

    Do not make any changes to the Default Name and Configured Name columns.

  • Use the numeric_fields_to_char worksheet to specify additional numeric fields that must be converted to character data type. This is useful if you want to generate additional visualizations. This worksheet contains the Original_Field_Name column that lists the original names of the fields that must be converted to character data type. Add any additional fields that you want to convert.

    Note

    Do not modify the original list.

Step 5: Replicate the automated functionality in production mode

Once you are satisfied that the SOX Storyboard Tables robot is functioning correctly in development mode you can replicate the automated functionality in production mode. Do the following:

  1. Activate the robot script to production mode.

  2. Upload the SOX Field Configuration file to the Input/Output tab in production mode.

  3. Using the same process that you used in development mode, create and schedule a task in production mode to run the script.

  4. In development mode, disable the task.

    Caution

    Do not leave the development mode task enabled. If you do, both the production mode and the development mode tasks will run at their scheduled times and modify the same storyboard.

For more information, see Development mode and production mode in Robots.

(Optional) Configuring pre-built SOX Storyboards

A storyboard is a communication platform and you may want to make your pre-built storyboards more appealing to your executive stakeholders by adding additional charts, formatting text, and selecting colors. For more information, see Editing storyboards.

Note

You must create a copy of the pre-built storyboard, by using the Save As option, before making any changes. For more information, see Duplicating storyboards.