|
The Rolling Pin spreadsheet format can be imported using the Data Import/Spreadsheet Import (Dataset) page. It can be imported either before the macro has been run by using the import_rolling_pin file format or after the macro using the ONESOURCE Tax Provision format. The Rolling Pin is a flexible general purpose macro which uses a wide range of spreadsheet formats. Some general rolling pin formatting must occur before the data can be imported. Once the data is identified in the file, you can import that data into the dataset.
Note: To find the Rolling Pin macro, look in the System folder where Tax Provision 2014.0 is installed on your computer. For example, C:\Program Files\Thomson Reuters\Tax Provision2014.0\System. Look for the file named import_rolling_pin.vbs. This folder is not available for hosted clients.
The Rolling Pin macro is a flexible general purpose macro which:
| • | Handles a wide range of spreadsheet formats. |
| • | Generates import_categories spreadsheets. |
| • | Generates import_numbers spreadsheets. |
Rolling Pin Input:
Spreadsheet based provision processes often represent the current provision as follows:
XYZ Corp.
|
Unit A
|
Unit B
|
Unit C
|
Total
|
Pre-Tax Inc.
|
200
|
300
|
400
|
900
|
Perm 1: M&E
|
10
|
20
|
30
|
60
|
Perm 2: Fines
|
0
|
5
|
0
|
5
|
Temporary 1
|
50
|
0
|
30
|
80
|
Taxable Inc.
|
260
|
325
|
460
|
1045
|
Tax Rate
|
35%
|
35%
|
12%
|
N/A
|
Rolling Pin Challenge:
The challenge is assigning the Rolling Pin rows and columns for the source spreadsheet.
From the entry example:
| • | Some rows contain perms while others contain temps, tax rates, and so forth. |
| • | Some columns contain unit information while others contain totals, and comments, |
| • | At the intersection of a row with perms and a column with unit information is a useful value. |
Rolling Pin Output:
| • | Most information can be imported by categories and numbers spreadsheets. |
| • | These spreadsheets must be arranged in specific ways. |
| • | You need separate sheets for perms, temps, and so forth. |
| • | The columns in each sheet have specific meanings. |
| • | The Rolling Pin must produce spreadsheets that can be imported directly into the system. |
Rolling Pin Annotations and Markers:
The Rolling Pin looks for special values in the spreadsheet for values to track what is in the rows/columns.
Consider the (simplified) example:
XYZ Corp.
|
Unit A
|
Unit B
|
Unit C
|
Total
|
#mark
|
Pre-Tax Inc.
|
200
|
300
|
400
|
900
|
|
Perm 1: M&E
|
10
|
20
|
30
|
60
|
#perm
|
Perm 2: Fines
|
0
|
5
|
0
|
5
|
#perm
|
etc.
|
|
|
|
|
|
#mark
|
#unit
|
#unit
|
#unit
|
|
|
The special values, or annotations, go in marker rows and columns.
| • | Specify marker row with #mark in 1st column. |
| • | Specify marker column with #mark in 1st row. |
| • | The #unit annotations, indicate that there is unit information in columns 2, 3 and 4. |
| • | The #perm annotations indicate that rows 3 and 4 contain Permanent Differences values. |
| • | The Rolling Pin can process the sheet and use the annotations to produce an import_numbers #UP# spreadsheet. |
| • | The macro iterates through each row and column building the list of permanent difference amounts in the format required by the standard import_numbers #UP# sheet format. |
Rolling Pin Category Codes:
| • | Unit code is read from the row annotated by #ucode. |
| • | Permanent code is read from the column annotated by #code. |
| • | The full set of annotations and markers that produce the import_categories #UPD# include: |
|
|
|
|
|
|
|
#mark
|
|
|
|
Unit A
|
Unit B
|
Unit C
|
|
|
|
|
|
A
|
B
|
C
|
Total
|
#ucode
|
|
Pre-Tax Inc
|
|
200
|
300
|
400
|
900
|
|
|
Perm 1
|
M&E
|
10
|
20
|
30
|
60
|
#perm
|
|
Perm 2
|
Fines
|
0
|
5
|
0
|
5
|
#perm
|
|
Temporary 1
|
T1000
|
50
|
0
|
30
|
80
|
|
|
Taxable Inc.
|
|
260
|
325
|
460
|
1,045
|
|
|
Tax Rate
|
|
35%
|
35%
|
12%
|
N/A
|
|
|
C.T.P.
|
|
91
|
114
|
55
|
260
|
|
#mark
|
|
#code
|
#unit
|
#unit
|
#unit
|
|
|
Rolling Pin Extra Features:
| • | Flip the sign (+/-) of a row of values. |
| • | Add “–f” to the end of a marker that extracts numeric values in the opposite sign (converting 100 to -100 and vice versa). |
| • | Flip the sign of a whole unit. |
| • | Use #unit-f instead of #unit. |
| 
