File Library


Beyond the P&L: Balance Sheet Planning Made Easier Using Movement Members
Topic: Planning
Owner: Amy Del Rosario
Date: 2014-05-28
Subtopic: Tips and Techniques

Whether your company is already successfully using Hyperion Planning or Essbase to forecast Income Statement (P&L) accounts or it is still in the design phases of an enterprise wide initiative, it is always the right time to think about the relationships between Income Statement, Balance Sheet and Cash Flow accounts.
The use of roll-forward and movement members in the outline can add a level of understanding to an otherwise complex process that uses prior ending balances and current flow accounts to calculate current ending balances. Translating these amounts from local currencies allows the CTA to be easily identified and segregated at a granular level.
In this session, I will be walking through a comprehensive example of how to calculate Ending Balance = Beginning Bal + Periodic Movements + Currency Translation Adjustment (CTA).
Pre-existing knowledge of outline hierarchy concepts and calculation syntax is recommended.


Download File   ADelRosario.BeyondP&L.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database