Questions? We have answers.

Completeness check (General ledger)

  • Updated

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:

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

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

Note: This report is only available after an analysis has been run. You can also perform a pre-analysis completeness check to compare balances and identify and correct any data or account mapping issues before running the analysis.

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.

  1. Select Reports.
    You will go to the Reports tab.
  2. Go to the Balance checks section.
  3. Select Export in line with the completeness check.

From the Reports tab

  1. Open the MindBridge sidebar and select the analysis you want to see.
    You will go to the Financial statements tab of the completed analysis.
  2. Select the Reports tab.
    You will see all available checks and reports for the analysis.
  3. Go to the Balance checks section.
  4. 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:

  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 (default is $1.00) 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.

If you see accounts that are out of balance, try these troubleshooting tips for the completeness check report.


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.


Related article

Was this article helpful?