Questions? We have answers.

Why does MindBridge say my general ledger is out of balance?

  • Updated

Summary

Learn why the general ledger is out of balance in MindBridge, even though the raw data file is balanced.


Resolution

Rows have been ignored in the analysis

A transaction ID may have been applied where not all rows contain the required data. These rows are ignored in the analysis, which may leave the remaining entries out of balance.

Check for ignored data rows in the Data Integrity step of the import process.
Screen_Shot_2021-02-18_at_11.29.54_AM.png

Out-of-period entries present

Entries may exist outside of the defined analysis period dates. These entries are not included within the analysis, causing the rest of the entries to be out of balance.

Check for out-of-period entries in the Analysis Period step of the import process.

Screen_Shot_2021-02-18_at_11.20.41_AM.png

There is a filter applied to the raw data file only showing entries that balance to zero

Since MindBridge reads all data within the file, filters should be removed before importing the file.

Also before importing, ensure the whole general ledger file is balanced.

There are negative credit values

Credit values must be imported as absolute values.

MindBridge assumes credit values are negative, and will automatically subtract these values.

If credit amounts are imported as negative values, MindBridge considers these as positive values (they are now double negatives), which results in doubling the overall balance of the file.


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 articles

Was this article helpful?