Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Ligia Olguin
    Balance Sheet and Income Statement reports: Periodic viewAnswered
    Topic posted January 31, 2019 by Ligia OlguinGreen Ribbon: 100+ Points, tagged Balance Sheet, Income Statement 
    93 Views, 1 Comment
    Title:
    Balance Sheet and Income Statement reports: Periodic view
    Content:

    Hi guys,

    Probably a basic question, but it would be useful to get a confirmation. We loaded YTD data in December 2016 and both Periodic and YTD have been populated in that month. In Jan 2017, we have loaded Periodic data. We also mapped all accounts to the movements dimension for Cash Flow purposes.

    While creating the reports, we noticed that the only way to show the client Periodic and YTD data is working with two different Movements: (FCCS_Mvmts_Total and FCCS_ClosingBalance, respectively). So, we're building two BG and IS. 

    Is this the way you usually do your reports in FCCS?

    Thanks!

    Best Comment

    Harsh Dave

    Hi Ligia

    I'm not 100% sure of your setup, loading ending balances is fine as long as the period activity and opening balances are calculating correctly.

    Here's the way I've done it:

    Data Load:
    - Load Opening Balances for first period to the member FCCS_OpeningBalanceAdjustment
    - Load Period Activity for all periods moving forward to members within FCCS_Mvmts_Total

    Review/Reporting:
    - BS use the movement FCCS_ClosingBalance and view FCCS_YTD
    - IS use the movement FCCS_Mvmts_Total and view FCCS_Periodic

    Comments Are Closed

     

    • Harsh Dave

      Hi Ligia

      I'm not 100% sure of your setup, loading ending balances is fine as long as the period activity and opening balances are calculating correctly.

      Here's the way I've done it:

      Data Load:
      - Load Opening Balances for first period to the member FCCS_OpeningBalanceAdjustment
      - Load Period Activity for all periods moving forward to members within FCCS_Mvmts_Total

      Review/Reporting:
      - BS use the movement FCCS_ClosingBalance and view FCCS_YTD
      - IS use the movement FCCS_Mvmts_Total and view FCCS_Periodic