Forum Discussion

Kristykyeema1's avatar
Kristykyeema1
Member
3 years ago

An incorrectly displayed Calculated Statement Balance

Hi   Just wondering if anyone else is having the same issue.   I'm attempting to reconcile at 30/06/22. My Balance sheet and account balance match with my bank statement and if I run a reconcilia...
Komal_S's avatar
Komal_S
MYOB Staff
3 years ago

Hi Kristykyeema1 

Before we go through those steps, can you please apply the following and let me know how you go on:

 

  1. Check Last Reconciled date on Reconcile Accounts window.
  2. Go to Reports > Banking > Cheques and Deposits > Reconciliation Report
  3.  Select Advanced Filters
  4.  Select Individual bank account > OK
  5.  Select Change Entered Statement Date to List of Recorded Statement Dates and Run Report
  6. Click on Statement Date to see all statement dates
 
 
If the latest date on this report does not match the last reconciled date on the reconcile accounts window, that means there is an issue with the report. In order to correct it, take a backup of your file, and
 
  1. Go to Banking > Reconcile Accounts
  2. Enter a fake date after the latest statement date: e.g. 01/08/2023. Ignore the message about the transaction being future-dated.
  3. Enter the Calculated Statement Balance into the Closing Statement Balance field, so that the Out of Balance is $0.00
  4. Press the Reconcile button. This should then allow you undo the 'fake' reconciliation and any other future dated transactions and the calculated balance should then appear correctly. 
  • Kristykyeema1's avatar
    Kristykyeema1
    Member
    3 years ago

    Hi 

     

    Thanks for your respones.

     

    The latest date on the report matches the last reconciled date, so that's not the issue.

     

    Any other suggestions?

     

    Thanks

    • Komal_S's avatar
      Komal_S
      MYOB Staff
      3 years ago

      HI Kristykyeema1 


      Apologies for the delay in getting back to you. 

      Can you please try applying the following fix as it has fixed the situation for many customers with the incorrect calculated balance issue :

       


      Can you please try the following steps and let me know how you go on: 

      Take a backup of your file, and
       
      1. Go to Banking > Reconcile Accounts
      2. Enter a fake date after the latest statement date: e.g. 01/08/2023. Ignore the message about the transaction being future-dated.
      3. Enter the Calculated Statement Balance into the Closing Statement Balance field, so that the Out of Balance is $0.00
      4. Press the Reconcile button. This should then allow you undo the 'fake' reconciliation and any other future dated transactions and the transactions should show up for you to reconcile again.

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.