Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

My Datasets

Tax Provision Format

You can create an Import_Numbers spreadsheet (template), by selecting Export Datasets in
My Datasets for Review
 or, Export Data Entry in
Review & Edit
.
  • Import_Numbers templates cannot contain macros, custom formatting, or links to external workbooks.
  • The Excel workbook contains a group of worksheets. Each worksheet corresponds to a data entry page in a dataset.
  • Any data entered in the first two rows will be ignored by the program. Each worksheet of the Excel workbook reserves the first two rows for column headings. Column headings shaded in green signify the data required by the application.
  • The worksheet name after the characters## can be renamed. This name appears in the log file.
  • Do not modify the column order for the worksheet.
  • The cells for codes must have data, however, cells for balances can be empty. Empty cells are ignored. Entering a 0 (zero) overrides the amount.
  • If a duplicate row of data exists, the import will write over the initial row of data with the subsequent one.
  • Imports do not stop on a blank row. The information from every row of a template is imported into the system.
  • After the import completes, you can review the import
    Log
     information in
    Jobs
     to ensure that no errors occurred to restrict data from being imported. There is a list of possible Import Error Messages and their causes available in the reference section.
  • Each worksheet can be imported either on a separate basis or with other import spreadsheet worksheets.

Dataset Import Worksheets

The export functionality generates a file with the following 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

This article applies to:

  • PRODUCT: ONESOURCE Tax Provision