Summary
Learn about the completeness check report and how to access it.
Required files
There are 3 files required in order to leverage the completeness check report:
Overview
The completeness check report is an exported .XLSX file that can help you confirm the completeness of the analyzed general ledger (GL) information by comparing the opening balances and general ledger activity against the provided closing balances.
Access the report
From the Data page
After the analysis has been run, a link to the Reports tab will appear in the capabilities list beneath the completeness check.
- Select Reports.
You will go to the Reports tab. - Go to the Balance checks section.
- Select Export in line with the completeness check.
From the Reports tab
- Open the MindBridge sidebar and select the analysis you want to see.
You will go to the landing tab of the completed analysis. - Select the Reports tab.
You will see all available checks and reports for the analysis. - Go to the Balance checks section.
- Select Export in line with the completeness check.
How completeness is calculated
It is important to understand the math behind the scenes of the Completeness Check Report.
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 (default is $1.00) 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.
If you see accounts that are out of balance, try these troubleshooting tips for the completeness check report.
Anything else on your mind? Chat with us or submit a request for further assistance.