Importing And Exporting
Once you are finished preparing import files, you can use Tax Provision to import those files into the system. You can also use Tax Provision to export information from the system.
You can import the following types of import files in Tax Provision:
- System settings. For more information, see Preparing an import file for system settings.
- Hierarchy structures. For more information, see Preparing import files for hierarchy structures.
- Symbol settings. For more information, see Preparing import files for parameters.
- Data. For more information, see Preparing import files for data.
- Users and user groups. For more information, see Preparing import files for users and user groups.
Depending on the type of import file, you may have to import files in a specific order.
Understanding import file dependencies
When you’re importing files, you should be aware that some files need to be imported at the same time, or before, others. If you import dependent files at the same time, the system processes the files in the order required to satisfy any dependencies. For information on the import file process, see Importing files.
To import files in the required order:
- Import all system settings at the same time, or before, all other files. All other import files are dependent on the System Settings import.
- Import structures files. The following dependencies apply:
File Dependent on… Entity_Primary_Structure.csv
Currency_Structure.csv
Entity_Alternate_Structure.csv
Currency_Structure.csv
Entity_Primary_Structure.csv
Entity_Jurisdiction_Structure.csv
Currency_Structure.csv
Partnership_Structure.csv
Currency_Structure.csv
TaxBasisBS_Structure.csv
ChartOfAccounts_Structure.csv
BookTaxDifferences_Structure.csv
- Import parameters files. Make sure to import any dependent files at the same time or before the parameters files. The following dependencies apply:
File Dependent on… FXSetup_Parameters.csv
ChartOfAccounts_Structure.csv
BookTaxDifferences_Structure.csv
Entity_Parameters.csv
Entity_Primary_Structure.csv
Entity_Jurisdiction_Structure.csv
Entity_Automation_Group_Structure.csv
LegalEntityGroupings_Parameters.csv
Entity_Jurisdiction_Structure.csv
PartnershipEntity_Parameters.csv
Partnership_Structure.csv
Entity_Automation_Group_Structure.csv
PartnershipOwner_Parameters.csv
Entity_Primary_Structure.csv
Partnership_Structure.csv
Branch_Parameters.csv
Entity_Primary_Structure.csv
NIBT_Parameters.csv
ChartOfAccounts_Structure.csv
NIBT_Structure.csv
BookTaxDifferences_Parameters.csv
Entity_Primary_Structure.csv
ChartOfAccounts_Structure.csv
BookTaxDifferences_Structure.csv
CurrentAndDeferredTax_Parameters.csv
ChartOfAccounts_Structure.csv
BookTaxDifferences_Structure.csv
InterimAccount_Parameters.csv BookTaxDifferences_Structure.csv
TARF_Parameters.csv ChartOfAccounts_Structure.csv
BookTaxDifferences_Structure.csv
TARFTargetElement_Parameters.csv
- Import data files. The following dependencies apply:
File Dependent on… ChartOfAccounts_Data.csv
Currency_Structure.csv
Entity_Primary_Structure.csv
Partnership_Structure.csv
ChartOfAccounts_Structure.csv
FXRates_Data.csv
Currency_Structure.csv
Entity_Primary_Structure.csv
Entity_Alternate_Structure.csv
Partnership_Structure.csv
FXReturnRates_Data.csv
Currency_Structure.csv
Entity_Primary_Structure.csv
Entity_Alternate_Structure.csv
Partnership_Structure.csv
GrossDeferredTaxBegBal_Data.csv
Currency_Structure.csv
Entity_Primary_Structure.csv
Partnership_Structure.csv
BookTaxDifferences_Structure.csv
NationalOverrideTaxRates_Data.csv
Entity_Primary_Structure.csv
BookTaxDifferences_Structure.csv
NationalReturnTaxRates_Data.csv
Entity_Primary_Structure.csv
NationalSchedulingTaxRates_Data.csv
Entity_Primary_Structure.csv
Entity_Parameters.csv
NationalTaxRates_Data.csv
Entity_Primary_Structure.csv
NetDeferredTaxNationalBegBal_Data.csv
Currency_Structure.csv
Entity_Primary_Structure.csv
Partnership_Structure.csv
BookTaxDifferences_Structure.csv
NetDeferredTaxRegionalBegBal_Data.csv
Currency_Structure.csv
Entity_Primary_Structure.csv
Partnership_Structure.csv
BookTaxDifferences_Structure.csv
RegionalOverrideTaxRates_Data.csv
Entity_Primary_Structure.csv
BookTaxDifferences_Structure.csv
RegionalReturnTaxRates_Data.csv
Entity_Primary_Structure.csv
RegionalSchedulingTaxRates_Data.csv
Entity_Primary_Structure.csv
Entity_Parameters.csv
RegionalTaxRates_Data.csv
Entity_Primary_Structure.csv
- Import users and user groups files. The following dependencies apply:
File Dependent on… UserGroup_Assignment.csv
Users.csv
UserGroups.csv
User_SymbolAccess.csv
Users.csv
All hierarchy structures files
User_Authorization.csv
Users.csv
User_Attributes.csv
Users.csv
UserGroup_SymbolAccess.csv
UserGroups.csv
All hierarchy structures files
UserGroup_Authorization.csv
UserGroups.csv
Importing files
When you are finished preparing the import files, you can import them using Tax Provision. For information on preparing import files, see:
- Preparing an import file for system settings
- Preparing import files for hierarchy structures
- Preparing import files for parameters
- Preparing import files for data
- Preparing import files for users and user groups
Some import files are dependent on others. For more information, see Understanding import file dependencies.
If you are importing exported files as part of a migration from one environment to another, Longview recommends that you remove all user group assignments, all symbol access for users and user groups, and all authorizations for users and user groups before you import the files. This ensures that only the assignments, symbol access, and authorizations from the source system are included in the target system. For more information on removing settings for users and user groups, see “Preparing import files for users and user groups”.
To import files:
- In the Tax Provision navigation pane, click Administration.
- Expand Import and Export.
- Click Import. The Import tool opens in the workspace.
- Click Dynamic Calculations to turn dynamic calculations on or off. Longview recommends that you turn dynamic calculations off during large imports.
Note: You can turn dynamic calculations off to avoid triggering tax calculations during the import process. Longview recommends that you manually run calculations when the import process is complete if you turn this setting off.
- Click Time Period on the toolbar. The Time Period field becomes available for modification.
- In the Time Period field, type the name of a time period, use the drop-down list, or use the symbol selector to select the time period for which to clear data for.
- In the Folder box, type the folder location for the import file. Alternatively, click Browse to open the Browse for Folder dialog. The import file categories appear in the workspace with a number indicating the number of valid .csv files found in that category.
Note: If a file in the folder location is not a .csv file and/or does not have a recognizable prefix, it appears in the Unknown File Type category.
- To import system settings, select System_Settings.csv.
Note: Click the Select All check box in the header row to select all import files.
- To import symbol structures, select from the following:
Currency_Structure.csv: For more information, see Preparing import files for currency structures.
- Entity_Primary_Structure.csv: For more information, see Preparing import files for entity structures.
- Entity_Alternate_Structure.csv: For more information, see Preparing import files for jurisdiction structures.
- Entity_Jurisdiction_Structure.csv: For more information, see Preparing import files for jurisdiction structures.
- Partnership_Structure.csv: For more information, see Preparing import files for partnership structures.
- ChartOfAccounts_Structure.csv: For more information, see Preparing import files for chart of accounts structures.
- NIBT_Structure.csv: For more information, see Preparing import files for net income before tax account structures.
- BookTaxDifferences_Structure.csv: For more information, see Preparing import files for book-tax difference account structures.
- TaxBasisBS_Structure.csv: For more information, see Preparing import files for tax basis balance sheet account structures.
Note: If you create new difference symbols or chart of account symbols that impact TARF, you must open the TARF editor and click SAVE for those new accounts to be included in the list of accounts that is used to trigger the TARF data transfer calculation.
- To import symbol parameters, select from the following:
FXSetup_Parameters.csv: For more information, see Preparing import files for foreign exchange settings.
Entity_Parameters.csv: For more information, see Preparing import files for entity settings.
LegalEntityGroupings_Parameters.csv: For more information, see Preparing import files for legal entity grouping settings.
PartnershipEntity_Parameters.csv: For more information, see Preparing import files for partnership entity settings.
PartnershipOwner_Parameters.csv: For more information, see Preparing import files for partnership owner settings. You can optionally clear data when importing this file. For more information, see step 12.
Branch_Parameters.csv: For more information, see Preparing import files for branch settings.
NIBT_Parameters.csv: For more information, see Preparing import files for net income before tax settings.
BookTaxDifferences_Parameters.csv: For more information, see Preparing import files for book-tax difference settings.
CurrentAndDeferredTax_Parameters.csv: For more information, see Preparing import files for current and deferred tax settings.
InterimAccount_Parameters.csv: For more information, see Preparing import files for interim account settings.
TARFTargetElement_Parameters.csv: For more information, see Preparing import files for TARF target element settings.
TARF_Parameters.csv: For more information, see Preparing import files for TARF settings.
- To import data, select from the following:
Parameters Description ChartOfAccounts_Data.csv
For more information, see “Preparing import files for chart of accounts data”.
ConsolidatedTaxRates_Data.csv
For more information, see “Preparing import files for consolidated tax rates”.
FXRates_Data.csv
For more information, see “Preparing import files for foreign exchange rates”.
FXReturnRates_Data.csv
For more information, see “Preparing import files for foreign exchange return rates”.
GrossDeferredTaxBegBal_Data.csv
For more information, see “Preparing import files for gross deferred tax beginning balances”.
NationalOverrideTaxRates_Data.csv
For more information, see “Preparing import files for national override tax rates”.
NationalReturnTaxRates_Data.csv
For more information, see “Preparing import files for national return tax rates”.
NationalSchedulingTaxRates_Data.csv
For more information, see “Preparing import files for national scheduling tax rates”.
NationalTaxRates_Data.csv
For more information, see “Preparing import files for national tax rates”.
NetDeferredTaxNationalBegBal_Data.csv
For more information, see “Preparing import files for net deferred tax beginning balances”.
NetDeferredTaxRegionalBegBal_Data.csv
For more information, see “Preparing import files for net deferred tax beginning balances”.
RegionalOverrideTaxRates_Data.csv
For more information, see “Preparing import files for regional override tax rates”.
RegionalReturnTaxRates_Data.csv
For more information, see “Preparing import files for regional return tax rates”.
RegionalSchedulingTaxRates_Data.csv
For more information, see “Preparing import files for regional scheduling tax rates”.
RegionalTaxRates_Data.csv
For more information, see “Preparing import files for regional tax rates”.
- If you selected any files that support clearing data, complete these steps:
- To clear the data area for a data file during import, select the adjacent Clear Data check box. Depending on the selected files, the Entity and Time Period columns become available.
Note: Selecting a time period in the toolbar populates the Time Period column, which is read-only.
- In the Entity column, type the name of one or more parent or leaf symbols to clear data for or select a parent or leaf in the hierarchy. Alternatively, you can use the symbol selector.
Note: You can select one or more parent or leaf symbols for which to clear data. Separate symbols with a semicolon ( ; ).
- To clear the data area for a data file during import, select the adjacent Clear Data check box. Depending on the selected files, the Entity and Time Period columns become available.
- To import users and user groups, select from the following:
Users.csv: For more information, see Preparing import files for adding and modifying users.
UserGroups.csv: For more information, see Preparing import files for adding and modifying user groups.
UserGroup_Assignment.csv: For more information, see Preparing import files for user group assignment.
User_SymbolAccess.csv: For more information, see Preparing import files for user symbol access.
User_Authorization.csv: For more information, see Preparing import files for user authorization.
User_Attributes.csv: For more information, see Preparing import files for user attributes.
UserGroup_SymbolAccess.csv: For more information, see Preparing import files for user group symbol access.
UserGroup_Authorization.csv: For more information, see Preparing import files for user group authorization.
User_Delete.csv: For more information, see Preparing import files for deleting users.
UserGroup_Delete.csv: For more information, see Preparing import files for deleting user groups.
- When you are finished, click Start Import. When the import is finished, the status updates.
- To view a report for the import process, click View Report.
Note: By default, the report is stored in your My Documents\Longview folder and is overwritten after subsequent reports are generated. To save multiple copies of the report, use Save As to save it to a local folder with a relevant file name.
- If you added chart of accounts or difference symbols that impact a Tax Provision calculation, open the corresponding editor and click Save to include the new symbols in the list used to trigger the calculation.
Calculation Related editor
NIBT Transfer
Net Income Before Tax
Current Tax Automation
(Perm/Temp Automation)Book-Tax Differences
Deferred Tax Automation
Current and Deferred Tax
Tax Account Rollforward (TARF)
Tax Account Rollforward Data Transfer
- If you want to run calculations based on the files you have imported, click Tax Calculations on the toolbar. For more information, see Running Calculations.
- When you are finished, click Reset to clear all selections and reset the Import tool.
Exporting system information
You can export information to make it easier to migrate from one environment to another. For example, you can export symbols and settings from your development environment, and then import them into your production environment.
To export system information:
- In the Tax Provision navigation pane, click Administration.
- Expand Import and Export.
- Click Export. The Export tool opens in the workspace.
- Click Time Period on the toolbar. The Time Period field becomes available for modification.
- In the Time Period field, type the name of a time period, use the drop-down list, or use the symbol selector to select the time period for which to export data for.
- To export system settings, select System_Settings.csv.
Note: Click the Select All check box in the header row to select all files.
- To export symbol structures, select from the following:
Currency_Structure.csv
Entity_Primary_Structure.csv
Entity_Alternate_Structure.csv: Select the alternate hierarchy root symbol to export.
Partnership_Structure.csv
ChartOfAccounts_Structure.csv
NIBT_Structure.csv
BookTaxDifferences_Structure.csv
TaxBasisBS_Structure.csv
- To export symbol parameters, select from the following:
File name Options FXSetup_Parameters.csv
Select one of the following:
- Global Settings — Exports the global settings from the Dim0Set symbol. If you select this option, any settings that are not set export double quotation marks ( "" ).
- Override Settings — Exports accountspecific tax method rates from accounts in the TrnAcc hierarchy. If you select this option, only account/ element intersections that have a Tax Method Rate are exported.
Entity_Parameters.csv
Select the entity for which to export parameters from the TENTITIES hierarchy.
LegalEntityGroupings_Parameters.csv
not applicable
PartnershipEntity_Parameters.csv
Select the entity for which to export parameters from the Pship hierarchy.
PartnershipOwner_Parameters.csv
not applicable
Branch_Parameters.csv
not applicable (Exporting branch parameters exports only data that has a value set.)
NIBT_Parameters.csv
Select one of the following:
- Default Settings — Exports the default settings for net income before tax from the Dim2Set symbol.
- Entity symbol — Select an entity from the TENTITIES hierarchy to export entity-specific settings for net income before tax.
BookTaxDifferences_Parameters.csv
Select one of the following:
- Default Settings — Exports the default settings for book-tax differences from the Dim2Set symbol.
- Entity symbol — Select an entity from the TENTITIES hierarchy to export entity-specific settings for book-tax differences.
CurrentAndDeferredTax_Parameters.csv
Select one of the following:
- Default Settings — Exports the default settings for deferred tax from the Dim2Set symbol.
- Entity symbol — Select an entity from the TENTITIES hierarchy to export entity-specific settings for deferred tax.
InterimAccount_Parameters.csv
not applicable
TARFTargetElement_Parameters.csv
not applicable
TARF_Parameters.csv
not applicable
- To export data, select from the following:
Note: The availability of data files for export depends on whether you are exporting from an actual, scenario, or return time period. If a file for which you want to export data is unavailable, specify a different time period on the toolbar.
File name
Options
ChartOfAccounts_Data.csv
Do one of the following:
- To export chart of accounts data for a legal entity or branch, select the appropriate symbol in the TENTITIES hierarchy.
- To export chart of accounts data for a partnership, select the appropriate symbol in the PShip hierarchy.
ConsolidatedTaxRates_Data.csv
not applicable
FXRates_Data.csv
Do one of the following:
- To export foreign exchange rates for a legal entity or branch, select the appropriate symbol in the TENTITIES hierarchy.
- To export foreign exchange rates for a partnership, select the appropriate symbol in the PShip hierarchy.
FXReturnRates_Data.csv
Do one of the following:
- To export foreign exchange return rates for a legal entity or branch, select the appropriate symbol in the TENTITIES hierarchy.
- To export foreign exchange return rates for a partnership, select the appropriate symbol in the PShip hierarchy.
GrossDeferredTaxBegBal_Data.csv
Do one of the following:
- To export gross deferred tax beginning balances for a legal entity or branch, select the appropriate symbol in the TENTITIES hierarchy.
- To export gross deferred tax beginning balances for a partnership, select the appropriate symbol in the PShip hierarchy.
NationalOverrideTaxRates_Data.csv
Select the entity for which to export national override tax rates from the TENTITIES hierarchy.
NationalReturnTaxRates_Data.csv
Select the entity for which to export national return tax rates from the TENTITIES hierarchy.
NationalSchedulingTaxRates_Data.csv
Select the entity for which to export national scheduling tax rates from the TENTITIES hierarchy.
NationalTaxRates_Data.csv
Select the entity for which to export national override tax rates from the TENTITIES hierarchy.
NetDeferredTaxNationalBegBal_Data.csv
Do one of the following:
- To export net deferred tax national beginning balances for a legal entity or branch, select the appropriate symbol in the TENTITIES hierarchy.
- To export net deferred tax national beginning balances for a partnership, select the appropriate symbol in the PShip hierarchy.
NetDeferredTaxRegionalBegBal_Data.csv
Do one of the following:
- To export net deferred tax regional beginning balances for a legal entity or branch, select the appropriate symbol in the TENTITIES hierarchy.
- To export net deferred tax regional beginning balances for a partnership, select the appropriate symbol in the PShip hierarchy.
RegionalOverrideTaxRates_Data.csv
Select the entity for which to export regional override tax rates from the TENTITIES hierarchy.
RegionalReturnTaxRates_Data.csv
Select the entity for which to export regional return tax rates from the TENTITIES hierarchy.
RegionalSchedulingTaxRates_Data.csv
Select the entity for which to export regional scheduling tax rates from the TENTITIES hierarchy.
RegionalTaxRates_Data.csv
Select the entity for which to export regional tax rates from the TENTITIES hierarchy.
Note: Selecting a time period in the toolbar populates the Time Period column, which is read-only.
- To export users and user groups, select from the following:
Users.csv
UserGroups.csv
UserGroup_Assignment.csv
User_SymbolAccess.csv
User_Authorization.csv
User_Attributes.csv
UserGroup_SymbolAccess.csv
UserGroup_Authorization.csv
- When you are finished, click Start Export. The Export dialog opens.
- For Export Folder, type the name of the folder to export files to, or click Browse to browse for a folder location.
- Optionally, for File Name Suffix, type a file suffix to append to all file names.
Note: If you do not specify a file suffix, the export process creates the files with the default file names.
- Click Export. The export process starts, and a progress bar appears in the Status field indicating the progression of each file.
Note: For information on importing the exported files, see Importing files.
- When you are finished, click Reset to clear all selections and reset the Export tool.