The Interim Provision (State) report in the Interim dataset displays state tax provision calculations for the state selected in the Reporting page. Supporting detail for calculations can be viewed on separate reports.

 

Provision Items

•Current State Tax Expense

•Deferred State Tax Expense

•State Equity Offset to Current Expense

•Total State Tax Provision

 

Report Views

•Defaults to a detail view.

•Selecting Unit breakout generates an Excel spreadsheet that details the unit-by-unit underlying calculations for the state's provision expenses.

•The Unit breakout comparison view option allows you to create a side-by-side comparison of two datasets. The result is a total and unit-by-unit variance report. It displays on the screen or exports to an Excel file, depending on the version and parameter settings.

 

Line by Line

•Pre-Tax Book Income: Data Entry > PTBI.

•Forecast Rate: Reports > Unit/Consolidated > Forecast Rate.

•PTBI at Forecast Rate: Pre-Tax Book Income times Forecast Rate.

•Permanent Differences includable for State: Data Entry > Permanent Differences and InterCompany Transaction Entry, where includable status is Yes.

•Modifications: Data Entry > State Permanent Differences.

•Temporary Differences includable for State: Data Entry > Temporary Differences - Tax Basis, where includable status is Yes. Only amounts entered as Activity. Deferred Only and Balance Sheet Only entries do not impact the current tax provision calculation.

•Temporary Difference Adjustments: Data Entry > State Temporary Differences - Tax Basis. Only amounts entered as Activity. Deferred Only and Balance Sheet Only entries do not impact the current tax provision calculation.

•Discretes pre Rate: Permanent Differences includable for State, Modifications, Temporary Differences includable for State and Temporary Difference Adjustments lines.

•State Apportionment Percentage: My Datasets > Units > Jurisdictions > Edit > Apportionment PCTS. Displays only at the Unit level.

•Apportioned Discretes Pre-NOL: Discretes pre Rate line times State Apportionment Percentage line.

•NOLs: Data Entry > State After Apportionment Temporary Differences - Tax Basis.

•Total Apportioned Discretes: Sum of Apportioned Discretes Pre-NOL and NOLs lines.

•State Tax Rate: My Datasets > Units > Jurisdictions > Edit > Tax Rates. Displays only at the Unit level.

•Tax Before Credits: Total Apportioned Discretes line times the current State Tax Rate line.

•After Tax State Temporary Differences: Data Entry > State After Tax Temporary Differences - Tax Basis. Only amounts entered as Activity. Deferred Only and Balance Sheet Only entries do not impact the current tax provision calculation.

•Cash Tax Adjustments: Data Entry > State Tax Adjustments. Only cash items with codes that do not start with NC_.

•Cash Discretes: Sum of Tax Before Credits, After Tax State Temporary Differences - Tax Basis and Cash Tax Adjustments.

•Non-Cash Tax Adjustments: Data Entry > State Tax Adjustments. Only non-cash items with codes that start with NC_.

•Current State Provision: Sum of Cash Provision and Non-Cash Tax Adjustments.

•Begin Deferred Tax Per B/S: The Total Beginning Balance column of the Deferred Balances report with the State view option.

•Bal Sheet Only Adjustment: Data Entry > Temporary Differences - Tax Basis, NOL Temporary Differences - Tax Basis plus Data Entry > State Temporary Differences - Tax Basis times the appropriate rates and apportionment Percentage plus Data Entry > State After Apportionment Temporary Differences - Tax Basis times the appropriate rates plus Data Entry After Tax Temporary Differences - Tax Basis plus Data Entry > State After Tax Temporary Differences - Tax Basis. Only amounts entered as Balance Sheet Only entries do not impact the current tax provision calculation.

•Ending Deferred Tax Per B/S: The Total Ending Balance column of the Deferred Balances report with the State view option.

•CTA: The Total CTA column of the Deferred Balances report with State or State+FBOS and Expanded (income statement) view options.

•Deferred Provision Only: My Datasets > Units > More > Rates.

•Deferred Tax Provision: Begin Deferred Tax Per B/S plus Bal Sheet Only Adjustment minus Ending Deferred Tax Per B/S plus CTA and Deferred Provision Only lines.

•Equity Adjustment: Data Entry > Permanent Differences. Reversal of the impact to the current provision for Equity Adjustment Permanent Differences.

•Total State Tax Provision: Sum of the Total Current Provision, Deferred Tax Provision and Equity Adjustment lines.