|
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.1\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.1\Templates are not created for hosted clients. |
| • | Any data entered in the first two rows will be ignored by the program. |
| • | 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. |
| o | Do 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. |
| o | The v.2013 Numbers Template applies classes or tags to the dataset. |
| o | If you import numbers with classes to the dataset, the value entered for tags is ignored. |
| o | If you import numbers to the dataset with tags, value for classes will be ignored. |
|
