Forum Discussion

GA39's avatar
GA39
Trusted User
4 years ago
Solved

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

GA39's avatar
GA39
Trusted User

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?

  • GA39's avatar
    GA39
    Trusted User
    4 years ago

    Tracey_H If I change the bank statement date to today's date, I don't have any ticked transactions.

    If I untick all transaction then change the date back to 01/07/2018, the calculated statement balance is still not correct.

    • Tracey_H's avatar
      Tracey_H
      Former Staff
      4 years ago

      Hi GA39 

       

      Thanks for that. Can you please follow these steps to see if there is an issue with the calculated statement balance:

       

      1. On the Reconcile Accounts window:
        1. Enter the closing date of your latest bank statement in the Bank Statement Date field.
        2. Enter $0.00 in the Closing Statement Balance field.
        3. Select all transactions as cleared and take note of the Calculated Statement Balance .
      2. Go to Find Transactions > Accounts tab.
      3. Select the bank account you're trying to reconcile.
      4. Enter the closing date of your latest bank statement in both the Dated From and To fields.
      5. Press the TAB key on your keyboard and take note of the Ending Balance in the bottom-right of the screen.

      The Ending Balance should be the same as the Calculated Statement Balance.

      • GA39's avatar
        GA39
        Trusted User
        4 years ago

        Tracey_H Per below two screenshots, these two figures are not the same.

Related content