Forum Stats

  • 3,757,497 Users
  • 2,251,236 Discussions
  • 7,869,845 Comments

Discussions

2 different reporting periods in HFM

Steffi Chris
Steffi Chris Member Posts: 38
edited Feb 10, 2015 8:19AM in Financial Consolidation

Hi All,

We are currently following the Calendar year in our HFM application. Recently the company has acquired a few new entities who follow the Fiscal year end (March) for their reporting purposes.

My question is:

Is it possible to have 2 different reporting periods within a single application?

What would happen to the retained earnings calculation for the new entities?

Please share you comments/thoughts and experiences on this.

Thanks,

Steffi.

Tagged:
Thanos A

Answers

  • Hello Steffi,

    We can have only 1 reporting period hierarchy in HFM.  At a group level what GAAP are you following?

    As regards retained earnings is your question pertaining to impact of period rollup on RE calc?

    Regards,

    Darshana

  • Steffi Chris
    Steffi Chris Member Posts: 38
    edited Feb 3, 2015 5:05PM

    Hi Darshana,

    Thanks for your reply. The parent company is an US entity, so it will be US GAAP. Right now, I am really focussed on the sub entities that are reporting at Fiscal year end. I am trying to add a line to the rule saying, do not calculate Retained earnings for these entities.

    Is that the right way to do it?

    This is the piece of the rule that I am trying to work on: (339990C is the retained earnings a/c)

    Sub RetainedEarnings()

    If Not HS.YEAR.ISFIRST and HS.Year.Member > 2010 Then

      REAcc = "A#339990C"

      NIAcc = "A#Net_Income_beforeNCI"

      TopNIAcc = "A#NI"

     

      'Define the Closing and Movement Flow used to store the CY Retained Earnings in the BalanceSheet

      OPEFlow = ".DN#OPE"

      NIFlow = ".DN#NIN"

      NCIFlow = ".DN#NIM"

      MMIFLOW = ".DN#MMI"

      PYREFlow = ".DN#APP"

      ECQFLow = ".DN#ECQ" 

      CLOFlow = ".DN#CLO"

      MVTFlow = ".DN#FMVT"

      NITopMember = ".DN#[None]"

      TopCustoms = ".SH#" & "AllEmployeeShareholders" & ".LC#" & "AllLocations" & ".DP#" & "AllDepartments" & ".PR#" & "AllProjects"

      NoneCustoms =  ".SH#" & "[None]" & ".LC#" & "[None]" & ".DP#" & "[None]" & ".PR#" & "[None]"

     

      If HS.Value.Member = "<Entity Currency>" Or HS.Value.Member = "<Entity Curr Adjs>" or HS.VALUE.ISTRANSCURADJ or HS.Value.Member = "[Contribution Adjs]"  Then

       If HS.ENTITY.ISBASE("",HS.ENTITY.MEMBER()) Then

        HS.CLEAR REAcc & CLOFlow

        HS.CLEAR REAcc & NIFlow

        HS.Exp REAcc & NIFlow & NoneCustoms & " = " & NIAcc & NITopMember & TopCustoms

        HS.Exp REAcc & CLOFlow & " = " & REAcc & OPEFlow & " + " & REAcc & NIFlow & " + " & REAcc & NCIFlow & " + " & REAcc & ECQFlow & " + " & REAcc & MMIFlow & " + " & REAcc & PYREFlow

       Else 'we are not at a base entity

        If HS.Value.Member = "[Contribution Adjs]" or HS.VALUE.ISTRANSCURADJ then

         HS.CLEAR REAcc & NIFlow

         HS.Exp REAcc & NIFlow & NoneCustoms & " = " & TopNIAcc & NITopMember & TopCustoms

        End if 'parent level journal entries

       End if

      Else 'we are not at select value dimensions (<EC>, <ECA>, <PCA>, and [CA])  

       HS.Exp REAcc & CLOFlow & ".AT#ELI_NCI" & " = " & REAcc & OPEFlow & ".AT#ELI_NCI" & " + " & REAcc & NIFlow & ".AT#ELI_NCI" & " + " & REAcc & NCIFlow & ".AT#ELI_NCI" & " + " & REAcc & ECQFlow & ".AT#ELI_NCI" & " + " & REAcc & MMIFlow & ".AT#ELI_NCI" & " + " & REAcc & PYREFlow & ".AT#ELI_NCI"

      End If 'Roll NCI elimination

    End If 'year condition

    End Sub

  • Thanos A
    Thanos A Consolidation System Manager Member Posts: 1,413 Silver Trophy
    edited Feb 10, 2015 8:19AM

    Hi StefRon,

    The usual question on your question is how the Group accounting consolidate this entity on their data.

    In the majority of application the different periods are displayed as P01 to P12. This means that you can have one entity structure with Fiscal periods in which P01 = April and another entity structure with Calendar periods in which P01 = January.

    Cheers,

    Thanos

This discussion has been closed.