Preparing import files for data

Tax Provision provides you with Excel import files that you can use to seed the system with data during implementation.

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

• Preparing import files for chart of accounts data
• Preparing import files for foreign exchange rates
• Preparing import files for deferred tax beginning balances
• Preparing import files for tax rates

Tax Provision includes the following data import files to help you load system data during implementation:

Preparing import files for chart of accounts data

You can use the ChartOfAccounts_Data.csv file to load all the chart of accounts data for your system.

To prepare an import file for chart of accounts data:

1. Open the ChartOfAccounts_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete the following fields:

   Field	Description
   Account [R]	Specify the relevant leaf symbol in the chart of accounts (TrialBal) hierarchy.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy, Scenario hierarchy, or Return hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Entity [R]	Specify the appropriate leaf entity. Valid entities are those set for Entities that Load Chart of Accounts Data in the System_Settings.csv import file.
   Detail	Specify the appropriate leaf Details symbol. Valid details are those set for Current Tax Automation - Valid Source Details Symbols in the System_Settings.csv import file. If you do not specify a details symbol, SummDet is used
   Currency	Specify the appropriate leaf currency symbol in the Currencies hierarchy. If you do not specify a currency, the value set for Functional Currency for the specified entity in the Entity_Primary_Structure.csv import file is used.
   Segment	Specify the appropriate leaf segments symbol from the SegmentsT hierarchy. Valid segments are those set for Current Tax Automation - Valid Source Segments Symbols in the System_Settings.csv import file. If you do not specify a details symbol, SummSeg is used.
   Reporting Method	Specify the appropriate leaf elements symbol. Valid elements are those set for Current Tax Automation - Valid Source Reporting Methods in the System_Settings.csv import file. If you do not specify a reporting method, SummEle is used.
   Value	Specify the value for the intersection. Values can have up to 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for foreign exchange rates

Tax Provision contains import files to help you load foreign exchange rates in bulk during implementation.

For information, see:

• “Preparing import files for foreign exchange rates”
• “Preparing import files for foreign exchange return rates”

Preparing import files for foreign exchange rates

Tax Provision includes an import file to help you load foreign exchange rates in bulk during implementation.

To prepare an import file for foreign exchange rates:

1. Open the FXRates_Data.csv file in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the translation entity for the foreign exchange rate. Valid symbols are leafs in the TRNENT hierarchy.
   Translate To/From [R]	Specify the translation in the format TToCurrencyFromCurrency. For example, to translate from US dollars to Canadian dollars, type TCADUSD. Valid currencies are those in the FXTRANSLATION hierarchy.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Period Average	Specify the income statement average rate. This value can contain a maximum of 9 decimal places.
   Spot BOY	Specify the beginning of year balance sheet spot rate. This value can contain a maximum of 9 decimal places.
   Spot EOY	Specify the end of year balance sheet spot rate. This value can contain a maximum of 9 decimal places.
   Q1 Spot	Specify the quarter 1 balance sheet spot rate. This value can contain a maximum of 9 decimal places.
   Q2 Spot	Specify the quarter 2 balance sheet spot rate. This value can contain a maximum of 9 decimal places.
   Q3 Spot	Specify the quarter 3 balance sheet spot rate. This value can contain a maximum of 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for foreign exchange return rates

Tax Provision includes an import file to help you load foreign exchange return rates in bulk during implementation.

To import foreign exchange return rates:

1. Open the FXReturnRates_Data.csv file in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the translation entity for the foreign exchange rate. Valid symbols are leafs in the TRNENT hierarchy.
   Translate To/From [R]	Specify the translation in the format TToCurrencyFromCurrency. For example, to translate from US dollars to Canadian dollars, type TCADUSD. Valid symbols are leafs in the FXTranslations hierarchy.
   Return Period	Specify the return period for the translation. This value can contain up to 9 decimal places. If you do not specify a period, the value of the working return time period for the current user is used (the AUTaxD1ReturnDefault attribute).
   Rate	Specify the return foreign exchange rate. This value can contain up to 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for deferred tax beginning balances

Tax Provision includes import files to help you load national and regional beginning balances for gross deferred tax and net deferred tax during implementation.

For more information, see

• Preparing import files for gross deferred tax beginning balances
• Preparing import files for net deferred tax beginning balances

Preparing import files for gross deferred tax beginning balances

Tax Provision includes import files to help you populate national and regional gross beginning balances for deferred tax.

To import gross deferred tax beginning balances:

1. Open the GrossDeferredTaxBegBal_Data in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Account [R]	Specify the relevant leaf symbol in the chart of accounts. Valid symbols are children of the NatDefTax_ASC/NatDefTax_IAS and RegDefTax_ASC/RegDefTax_IAS hierarchies.
   Entity [R]	Specify the appropriate leaf entity. Valid symbols are children from the TENTITIES and PShip hierarchies.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Detail	Specify the appropriate leaf details symbol from the DetailsT hierarchy. If you do not specify a details symbol, SummDet is used.
   Segment	Specify the appropriate leaf segments symbol from the SegmentsT hierarchy. If you do not specify a segments symbol, SummSeg is used.
   Gross Deferred Tax	Specify the value for the intersection. Values can have up to 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for net deferred tax beginning balances

Tax Provision includes import files to help you populate national and regional tax affected beginning balances for deferred tax.

To import net deferred tax beginning balances:

1. Open one of the templates in Microsoft Excel:
   • NetDeferredTaxNationalBegBal_Data.csv—Use this file to import national net deferred tax beginning balances.
   • NetDeferredTaxRegionalBegBal_Data.csv—Use this file to import regional net deferred tax beginning balances.

   For information on obtaining template files, see “Obtaining import template files”.

2. Complete these fields:

   Field	Description
   Account [R]	Specify the relevant leaf symbol in the chart of accounts. Valid symbols are: For National—Leaf symbols in the DefTax_ASC and DefTax_IAS hierarchies. For Regional—Leaf symbols in the RegDefTax_ASC and RegDefTax_IAS hierarchies.
   Entity [R]	Specify the appropriate leaf entity from the TENTITIES or PShip hierarchy.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Detail	Specify the appropriate leaf details symbol from the DetailsT hierarchy. If you do not specify a details symbol, SummDet is used.
   Segment	Specify the appropriate leaf segments symbol from the SegmentsT hierarchy. If you do not specify a details symbol, SummSeg is used.
   Net Deferred Tax	Specify the value for the intersection. Values can have up to 9 decimal places.
   National Benefit of Region	This field applies only to the national beginning balance files. Specify the national benefit of region amount for the account. Amounts can contain up to 9 decimals.
   Prior Year Adjustment (Restatement) (ASC)	This field applies to ASC systems only. Enter the data that should display in the NA0401 - Deferred Tax Rollforward National Actual.rtp report. Amounts can contain up to 9 decimals.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for tax rates

Tax Provision includes import files to help you load tax rates during implementation.

For more information, see:

• Preparing import files for consolidated tax rates
• Preparing import files for national tax rates
• Preparing import files for national return tax rates
• Preparing import files for national scheduling tax rates
• Preparing import files for national override tax rates
• Preparing import files for regional tax rates
• Preparing import files for regional return tax rates
• Preparing import files for regional scheduling tax rates
• Preparing import files for regional override tax rates

Preparing import files for consolidated tax rates

Tax Provision contains import files to help you load consolidated tax rates in bulk during implementation.

To prepare an import file for consolidated tax rates:

1. Open the ConsolidatedTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Type	Specify one of the following: ASC—Use this value for ASC rates. IAS—Use this value for IAS rates. If you do not specify a type, the value set for Tax Accounting Standard in the System_Settings.csv import file is used.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Rate	Specify the tax rate percentage. This value can include up to 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”..

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for national tax rates

Tax Provision includes an import file to help you load national tax rates in bulk during implementation.

To prepare an import file for national tax rates:

1. Open the NationalTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the entity for which to set the national tax rate. Valid symbols are leafs in the TENTITIES hierarchy.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Tax Rate Prior	Specify the national statutory tax rate for the prior year. This rate is used in the calculation of the return to provision/prior year adjustment. This value can contain a maximum of 9 decimals.
   Tax Rate Current	Specify the national statutory tax rate for the current year or period. This rate is used to calculate: the current tax charge the current year activity in the deferred tax account the foreign rate differential in the consolidated Effective Tax Rate Report the current year rate change component in the deferred tax rollforward This value can contain a maximum of 9 decimal places.
   Current Deferred Tax Rate BOY	Specify the beginning of year deferred tax rate used for temporary differences classified as current. This rate is used to calculate: the beginning of year deferred tax balance for temporary differences classified as current the beginning of year rate change component in the deferred tax rollforward This value can contain a maximum of 9 decimal places.
   Current Deferred Tax Rate EOY	Specify the end of year deferred tax rate, which is used for temporary differences classified as current. The rate is used to calculate: ending deferred tax balance for temporary differences classified as current beginning of year and current year rate change components in the deferred tax rollforward This value can contain a maximum of 9 decimal places.
   Non-Current Deferred Tax Rate BOY	Specify the beginning of year deferred tax rate, which is used for temporary differences classified as non-current. This rate is used to calculate: the beginning of year deferred tax balance for temporary differences classified as non-current the beginning of year rate change component in the deferred tax rollforward This value can contain a maximum of 9 decimal places.
   Non-Current Deferred Tax Rate EOY	Specify the end of year deferred tax rate to be used for temporary differences classified as non-current. The rate is used in the calculation of: the ending deferred tax balance for temporary differences classified as non-current the beginning of year and current year rate change components in the deferred tax rollforward This value can contain a maximum of 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for national return tax rates

Tax Provision includes an import file to help you load national return tax rates in bulk during implementation.

To prepare an import file for national return tax rates:

1. Open the NationalReturnTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the entity for which to set the national return tax rate. Valid symbols are leafs in the TENTITIES hierarchy.
   Period	Specify the return period symbol for the tax rate. Valid symbols are leaf symbols in the Return hierarchy. This field is optional. If you do not specify a period, the value of the working return time period for the current user is used (the AUTaxD1ReturnDefault attribute).
   Tax Rate	Specify the return tax rate for the entity. This value can contain a maximum of 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for national scheduling tax rates

Tax Provision includes an import file to help you load national return tax rates in bulk during implementation.

To prepare an import file for national scheduling tax rates:

1. Open the NationalSchedulingTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the entity for which to set the national scheduling tax rates. Valid symbols are leafs in the TENTITIES hierarchy.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Tax Rate for Amount Reversing in Year 1	Specify the tax rate for amounts reversing in year one. This value can contain a maximum of 9 decimal places.
   Tax Rate for Amount Reversing in Year 2	Specify the tax rate for amounts reversing in year two. This value can contain a maximum of 9 decimal places.
   Tax Rate for Amount Reversing in Year 3	Specify the tax rate for amounts reversing in year three. This value can contain a maximum of 9 decimal places.
   Tax Rate for Amount Reversing in Year 4	Specify the tax rate for amounts reversing in year four. This value can contain a maximum of 9 decimal places.
   Tax Rate for Amount Reversing in Year 5	Specify the tax rate for amounts reversing in year five. This value can contain a maximum of 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for national override tax rates

If you have entity/account combinations that requires a specific national tax rate, you can use an import file to override the national tax rate for those entities/accounts during implementation.

To prepare an import file for national override tax rates:

1. Open the 8p9uyt32bnj;pu577-5[p0,otionalOverrideTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the entity for which to override the national tax rate. Valid symbols are leafs in the TENTITIES hierarchy.
   Account [R]	Specify the account for which to override the national tax rate. Valid symbols are leafs from the NatDefTax_ASC and NatDefTax_IAS hierarchies.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Beginning of Year Override	Specify the beginning of year override tax rate for the entity/account. This value can contain a maximum of 9 decimal places.
   Current Year Override	Specify the current year override tax rate for the entity/account. This value can contain a maximum of 9 decimal places.
   End of Year Override	Specify the end of year override tax rate for the entity/account. This value can contain a maximum of 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for regional tax rates

Tax Provision contains an import file to help you load regional tax rates in bulk during implementation.

To prepare an import file for regional tax rates:

1. Open the RegionalTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the entity for which to set the regional tax rate. Valid symbols are leafs in the TENTITIES hierarchy
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Tax Rate Prior	Specify the national statutory tax rate for the prior year. This rate is used in the calculation of the return to provision/prior year adjustment. This value can contain a maximum of 9 decimals.
   Tax Rate Current	Specify the national statutory tax rate for the current year or period. This rate is used to calculate: the current tax charge the current year activity in the deferred tax account the foreign rate differential in the consolidated Effective Tax Rate Report the current year rate change component in the deferred tax rollforward This value can contain a maximum of 9 decimal places.
   Current Deferred Tax Rate BOY	Specify the beginning of year deferred tax rate used for temporary differences classified as current. This rate is used to calculate: the beginning of year deferred tax balance for temporary differences classified as current the beginning of year rate change component in the deferred tax rollforward This value can contain a maximum of 9 decimal places.
   Current Deferred Tax Rate EOY	Specify the end of year deferred tax rate, which is used for temporary differences classified as current. The rate is used to calculate: ending deferred tax balance for temporary differences classified as current beginning of year and current year rate change components in the deferred tax rollforward This value can contain a maximum of 9 decimal places.
   Non-Current Deferred Tax Rate BOY	Specify the beginning of year deferred tax rate, which is used for temporary differences classified as non-current. This rate is used to calculate: the beginning of year deferred tax balance for temporary differences classified as non-current the beginning of year rate change component in the deferred tax rollforward This value can contain a maximum of 9 decimal places.
   Non-Current Deferred Tax Rate EOY	Specify the end of year deferred tax rate to be used for temporary differences classified as non-current. The rate is used in the calculation of: the ending deferred tax balance for temporary differences classified as non-current the beginning of year and current year rate change components in the deferred tax rollforward This value can contain a maximum of 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for regional return tax rates

Tax Provision contains an import file to help you load regional return tax rates in bulk during implementation.

To prepare an import file for regional return tax rates:

1. Open the RegionalReturnTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the entity for which to set the regional return tax rate. Valid symbols are leafs in the TENTITIES hierarchy.
   Period	Specify the return period symbol for the tax rate. Valid symbols are leaf symbols in the Return hierarchy. This field is optional. If you do not specify a period, the value of the working return time period for the current user is used (the AUTaxD1ReturnDefault attribute).
   Tax Rate	Specify the regional return tax rate for the entity. This field can contain a maximum of 9 decimals.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for regional scheduling tax rates

Tax Provision includes an import file to help you load regional return tax rates in bulk during implementation.

To prepare an import file for regional scheduling tax rates:

1. Open the RegionalSchedulingTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the entity for which to set the regional scheduling tax rates. Valid symbols are leafs in the TENTITIES hierarchy.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Tax Rate for Amount Reversing in Year 1	Specify the tax rate for amounts reversing in year one. This value can contain a maximum of 9 decimal places.
   Tax Rate for Amount Reversing in Year 2	Specify the tax rate for amounts reversing in year two. This value can contain a maximum of 9 decimal places.
   Tax Rate for Amount Reversing in Year 3	Specify the tax rate for amounts reversing in year three. This value can contain a maximum of 9 decimal places.
   Tax Rate for Amount Reversing in Year 4	Specify the tax rate for amounts reversing in year four. This value can contain a maximum of 9 decimal places.
   Tax Rate for Amount Reversing in Year 5	Specify the tax rate for amounts reversing in year five. This value can contain a maximum of 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.

Preparing import files for regional override tax rates

If you have entity/account combinations that requires a specific regional tax rate, you can use an import file to override the regional tax rate for those entities/accounts during implementation.

To prepare an import file for regional override tax rates:

1. Open the RegionalOverrideTaxRates_Data.csv in Microsoft Excel. For information on obtaining template files, see “Obtaining import template files”.
2. Complete these fields:

   Field	Description
   Entity [R]	Specify the entity for which to override the regional tax rate. Valid symbols are leafs in the TENTITIES hierarchy.
   Account [R]	Specify the entity for which to override the regional tax rate. Valid symbols are children of the RegDefTax_ASC and RegDefTax_IAS hierarchies.
   Period	Specify the relevant period leaf symbol from the ActualYTD hierarchy or Scenario hierarchy. If you do not specify a period, the value of the working current time period AUTaxD1CurrentDefault attribute is used.
   Beginning of Year Override	Specify the beginning of year regional override tax rate for the entity/account. This value can contain a maximum of 9 decimal places.
   Current Year Override	Specify the current year regional override tax rate for the entity/account. This value can contain a maximum of 9 decimal places.
   End of Year Override	Specify the end of year regional override tax rate for the entity/account. This value can contain a maximum of 9 decimal places.

3. When you are finished, save the template as a comma-delimited (.csv) file.

   Note: You can rename the file, but the file prefix must remain the same. For a list of file prefixes, see “Preparing import files for data”.

4. If you are ready to import the data, continue to “Importing and exporting”.