Forum Discussion

Viv4's avatar
Viv4
4 years ago
Solved

Reconciliation Report

hi,  My cleared transactions (from 20th Aug) are appearing on my reconciliaton report.  The balance is correct and the transactions are showing as already reconciled - how do I clear them?  thanks

 

  • Komal_S's avatar
    Komal_S
    4 years ago

    Hi Viv4 

     

    In that case, please ensure that the reconciliations are not done out of sequence. In your screenshot, I see that the last reconciled date in the Reconcile Accounts window is 2023 and the current statement date is from 2021. You will need to undo the 2023 reconciliation first and then reconcile the previous months in chronological order. 

     

    Once the reconciliation is done in the correct order, run the report again and if the issue still exists, clear AccountRight cache, run the report again and let me know how you go on.

5 Replies

Sort By
Replies have been turned off for this discussion
  • Komal_S's avatar
    Komal_S
    MYOB Staff
    4 years ago

    Hi Viv4 

    Welcome to the Community Forum!

     

    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 report should also run correctly.

    Let me know how you go on. 

  • Viv4's avatar
    Viv4
    4 years ago

    Hi Komal

    thanks for the help

     

    It worked reconciling to a fake date, all the transactions cleared.  However, now I have returned to current date and reconciled 2 transactions today – the ‘old’ transactions from the 20th August 2021 have reappeared again.

     

    Please let me know what I need to do

     

    thanks Viv

  • Komal_S's avatar
    Komal_S
    MYOB Staff
    4 years ago

    Hi Viv4 


    If those transactions are appearing in the reconciliation window, can you please take a backup of your file, undo the reconciliation back to the point where it's not out of balance, reconcile the August period again and confirm if everything then reconciles perfectly going forward. 

  • Viv4's avatar
    Viv4
    4 years ago

    Hi Komal

     

    can I just check something,  I am not out of balance.  The only issue is that when I print the reconciliation report is it showing cleared transactions from the 20th Aug.   These individual transactions if you click on them, the window pops up advising the transaction has been reconciled yet they still appear on the reconciliation report

    thanks Viv

  • Komal_S's avatar
    Komal_S
    MYOB Staff
    4 years ago

    Hi Viv4 

     

    In that case, please ensure that the reconciliations are not done out of sequence. In your screenshot, I see that the last reconciled date in the Reconcile Accounts window is 2023 and the current statement date is from 2021. You will need to undo the 2023 reconciliation first and then reconcile the previous months in chronological order. 

     

    Once the reconciliation is done in the correct order, run the report again and if the issue still exists, clear AccountRight cache, run the report again and let me 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.