Forum Discussion

Kyliegr's avatar
Kyliegr
Contributing Cover User
4 years ago
Solved

Bank Rec prior cleared transactions showing on current bank rec

Hi, When i complete my bank rec for the month and print the Reconcilation Report,  Old Transactions going back to December 2020 are showing as"Cleared Cheques" & "Cleared Deposits" The bank account ...
  • Kyliegr's avatar
    Kyliegr
    4 years ago

    Hi, I have just had a look and worked out that when i run this report:

     

     you run the Reports>>Bank Register report and add in the Reconciled date, do those older transactions have a reconciled date against them? ( To add Reconciled date column, go to Insert/Modify>>Show/Hide>>Show Reconciled date

     

    Those transactions are showing as Reconciled on 31/12/5020? How do I go about trying to fix this error?

     

    Thanks

     

    Kylie

     

Komal_S's avatar
Komal_S
MYOB Staff
4 years ago

Hi @Kyliegr 


This is only expected to happen if reconciliation is done out of order, for example, the period 31/08/2021 is reconciled before 31/07/2021. If that's the case, you will have to undo the reconciliation back to the offending period and then reconcile again.

 

Please also check the following:

  • When you go to Banking>>Reconcile Accounts, do those older transactions appear in this window?
  • If you run the Reports>>Bank Register report and add in the Reconciled date, do those older transactions have a reconciled date against them? ( To add Reconciled date column, go to Insert/Modify>>Show/Hide>>Show Reconciled date)
  • Kyliegr's avatar
    Kyliegr
    Contributing Cover User
    4 years ago

    Hi,

     

    • When you go to Banking>>Reconcile Accounts, do those older transactions appear in this window? - No these do not show
    • If you run the Reports>>Bank Register report and add in the Reconciled date, do those older transactions have a reconciled date against them? ( To add Reconciled date column, go to Insert/Modify>>Show/Hide>>Show Reconciled date) - No They do not show

    I have also undone all the bank rec back until prior to the amounts showing on the bank rec and this also hasn't fixed the issue.

     

    Thanks for your help

     

    Kylie

     

    • Komal_S's avatar
      Komal_S
      MYOB Staff
      4 years ago

      Hi Kyliegr

       

      You mentioned that the reconciled date for those transactions does not appear in the bank register report however, they have been reconciled (

      • If you run the Reports>>Bank Register report and add in the Reconciled date, do those older transactions have a reconciled date against them? ( To add Reconciled date column, go to Insert/Modify>>Show/Hide>>Show Reconciled date) - No They do not show)

       

      If the transactions were reconciled without any issues, the reconciled date should show against them in the bank register report. As dates are not appearing, it leads me to think those transactions are stuck in the reconciliation and not actually reconciled. 

      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.
      • Kyliegr's avatar
        Kyliegr
        Contributing Cover User
        4 years ago

        Hi, I have just had a look and worked out that when i run this report:

         

         you run the Reports>>Bank Register report and add in the Reconciled date, do those older transactions have a reconciled date against them? ( To add Reconciled date column, go to Insert/Modify>>Show/Hide>>Show Reconciled date

         

        Those transactions are showing as Reconciled on 31/12/5020? How do I go about trying to fix this error?

         

        Thanks

         

        Kylie

         

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Learn:

 

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content