NetClose - Generate a Flux Scenario(s)

Overview

To perform a flux analysis, a flux scenario must first be generated. This article outlines the steps for generating a flux scenario(s) to enable the analysis. 

Step-by-Step Process

Generating a single scenario

  • Navigate to NetClose > Flux Analysis > Generate Flux.

  • On the "Generate Flux Scenario" page, define the periods for comparison and set the relevant thresholds.

  • If a saved source scenario exists, it will appear in the "Source Scenario" field. You can select the saved scenario, and the flux criteria will automatically populate based on the pre-defined settings. If no relevant source scenario is available, manually complete the required fields.

  • In the "Primary Information" section, select the subsidiary, flux grouping, flux account types, and any additional segment types to be included in the flux analysis.

  • The "Period Information" section allows for defining the comparison periods. Additionally, a budget category can be chosen for comparison.

  • The "Options" section allows for setting thresholds for the flux analysis. Thresholds can be defined by amount and/or percentage, and can apply to the balance sheet and/or income statement.

  • The "Or" checkboxes indicate that if thresholds for both amount and percentage are set for the balance sheet or income statement, NetClose will trigger a required explanation for the account if either threshold is met. If these checkboxes are not selected, NetClose will require an explanation only if both thresholds are met.

  • The "Large Transaction Threshold" allows for setting a threshold for individual transactions. Transactions exceeding this threshold will appear in the flux analysis, potentially accounting for a significant portion of the change in the account balance. This helps identify the transactions responsible for the fluctuations. 

  • If AI Flux Explanations are enabled in the system setup, the "AI Explanation" section allows users to configure whether the system should copy the AI explanation to the primary explanation, generate an AI explanation when a primary explanation is not required, and provide additional AI context to assist in generating the explanations.

  • Once all criteria have been completed, click Submit to generate the flux analysis based on the provided information.

Generating multiple scenarios

Navigate to NetClose > Close Management > Generate Flux Analysis from Scenario.

This page allows the user to generate multiple flux scenarios at the same time. 

There are filters to help the user pull up the correct scenarios that they would like to generate. 

Under the "Period Information", the user will specify the "Current" and "Comparison" Periods they need to run for the flux scenarios. 

Then they will select all scenarios that need to be generated and select "Submit". 

In order to avoid duplicates, if a specific scenario has already been run for the Current and Comparison period selected or if two scenarios that are selected would generate the same records, the system will notify the user by highlighting the scenarios in red. 

The user will need to de-select the scenarios highlighted in red and only generate the blue.

To view the newly generated scenarios, the user will navigate to NetClose > Flux Analysis > Review Flux Analysis.

Using Relative Start Dates

Flux scenarios can be configured with a "Relative Start" so that their date ranges adjust automatically based on the selected current period. Instead of manually setting fixed start and end dates, the system calculates the appropriate range using your fiscal calendar.

The following Relative Start options are available:

  • Year-to-Date (YTD) – Starts from the first day of the fiscal year through the end of the current period
  • Trailing 12 Months (T12M) – The 12 complete months ending with the current period
  • Trailing 6 Months (T6M) – The 6 complete months ending with the current period
  • Trailing 3 Months (T3M) – The 3 complete months ending with the current period

For example, if the current period is September 2025 and "Trailing 12 Months" is selected, the system will automatically calculate the range as October 1, 2024 through September 30, 2025.

To use a Relative Start, select the desired option in the "Relative Start" field on the flux scenario. The system will determine the correct periods at runtime based on your accounting calendar.

Key Considerations:

  • When using a Relative Start, both the current and comparison periods must be posting periods. Non-posting periods (such as adjustment periods) will trigger an error.
  • The "Trending Periods" filter on the Review Flux Analysis page is disabled for scenarios using a Relative Start, since the relative rule already defines the date range.

 

Was this article helpful?