Check Consolidation Execution

An ad-hoc Capsule is provided to facilitate troubleshooting and data quality verification. Open BFC_Troubleshooting  Capsule : in the Main screen a Process Check Report Library is provided.

 

image158.jpg

 

 

 

 

 

Of course it can be fully customized or integrated with ad-hoc analysis.

The available report has few functional meanings; they mostly spot out data inconsistency across the different steps (Layers) of the Consolidation Process.

 

Such Capsule is not part of the Business Application but its utilization should be narrowed to Developer and Process Owners.

 

A quick abstract of all the available reports:

 

Category Screen Short Description Validation Rule
Settings 100 - 10 Input Account It checks that data have been loaded on Input Accounts Only Report must be empty
Settings 100 - 20 Movement Groups It checks that the data have been loaded on proper Movement per Account (eg P&L Accounts must have only the CLOsing Movement) After clicking Movement Group Account (in master mode) the Report below must not be Red alerted
Settings 100 - 30 Intercompany and TP It checks that data have been loaded for IC Account on IC only and vice-versa for TP It reports the error only (Accounts red alerted)
Settings 100 - 40 Movements in BS and IC It checks that data have been loaded on Movement Accounts for BS and Not Available for IC It reports red alert by Movement Group Accounts
Data input 200 - 10 Input Layers It checks that Profit and Loss match with the Balance Sheet It reports red alert by Layer (Input Layer only)
Data Input 200 - 20 Movements and Closing It checks that (OPE+MOVs)=CLO It reports red alert by Layer
Data Input 200 - 30 Profit for the Period It checks that Profit and Loss match with the Balance Sheet It reports red alert by Layer (All Layers)
Opening Balance 300 - 10 Opening Balances It checks that CFY(OPE)=PFY(CLO) It reports red alert on Totals
Opening Balance 300 - 20 Profit Allocation It checks that OPE Profits are zeroed and Retaining Earnings correctly calculated It reports red alert on Layers
Conversion 400 - 10 AVG Rate It checks that Accounts translated at AVG Rate have been properly translated It reports red alert on Currencies
Conversion 400 - 20 CLO Rate It checks that Accounts translated at CLO Rate have been properly translated It reports red alert on Currencies
Conversion 400 - 10 HIS Rate It checks that Accounts translated at HIS Rate have been properly translated It reports red alert on Currencies (draft)
Conversion 400 - 40 P&L It checks that P&L Conversion Difference Calculation has been done correctly It reports red alert on Currencies
Conversion 400 - 50 P&L It checks that Group Conversion Reserve e Calculation has been done correctly It reports red alert on Currencies
Elimination 500 - 40 Profit (L10-04) It checks the P&L has been correctly zeroed and Group and Minorities have been correctly calculated It reports red alert on Profit Plug Account (Global Only)