Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Treatment of opening balance for aggregation of P&L and Balance Sheet accounts

Hi All,

We have a situation on our Balance Sheet where we are rolling up multiple accounts into a summary account "Cashflow Hedge Reserve" this account is dynamic and is made up of a P&L account and also Balance Sheet Accounts. We use the "ExtendAccountScope" variable to ensure that the P&L account does not have an opening balance created by setting this value to 'false' however at the consolidated account "Cashflow Hedge Reserve" the incorrect Opening Balance is being calculated as it does not include the P&L account ytd amount(see below):-

You can see from the above that the opening balance in Jan 22 should be -129k but it is showing as 240k (this is the only Balance Sheet account). Any thoughts as to how we can get the correct Opening Balance in Jan 21?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!