Loading Tax Provision System Data

Before the tax users begin inputting data for the current cycle, you must load certain information into Tax Provision. For example, you can update foreign exchange translation rates, chart of accounts data, and entity data. There may be more than one method for loading data into the system; for example, you may be able to use an import file, an input app, or a data import app.

For information on loading data in bulk during implementation using an import file, see the Tax Provision Implementer’s Guide.

For information on using a data import app, see the Longview Designer Guide.

Initializing your system during implementation

The following input apps are used to pre-populate a variety of elements during implementation.

For ASC systems:

• Deferred Tax Beginning Balance (XNC0501) input app
• Deferred Tax Beginning Balance (XRC0501) input app

For IAS systems:

• Deferred Tax Beginning Balance (XNC1501) input app
• Deferred Tax Beginning Balance (XRC1501) input app
• Triggering the Prior Year Deferred Tax Recognised Percentage calculation manually
• Gross DTR Percentage Prior Year Ending Balance (XNC1503) input app
• Gross DTR Percentage Prior Year Ending Balance (XRC1503) input app

Deferred Tax Beginning Balance (XNC0501) input app

Use this input app to pre-populate net beginning of year values displayed in report NA0401 - Deferred Tax Rollforward and gross beginning of year values displayed in the NA0301 - Temporary Differences input app and related reports.

Note: These elements are calculated in the Deferred Tax calculation process. If the input app is open when the deferred tax process is run, the calculation will not complete successfully. Similarly, if the deferred tax process is running, the input app is read only.

To pre-populate the ASC deferred tax beginning balances:

1. In the Tax Provision navigation pane, click Administration.
2. Expand System.
3. Expand Initial System Setup.
4. Click XNC0501 - Deferred Tax Beginning Balance.lvapp. The Symbol Selection page opens.
5. Select an Entity and click Done. The input app opens in the workspace.
6. Enter data for the following symbols for each leaf account:

   Symbol	Description
   CURNONCUR — Current or Non-Current	Enter Current, or Non-Current for each leaf account.
   GrsBOY_ASC — Beginning of Year	Enter the gross beginning of year value to display in the NA0301 - Temporary Differences report. This element does not apply to regional accounts.
   NetNBOY_ASC_Input — BOY Deferred Tax Asset/(Liability)	This column appears only for entities that use Scheduling. This element does not apply to regional accounts. Enter the beginning of year deferred tax asset to display in the NA0401 - Deferred Tax Rollforward report.
   NetNBRBOY_ASC_Input — NBR BOY Deferred Tax Asset/Liability	This column appears only for entities that use Scheduling and National Benefit of Region. Enter the national benefit of region for the beginning of year deferred tax balance to display in the NA0401 - Deferred Tax Rollforward report.

7. When you are finished, click Submit.

Deferred Tax Beginning Balance (XRC0501) input app

Use this input app to pre-populate the regional net deferred tax beginning balances displayed in report RA0401 - Deferred Tax Rollforward and regional gross beginning of year values displayed in the Temporary Differences input app and report.

Note: These elements are calculated in the Deferred Tax calculation process. If the input app is open when the deferred tax process is run, the calculation will not complete successfully. Similarly, if the deferred tax process is running, the input app is read only.

To pre-populate the ASC regional net deferred tax beginning balances:

1. In the Tax Provision navigation pane, click Administration.
2. Expand System.
3. Expand Initial System Setup.
4. Click XRC0501 - Net Deferred Tax Beginning Balance Regional.lvapp. The Symbol Selection page opens.
5. Enter data for the following symbols for each leaf account:

   Symbol	Description
   CURNONCUR — Current or Non-Current	Enter Current, or Non-Current for each leaf account.
   GrsBOY_ASC — Beginning of Year	Enter the gross beginning of year value to display in the RA0301 - Temporary Differences report. This element applies only to regional accounts.
   NetRBOY_ASC_Input — NBR BOY Deferred Tax Asset/Liability	This column appears only for entities that use Scheduling. This element applies only to regional accounts. Enter the beginning of year deferred tax asset to display in the RA0401 - Deferred Tax Rollforward report.

6. When you are finished, click Submit.

Deferred Tax Beginning Balance (XNC1501) input app

Use this input app to pre-populate net beginning of year values displayed in report NA1401 - Deferred Tax Account and gross beginning of year values in the Temporary Differences input app and report. In addition, use this input app to override the calculated Opening DTR Percentage that is transferred to the prior year.

To pre-populate the IAS deferred tax beginning balances:

1. In the Tax Provision navigation pane, click Administration.
2. Expand System.
3. Expand Initial System Setup.
4. Click XNC1501 - Deferred Tax Beginning Balance.lvapp. The Symbol Selection page opens.
5. Select an Entity and click Done. The input app opens in the workspace.
6. Enter data for the following symbols for each leaf account:

   Symbol	Description
   GrsBOY_IAS — Opening balance	Enter the gross opening balance to display in the NA1301 - Temporary Differences report. This element does not apply to regional accounts.
   NetNBOY_IAS_Input — Opening Deferred Tax Asset/(Liability)	This column appears only for entities that use Scheduling. This element does not apply to regional accounts. Enter the opening deferred tax asset to display in the NA1401 - Deferred Tax Account report.
   NetNBRBOY_IAS_Input — NBR BOY Deferred Tax Asset/(Liability)	This column appears only for entities that use Scheduling and National Benefit of Region. Enter the national benefit of region for the beginning of year deferred tax balance to display in the NA1401 - Deferred Tax Account report.
   NetDTNRPY_IAS_Input — Opening Deferred Tax Not Recognisable	Enter the opening deferred tax not recognizable to display in the NA1401 - Deferred Tax Account report.
   DTRPctOver - Opening Deferred Tax Recognised Percentage - Override	Enter the opening DTR percentage to override the calculated value below. This will be transferred to the prior year.
   DTRPctCalc - Opening Deferred Tax Recognised Percentage - Calculated	This column is the opening DTR percentage that is calculated by the system and transferred to the prior year. This column is read-only.

7. When you are finished, click Submit.

Deferred Tax Beginning Balance (XRC1501) input app

Use this input app to pre-populate regional net beginning of year values displayed in report RA1401 - Deferred Tax Account and regional gross beginning of year values displayed in the Temporary Differences input app and report. In addition, use this input app to override the calculated Opening DTR Percentage that is transferred to the prior year

To pre-populate IAS regional net beginning of year balances:

1. In the Tax Provision navigation pane, click Administration.
2. Expand System.
3. Expand Initial System Setup.
4. Click XNC1501 - Net Deferred Tax Beginning Balance.lvapp. The Symbol Selection page opens.
5. Select an Entity, and click Done. The input app opens in the workspace.
6. Enter data for the following symbols for each leaf account:

   Symbol	Description
   GrsBOY_IAS — Opening balance	Enter the gross opening balance to display in the RA1301 - Temporary Differences report. This element applies only to regional accounts.
   NetRBOY_IAS_Input — Regional Opening Deferred Tax Asset/ (Liability)	This column appears only for entities that use Scheduling. This element applies only to regional accounts. Enter the regional opening deferred tax asset to display in the RA1401 – Deferred Tax Account report.
   NetRDTNRPY_IAS_Input — Regional Opening Deferred Tax Not Recognisable	Enter the regional opening deferred tax not recognisable to display in the RA1401 - Deferred Tax Account report.
   DTRPctOver - Opening Deferred Tax Recognised Percentage - Override	Enter the opening DTR percentage to override the calculated value below. This will be transferred to the prior year.
   DTRPctCalc - Opening Deferred Tax Recognised Percentage - Calculated	This column is the opening DTR percentage that is calculated by the system and transferred to the prior year. This column is read-only

7. When you are finished, click Submit.

Triggering the Prior Year Deferred Tax Recognised Percentage calculation manually

The system calculates the Prior Year DTR% based on the Deferred Tax Beginning Balances. Typically, the Prior Year Deferred Tax Recognised Percentage is calculated automatically when you submit the Deferred Tax Beginning Balances; however, if you have disable Dynamic Calculations, you must manually trigger the Prior Year Deferred Tax Recognised Percentage calculation for your system in order to calculate these values.

To manually trigger the Prior Year Deferred Tax Recognised Percentage calculation:

1. In the Tax Provision navigation pane, click Administration.
2. Expand System.
3. Expand Initial System Setup.
4. Click Prior Year Deferred Tax Recognised Percentage Calculation. The Prior Year Deferred Tax Recognised Percentage app opens.
5. Type the name of the entity for which to run the calculation or use the symbol selector.
6. Click OK. The system calculates the Prior Year Deferred Tax Recognised Percentage for the selected entity based on the current year beginning balances.

Gross DTR Percentage Prior Year Ending Balance (XNC1503) input app

Use this input app to specify the Deferred Tax Recognised Percentage for national deferred tax accounts. The Prior Year Deferred Tax Recognised Percentage is calculated by the system; however, if you want to manually input the DTR%, you can do so using this input app. This input app is unpublished in the out-of-box product. To make it available, you must publish it. In addition, you must turn the relevant calculation. For more information, contact your Professional Services representative.

To specify national deferred tax recognised percentages:

1. In the Tax Provision navigation pane, click Administration.
2. Expand System.
3. Expand Initial System Setup.
4. Click XNC1503 - Gross DTR Percentage Prior Year Ending Balance Regional.lvapp. The Symbol Selection page opens.
5. Select an Entity, and click Done. The input app opens in the workspace.
6. Enter data for the following symbols for each leaf account:

   Symbol	Description
   DTRPct — Deferred Tax Recognised Percentage	For each deferred tax account, specify the percentage of the end of year total that should be Recognised.

7. When you are finished, click Submit.

Gross DTR Percentage Prior Year Ending Balance (XRC1503) input app

Use this input app to specify the Deferred Tax Recognised Percentage for regional deferred tax accounts. The Deferred Tax Recognised Percentage is calculated by the system; however, if you want to manually input the DTR%, you can do so using this input app. This input app is unpublished in the out-of-box product. To make it available, you must publish it. In addition, you must turn the relevant calculation. For more information, contact your Professional Services representative.

To specify regional deferred tax recognised percentages:

1. In the Tax Provision navigation pane, click Administration.
2. Expand System.
3. Expand Initial System Setup.
4. Click XRC1503 - Gross DTR Percentage Prior Year Ending Balance Regional.lvapp. The Symbol Selection page opens.
5. Select an Entity, and click Done. The input app opens in the workspace.
6. Enter data for the following symbols for each leaf account:

   Symbol	Description
   DTRPct — Deferred Tax Recognised Percentage	For each deferred tax account, specify the percentage of the end of year total that should be Recognised.

7. When you are finished, click Submit.

Loading chart of accounts data

You can load IFRS/US-GAAP chart of accounts data, statutory (local GAAP) chart of accounts data, and tax base amounts and use Tax Provision to easily compare them.

You can load chart of accounts data using an import file, an input app, or a data import app. For information on loading data in bulk during implementation using an import file, see the Tax Provision Implementer’s Guide. For information on using a data import app, see the Longview Designer Guide.

The method you choose to use to load your trial balance data varies depending on your requirements and the available source data. Some common scenarios related to loading chart of accounts data are described below.

Common chart of accounts scenarios

This section describes strategies for loading data into your Tax Provision system based on the way your company handles chart of accounts data. Common chart of accounts that includes statutory data This scenario assumes your company has a common chart of accounts for the IFRS/US-GAAP and statutory (local GAAP) balances, to which the tax base can also be loaded. In this scenario, the chart of accounts values represents the separate and distinct balance sheet and income statement for both IFRS/US-GAAP and statutory data.

You must load the amounts as total amounts for IFRS/US-GAAP and statutory data so that both full chart of accounts exists in the system. The variance between the balances are calculated and stored in the new comparison elements, as described in the table below.

In this scenario, you must make sure that the element symbols listed in the table below are valid for selection in the Book-Tax Differences editor (ASTaxPTAValidElements) and the Current and Deferred Tax editor (ASTaxDTAValidElements):

For information on setting values for the ASTaxPTAValidElements and ASTaxDTAValidElements, see Configuring Current Tax automation settings and Configuring Deferred Tax automation settings.

Common chart of accounts that does not include statutory data

This scenario assumes your company has a common chart of accounts for the IFRS/US-GAAP balances, to which the tax base can also be loaded, but the statutory (local GAAP) data is not required or available.

In this scenario, you must make sure that the following element symbols are valid for selection in the Book-Tax Differences editor (ASTaxPTAValidElements) and the Current and Deferred Tax editor (ASTaxDTAValidElements):

For information on setting values for the ASTaxPTAValidElements and ASTaxDTAValidElements, see Configuring Current Tax automation settings and Configuring Deferred Tax automation settings.

Common chart of accounts and statutory data that roll up

This scenario assumes your company has a common chart of accounts for the IFRS/US-GAAP and statutory (local GAAP) balances, to which the tax base can also be loaded, and the chart of accounts values roll up to the IFRS/US-GAAP balance sheet and income statement.

An example of this scenario is when there is both a statutory value and a statutoryto- IFRS/US-GAAP value that rolls up to the IFRS/US-GAAP total balance sheet and income statement. You must load amounts as total amounts and load the statutory and tax base numbers as differences. Since you load the differences, there is no need to calculate the variance amounts in the comparison elements, which in this case, are omitted.

In this scenario, you must make sure that the following element symbols are valid for selection in the Book-Tax Differences editor (ASTaxPTAValidElements) and the Current and Deferred Tax editor (ASTaxDTAValidElements):

For information on setting values for the ASTaxPTAValidElements and ASTaxDTAValidElements, see Configuring Current Tax automation settings and Configuring Deferred Tax automation settings.

Separate chart of accounts

This scenario assumes your company has a common chart of accounts for the IFRS (US-GAAP), statutory, and tax base amounts, and you cannot load the data to an element to identify the data type. In this case, you must load all data to a common, unidentified element, SUMMELE, and no variance calculations are performed.

In this scenario, you must make sure that the SUMMELE (accounting balances) element symbol is valid for selection in the Book-Tax Differences editor (ASTaxPTAValidElements) and the Current and Deferred Tax editor (ASTaxDTAValidElements).

For information on setting values for the ASTaxPTAValidElements and ASTaxDTAValidElements, see Configuring Current Tax automation settings and Configuring Deferred Tax automation settings.

Chart of Accounts Adjustments input app (XCCC400)

Use this input app to manually input adjustments to the chart of accounts data. This input app is used to input adjustments for the Balance Sheet - End of Period reporting method only. If chart of accounts data is loaded to more detailed reporting methods, use the “Book Chart of Accounts Adjustments input app (XCCC401)”.

For example, the Canadian source data is loaded to CAD for a Canadian entity of a London company. The translated data for the reporting currency is loaded to GBPCAD.

To view the chart of accounts data, use the following reports:

• “Book Balance Sheet report (NCC001)”
• “Book Income Statement report (NCC002)”

To input chart of accounts data:

1. In the Tax Provision navigation pane, click Data Collection.
2. Expand Chart of Accounts.
3. In the Entity box, type the name of the entity for which you want to input Chart of Accounts adjustments, or select the entity in the drop-down list. Alternatively, you can use the symbol selector. For more information, see Using the Symbol Selector.
4. Click XCCC400 - Chart of Accounts Adjustments.lvapp. The input app opens in the workspace.
5. For each account, enter the accounting balance.
6. When you are finished, click Submit.

Book Chart of Accounts Adjustments input app (XCCC401)

Use this input app to manually input adjustments to the Book Chart of Accounts data. This input app is used to input adjustments for the IFRS/US GAAP, Statutory, and Tax Base reporting methods. The Book Chart of Accounts Adjustments input app allows you to work with different reporting methods for Chart of Accounts data, which can be used to provide greater detail when automating current tax amounts or end of year temporary difference amounts.

For example, the Canadian source data is loaded to CAD for a Canadian entity of a London company. The translated data for the reporting currency is loaded to GBPCAD.

To view the chart of accounts data, use the following reports:

• “Book Balance Sheet by Reporting Method report (NCC003)”
• “Book Income Statement by Reporting Method report (NCC004)”

To input Book Chart of Accounts data:

1. In the Tax Provision navigation pane, click Data Collection.
2. Expand Chart of Accounts.
3. In the Entity box, type the name of the entity for which you want to input Book Chart of Accounts adjustments, or select the entity in the drop-down list. Alternatively, you can use the symbol selector. For more information, see Using the Symbol Selector.
4. Click XCCC401 - Book Chart of Accounts Adjustments.lvapp. The input app opens in the workspace.
5. For each appropriate account, enter data for the following symbols in the across dimension:

   Symbol	Description
   IFRS_GAAP_Balance — IFRS/GAAP - Balance	This column represents the IFRS/US GAAP balance. This value is set in an import file, as part of the implementation process. For more information, see the Tax Provision Implementer’s Guide.
   IFRS_GAAP_Adjustment — IFRS/GAAP - Adjustment	Use this column to enter data for the IFRS/US GAAP balance if you are not importing any trial balance data, or to enter an adjustment to the IFRS/US GAAP balance if you are importing trial balance data.
   IFRS_GAAP_Total — IFRS/GAAP - Total	This column represents the IFRS/GAAP total. This symbol is calculated (IFRS_GAAP_Balance + IFRS_GAAP_Adjustment).
   Statutory_Balance — Statutory - Balance	This column represents the Statutory (Local GAAP) balance. This value is set in an import file, as part of the implementation process. For more information, see the Tax Provision Implementer’s Guide.
   Statutory_Adjustment — Statutory - Adjustment	Use this column to enter data for the Statutory (Local GAAP) balance if you are not importing any trial balance data, or to enter an adjustment to the Statutory/Local GAAP balance if you are importing trial balance data.
   Statutory_Total — Statutory - Total	This column represents the Statutory total. This symbol is calculated (Statutory_Balance +Statutory_Adjustment).
   Tax_Base_Balance — Tax Base - Balance	This column represents the Tax Base balance. This value is set in an import file, as part of the implementation process. For more information, see the Tax Provision Implementer’s Guide.
   Tax_Base_Adjustment — Tax Base - Adjustment	Use this column to enter data for the Tax base balance if you are not importing this value, or to enter an adjustment to the Tax Base balance if you are importing this value.
   Tax_Base_Total — Tax Base - Total	This column represents the Tax Base total. This symbol is calculated (Tax_Base_Balance + Tax_Base_Total).
   IFRS_GAAP_STAT — IFRS/GAAP v. STAT	This column represents a comparison of the IFRS/US GAAP total and the Statutory (Local GAAP) total. This symbol is calculated (Statutory_Total - IFRS_GAAP_Total).
   STAT_TAX — STAT v. TAX	This column represents a comparison of the Statutory (Local GAAP) total and the Tax Base total. This symbol is calculated (Tax_Base_Total - Statutory_Total).
   IFRS_GAAP_TAX — IFRS/GAAP v. TAX	This column represents a comparison of the IFRS/ US GAAP total and the Tax Base total. This symbol is calculated (IFRS_GAAP_STAT + STAT_TAX).

6. When you are finished, click Submit

Updating and reviewing foreign exchange translation rates

Longview will impute the period average rate using the functional and the reporting currency values in the NIBT account. This is the product of the Period Average FX Rate Calculation. This calculation can be turned on and off with the following system attribute:

• ASTaxUseImputedFXRate - Use Imputed FX Rate
  • Valid Settings: TRUE or FALSE

You can upload the foreign exchange rates using an input app. You can enter foreign exchange rates for period beginning/end (used for balance sheet accounts) and period average rates (used for income statement accounts).

FX Rates - Period Average input app (XCCC100)

Use this input app to update override foreign exchange rates. You can also view a report that shows the foreign exchange rates for the average rate for the year. Global FX rates are displayed for the current period activity month symbol. The method rates included in this input app are (when ASTaxUseImputedFXRate = "TRUE"):

The method rates included in this input app are (when ASTaxUseImputedFXRate = "FALSE"):

To update foreign exchange rates:

1. In the Tax Provision navigation pane, click Data Collection.
2. Expand Rates.
3. Click XCCC100 - FX Rates - Period Average.lvapp. The input app opens in the workspace.
4. If your system uses translation with Partnerships and Branches, enter the appropriate Cross Currency Translation rates for each branch or corporate owner for each appropriate method rate.

   Note: The system uses the Cross Currency Translation rates to calculate the target currency amount from the source currency for Partnerships and Branches.

5. Enter the appropriate translation rates (for example, USD from CAD) for each entity for each imputed rate you wish to override.
6. When you are finished, click Submit

FX Rates - Period End input app (XCCC100)

Use this input app to update foreign exchange rates. You can also view a report that shows the foreign exchange rates for the beginning of the year and end of year. Global FX rates are displayed for the current period activity month symbol.

The method rates included in this input app are:

To update foreign exchange rates:

1. In the Tax Provision navigation pane, click Data Collection.
2. Expand Rates.
3. Click XCCC100 - FX Rates - Period End.lvapp. The input app opens in the workspace.
4. If your system uses translation with Partnerships and Branches, enter the appropriate Cross Currency Translation rates for each branch or corporate owner for each appropriate method rate.

   Note: The system uses the Cross Currency Translation rates to calculate the target currency amount from the source currency for Partnerships and Branches.

5. Enter the appropriate translation rates (for example, USD from CAD) for each entity for each appropriate method rate.
6. When you are finished, click Submit.

Updating foreign exchange return-to-provision rates

Use this input app to input the FX rates to use for the return to provision and prior year adjustment true-ups.

To update return-to-provision rates:

1. In the Tax Provision navigation pane, click Data Collection.
2. Expand Rates.
3. Click XCCC101 - Return FX Rates.lvapp. The input app opens in the workspace.
4. For each appropriate account, enter data for the following symbols for the appropriate currency translation in the across dimension:

   The method rates included in this input app are (when ASTaxUseImputedFXRate = "TRUE"):

   Method rate	Description
   RPerTaxImp - FX Rate - Period Average - Imputed	Calculated by Longview (Read-only)
   RPerTaxOver - FX Rate - Period Average - Override	Override imputed FX rate (Input)
   RPerTax-FX Rate - Period Average	Calculated by Longview (Read-only)

   The method rates included in this input app are (when ASTaxUseImputedFXRate = "FALSE"):

   Method rate	Description
   RPerTaxOver - FX Rate - Period Average - Override	Override imputed FX rate (Input)

5. When you are finished, click Submit.