Forum Discussion

cwish27's avatar
cwish27
Experienced Cover User
6 months ago
Solved

Reconciliation report mistake

On 30 June 2023, when I reconciled a bank account, I mistyped the date of reconciliation as 30 June 2026. Since then the entries from 22/06/2023 through to 30/06/2023 which were on that reconciliatio...
  • cwish27's avatar
    cwish27
    6 months ago

    From what you said, I deliberately created another reconciliation as at 30/06/2026 on the hopeful assumption that MYOB will pick up the other data which was reconciled at the same date.

     

    I backed up my data and made sure that the balance in my bank account on the date I was going to "mistakingly reconcile" again, which was 15/01/2024, was correct.

     

    I then printed the report on the mistaken "reconciled" day of 30/06/2026.

     

    I then pressed the "reconcile button".

     

    I effectively had two erroneous reconciliations for 30/06/2026, and I hoped that when I "unreconciled" the reports as of 30/06/2026, all the entries I needed to correct would come up.

     

    It worked. All the past records prior to 30/06/2023 came up.

     

    I then reconciled on 15/01/2024, and my problem has been solved. I now have a clean reconciliation.

     

     

Genreve_S's avatar
Genreve_S
MYOB Moderator

Hi cwish27, 

 

Thanks for posting your concern in the forum. 


I'm sorry to hear about your difficulties reconciling your accounts. I recommend following these steps to fix this issue. 

  1. Open the Reconcile Account screen, 
  2. Choose the bank account in question. 
  3. Choose the statement date to 30/12/9998.
  4. Mark all transactions check. 
  5. Copy the Calculated Statement Balance to the Closing Statement Balance field. 
  6. Click Reconcile button. 
  7. Undo reconciliation. 

This will likely fix your issue. If the issue persists after following this. Let us know and we'll investigate further. 

 

Feel free to create a new thread if you require any other assistance. 


Thanks,
Genreve

cwish27's avatar
cwish27
Experienced Cover User
6 months ago

Thank you, but the problem is not on the reconciliation page, but the report when I print it. I have followed your instructions, but the printed reconciliation for the 10 January 2024 date, which I just did, shows the problem. The entries that I mis-reconciled on 30/06/2026 still showed up on the report. Please see the PDF attached.

They don't show up on the reconciliation screen as they have been reconciled.

 

How do I get a clean report with the entries from prior to June 30 2023, removed?

 

Thank you. 

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    6 months ago

    Hi cwish27, 


    Thanks for the response and the information you've provided so far.

     

    The Reconciliation report gets its data from the previously completed reconciliations. If the report shows this data, you will need to undo the reconciliation and redo it to refresh the data based on the correct date of reconciliation. This will likely fix the issue.

     

    Let us know if you require further assistance. 


    Thanks,
    Genreve

    • cwish27's avatar
      cwish27
      Experienced Cover User
      6 months ago

      Thank you for your response, but I do not know how to do this.

       

      Do I have to undo every reconciliation I have done since 30 June? 

       

      How do I reverse the 30/6/2026 reconciliation that I did by mistake?

       

      Craig

       

      • cwish27's avatar
        cwish27
        Experienced Cover User
        6 months ago

        From what you said, I deliberately created another reconciliation as at 30/06/2026 on the hopeful assumption that MYOB will pick up the other data which was reconciled at the same date.

         

        I backed up my data and made sure that the balance in my bank account on the date I was going to "mistakingly reconcile" again, which was 15/01/2024, was correct.

         

        I then printed the report on the mistaken "reconciled" day of 30/06/2026.

         

        I then pressed the "reconcile button".

         

        I effectively had two erroneous reconciliations for 30/06/2026, and I hoped that when I "unreconciled" the reports as of 30/06/2026, all the entries I needed to correct would come up.

         

        It worked. All the past records prior to 30/06/2023 came up.

         

        I then reconciled on 15/01/2024, and my problem has been solved. I now have a clean reconciliation.