Manage Supplemental Accounts

Manage Supplemental Accounts allows you to create and delete supplemental (statistical) accounts, and edit the properties of existing accounts.

In this section, you can find information on the following topics:

• Accessing manage supplemental accounts
• Importing supplemental accounts
• Managing supplemental accounts
• Exporting supplemental accounts

Accessing manage supplemental accounts

1. Select the Consolidate module.
2. Select the Administration category.
3. Expand Accounts.
4. Click Manage Supplemental Accounts. The Manage Supplemental Accounts dialog appears and contains the following options:
   • Import
   • Manage
   • Export

Importing supplemental accounts

The import option in the Manage Supplemental Accounts dialog allows you to create and update statistical accounts in the database from a .csv file.

To import accounts:

1. For Option, select Import.
2. Select the .csv file to import from.
3. Click OK. A table will be displayed showing the summary of all actions performed by the import.

.csv file example:

where:

• Account is the name of the supplemental account.
• Description is the description of the supplemental account.
• Type indicates whether the account is a STATIC, STANDARD or CARRYFORWARD account.
• Parent Account is the name of a supplemental account under ACCOUNTS_Supplemental to assign the account to. The account will become a child of the specified parent, and the values in the parent will be calculated from all its children.
• Sort Order indicates the order of the account under the parent, with lower numbers ordered before higher numbers. You can specify NULL or 0, which will assign the sort order as 0, which results in the symbol being sorted by when it was created.
• Weight defines how the account will roll up to it’s parent. Valid options are +, - and 0.

Managing supplemental accounts

The Manage option in the Manage Supplemental Accounts dialog allows you to create, update and delete accounts from within the Manage Supplemental Accounts table.

To manage accounts:

1. For Option, select Manage.
2. Select the account to manage. In the Manage Supplemental Accounts table, the list of accounts selected is displayed.

   Note: You may leave the account selection blank to start with an empty table. This can be used if accounts only need to be added; not deleted or modified.

Adding an account

1. Click Add to add a new account.

   Note: You can add a new account that has similar settings by selecting an existing row and clicking duplicate.

2. For each account fill in the following fields:

   1. Account: Enter the name of the account. The name of the account is limited to 31 characters.

   2. Description: Enter a description for the account. The description of the account is limited to 100 characters.

   3. Type: Select CARRYFORWARD, STANDARD, or STATIC to indicate the type of the account.

      Note: The type for STATIC account types cannot be modified.

   4. Parent: This is a read-only field to indicate if the account is a parent account.

   5. Parent Account: Select or enter the name of the parent to assign the account to.

      Note: The list only contains parents that already exist in the database. You can enter the name for the parent to make an account being added into a parent.

   6. Sort Order: Enter a number to define the order of the account under the parent. Accounts are sorted from low to high.

   7. Weight: Select +, -, or 0 to indicate the weight of the account.

      Note: The weight for STATIC account types cannot be modified.

Accounts are not added to the database until you click Apply.

Deleting an account

Delete an account by selecting the row and clicking delete. The account is not deleted from the database until you click Apply.

Modifying an account

You can change the properties of an existing account:

• Modify the description by editing the value in the Description cell.
• Change the type by selecting a different value.

  Note: The type for STATIC account types cannot be modified.

• Switch the parent of the account by selecting or entering a new parent name.

  Note: The parent specified must either already exist in the database or be a new account that will be added before the account being modified.

• Change the order the account appears under its parent by modifying the sort order value.
• Change the weight of the account by selecting a different value.

  Note: The weight for STATIC account types cannot be modified.

No changes are applied until you click Apply.

Applying changes

To apply changes to the supplemental accounts, click Apply.

For new rows in the table:

• Each new account will be added under the selected parent symbol.

  Note: New rows in the table where the account matches an existing account in the database, will modify the existing account.

For modified accounts:

• Any description changes will be applied.
• Any changes to the ‘Type’ setting will be applied.

  Note: The type for STATIC account types cannot be modified.

• If the parent account is changed, the account will be reassigned to the new parent with the specified sort order.
• Any changes to the sort order (same parent account) will be applied.
• Any changes to the ‘Weight’ setting will be applied.

  Note: The weight for STATIC account types cannot be modified.

For deleted accounts:

• Each deleted account will be confirmed before deleting.
  • If confirmed, the related symbol is deleted.
  • Otherwise, the row is restored to the table.

Results:

• All actions performed are presented at the end of processing with:
  • Each row identified by its row number.
  • The action performed or the reason any error occurred.
• Any valid changes, not cancelled, are applied.

Refreshing the accounts

1. Click Refresh to refresh the list of accounts.
2. Click Selections to change the selected supplemental account and refresh the list of accounts.

In either case, if there are any unapplied changes, you will be prompted to apply or discard any changes that have not yet been applied.

• Choose Apply Changes to apply any changes made, then refresh the list of accounts. If there are any errors the refresh will not be performed.
• Choose Discard Changes to discard any changes made, then refresh the list of accounts.
• Click Cancel to return to the table without refreshing the list of accounts.

Importing into the accounts table

1. Click Import to import from a .csv file into the accounts table.
2. Select the file to import. See .csv file example: for import file format.
3. Select one of the following options to replace existing rows:

   1. Replace Existing Rows: If this option is checked, all rows in the table view will be cleared and replaced with the accounts in the import file.

      Note: This will only clear the accounts from the table view. It will NOT delete any accounts in the database

   2. Do Not Replace Existing Rows: If this option is unchecked, all entries in the import file will be appended to the table view.

      Note: Any accounts that exist multiple times in the same import file will be initially duplicated in the table view. Any accounts that exist in the import file AND already exist in the table prior to import will be initially duplicated in the table view. Once you click Apply, the settings for the last instance of the duplicate account will be used.

4. Click OK. The file will be imported into the table.
5. Click Apply to save the changes.

Exporting from the accounts table

1. Click Export to export from the accounts table to a .csv file.
2. Select the .csv file to export to.

   Note: If the file selected does not currently exist, it will be created during the export process.

3. Click OK. A confirmation dialog will appear.
4. Click View File to view the exported file.

Exporting supplemental accounts

The Export option in the Manage Supplemental Accounts dialog allows you to export supplemental accounts and their related settings from the database to a .csv file.

To export accounts:

1. For Option, select Export.
2. Select the .csv file to export to.

   Note: If the file selected does not currently exist, it will be created during the export process.

3. Select symbols to export.
4. Click OK. A confirmation dialog will appear.
5. Click View File to view the exported file.