Use the Validation Movement report to get a detailed breakdown of various accounts by movements and their validation status. This validation ensures that sum of opening and all the other movements matches with the closing balance.

Once you select the parameters, the report shows the Balance Sheet data for the different movement categories. It also shows the difference column to show if the movements are in balance.

FieldDefinition
Columns

Movements

  • All movements from Opening through Closing, including Variation Auto are displayed.
  • A difference column displays the Closing amount minus (-) the Opening amount and all movements. This column is highlighted in red if the difference isn't zero.
  • A check column shows a green check mark if the difference is 0. Otherwise, a red X is displayed.
Rows
  • It displays members under the account tagged as #BalanceSheet.

Viewing data intersections

Within the report, right-click on any cell and select View Data Intersections. This opens another report that displays data that makes up the cell you selected. 

For example, if you are looking at a parent Entity, you will see all the child entities that make up this data value.

Note: You can only view data intersections for standard consolidation dimensions. Any additional dimension, such as Products, aren't displayed.