State Calculated Values

State Calculated Values may be transferred into Active Workpapers by selecting STATECALC as the component type. You then may designate the state and hierarchy level (Unit, SubCon, Consolidated) and the currency (Reporting or Local). Below is a list of all state calculated values which can be pulled into Active Workpapers:

When using calculated values, select the options from the Active Cell Mapping in the following order:

1.Select Action.
2.Select Component Type.
Select STATECALC as the Component Type.
3.Select Dataset.
4.Select Unit, sub-consolidation, or consolidated (from the Subcon drop-down list).
5.Select Adjustment.
6.Select Currency.

Note: The State Calculated Values are transferred from reports, therefore, only the GET action is available. The values do not transfer from Data Input.


 

ABBREVIATION

VALUE

AI

State Allocable Income Pre Apportionment

AIPN

State Apportioned Income Pre NOLs

APPI

State Apportioned Income Post NOLs

BDTBS

Beginning State Deferred Tax Balance Sheet

BSOA

State Balance Sheet Only Adjustments

CSP

State Tax Adjustments (Cash)

CSTP

Total Current State Provision

EDTBS

Ending State Deferred Tax Balance Sheet

FPDIS

Federal Permanent Differences Includible for State

FPDNIS

Federal Permanent Differences not Includible for State

FTDIS

Federal Temporary Differences Includible for State

FTDNIS

Federal Temporary Differences not Includible for State

NCSP

State Tax Adjustments (Non-Cash)

PTBI

Pre Tax Book Income

RPTBI

Rounded PTBI

SAATD

State After App Temporary Differences

SDP

State Deferred Tax Provision

SEA

State Equity Adjustment

SM

State Only Permanent Differences

STC

State Tax Credits

TBC

State Tax Before Credits

TD

State Only Temporary Differences

TSTP

Total State Tax Provision