NetClose - Create Flux Scenario Templates

Overview

Flux Scenario Templates are saved configurations that store the criteria used to generate a flux analysis — such as subsidiaries, flux grouping, account types, comparison periods, and thresholds. When a template (source scenario) is selected on the Generate Flux page, all saved settings populate automatically, eliminating the need to re-enter the same information each time.

Templates are optional, but are especially useful for recurring analyses like Month-to-Month or Year-to-Year comparisons. This article covers how to create templates manually and how to add them in bulk via CSV import. 

Create Flux Scenario Templates Manually

  1. Navigate to NetClose > Flux Analysis > Flux Scenarios > New.
  2. On this page—at a minimum—input the following criteria in the Primary Information section: 
    • Enter a name for the saved scenario.
    • Select the subsidiaries to include in the analysis.
    • Select the Flux Grouping and Flux Account Types. 

3. The "Flux Dates" section allows you to select the two comparison periods for the flux analysis. The dropdown menu offers a wide range of options, such as Last Fiscal Half, Last Fiscal Quarter, Last Fiscal Year, and Last Month, among others.

4. The "Flux Options" section is where you define the thresholds for the flux analysis. You can set thresholds based on either amount, percentage, or both. These thresholds can be applied to the balance sheet, income statement, or both, depending on your analysis needs.

5. The "Balance Sheet Or" and "Income Statement Or" checkboxes determine how the threshold requirements are applied. When these boxes are checked, NetClose will trigger a required explanation for the account if either the percentage or amount threshold is exceeded for the balance sheet or income statement. If the boxes are unchecked, NetClose will only trigger a required explanation if both the percentage and amount thresholds are exceeded.

6. The "Large Transaction Threshold" field allows you to set an amount threshold for individual transactions. If a transaction exceeds this threshold, it will be highlighted in the flux analysis. These transactions could explain a significant portion of the account balance change, providing valuable insights and helping users better understand the cause of the change, as well as aiding in the completion of the flux analysis explanation.

7. If Flux Analysis AI is enabled in the system setup, the "AI Explanation" section offers several options:

  • Automatically copy the AI-generated explanation as the Primary Explanation.
  • Generate a Flux AI when an explanation is not required.
  • Provide additional context to assist the system in generating more accurate AI explanations.

8. Once the page is completed, click Save to store the flux scenario as a template in NetClose.

Once created, you can generate your flux scenario. 

Import Flux Scenario Templates

Flux scenario templates can be added in bulk via CSV import. 

  1. Fill out the applicable information in the NetClose Flux Templateon the "Flux Scenario Template" tab
    1. Delete any informational or example rows
  2. When finished updating the Excel File, save it in a known location as a .csv file
  3. Navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records
  4. With the Import Assistant open, update the Import Type to Custom Records and the Record Type drop-down to NetClose Flux Scenario.
  5. Under the CSV files section, click on the Select button and upload the .csv file you saved
  6. Select Next to progress to Step 2 Import Options
  7. Within the Import Options section, select Add and check "Run Server SuiteScript and Trigger Workflows" 
  8. Select Next to progress and follow the prompts to finish the import. 
  9. To review your templates, go to NetClose > Flux Analysis > Flux Scenarios.

Once created, you can generate your flux scenario. 


Was this article helpful?