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?