Forum Discussion

GA39's avatar
GA39
Trusted User
4 years ago

Calculated Statement Balance is incorrect from the very beginning

Previously I reconcil my bank account every month without problems. Now it comes to my attention that the bank reconciliation doesn't make any sense. I have undo reconciliation to the very beginnin...
  • gavin12345's avatar
    gavin12345
    4 years ago

    Hi GA39 

     

    I suggest you don't waste too much more time on this. In my opinion, based on seeing this several times before, there is a corruption in your file. Send it to MYOB to fix.

     

    Tracey_H  wrote : The calculated statement balance comes from the closing balance of the previous reconciliation, and any transactions that have been ticked in the Reconcile Accounts window.

     

    This is incorrect. Something in the future has caused this issue. The 26/11/2020 transaction likely updated something it should not have, or didn't update something it should have. Try deleting and re-entering that transaction. (Make a backup first). If you get a Data Invalid error this confirms corruption.

     

    Regards

    Gavin

Tracey_H's avatar
Tracey_H
Former Staff

Hi GA39 

 

Thanks for your post. Making changes to previously reconciled transactions can cause those transactions to become unreconciled. This means that you need to undo the previous reconciliations and then re-reconcile to include that transaction. 

 

The Closing statement balance needs to be the closing balance from your bank statement, not the opening balance, so I would check that you are entering the correct figure in that field.

 

This help article has detailed information to assist you: Resolving out of balance bank reconciliations

 

If you still have problems with this please do let me know.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

GA39's avatar
GA39
Trusted User
4 years ago

Tracey_H ,

 

I have undo all bank reconciliation to Day 1 of the file. The opening balance that I key in via "Set up-Balances-Account Opening Balances as of 01/07/2018" is $905,404.07. This figure should be the same as the reconciliation function when there is no transaction at all. However, it is already out of balance by $1,469.81 when there is no transaction on 02/07/2018.

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    4 years ago

    Hi GA39 

     

    The Closing Statement balance for your first reconciliation needs to be the closing bank balance on the day prior to your conversion month. So if your conversion month is 01/07/2018 you need to enter the closing balance from the bank statement on the 30/06/2018. Can I get you to confirm that the Closing statement balance figure is from your bank statement on the 30/6/2018?

    • GA39's avatar
      GA39
      Trusted User
      4 years ago

      Tracey_H the figures for both 30/06/2018 & 01/07/2018 are the same.

      • Tracey_H's avatar
        Tracey_H
        Former Staff
        4 years ago

        Hi GA39 

         

        Thanks for confirming that. The calculated statement balance comes from the closing balance of the previous reconciliation, and any transactions that have been ticked in the Reconcile Accounts window. If you change the bank statement date to today's date do you have any ticked transactions? If you untick all transactions then change the date back to 01/07/2018 is the calculated statement balance correct?

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content