Forum Discussion

Kyliegr's avatar
Kyliegr
Contributing Cover User
3 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
    3 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

     

Kyliegr's avatar
Kyliegr
Contributing Cover User

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 Moderator
3 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
    3 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

     

    • Kyliegr's avatar
      Kyliegr
      Contributing Cover User
      3 years ago

      I have now fixed this

Related content