I just noticed that my trial balance is out of balance. I have Sage 50 2024.

SOLVED

When I went to print my financial statement, it told me my trail balance was out of balance.   How did this happen???  So I clicked ont the link and it took me thro the whole Chart of Accounts Journal Synchronization test and Integrity Checks.  

I went thro the whole thing where I go back to Period 1 and do all the Integrity Checks, then I checked my trial balance and it was still out of balance, so I went back to the Integrity check and selected the journal balances box and ok, then I did the integrity check again selected G/L Balances box and ok... this test will forcibly put the system back into balance by moving the offset into the Equity Retained Earnings account..  but it took that amount that I was off (on the trial balance difference) and deducted it from my Retained Earnings account.  and also lessened my Total Liabilities & Capital.  It does say I can do a general journal entry... but I'm confused should I?  and if I do what do I credit and debit, what accounts?  

  • 0
    verified answer

    You can't do a one-sided journal entry. The numbers on the Trial Balance come from the ending account balances from the Chart, and those numbers coming from the chart are not in balance. First find out which period is reporting the out of balance and then change your accounting period to that period.  Run the following tests from that period. Go to integrity check, run each of the following steps separately:

    1. Reindex the Chart

    2. Journal Balances

    3 G/L Balances

    4. Data Sync Test - Run Chart of Accounts / Journal

  • 0

    ok, this whole thing is crazy.  It had to have happened either when I bought a new computer and restored everything or it happened during an upgrade... I looked at all my paperwork (print outs) and my trial balance all matches.  but if I go into the computer and look at trial balances as of 12/31/19 it does not match the printed out paper of 12/31/19.  The retained earnings do not match.  It is off, same goes for 12/31/20, 12/31/22.. this is crazy... how did this happen?  And no I did not go back to these periods and change them accidently...  what the heck should I do? 

  • 0

    I have a similar issue after the 2024 upgrade, but my reports ARE in balance, even though the message say they are not.  Not sure what the issue is, but I just ignore the message.  Just annoying that is pops up every time I run a report Disappointed

    Hate upgrades!!

  • 0 in reply to JimHeintz

    check the general ledger on 1/1 of this year (or first day of this fiscal year) mine are off, I know what it's supposed to be but if you change anything in a prior year it adds an account to balance that....