Forum Discussion

FPM2012op's avatar
FPM2012op
3 years ago

Bank Reconciliation report shows past transactions

Hello,

 

I am trying to understand what is going on with my Reconciliation Report.

Every time I reconcile the accounts and I print the report I get also the cleared cheques and deposits for the previous year. For example , I just did May 2022, everything matches with the bank statement, out of balance=0 , balance correct, when I print the report t shows me also Cheques and Deposits from October 2021 that were cleared already. 

 

Is there someone I can send the file to as I have tried reconciling and this didn't help?

 

Thank you for your help

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi

     

    You say you print the report but do you then reconcile?

     

    Check what the last reconciled date is - In the reconcile bank screen just under the account name.

     

    If the transactions for the previous months are showing and the last dat reconciled is prior to Oct 21 then you need to reconcile. ( the options are print report or reconcile) So print report first and then reconcile, That will clear the transactions for future reconciliations

     

    If that isn't the issue not sure how to help sorry, hope this is some use though.

     

    Screen shots help if there is a different issue

     

    Lisa

    • Komal_S's avatar
      Komal_S
      MYOB Staff
      3 years ago

      Hi FPM2012op 


      It would be worthwhile to follow the troubleshooting steps given by LRBooks61 

       

      Besides this, if you're using MYOB AccountRight, sometimes this can happen due to a glitch in the reports. So we can confirm that's the issue, can you please do the following:

       

      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 transactions should show up for you to reconcile again.

       

      Let us know how you go on.

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.