Tax Reporting

Get Involved. Join the Conversation.

Topic

    Al Gutierrez
    Current Provision Regional
    Topic posted February 14, 2019 by Al GutierrezGreen Ribbon: 100+ Points, tagged Tax Provision 
    85 Views, 3 Comments
    Title:
    Current Provision Regional
    Summary:
    Values are being aggregated at the regional level (for Example US_Regional).
    Content:

    In the Current Provision Regional, account values (for example NIBT) are being aggregated at the Regional member in the jurisdiction dimension. For example, assuming an entity with National Jurisdiction as United States with a NIBT value of $81,300. When pulling Current Provision Regional at the US_Regional, all values for each region are being aggregated.

    NIBT -> US_AK -> 81,300

    NIBT -> US_AL -> 81,300

    NIBT -> US_AZ -> 81,300

    and so on.... then

    NIBT -> US_Regional = 4,065,000 with it doesn't seem to make sense.

    Version:
    19.02.83 (Tax Reporting Cloud)

    Comment

     

    • Julien Coudrette

      Hi Al

      Yes, that's true, it doesn't make a lot of sense to add up the gross state provision numbers. But it makes a lot of sense if you look at it tax effected.

      In your example, if the tax rates of AK, AL and AZ are 4%, 6% and 10% and their apportionment rates 6%, 5% and 9%, then your tax will be:

      NIBT -> Tax -> US_AK -> 81,300 * .04 * .06 = 195.12

      NIBT -> Tax -> US_AL -> 81,300 * .06 * .05 = 243.9

      NIBT -> Tax -> US_AZ -> 81,300 *.1 * .09 = 731.7

      Then   NIBT -> Tax -> US_Regions = 1,170.72   which should make more sense.

      Hope that helps.

      Julien

    • Kenneth Kramer

      Hi Al, the total at US_Regions is not a valid view as it is rolling/totaling up the Federal (starting point for State provision) provision for each state as you noted.  The state provision is best viewed on a tax effected basis.  If you have a format that you currently use please log an SR with an attachment.  A report may be able to be configured.

      @Julien, thanks for the comment. 

    • Al Gutierrez

      Thanks Julian and Kenn. Yes, we are proceeding to address this on a report.