NetClose - Set Up Flux Accounts

Overview

By default, flux analysis is available for all accounts in the chart of accounts immediately after NetClose is installed — no additional setup is required to begin generating flux scenarios. However, users can customize flux behavior on a per-account basis by populating any of the following fields outlined below.

Each of these fields can be configured manually on the Flux Analysis Account Mappings page, or populated in bulk via CSV import.

Step-by-Step Process: Manual Setup

Account Mappings

Navigate to NetClose > Setup > Flux Analysis Account Mappings

This page displays the full chart of accounts in NetSuite, including parent and subaccounts, with each account's name and type. Use the filters at the top to narrow the list.

Flux Groups

When NetClose is installed, each account is automatically assigned a Flux Group based on its Account Type. These Flux Groups can be customized if the default assignments don't fit your organization's needs. To learn more about modifying Flux Groups and their assignments, see this article.

Note

Inactive accounts are not included in the flux analysis
Accounts without a Flux Group will not appear in flux scenarios generated by Group. They will still appear in flux scenarios generated by Account or by Accounts & Groups.

Include Subaccount Activity

The "Include Subaccount Activity" box allows the user to generate a single flux that includes the parent and subaccounts. To enable, check the "Include Subaccount Activity" box in the row of the parent account.

Override Thresholds

When generating a flux scenario, thresholds determine which accounts require an explanation based on how much they've changed. Thresholds are typically set at the scenario level, but can be overridden here on a per-account basis.

The following override threshold fields are available:

Override Amount Threshold: Accounts that change by more than this dollar amount in the comparison period will require an explanation
Override Large Transaction Threshold: Individual transactions above this amount will be highlighted in the flux analysis
Override Percent Threshold: Accounts that change by more than this percentage in the comparison period will require an explanation

Any values set here will take precedence over the thresholds configured on the flux scenario.

Default Preparers/Reviewers

When the Flux Approvals global setting is enabled, users can configure Flux Preparers and Flux Reviewers. On this page, double-click on the Default Preparer and Default Reviewer columns and select the default assignments by account.

Note

For information on making preparer/reviewer assignments at the subsidiary level or by specific flux analysis, please see our article here.

Step-by-Step Process: CSV Import

All of the fields described above can be populated in bulk using a CSV import rather than editing accounts one at a time. This is especially useful during initial setup or when making widespread changes across the chart of accounts.

Fill out the applicable information in the NetClose Flux Template on the "Set Up Flux Accounts" tab
1. Delete any informational or example rows
When finished updating the Excel File, save it in a known location as a .csv file
Navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records
With the Import Assistant open, update the Import Type to Accounting and the Record Type drop-down to Chart of Accounts
Under the CSV files section, click on the Select button and upload the .csv file you saved
Select Next to progress to Step 2 Import Options
Within the Import Options section, make sure Update is selected and "Run Server SuiteScript and Trigger Workflows" is checked
Select Next to progress
After progressing through File Mapping, you will be prompted for Field Mapping
Note that NetSuite tries to directly map all the fields it can recognize. When fields are not recognized, they must be manually matched between the .csv upload file and NetSuite fields
1. Our recommendation is to match based on Internal ID for applicable fields
If the fields are mapped correctly and the field contents match the field values in NetSuite, select Save & Run, if you want to save the import for future updates, or Run as desired.
To view the status of the upload, select "Import Job Status" in the Confirmation banner or navigate to Setup > Import/Export > View CSV Import Status.
When complete, the status will change to complete and show the records imported successfully.
In the event of a failed upload, review the logs for the specific reasons, make necessary updates to the CSV file, and repeat the above steps.
To review your changes, go to NetClose > Setup > Flux Analysis Account Mappings.

Was this article helpful?