ONESOURCE Tax Provision Format

A blank Import_Numbers spreadsheet (template) is provided with the software. The templates are typically stored in the following folder: C:\Program Files\Thomson Reuters\Tax Provision 2014.0\Templates. Additionally, the template is created by selecting Export Selected Dataset in a Provision dataset.


Notes:

The following folder: C:\Program Files\Thomson Reuters\Tax Provision 2014.0\Templates are not created for hosted clients.
Any data entered in the first two rows will be ignored by the application

The Excel workbook contains a group of sheets. Each sheet corresponds to a data review screen found in a Provision dataset.
Each sheet 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 sheet name after characters ## can be renamed. This name appears in the log file.
oDo not modify the column order for the worksheet.
Each sheet can be imported either on a separate basis or with other import spreadsheet sheets.
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.
The information from every row of a template is imported into the system. Imports do not stop on a blank row.
If a duplicate row of data exists, the import will write over the initial row of data with the subsequent one.
After the import is complete you will review the Import Log to ensure that no errors occurred to restrict data from being imported. There is a list of possible error codes and their causes available for reference.
Import_Numbers templates cannot contain macros, custom formatting, or links to external workbooks.
oThe v.2013 Numbers Template applies classes or tags to the dataset.
oIf you import numbers with classes to the dataset, the value entered for tags is ignored.
oIf you import numbers to the dataset with tags, value for classes will be ignored.