SOX Financial Control Management

This template is designed to track process controls that relate to financial procedures and processes. The template was created in response to Sarbanes-Oxley requirements.

• Built-in Fields
  • Control Objective (Title)—Single-line character field that is analogous to Title.
  • Priority—Drop-down field.
  • Status—Drop-down field. Values are:  Pending, Testing, Request Approval, Requires Remediation, Control Updated, Effective.
  • Description of Control (Description) —Multi-line character field.  Used for complete description of the process control.
• Suggested Fields
  • Notes—Multi-line character field for any relevant information to be included with the Issue.
  • Process—Drop-down field.  Values are:
    • Expenditures—Dependent values that are displayed in the Subprocess field when this value is selected are Purchasing, Processing AP, Maintaining Supplier Master File.
    • Fixed Assets— Dependent values that are displayed in the Subprocess field when this value is selected are Acquiring Fixed Assets, Depreciating Fixed Assets, Disposing of Fixed Assets, Managing Fixed Assets, Maintaining Register and/or Master File.
    • Inventory Management— Dependent values that are displayed in the Subprocess field when this value is selected are Managing Inventory, Receiving and Storing Raw Materials, Requisitioning Materials, Producing/Costing Inventory, Handling Finished Products, Shipping Finished Products, Maintaining Inventory Master File.
    • Payroll and Personnel— Dependent values that are displayed in the Subprocess field when this value is selected are Hiring Personnel, Terminating Personnel, Recording Time, Calculating Payroll, Disbursing Payroll, Maintaining Payroll Master Files.
    • Revenue— Dependent values that are displayed in the Subprocess field when this value is selected are Managing and Processing Orders, Invoicing, Sales Returns and Adjustments, Processing Cash Receipts, Maintaining Customer Master File.
    • Treasury— Dependent values that are displayed in the Subprocess field when this value is selected are Borrowing, Managing Cash Investments, Managing Derivative Transactions.
  • Subprocess—Drop-down field for selecting the subprocess to the main process.  This is actually a dependent field, the choices for which depend on the choice of Process.
  • Next Review Date—Date/time field.  Set the appointment for the next review of the control process.
  • Test Date—Date/time field for defining the test date.
  • Test Plan—Multi-line character field for entering the test plan for the process.
  • Test Results—Drop-down field for entering the test results.  Values are Aborted, Completed Successfully, Completed with Failures.
• Address Book—The Address Book is a sub-database that contains all of the contact information for your organization members.  Each record in the Address Book is called a “Contact”. Organization members are referred to as “Contacts”. The Address Book can contain up to 100 fields (SQL/Access versions are unlimited) for employee data, including Name, Department, Phone number, Email address, etc.
  • Suggested Address Book Fields
    • Last Name (character field)
    • First Name (character field)
    • Email address (Email address)
    • Department (character field)
    • User ID (character field)
    • Phone (character field)