Learn about the pre-analysis completeness check and how to access the report.
There are 3 files required to unlock the pre-analysis completeness check.
The pre-analysis completeness check can help you assess the completeness of a general ledger (GL) by comparing top-level closing balances with calculated values. This check, performed before an analysis is run, enables you to identify and correct any data or account mapping issues before running the analysis.
Access the report
- Import an opening balance file, a closing balance file, and a general ledger.
The pre-analysis completeness check becomes available.
- In the capabilities list, select Calculate balances.
- Compare the top-level balances to the calculated values, or Export the report for a complete account list.
How completeness is calculated
It is important to understand the math behind the scenes of the pre-analysis completeness check.
Opening balance + GL activity = Closing balance
If you have provided the files for the 3 components in the above equation, MindBridge will start by calculating the left side of the equation (opening balance + GL activity). The result of this calculation is done for every account and is then compared against the accounts in the supplied closing balance file.
There are 3 possible outcomes for each account using this calculated approach:
- Balanced: If the number that MindBridge calculated is the same as the number in the supplied closing balance file, it will be considered balanced.
- Within tolerance: If the number that MindBridge calculated is within the designated tolerance amount (the $1.00 default is only adjustable on the Reports tab after running the analysis) from the number in the supplied closing balance file, it will be considered within tolerance.
- Out of balance: If the number that MindBridge calculated is outside the designated tolerance amount compared to the number in the supplied closing balance file, it will be considered out of balance.
Anything else on your mind?