Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

Export

Exporting

Topics discussed in this section include exporting categories from Administration, as well as dataset data, and component data from the Data Entry pages. When exporting data, and the export is complete, you can save the file from the current browser page. A download message appears for saving the file. The message you see varies and depends on the browser and version of the browser in use.

Dataset Export Worksheets

The export functionality generates a file with multiple worksheets:
Worksheets
#U# Unit
#UATTDAM# U AfterTxTD-Bk Tx Bas
#UDSP# UDS Params
#CTAA# Currency Translation Adj
#UQ# Unit Questions
#FL# Fed Liability Txns
#DP# Dataset Params
#DSRF# Dataset RollFrwd
#UPD# Unit Perm Diffs
#ICOTXNS# Inter Co Txns
#JES# Journal Entries
#TBM# Tax Basis Mapping
#UNOLTD# Unit NOL TDs-Tax Basis
#DSFX# FX Rates
#JETAX# JE Tax Calcs
#PARTH# Flow-Through Header
#UTD# Unit Temp Diffs-Tax Basis
#S# States
#JEGL# JE GL Calcs
#PARTD# Flow-Through Detail
#UATTD# U AfterTx TDs-Tax Basis
#SPM# State Perm Mods
#SL# State Liability Txns
#PARTTAG# Flow-Through Tags
#UTA# Unit Tax Adjs
#STD# St TD-Tax Basis
#UQUEST# Questionnaires
#TCM_IS# Tax Calcs Mapping IS
#UTBBS# Unit Tax Basis BalSheet
#SAATD# St AfterApp TD-Tax Bas
#UQSTNS# Questions
#TCM_BS# Tax Calcs Mapping BS
#ULB# Unit Liability Begin Bals
#SATTD# St AfterTax TD-Tax Bas
#UQRESP# Responses
#ALTRATE# Alt Prov Rates
#ULC# Unit Liability Changes
#STA# State Tax Adjs
#COU_RATES# Country Rates (Hidden)
#ALT1# Scenario 1 Adj
#UTDAM# U Temp Diff-Bk Tx Basis
#J# Jurisdictions
#CUR_RATES# Currency Rates (Hidden)
#ALT2# Scenario 2 Adj
#UPDAM# Unit Perm Diff Amort
#USDSP# USDS Params
#S_RATES# State Rates (Hidden)
#UAPIC# APIC Pool Amounts

Category Export Worksheets

The Import Categories template contains the following worksheets:
#ADS# Archive Datasets, #ARDS# Archive Reporting Datasets, #CATTD# AfterTax TempDiffs, #CD# Datasets, #CDRF# Def RollForwards, #CDSR# Dataset Relations, #CRD# Reporting Datasets, #COU# Countries, #CUR# Currencies, #CDRF# Def RollForwards, #CIFTD# Incl. for Temp Diffs, #CLRF# Liab RollForwards, #CNOLTD# NOL TempDiffs, #CNRF# NOL RollForwards, #CP# Parameters, #CPRU# ParamsReportsUser, #CPD# Permanent Differences,#CPTBI# PTBI Codes, #CPYBK# Payable Buckets, #CPYRL# Payable Rollups, #CPYTP# Payable Txn Types, #CRU# Component Rollup Sets, #CS# States, #CSAATD# St AfterApp TempDiff, #CSATTD# St AfterTax TempDiff, #CSC# SubConsolidations, #CSTA# St Tax Adjs, #CTA# Tax Adjustments, #CTBL# Trial Balance Lines, #CTBSL# Trial Balance SubLines, #CTD# Temporary Differences, #CTDP# Temp Diff Postings, #CU# Units, #CUC# User Components, #CUSR# Users, #CUSRGP# Group Permissions, Users#ICOTXNT# Inter Co Txn Types, #ICOTRTT# Inter Co Trtmnt Types, #CUNC# Unit Components, and #CUNCM# Unit Component Multiple,#JEN# Journal Entry Numbers.
note
To review the status of your export jobs, select Jobs in the Tax Provision menu.

This article applies to:

  • Product: ONESOURCE Tax Provision