Contents x
    Consolidated Trial Balance is out of Balance and does not Match the YTD GL Report for the Same Period for One Fund and One GL Account
    • 18 Jan 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    Consolidated Trial Balance is out of Balance and does not Match the YTD GL Report for the Same Period for One Fund and One GL Account

    • Updated on 18 Jan 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary

    When running the consolidated trial balance it is noted that it is out of balance for a specific fund and GL account and does not match the YTD GL report for the same period which is correct and in balance for the fund and GL account in question. Why would the consolidated trial balance be off for this fund and GL account?

    Answer:
    This issue can be caused if the sum of journal entries for the period does not match the value on the Account tab, account sub-tab, Actuals column for the GL account in question in the GL module.

    This can also be caused in the GL account in question is missing for the GL year in question.

    To fix this:
    • Check and be sure that the GL account is not missing for the year in question where the issue occurs. If the account is missing, then you will need to add it for that year first.
    • Go to Tools\System Utilities\Admin Utilities\Finance Utilities
    • Select the Compare/Fix GL Accounts from Detail Option
    • Select the year for which the fix is needed
    • Check the box for Show Report
    • Click OK
    • A report will generate to show what issues are present with GL accounts
    • Run the report again and this time check both check boxes for Show Report and Change Summary Values so that you can see what was changed and also update.
    • Lastly, run the end of year process if you have an issue with GL entries from the previous year that are not flowing into the current year. Be sure to not check the checkbox to advance fiscal year if you have already previously done so.
    Was this article helpful?
    What's Next