Summary
The completeness check report is an exportable .XLSX file that can help you confirm the completeness of the analyzed general ledger (GL) balances by comparing the opening balances and general ledger activity against closing balances.
Learn about the completeness check report in MindBridge:
Required files
The following files must be imported into your analysis in order to access the completeness check report:
Access the report
- Open the Analyze menu (
) within the MindBridge sidebar, then select the analysis you want to see. You will go your team's default dashboard within the analysis results.
- Go to the Reports tab. You will see all available checks and reports for the analysis.
- Find the Balance checks section.
- Select Export in line with Completeness check. The report will appear in your default download location.
Overview
This report provides sheets with detailed information about the grouped or ungrouped data for each analysis period. The following columns are included on each sheet.
| Column | Description | Derived from |
|---|---|---|
| Account Description | The names or descriptions of the accounts in your dataset. | General ledger file |
| Account # | The code used to identify specific accounts. | General ledger file |
| Opening Balances Per User-Supplied Opening Balances | These values are imported into MindBridge by you or your team and should be an accurate representation of account balances at the beginning of the given period. Referred to in formulas as "Supplied opening balances." | Opening balance file |
| Debit Movement Per Current Year General Ledger | These values reflect debits in the given period. | General ledger file |
| Credit Movement Per Current Year General Ledger | These values reflect credits in the given period. | General ledger file |
| Net Movement Per Current Year General Ledger |
These values reflect activity for the given period. Referred to in formulas as "Net movement." Find out how this column is calculated below. |
General ledger file |
| Expected Closing Balance Given Opening Balance and Net Movement From GL |
These values reflect what MindBridge expects the closing balance to be. Find out how this column is calculated below. |
Opening balance file General ledger file |
| Closing Balances Per User Supplied Closing Balances | These values are imported into MindBridge by you or your team and should be an accurate representation of account balances at the end of the given period. Referred to in formulas as "Supplied closing balances." | Closing balance file |
| Net Difference Between Expected and Supplied Closing Balances |
These values reflect any discrepancy between the expected closing balance and the closing balance supplied by you or your team. Find out how this column is calculated below. |
General ledger file Closing balance file |
| Account Balanced |
This column provides true/false statements based on whether or not the given account's final balance is within the allotted tolerance. |
General ledger file |
| Tolerance Testing |
This column reflects the result of comparing the account's calculated closing value to the value in the supplied closing balance file. Learn more about tolerance testing below. |
General ledger file Closing balance file |
How completeness is calculated
Each column in the report uses a different formula to calculate results, so it is important to understand the calculations going on behind the scenes.
| Column | Formula |
|---|---|
| Net Movement Per Current Year General Ledger |
(Expected closing balance – Supplied opening balance) |
| Expected Closing Balance Given Opening Balance and Net Movement From GL | (Supplied opening balance – Net movement) |
| Net Difference Between Expected and Supplied Closing Balances | (Supplied closing balance – Expected closing balance) |
Tolerance testing
MindBridge calculates the expected closing balance for each account, then it compares those results against the values in the supplied closing balance file.
There are 3 possible outcomes when using this calculated approach:
- Account Balanced: The account's calculated closing value is the same as the value in the supplied closing balance file.
- Within Tolerance: The difference between the account's calculated closing value and the value in the supplied closing balance file is within the given tolerance amount (default is $1.00).
- Out of Balance: The difference between the account's calculated closing value and the value in the supplied closing balance file is outside the given tolerance amount.
Anything else on your mind? Chat with us or submit a request for further assistance.