Bank Reconciliation old transactions

Question

I have endured a whole week of undoing my bank reconciliations for the past three years ! 
Was not fun ..

however I managed to reconcile my main account as of June 30/23

however when I go into bank reconciliation I am still seeing over 50+ outstanding deposits and Cheques dating back to 2019 ! 
how do I clear these transactions without throwing out my current reconciled statement ?

and if I enter a "fake" future date eg: 1/9/23 when it comes time to reconcile September will the system allow me to or will I stuff up my balance for September?

Celia_B · Answer

Hi @TrulyJulie,

Thank you for your post. I'd like to extend you a warm welcome to the Community Forum, I hope you find it a valuable resource.

In this regard, If you are using MYOB AccountRight this can happen due to glitch of the reports. So we can confirm that's the issue, can you please follow these steps?

* Check the latest reconciled date on Reconcile accounts window.
* Go to Reports>Banking>Cheque and deposits>Reconciliation Report
* Select Advance Filters
* Select Individual bank account> OK
* Select Change Entered Statement Date to List of Recorded Statement Dates and Run Report
* Click on Statement Date to see all statements 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. To correct it, take a backup of your file and

* Go to Banking> Reconcile Accounts
* Enter a fake date after the latest statement date. Ignore the message about the transaction being future-dated.
* Enter the Calculated Statement Balance into the Closing Statement Balance field, so that the Out of Balance is $0.00
* Press the Reconcile button. This should allow you to undo the fake reconciliation and any other future dated transactions and the transactions should show up for to reconcile again.

Please let me know how you go.

If my response has answered your enquiry, please click "Accept as Solution" to assist other users find this information.

Thanks,

Cel