Questions? We have answers.

Pre-analysis completeness check (General ledger)

Article author
Tasha Kociszewski
  • Updated

Summary

Learn about the pre-analysis completeness check and how to access the report.


Required files

There are 3 files required to unlock the pre-analysis completeness check.

*Tip: Roll the Profit and Loss accounts into Equity before importing.

Overview

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

  1. Import an opening balance file, a closing balance file, and a general ledger.
    The pre-analysis completeness check becomes available.
  2. In the capabilities list, select Calculate balances.
  3. Compare the top-level balances to the calculated values, or Export the report for a complete account list.
Note: If a file is replaced or an account mapping is changed, Recalculate balances before running the analysis.
Note: Once the analysis has been run, you can view and export the finalized Completeness Check Report from the Reports tab.

Access_the_pre-analysis_completeness_check.gif

 


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:

  1. Balanced: If the number that MindBridge calculated is the same as the number in the supplied closing balance file, it will be considered balanced. 
  2. 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.
  3. 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?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.

Share this article on

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.