Tax Automation Cell Text

The Tax Automation definition is stored in the Tax Automation cell text label of each Target account in Entity [None].

It uses the following syntax:

• Colon (:) separator - used to separate the KEYWORD from the VALUE.

• Caret (^) separator - used to identify and separate the different KEYWORD/VALUE pairs.

• Semicolon (;) separator - used to identify multiple values for the same KEYWORD.

• At (@) symbol - used to identify additional logic to use for the same destination account.

Because the Tax Automation definition is stored as cell text, you can also load and extract the Tax Automation definition to an external data file. Trace cell text information is cleared when Calculate, Force Calculate, or Tax Automation are run.

The following section is a sample of a Tax Automation definition using cell text:

Cell Text Example

!SCENARIO=Actual

!YEAR=2014

!PERIOD=P12

!VIEW=YTD

!VALUE=[None]

!ICP=[ICP None]

!JURISDICTION=SystemMembers

!ROLLFORWARD=SystemMembers

!DATACATEGORY=SystemMembers

!TAXTYPE=SystemMembers

!REPORTINGSTANDARD=SystemMembers

!ENTITY=[None]

!DESCRIPTIONS

PermST0001;"TaxAutomation~Logic:PULL^Percent:50^SourceAccounts:50034^ReportingStandard:US_GAAP@Logic:PULL^Percent:35^SourceAccounts:50034^ReportingStandard:US_GAAP^Entity:FLE201"

TempGS0001;"TaxAutomation~Logic:SQUEEZE^Percent:100^SourceAccounts:20315^ReportingStandard:US_GAAP"

TempST0001b;"TaxAutomation~Logic:PULL^Percent:100^SourceAccounts:70003^ReportingStandard:US_GAAP"

NIBT;"TaxAutomation~Logic:PULL^SourceAccounts:80000^Percent:100"