Skip to main content
January 17, 2025

Balance sheet report not working correctly

  • January 17, 2025
  • 1 reply
  • 0 views

Good morning, I have an issue with my Balance sheet report. When I look at my Retained earning CY_NI it is not equal to my P&L for q4. Not sure what to do.

 



 

1 reply

January 17, 2025

I would recommend you put CY_NI in one column and NI in another column and then you start drilling down to spot the problem.  Drill first on the months in Q4 and narrow the issue down to 1 (or all 3) months then drill on entity then go through your UDs.  You need to drill down and see if the problem is isolated to one entity or one dimension and go from there.  

But I think the starting point is to use Quick View Excel to start drilling and honing in on where the issue exists.  

Also on that note, ensure all your consolidations and calculations are run too.