Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

My Datasets

Rolling Pin Format

The Rolling Pin is a flexible general purpose macro which uses a wide range of spreadsheet formats. Before you import data, some general rolling pin formatting must occur. Once you identify the data in the file, then you can import that data into the dataset.
Use the Rolling Pin spreadsheet format to import data using the  Importing option. You can import before the macro has been run by using the import_rolling_pin file format or after the macro using the ONESOURCE Tax Provision format.
Options
Notes
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.
  • Is easily configurable.
The challenge is assigning the Rolling Pin rows and columns for the source spreadsheet.
In 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 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 versus).
  • #ptbi-f.
  • #temp-do-f.
  • Flip the sign of a whole unit.
  • Use #unit-f instead of #unit.
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 Annotations and Markers
The Rolling Pin looks for special values in the spreadsheet for values to track what is in the rows/columns.
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# worksheet format.
Consider the (simplified) example
XYZ Corp.
Unit A
Unit B
Unit C
Total
#mark
Pre-Tax Inc.
200
300
400
900
N/A
Perm 1: M&E
10
20
30
60
#perm
Perm 2: Fines
0
5
0
5
#perm
etc.
N/A
N/A
N/A
N/A
N/A
#mark
#unit
#unit
#unit
N/A
N/A
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.
N/A
N/A
N/A
N/A
N/A
N/A
N/A
#mark
N/A
N/A
N/A
Unit A
Unit B
Unit C
N/A
N/A
N/A
N/A
N/A
A
B
C
Total
#ucode
N/A
Pre-Tax Inc
N/A
200
300
400
900
N/A
N/A
Perm 1
M&E
10
20
30
60
#perm
N/A
Perm 2
Fines
0
5
0
5
#perm
N/A
Temporary 1
T1000
50
0
30
80
N/A
N/A
Taxable Inc.
N/A
260
325
460
1,045
N/A
N/A
Tax Rate
N/A
35%
35%
12%
N/A
N/A
N/A
C.T.P.
N/A
91
114
55
260
N/A
#mark
N/A
#code
#unit
#unit
#unit
N/A
N/A

This article applies to:

  • PRODUCT: ONESOURCE Tax Provision