Learn what to do when your completeness check report shows unexpected imbalances.
- Choose an example account number to test.
- Check whether the supplied opening and closing balances in your completeness check report align with the imported trial balance totals for this account number.
In the example below we can see that the opening and closing balance in the trial balance match the completeness check.
- If the trial balance totals align with the supplied totals, open your imported GL file:
- Filter for the account number being tested and calculate the subtotal of the Amount column
- Check whether this subtotal aligns with the "Supplied Delta" value in the completeness check report
- If it does not align with the reported value, please reach out through:
- Get help — The online chat option within the MindBridge app, or
- Grant MindBridge access* — Securely grant our team access to your engagement, allowing for more hands-on support services
- If it does align with the reported value, ask yourself:
- Did I import a complete general ledger file for the fiscal year?
- Are there any adjustments or reclassifications I should be aware of for these accounts?
- Did I import the correct closing balance file that reflects the timeline of general ledger activity imported? (for example, if your general ledger does not contain year-end adjustments, you should be uploading a pre-adjustment closing balance)?
- Is this account number formatted differently throughout the general ledger file and/or between the trial balance and general ledger file account number formats?
In this example, there were no transactions against account 1000 in the GL. We proceeded by connecting with the client to see if there is an entry missing from this account.
- If the trial balance totals do not align with the supplied totals:
- First check if you mapped the correct columns in your opening and closing balance file imports
- If everything is mapped correctly, please contact your customer success manager for level 2 support.