Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Working with net income before tax accounts

You can use the Net Income Before Tax editor to manage your net income before tax (NIBT) accounts. For information on configuring the system settings for NIBT accounts, see “Configuring Net Income Before Tax automation settings”.

NIBT calculation settings

Field

Notes

Automate NIBT Amounts

Select this option to automatically transfer data to the current provision (current tax charge) for the NIBT account. The amounts may be transferred to the current year, equity, and OCI columns, depending on whether Use Income/ Equity/OCI Setting is selected or cleared in the System Settings editor and the Target Elements setting for the NIBT account. Amounts automatically transferred into the current year column are also reported in the Effective Tax Rate reports. This automation can be performed for functional currency or functional and reporting currency net income before tax values included in the general ledger.

If you select Automate NIBT Amounts for the default settings or any other entity, the NIBT account is set to read-only for all entities.

Note: Automate NIBT Amounts must be selected to modify the following fields.

Actuals Calculation Method

Specify the calculation method to use for actuals, using one of the following values:

  • No Calculation—No actuals calculation method is set for the NIBT account. No data is transferred for actuals.

  • Year-To-Date Balance—Multiplies the sum of the source by the specified percentage to calculate the values for the current year column of the current provision (current tax charge). For example, you can set up NIBT to be equal to the pre-tax income. This type of method is used when the source accounts are income statement accounts.

  • Change In Balance—Uses the difference between the current year-to-date amount and the prior year ending balance of a single or multiple accounts multiplied by the specified percentage to calculate the current year column of the current provision (current tax charge). This type of method is used when the source accounts are balance sheet accounts.

  • Custom—If your company has set up any custom calculation methods, they appear in this list. For information on creating a custom calculation method, see the Tax Provision Implementer’s Guide.

%

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 and can have a maximum of two decimal places.

Source Accounts

Specify the source accounts for the NIBT account. You can specify one or more parent or leaf symbols.

Valid source accounts are those set for NIBT Automation — Valid Source Accounts in the System Settings editor.

Source Reporting Methods

Specify the source reporting method for the NIBT account. You can specify one or more parent or leaf symbols.

Valid source reporting methods are those set for NIBT Automation — Valid Source Reporting Methods in the System Settings editor.

Source Currencies

Specify the source currencies for the NIBT account using one of the following values:

  • Functional—Transfers functional (native) currencies from the chart of accounts to the current provision (current tax charge) and translates the NIBT account. If the NIBT account is not automated or if you do not specify a source currencies value, the account is treated as if Functional was specified.

  • All—Transfers functional and reporting currencies from the chart of accounts to the current provision (current tax charge) and does not translate the NIBT account. You can specify All only if Automate NIBT Amounts is selected for the default settings of the NIBT account.

Note

Source currencies can be specified for the default settings only. The source currencies setting cannot be overridden for a specific entity.

 

Source Details

This field displays only if a value is set for Current Tax Automation — Target Detail Symbol in the System Settings editor. If Current Tax Automation — Target Detail Symbol is cleared, all details are transferred from and to the same symbols.

Specify the source details for the NIBT account. You can specify one or more parent or leaf symbols.

Valid source details are those set for NIBT Automation — Valid Source Details Symbols in the System Settings editor.

Source Segments

This field displays only if a value is set for Current Tax Automation — Target Segment Symbol in the System Settings editor. If Current Tax Automation — Target Segment Symbol is cleared, all segments are transferred from and to the same symbols.

Specify the source segments for the NIBT account. You can specify one or more parent or leaf symbols.

Valid source segments are those set for NIBT Automation

- Valid Source Segments Symbols in the System Settings editor.

Target Elements

This field displays only if Use Income/Equity/OCI

Setting is selected in the System Settings editor. If Use Income/Equity/OCI Setting is cleared, all added accounts are classified as Income accounts.

Specify the target elements for the NIBT account. The valid target elements values are dependent on the setting for Income/Equity/OCI.

  • If Income/Equity/OCI is set to Income, the valid value is Income.

  • If Income/Equity/OCI is set to Equity, the valid values are Equity or Equity and Income.

  • If Income/Equity/OCI is set to OCI, the valid values are OCI or OCI and Income.

Interim Calculation Method

Specify the calculation method for interim using one of the following values:

  • No Calculation—No interim calculation method is set for the NIBT account. No data is transferred for interim.

  • Annualize—Calculates the forecast current year column value by annualizing the current year-to-date balance. The interim current year column is equal to the current year-to-date amount divided by the current period multiplied by the number of remaining periods in the year. The forecast current year column is the sum of the current year-to-date column and the interim current year column. For example, assuming the value of an account at the end of the first quarter is 3000, the interim current year column is calculated as (3000/3) * (12-3). The annualized value in the forecast current year column is 3000 + 9000.

  • Prior Year—Calculates the forecast current year column value by using the year-to-date balance of the prior yearend current provision. The value in the interim current year column equals the prior year ending balance less the current year-to-date amount. For example, assuming the value of an account at the end of the first quarter is 3000, and the prior year ending balance was 24000, the interim current year column is calculated as 24000 — 3000. The prior year value in the forecast current year column is 3000 + 21000.

  • Forecast—Calculates the forecast current year column value by using the balance of the forecast current year input. The value in the interim current year column equals the forecast current year input balance less the current year-to-date amount. For example, assuming the value of an account at the end of the first quarter is 5000, and the forecast current year input balance is 20000, the interim current year column is calculated as 20000 — 5000. The forecast value in the forecast current year column is 5000 + 15000.

  • Custom—If your company has set up any custom interim calculation methods, they appear in this list. For information on creating a custom interim calculation method, see the Tax Provision Implementer’s Guide.

 

Adding NIBT accounts

You can add and configure NIBT accounts that are specific to your company using the Net Income Before Tax editor.

To add a NIBT account:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.

    Note: You can add NIBT accounts only with Default Settings (the DIM2SET— Entities Default symbol) selected for Entity on the editor toolbar. After you add an NIBT account, you can configure it for a specific entity or automation group, using an override. For more information, see “Overriding NIBT account default settings for an entity or automation group”.

  4. Select the appropriate parent for the NIBT account and click NIBT Account. A new row appears.

    Note: If you want to select a leaf symbol as the parent for the NIBT account, you must select the parent symbol manually in step 6. Otherwise, the parent of your selected leaf symbol is automatically set as the parent for the NIBT account.

  5. Complete the following fields:
    FieldNotes

    Account

    Type a name for the account. The account name can have a maximum of 31 characters.

    Description

    Type a description for the account. The description can have a maximum of 100 characters.

    Sort order

    Specify a numeric value from 1 and up representing the order of the symbol with respect to its parent. By default, the sort order for added symbols is 10 higher than the last child of the same parent symbol.

    If you specify a value of 0, the symbol appears at the bottom of the list.

    Income/Equity/ OCI

    This field displays only if Use Income/Equity/OCI Setting is selected in the System Settings editor. If Use Income/Equity/OCI Setting is cleared, all added accounts are classified as Income accounts.

    Specify the Income/Equity/OCI classification for the account using one of the following values:

    • Income—Classifies the account as an Income account.
    • Equity—Classifies the account as an Equity account.
    • OCI—Classifies the account as an Other Comprehensive Income account.

    The default for this setting is based on the value set for Account Default Setting for Deferred Tax Income/ Equity/OCI in the System Settings editor.

  6. For Parent, type the name of the parent symbol for the NIBT account, or select a parent in the drop-down list. Alternatively, you can use the symbol selector.

    Caution: If you select a leaf symbol as the parent for the account, settings and data are lost for the leaf symbol when it is changed to a parent symbol. The NIBT—GAAP Net Income/(Loss) Before Tax symbol cannot be selected as a parent symbol.

  7. If you want to automatically transfer data to the current provision (current tax charge) for this NIBT account, select Automate NIBT Amounts. The remaining fields become available.

    Caution: If you select a leaf symbol as the parent for the account, settings and data are lost for the leaf symbol when it is changed to a parent symbol. The NIBT—GAAP Net Income/(Loss) Before Tax symbol cannot be selected as a parent symbol. Use this automation to calculate values in the current provision (current tax charge) for NIBT accounts. The amounts may be calculated to the current year, equity, and OCI columns, depending on whether Use Income/Equity/OCI Setting is selected or cleared in the System Settings editor and the Target Elements setting for the NIBT account.

    Amounts automatically transferred into the current year column are also reported in the Effective Tax Rate reports. This automation can be performed for functional currency or functional and reporting currency net income before tax values included in the general ledger.

    If you select Automate NIBT Amounts for the default settings or any other entity, the NIBT account is set to read-only for all entities.

  8. Select the calculation options. See NIBT Calculation Settings.
  9. Click OK. The NIBT account appears in the hierarchy.
  10. When you are finished, click Save.
  11. If you want to run calculations based on the changes you have made, click Run Calculations.

Modifying NIBT account default settings

You can modify the default settings (settings for the DIM2SET—Entities Default symbol) for existing NIBT accounts. These default settings are applied to all entities unless the entity uses an override for that account.

Note: Default settings can be modified for leaf accounts only.

To view and print the current configuration settings for NIBT accounts, use the XCCC300 — NIBT Setup and Mapping.rtp report.

To modify NIBT account default settings:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. Do one of the following:
    • To edit the account name, description, sort order, Income/Equity/OCI classification, or parent, select the NIBT account, and click Properties. The fields become available. Continue to the next step.
    • To edit other settings, continue to step 7.
  5. Edit the following fields as necessary:
    FieldNotes

    Account

    Type a name for the account. The account name can have a maximum of 31 characters.

    Note: The NIBT—GAAP Net Income/(Loss) Before Tax symbol name cannot be modified.

    Description

    Type a new description for the account. The description can have a maximum of 100 characters.

    Sort order

    Specify a numeric value from 1 and up representing the order of the symbol with respect to its parent. By default, the sort order for added symbols is 10 higher than the last child of the same parent symbol.

    If you specify a value of 0, the symbol appears at the bottom of the list.

    Income/Equity/ OCI

    This field displays only if Use Income/Equity/OCI Setting is selected in the System Settings editor. If Use Income/Equity/OCI Setting is cleared, all added accounts are classified as Income accounts.

    Specify the Income/Equity/OCI classification for the account using one of the following values:

    • Income—Classifies the account as an Income account.
    • Equity—Classifies the account as an Equity account.
    • OCI—Classifies the account as an Other Comprehensive Income account.

    If you modify Income/Equity/OCI for a NIBT account that has a calculation method set for Actuals Calculation Method, you must also update the Target Elements setting (for both default settings and any entity override settings) to a valid value for the new Income/Equity/OCI classification.

    The default for this setting is based on the value set for Account Default Setting for Deferred Tax Income/ Equity/OCI in the System Settings editor.

  6. For Parent, type the name of the new parent symbol for the NIBT account, or select a parent in the drop-down list. Alternatively, you can use the symbol selector.

    Caution: If you select a leaf symbol as the parent for the account, settings and data are lost for the leaf symbol when it is changed to a parent symbol. The NIBT—GAAP Net Income/(Loss) Before Tax symbol cannot be selected as a parent symbol.

  1. Edit the calculation settings. See NIBT Calculation Settings.
  2. Click OK. A message opens indicating that the NIBT account has been modified successfully.
  3. When you are finished, click Save.
  4. If you want to run calculations based on the changes you have made, click Run Calculations.

Overriding NIBT account default settings for an entity or automation group

If you have NIBT accounts that should use different settings than the defaults, you can override the settings for a specific entity or for an automation group. These settings override the account settings specified for the DIM2SET—Entities Default symbol. Entity-specific overrides take priority over automation group overrides.

Note: You can override default settings for leaf accounts and automation groups only. Longview recommends that you use automation group overrides, when possible, to simplify maintenance. For information on creating automation groups, see “Adding automation groups”.

To view the current configuration settings for NIBT account overrides, use the XCCC301 — NIBT Setup and Mapping — Entity Specific Settings.rtp report.

To override NIBT account settings for an entity or automation group:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. On the editor toolbar, click Entity.
  5. In the Entity box, type the name of the entity or automation group for which to override the NIBT account settings, or select the entity or automation group in the drop-down list. Alternatively, you can use the symbol selector.

    Note: You can override default settings for leaf entities and automation groups only. If you have already configured NIBT account settings for an entity or automation group, and the new entity or automation group should use similar settings, you can copy settings from one entity or automation group to another. For more information, see “Copying entity settings for NIBT accounts”.

  6. Click Update. The account settings update to reflect the selected entity or automation group.
  7. Select Override Current Settings for the NIBT account that you want to specify override settings for. The Automate NIBT Amounts column becomes available.

    Note: You can use the Current Override column to determine whether an account already has an override for the selected entity. Overrides can be an automation group or the selected entity.

  8. Edit the calculation settings. See NIBT Calculation Settings.
  9. When you are finished, click Save.
  10. If you want to run calculations based on the changes you have made, click Run Calculations.

Copying account settings for NIBT accounts

If a NIBT account should have similar settings as an existing account, you can copy settings to the NIBT account.

To copy NIBT account settings:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. In the Entity box, type the name of the entity that contains the NIBT account that you want to copy settings to, or select the entity in the drop-down list. Alternatively, you can use the symbol selector.

    Note: If you want to copy account default settings, select DIM2SET as the entity.

  5. Select the account to copy settings to and click Copy Account Settings. The Copy Account Settings dialog opens.

    Note: You must select a leaf account.

  6. Type the name of the account to copy settings from or select the account in the drop-down list. Alternatively, you can use the symbol selector.

    Note: You must select a leaf account.

  1. Click Copy. The settings are copied to the specified account.
  2. When you are finished, click Save.
  3. If you want to run calculations based on the changes you have made, click Run Calculations.

Copying entity settings for NIBT accounts

If you have previously configured the override settings for a specific entity or automation group and you have another entity or automation group that should use similar settings, you can copy the override settings from the previously configured entity or automation group.

When you copy override settings from one entity or automation group to another, the settings are copied for all NIBT accounts.

To copy override settings from one entity or automation group to another:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. On the editor toolbar, click Entity.
  5. In the Entity box, type the name of the entity to copy settings to, or select the entity in the drop-down list. Alternatively, you can use the symbol selector.

    Note: You must select a leaf entity or an automation group.

  6. Click Update. The account settings update to reflect the selected entity or automation group.
  7. Click Copy Entity Settings. The Copy Entity Settings dialog opens.
  8. Type the name of the entity to copy settings from or select the entity in the drop-down list. Alternatively, you can use the symbol selector.

    Note: You must select a leaf entity or an automation group.

  9. Click Copy. The settings for all accounts are copied to the specified entity or automation group.
  10. When you are finished, click Save.
  11. If you want to run calculations based on the changes you have made, click Run Calculations.

Exporting NIBT accounts to Microsoft Excel

You can use the Net Income Before Tax editor to export information from all accounts in the editor to Microsoft Excel, including global and entity override settings.

To export NIBT accounts to Microsoft Excel:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. Click Export to Excel. The Export to Excel dialog opens.
  5. Complete the following:
    FieldNotes

    Layout

    Select one of the following:
    • Expanded view—To export all account symbols fully expanded.
    • Current view—To export only the account symbols visible in the current hierarchy expansion state. For more information on expanding and collapsing the symbol hierarchy, see “Using context menus”.

    Description

    Select one of the following:
    • Global settings, group overrides, and entity overrides—To export global settings for all accounts, and accounts with entity or automation group override settings applied.
    • Group and entity overrides—To export only accounts with entity or automation group override settings applied.

      Note: For accounts with entity or automation group override settings applied, separate rows appear in the Microsoft Excel worksheet for each entity or automation group that the account settings are overridden for, and for parents of the exported accounts.

    • Global settings—To export global settings for all accounts.
  6. Click Export. The Save As dialog opens.
  7. Navigate to the location where you want the file to be saved.
  8. Type the name of the file you want the account information to be exported to.
  9. Click Save. The file opens in Microsoft Excel.

    Note: The Global/Entity column in the Microsoft Excel worksheet specifies “Global” if the account settings are global or specifies an entity or automation group symbol name if the account settings are an entity or automation group override.

Published:

Working with net income before tax accounts

You can use the Net Income Before Tax editor to manage your net income before tax (NIBT) accounts. For information on configuring the system settings for NIBT accounts, see “Configuring Net Income Before Tax automation settings”.

NIBT calculation settings

Field

Notes

Automate NIBT Amounts

Select this option to automatically transfer data to the current provision (current tax charge) for the NIBT account. The amounts may be transferred to the current year, equity, and OCI columns, depending on whether Use Income/ Equity/OCI Setting is selected or cleared in the System Settings editor and the Target Elements setting for the NIBT account. Amounts automatically transferred into the current year column are also reported in the Effective Tax Rate reports. This automation can be performed for functional currency or functional and reporting currency net income before tax values included in the general ledger.

If you select Automate NIBT Amounts for the default settings or any other entity, the NIBT account is set to read-only for all entities.

Note: Automate NIBT Amounts must be selected to modify the following fields.

Actuals Calculation Method

Specify the calculation method to use for actuals, using one of the following values:

  • No Calculation—No actuals calculation method is set for the NIBT account. No data is transferred for actuals.

  • Year-To-Date Balance—Multiplies the sum of the source by the specified percentage to calculate the values for the current year column of the current provision (current tax charge). For example, you can set up NIBT to be equal to the pre-tax income. This type of method is used when the source accounts are income statement accounts.

  • Change In Balance—Uses the difference between the current year-to-date amount and the prior year ending balance of a single or multiple accounts multiplied by the specified percentage to calculate the current year column of the current provision (current tax charge). This type of method is used when the source accounts are balance sheet accounts.

  • Custom—If your company has set up any custom calculation methods, they appear in this list. For information on creating a custom calculation method, see the Tax Provision Implementer’s Guide.

%

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 and can have a maximum of two decimal places.

Source Accounts

Specify the source accounts for the NIBT account. You can specify one or more parent or leaf symbols.

Valid source accounts are those set for NIBT Automation — Valid Source Accounts in the System Settings editor.

Source Reporting Methods

Specify the source reporting method for the NIBT account. You can specify one or more parent or leaf symbols.

Valid source reporting methods are those set for NIBT Automation — Valid Source Reporting Methods in the System Settings editor.

Source Currencies

Specify the source currencies for the NIBT account using one of the following values:

  • Functional—Transfers functional (native) currencies from the chart of accounts to the current provision (current tax charge) and translates the NIBT account. If the NIBT account is not automated or if you do not specify a source currencies value, the account is treated as if Functional was specified.

  • All—Transfers functional and reporting currencies from the chart of accounts to the current provision (current tax charge) and does not translate the NIBT account. You can specify All only if Automate NIBT Amounts is selected for the default settings of the NIBT account.

Note

Source currencies can be specified for the default settings only. The source currencies setting cannot be overridden for a specific entity.

 

Source Details

This field displays only if a value is set for Current Tax Automation — Target Detail Symbol in the System Settings editor. If Current Tax Automation — Target Detail Symbol is cleared, all details are transferred from and to the same symbols.

Specify the source details for the NIBT account. You can specify one or more parent or leaf symbols.

Valid source details are those set for NIBT Automation — Valid Source Details Symbols in the System Settings editor.

Source Segments

This field displays only if a value is set for Current Tax Automation — Target Segment Symbol in the System Settings editor. If Current Tax Automation — Target Segment Symbol is cleared, all segments are transferred from and to the same symbols.

Specify the source segments for the NIBT account. You can specify one or more parent or leaf symbols.

Valid source segments are those set for NIBT Automation

- Valid Source Segments Symbols in the System Settings editor.

Target Elements

This field displays only if Use Income/Equity/OCI

Setting is selected in the System Settings editor. If Use Income/Equity/OCI Setting is cleared, all added accounts are classified as Income accounts.

Specify the target elements for the NIBT account. The valid target elements values are dependent on the setting for Income/Equity/OCI.

  • If Income/Equity/OCI is set to Income, the valid value is Income.

  • If Income/Equity/OCI is set to Equity, the valid values are Equity or Equity and Income.

  • If Income/Equity/OCI is set to OCI, the valid values are OCI or OCI and Income.

Interim Calculation Method

Specify the calculation method for interim using one of the following values:

  • No Calculation—No interim calculation method is set for the NIBT account. No data is transferred for interim.

  • Annualize—Calculates the forecast current year column value by annualizing the current year-to-date balance. The interim current year column is equal to the current year-to-date amount divided by the current period multiplied by the number of remaining periods in the year. The forecast current year column is the sum of the current year-to-date column and the interim current year column. For example, assuming the value of an account at the end of the first quarter is 3000, the interim current year column is calculated as (3000/3) * (12-3). The annualized value in the forecast current year column is 3000 + 9000.

  • Prior Year—Calculates the forecast current year column value by using the year-to-date balance of the prior yearend current provision. The value in the interim current year column equals the prior year ending balance less the current year-to-date amount. For example, assuming the value of an account at the end of the first quarter is 3000, and the prior year ending balance was 24000, the interim current year column is calculated as 24000 — 3000. The prior year value in the forecast current year column is 3000 + 21000.

  • Forecast—Calculates the forecast current year column value by using the balance of the forecast current year input. The value in the interim current year column equals the forecast current year input balance less the current year-to-date amount. For example, assuming the value of an account at the end of the first quarter is 5000, and the forecast current year input balance is 20000, the interim current year column is calculated as 20000 — 5000. The forecast value in the forecast current year column is 5000 + 15000.

  • Custom—If your company has set up any custom interim calculation methods, they appear in this list. For information on creating a custom interim calculation method, see the Tax Provision Implementer’s Guide.

 

Adding NIBT accounts

You can add and configure NIBT accounts that are specific to your company using the Net Income Before Tax editor.

To add a NIBT account:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.

    Note: You can add NIBT accounts only with Default Settings (the DIM2SET— Entities Default symbol) selected for Entity on the editor toolbar. After you add an NIBT account, you can configure it for a specific entity or automation group, using an override. For more information, see “Overriding NIBT account default settings for an entity or automation group”.

  4. Select the appropriate parent for the NIBT account and click NIBT Account. A new row appears.

    Note: If you want to select a leaf symbol as the parent for the NIBT account, you must select the parent symbol manually in step 6. Otherwise, the parent of your selected leaf symbol is automatically set as the parent for the NIBT account.

  5. Complete the following fields:
    FieldNotes

    Account

    Type a name for the account. The account name can have a maximum of 31 characters.

    Description

    Type a description for the account. The description can have a maximum of 100 characters.

    Sort order

    Specify a numeric value from 1 and up representing the order of the symbol with respect to its parent. By default, the sort order for added symbols is 10 higher than the last child of the same parent symbol.

    If you specify a value of 0, the symbol appears at the bottom of the list.

    Income/Equity/ OCI

    This field displays only if Use Income/Equity/OCI Setting is selected in the System Settings editor. If Use Income/Equity/OCI Setting is cleared, all added accounts are classified as Income accounts.

    Specify the Income/Equity/OCI classification for the account using one of the following values:

    • Income—Classifies the account as an Income account.
    • Equity—Classifies the account as an Equity account.
    • OCI—Classifies the account as an Other Comprehensive Income account.

    The default for this setting is based on the value set for Account Default Setting for Deferred Tax Income/ Equity/OCI in the System Settings editor.

  6. For Parent, type the name of the parent symbol for the NIBT account, or select a parent in the drop-down list. Alternatively, you can use the symbol selector.

    Caution: If you select a leaf symbol as the parent for the account, settings and data are lost for the leaf symbol when it is changed to a parent symbol. The NIBT—GAAP Net Income/(Loss) Before Tax symbol cannot be selected as a parent symbol.

  7. If you want to automatically transfer data to the current provision (current tax charge) for this NIBT account, select Automate NIBT Amounts. The remaining fields become available.

    Caution: If you select a leaf symbol as the parent for the account, settings and data are lost for the leaf symbol when it is changed to a parent symbol. The NIBT—GAAP Net Income/(Loss) Before Tax symbol cannot be selected as a parent symbol. Use this automation to calculate values in the current provision (current tax charge) for NIBT accounts. The amounts may be calculated to the current year, equity, and OCI columns, depending on whether Use Income/Equity/OCI Setting is selected or cleared in the System Settings editor and the Target Elements setting for the NIBT account.

    Amounts automatically transferred into the current year column are also reported in the Effective Tax Rate reports. This automation can be performed for functional currency or functional and reporting currency net income before tax values included in the general ledger.

    If you select Automate NIBT Amounts for the default settings or any other entity, the NIBT account is set to read-only for all entities.

  8. Select the calculation options. See NIBT Calculation Settings.
  9. Click OK. The NIBT account appears in the hierarchy.
  10. When you are finished, click Save.
  11. If you want to run calculations based on the changes you have made, click Run Calculations.

Modifying NIBT account default settings

You can modify the default settings (settings for the DIM2SET—Entities Default symbol) for existing NIBT accounts. These default settings are applied to all entities unless the entity uses an override for that account.

Note: Default settings can be modified for leaf accounts only.

To view and print the current configuration settings for NIBT accounts, use the XCCC300 — NIBT Setup and Mapping.rtp report.

To modify NIBT account default settings:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. Do one of the following:
    • To edit the account name, description, sort order, Income/Equity/OCI classification, or parent, select the NIBT account, and click Properties. The fields become available. Continue to the next step.
    • To edit other settings, continue to step 7.
  5. Edit the following fields as necessary:
    FieldNotes

    Account

    Type a name for the account. The account name can have a maximum of 31 characters.

    Note: The NIBT—GAAP Net Income/(Loss) Before Tax symbol name cannot be modified.

    Description

    Type a new description for the account. The description can have a maximum of 100 characters.

    Sort order

    Specify a numeric value from 1 and up representing the order of the symbol with respect to its parent. By default, the sort order for added symbols is 10 higher than the last child of the same parent symbol.

    If you specify a value of 0, the symbol appears at the bottom of the list.

    Income/Equity/ OCI

    This field displays only if Use Income/Equity/OCI Setting is selected in the System Settings editor. If Use Income/Equity/OCI Setting is cleared, all added accounts are classified as Income accounts.

    Specify the Income/Equity/OCI classification for the account using one of the following values:

    • Income—Classifies the account as an Income account.
    • Equity—Classifies the account as an Equity account.
    • OCI—Classifies the account as an Other Comprehensive Income account.

    If you modify Income/Equity/OCI for a NIBT account that has a calculation method set for Actuals Calculation Method, you must also update the Target Elements setting (for both default settings and any entity override settings) to a valid value for the new Income/Equity/OCI classification.

    The default for this setting is based on the value set for Account Default Setting for Deferred Tax Income/ Equity/OCI in the System Settings editor.

  6. For Parent, type the name of the new parent symbol for the NIBT account, or select a parent in the drop-down list. Alternatively, you can use the symbol selector.

    Caution: If you select a leaf symbol as the parent for the account, settings and data are lost for the leaf symbol when it is changed to a parent symbol. The NIBT—GAAP Net Income/(Loss) Before Tax symbol cannot be selected as a parent symbol.

  1. Edit the calculation settings. See NIBT Calculation Settings.
  2. Click OK. A message opens indicating that the NIBT account has been modified successfully.
  3. When you are finished, click Save.
  4. If you want to run calculations based on the changes you have made, click Run Calculations.

Overriding NIBT account default settings for an entity or automation group

If you have NIBT accounts that should use different settings than the defaults, you can override the settings for a specific entity or for an automation group. These settings override the account settings specified for the DIM2SET—Entities Default symbol. Entity-specific overrides take priority over automation group overrides.

Note: You can override default settings for leaf accounts and automation groups only. Longview recommends that you use automation group overrides, when possible, to simplify maintenance. For information on creating automation groups, see “Adding automation groups”.

To view the current configuration settings for NIBT account overrides, use the XCCC301 — NIBT Setup and Mapping — Entity Specific Settings.rtp report.

To override NIBT account settings for an entity or automation group:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. On the editor toolbar, click Entity.
  5. In the Entity box, type the name of the entity or automation group for which to override the NIBT account settings, or select the entity or automation group in the drop-down list. Alternatively, you can use the symbol selector.

    Note: You can override default settings for leaf entities and automation groups only. If you have already configured NIBT account settings for an entity or automation group, and the new entity or automation group should use similar settings, you can copy settings from one entity or automation group to another. For more information, see “Copying entity settings for NIBT accounts”.

  6. Click Update. The account settings update to reflect the selected entity or automation group.
  7. Select Override Current Settings for the NIBT account that you want to specify override settings for. The Automate NIBT Amounts column becomes available.

    Note: You can use the Current Override column to determine whether an account already has an override for the selected entity. Overrides can be an automation group or the selected entity.

  8. Edit the calculation settings. See NIBT Calculation Settings.
  9. When you are finished, click Save.
  10. If you want to run calculations based on the changes you have made, click Run Calculations.

Copying account settings for NIBT accounts

If a NIBT account should have similar settings as an existing account, you can copy settings to the NIBT account.

To copy NIBT account settings:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. In the Entity box, type the name of the entity that contains the NIBT account that you want to copy settings to, or select the entity in the drop-down list. Alternatively, you can use the symbol selector.

    Note: If you want to copy account default settings, select DIM2SET as the entity.

  5. Select the account to copy settings to and click Copy Account Settings. The Copy Account Settings dialog opens.

    Note: You must select a leaf account.

  6. Type the name of the account to copy settings from or select the account in the drop-down list. Alternatively, you can use the symbol selector.

    Note: You must select a leaf account.

  1. Click Copy. The settings are copied to the specified account.
  2. When you are finished, click Save.
  3. If you want to run calculations based on the changes you have made, click Run Calculations.

Copying entity settings for NIBT accounts

If you have previously configured the override settings for a specific entity or automation group and you have another entity or automation group that should use similar settings, you can copy the override settings from the previously configured entity or automation group.

When you copy override settings from one entity or automation group to another, the settings are copied for all NIBT accounts.

To copy override settings from one entity or automation group to another:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. On the editor toolbar, click Entity.
  5. In the Entity box, type the name of the entity to copy settings to, or select the entity in the drop-down list. Alternatively, you can use the symbol selector.

    Note: You must select a leaf entity or an automation group.

  6. Click Update. The account settings update to reflect the selected entity or automation group.
  7. Click Copy Entity Settings. The Copy Entity Settings dialog opens.
  8. Type the name of the entity to copy settings from or select the entity in the drop-down list. Alternatively, you can use the symbol selector.

    Note: You must select a leaf entity or an automation group.

  9. Click Copy. The settings for all accounts are copied to the specified entity or automation group.
  10. When you are finished, click Save.
  11. If you want to run calculations based on the changes you have made, click Run Calculations.

Exporting NIBT accounts to Microsoft Excel

You can use the Net Income Before Tax editor to export information from all accounts in the editor to Microsoft Excel, including global and entity override settings.

To export NIBT accounts to Microsoft Excel:

  1. In the Tax Provision navigation pane, click Administration.
  2. Expand Accounts.
  3. Click Net Income Before Tax. The Net Income Before Tax editor opens, displaying the accounts and their default settings.
  4. Click Export to Excel. The Export to Excel dialog opens.
  5. Complete the following:
    FieldNotes

    Layout

    Select one of the following:
    • Expanded view—To export all account symbols fully expanded.
    • Current view—To export only the account symbols visible in the current hierarchy expansion state. For more information on expanding and collapsing the symbol hierarchy, see “Using context menus”.

    Description

    Select one of the following:
    • Global settings, group overrides, and entity overrides—To export global settings for all accounts, and accounts with entity or automation group override settings applied.
    • Group and entity overrides—To export only accounts with entity or automation group override settings applied.

      Note: For accounts with entity or automation group override settings applied, separate rows appear in the Microsoft Excel worksheet for each entity or automation group that the account settings are overridden for, and for parents of the exported accounts.

    • Global settings—To export global settings for all accounts.
  6. Click Export. The Save As dialog opens.
  7. Navigate to the location where you want the file to be saved.
  8. Type the name of the file you want the account information to be exported to.
  9. Click Save. The file opens in Microsoft Excel.

    Note: The Global/Entity column in the Microsoft Excel worksheet specifies “Global” if the account settings are global or specifies an entity or automation group symbol name if the account settings are an entity or automation group override.

For an optimal Community experience, Please view on Desktop