Costpoint Online Help

Run Financial Anomaly Detection

View this special topic to learn about the financial anomaly detection process.

You have the option to run Dela's financial anomaly detection feature when you create general ledger report tables.

When you activate anomaly detection, Dela generates an analysis based on data from RPT_FS_COMPARE table for the specified fiscal year and period. Dela uses your configuration settings to determine the balance sheet, income statement, and the organization and account level to include in the analysis.

During the analysis, Dela calculates the following:
  • Period Percentage Variance (actual vs. budget)
  • Year-to-date Percentage Variance (actual vs budget)
  • Period-over-period change
  • Year-over-year change
  • Year-to-date Variance Amount
  • Period Variance Amount
  • Prior Period Variance Amount
  • Prior Year-to-date Variance Amount

After calculating these values, Dela compares the results with historical data and flags any items that deviate from established financial patterns. All identified anomalies are saved in the database for future review.

To run financial anomaly detection:

  1. Display the Create General Ledger Report Tables screen.
  2. Select One in the Option drop-down list of the Accounting Period selection range, and enter the Fiscal Year to include in the process.
  3. Enter or select the other reporting options you want.
  4. In the AI Analysis group box, select Run AI Anomaly Analysis.
  5. In the Balance Sheet Financial Statement Code field, enter or select a balance sheet to analyze.
  6. In the Income Statement Financial Statement Code field, enter or select an income statement to analyze.
  7. Specify the organization level(s) to include for the income statement analysis.
    Enter 0 to include all levels.
  8. Specify the account level(s) to include in the analysis.
    Enter 0 to include all levels.
  9. Enter a Materiality Threshold.
    Dela excludes FS lines below this threshold from the analysis.
  10. Run Create General Ledger Report Tables.

Financial Anomaly Analysis

Once Dela completes the financial anomaly detection process, you can view the records marked as anomalous on the Financial Anomaly Analysis screen for review and investigation.

To review financial anomalies:

  1. Display the Financial Anomaly Analysis screen.
  2. Enter or select a Fiscal Year.
  3. Enter or select an Accounting Period.
  4. Select the Type of financial statement to view.
  5. Click Execute.
    Financial statement lines flagged as anomalous by Dela display on the Details subtask.

    You can click the value of the FS Line field to view additional information about the line. When you click the link, the Financial Statement Comparison Inquiry screen opens and automatically displays the corresponding financial statement.

    On the Account/Organization subtask, you can drill down into the account and organization details associated with each FS Line displayed in the Details subtask. You can click the value of the Account field to view account activity information. When you click the link, the View General Ledger Activity screen opens and automatically displays the corresponding account activity details.