NetClose - Set Up Flux Account Groups
Overview
When NetClose is installed, each account is automatically assigned a Flux Group based on its Account Type, allowing flux scenarios to be generated immediately without any additional setup. The default Flux Groups may be customized to edit existing groups or create new groups. This can be done manually or via CSV import. This article outlines both approaches.
Note
This article does not address assigning accounts to flux groups. Those instructions can be found under Set Up Flux Accounts.
Update Flux Account Groups Manually
To review the default Flux Group assignments, navigate to NetClose > Setup > Flux Analysis Account Mappings and reference the Flux Group column.
To see a list of all Flux Groups, search "NetClose Flux Analysis Group" in the global search bar and navigate to the page. To edit an existing group, select Edit. To create a new group, select New NetClose Flux Analysis Group.
The following fields are available on the Flux Analysis Group record:
- Name (required): The display name for the group
- Flux Type (required): Income Statement or Balance Sheet
- Natural Balance: Debit or Credit
- Preparer: Individual assigned to prepare the flux group.
- Reviewer(s): Individual assigned to review the flux group.
- Absolute Due Date: Date the flux analysis is due.
- Close Timing (Business Days): Date in business days that the flux analysis is due.
- NetClose Flux Override Amount Threshold: A threshold amount can be set here for the consolidated group level.
- NetClose Flux Override Percent Threshold: A threshold percentage can be set here for the consolidated group level.
- Sort Order Index: If you would like your groups to show in a certain order on the Review page, indicate the order here.
Update Flux Groups via CSV Import
All of the fields described above can be populated in bulk using a CSV import rather than editing groups individually. This is especially useful during initial setup or when making widespread changes across groups.
Note
These instructions pertain to editing the Flux Analysis Group records themselves. To assign accounts to groups, please follow the instructions found in our Set Up Flux Accounts article.
- Fill out the applicable information in the NetClose Flux Templateon the "Flux Analysis Group" tab
- Delete any informational or example rows
- 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 Custom Records and the Record Type drop-down to NetClose Flux Analysis Group
- 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, select Add if adding new flux groups and Update if updating existing flux groups. Also, make sure "Run Server SuiteScript and Trigger Workflows" is checked
- Select Next to progress an follow the prompts to finish the import
- To review your changes, go to NetClose > Setup > Flux Analysis Groups
Once flux account groups are configured, you can proceed to generate flux scenarios.
