Working With Discrete Items In Multi-Regional Provision

You can use the Discrete Items editor to create discrete item accounts and edit default or override properties of existing accounts. These properties control the automation calculation of the discrete items within the Interim ETR calculation.

Discrete item accounts are present in the following individual hierarchies:

• MSP_NatIPT – Total Interim Provision Tax
• MSP_RegIPCurT – Regional Total Interim Provision Tax

Importing discrete items

The import option in the Manage Discrete Items dialog allows you to create and update discrete item 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. To skip confirmation of each new parent assignment, check the ‘Automatically confirm parent assignment’ option.
4. Select the root hierarchy that will be updated. Accounts in an import file must be assigned to a parent within the selected root hierarchy.
5. Click OK.
6. A table will be displayed showing the summary of all actions performed by the import.

Note: If there are any issues with the file, a table will be displayed indicating the issues. No changes will be made to the discrete items’ hierarchy.

.csv file example:

where:

• Name: The name of the discrete item account symbol.

• Description: The description of the trial balance account.

• Parent: The name of a trial balance account 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.

Managing discrete items

The Manage option in the Manage Discrete Items dialog allows you to create, and update accounts from within the Manage Discrete Items table.

To manage accounts:

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

Working with the hierarchy

The selected account and all its descendants are displayed in a hierarchical view. The view is initially expanded two levels below the selected account.

To change the level of expansion:

1. Click a collapsed hierarchy icon to expand the hierarchy one level below the selected symbol.
2. Click an expanded hierarchy icon to collapse the hierarchy to the selected symbol.
3. Right-click on the top row and select one of these options:
   • Expand All for Selected Row: to expand the entire hierarchy below the selected symbol.
   • Collapse All: to collapse the entire hierarchy.
4. Right-click on a parent row and select one of these options:
   • Expand All for Selected Row: to expand the entire hierarchy below the selected symbol.
   • Collapse All: to collapse the entire hierarchy.
   • Collapse Parent: to collapse the hierarchy to the parent of the selected symbol.
5. Right-click on a leaf row and select one of these options:
   • Collapse All: to collapse the entire hierarchy.
   • Collapse Parent: to collapse the hierarchy to the parent of the selected symbol.

Adding a discrete item account

You can add additional accounts to capture discrete items for interim periods. When adding new accounts be careful not to change any existing leaf accounts that are automated or contain manual data into parents as any data associated with those accounts will be lost.

To add a new account:

1. Select a row in the table. The new account will be assigned as a child of the selected account.

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

2. Click Add. The Add dialog appears.
3. Fill in the following fields:

   1. Name: 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. Parent: Select or enter the name of the parent to assign the account to.

      Note: You can also click the search button to open the symbol selector dialog to access advanced search options.

   4. Sort Order: Enter a number to define the order of the account under the parent. Accounts are sorted from low to high.Accounts added with a sort order of 0 will appear last, in the order the account was created.

4. Click OK to add the new symbol to the table.

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

Modifying an account

You can change the properties of an existing account:

1. Modify the description by editing the value in the ‘Description’ cell.
2. Change the order the account appears under its parent by modifying the sort order value.
3. To change the parent of an account:
   1. Select the row in the table
   2. Click Edit. The Edit dialog appears.
   3. Enter or select a new parent.
   4. Click OK.

No changes are made to the database until you click Apply.

Applying changes

To apply changes to the trial balance, click Apply.

For new rows in the table:

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

For modified accounts:

1. Any description changes will be applied.
2. Any changes to the ‘weight’ setting will be applied.
3. If the parent account is changed, the account will be reassigned to the new parent with the specified sort order.

   Note: If an existing symbol becomes a parent, virtual status will be set to ON.

4. Any changes to the sort order (same parent account) will be applied.

Results:

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

Refreshing the accounts

Click Refresh to refresh the list of accounts.

Click Symbols to change the selected discrete item 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.

Exporting from the accounts table

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

1. Select the .csv file to export to.

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

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

Exporting discrete item

The Export option in the Manage Discrete Items dialog allows you to export discrete item 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.

Importing discrete item automations

The Import Discrete Item Automations app allows you to import discrete item automation settings from a .csv file to the database

To import automations:

1. Open the app from Tax Provision > Administration > Import and Export > Import Discrete Item Automations.
2. Select the discrete items hierarchy.
3. Select the file to import.
4. Click OK.
5. If there are no errors in the source file:
   1. a confirmation dialog appears.
6. If there are errors in the source file
   1. A table displaying all the errors detected is displayed. No changes are made to the database.

Managing discrete item automations

The Manage Discrete Item Automations dialog allows you to select a discrete item account hierarchy for which you would like to set automation settings.

Discrete item accounts are present in the following individual hierarchies:

• MSP_NatIPT – Total Interim Provision Tax
• MSP_RegIPCurT – Regional Total Interim Provision Tax

To manage discrete item automations:

1. For Accounts, select a symbol or hierarchy structure to manage from within the discrete items account hierarchies.

   Note: The Manage Discrete Items app can be used to manage the account symbols within the discrete item account hierarchies. For more information on creating discrete item accounts, see Managing discrete items.

Understanding Details setting

The details setting is a cope limiter, in that if symbols are specified the in details field, the calculation is only applied to the selected details.

In the case of an override the details scope is replaced by the override.

For example, if a default setting has Details set to MSP_REGIONS, and an override specified the details ad MSP_NY, the calculation for the automation group or entity is only performed for MSP_NY.

Managing default settings

From the Default Settings tab, click Add to add automation default settings on a discrete item account. Automation settings are not added to the database until you click Apply.

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

For each account fill in the following fields:

• Account: Select the discrete item account for which you would like to set default automation settings.

• Automate: Check this option if this account will be automated. For the default settings, the automation check box is selected by default. Automated accounts will have data automatically transferred from the source accounts to the discrete item hierarchies

• Automation Method: Select the Automation Method to define how an automated account will be calculated. This is not required to be specified for parent and non-automated accounts. Valid options are:

  • Year-To-Date Balance (uses the balance in GrsCY)

  • Full Year Forecast (uses the forecast balance GrsCY + GrsCYIP)

  • Prorate (Prorates the full year forecast based on the current period i.e., multiplies by 3 / 12 if the current period is 3)

• %: Specify the percentage of the amount to transfer. The amount transferred is the percentage specified multiplied by the source amount. The percentage must be a number from -100 through 100.

• Source Accounts: Specify the source accounts for the Discrete Item account. You can select one or more parent or leaf symbols. This is not required to be specified for parent and non-automated accounts.

• Details: Optionally, specify the details symbol(s) to restrict the discrete item automation to. If no symbols are specified, the automation calculation applies to all symbols in the details dimension.

Managing override settings

From either the Group Override or Entity Override tab, click Add to add new override settings. Override settings are not added to the database until you click Apply.

Note:

• The Group Override tab is used to override discrete item account settings at an automation group level. This tab will only appear if you have automation groups set up in your system.

• The Entities Override tab is used to override discrete item account settings at an entity level.

For each account fill in the following fields:

• Account: Select the discrete item account for which you would like to set override automation settings.

• Automation Group/Entity: If on the Group Override tab, select the automation group you would like to set override settings for. If on the Entity Override tab, select the entity you would like to set override settings for.

  Note:

  • In Group Override:Once you select an account automation group, any settings for the selected account will be copied from the Default settings.
  • In Entity Override: Once you select an account and entity, any settings for the selected account will be copied from either the Group Override or Default settings, depending on whether there is a group override for the entity’s automation group or not

• Automation Method: Select the Automation Method to define how an automated account will be calculated. This is not required to be specified for parent and non-automated accounts. Valid options are:

  • Year-To-Date Balance (uses the balance in GrsCY)

  • Full Year Forecast (uses the forecast balance GrsCY + GrsCYIP)

  • Prorate (Prorates the full year forecast based on the current period i.e., multiplies by 3 / 12 if the current period is 3)

• %: Specify the percentage of the amount to transfer. The amount transferred is the percentage specified multiplied by the source amount. The percentage must be a number from -100 through 100.

• Source Accounts: Specify the source accounts for the Discrete Item account. You can select one or more parent or leaf symbols. This is not required to be specified for parent and non-automated accounts.

• Details: Optionally, specify the details symbol(s) to restrict the discrete item automation to. If no symbols are specified, the automation calculation applies to all symbols in the details dimension.

  Note: An override replaces the details scope for the default override settings, or in the case of an entity override the detail scope for the default settings or the automation group override.

Modifying an account

You can change the properties of an existing account:

1. Change the automation setting on the account by checking or un-checking the automate option.
2. Chane the automation method by selection a different method.
3. Change the % to be used in the automation calculation by modifying the % value.
4. Change the source account(s) by selecting different source account symbols.
5. Update the details dimension in one of the following ways:
   • remove all restrictions on the details dimension symbols calculated
   • set or modify the symbol restrictions for the details dimension

No changes are applied until you click Apply.

Applying changes

To apply changes to the discrete item accounts, click Apply.

1. Any changes to the ‘Automate’ setting will be applied.
2. Any changes to the ‘%’ setting will be applied.
3. Any changes to the ‘Automation Method’ will be applied.
4. Any changes to the ‘Source Accounts’ setting will be applied.
5. Any changes to the details dimension settings will be applied.

Refreshing the accounts

Click Refresh to refresh the list of accounts.

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.

Deleting automation settings

You can change or delete an automation setting at the default automation group override or entity override level:

1. Highlight the row you want to delete
2. Click the delete button
3. Automation settings are not deleted until you click Apply.

Exporting discrete item automations

The Export Discrete Item Automations app allows you to export discrete item automation settings from the database to a .csv file.

To export automations:

1. Open the app from Tax Provision > Administration > Import and Export > Export Discrete Item Automations.
2. Select the discrete items hierarchy.
3. Click OK. A confirmation dialog appears.

   Note: The file is exported to Documents\Longview\<Longview Identifier>\Data\Discrete Item Automations\Discrete Item Automations<date>_<time>.csv

4. Click View File to view the exported file.