Transactions missing after unwinding Bank Account Reconciliation

[Sileo]

Unfortunately to comply with STP we had to reinput and add to some transactions in our cheque account. This forced us to wind back some bank reconciliations and now whilst redoing the reconcilations we have got to a point where some transactions cannot be found in the reconciliation screen.

They can be found if we look in the bank stream so they are still in the database but it appears that that unwinding a previous reconciliation was only partially done.

Any clues as to how we can fix this

[Tracey_H · Accepted solution]

Hi @Sileo 

Thanks for your post. There was an issue in 2019.1 and 2019.2 where after undoing a bank reconciliation the Reconcile Accounts window would not show unreconciled transactions. This was because the unreconciled date was still marked as reconciled in the reports.

To check if this is your problem run the bank reconciliation report and change the filters to List of recorded statement dates. It should show the same last reconciled date as the Reconcile Accounts window. If those dates are not the same create a fake reconciliation to resolve this by:

Go to Reports > Banking > Cheques and Deposits > Reconciliation Report

• Select Advanced 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 statement dates

• Go to Banking > Reconcile Accounts

• Enter a fake date after the latest statement date: e.g. 01/08/2023

• Enter the Calculated Statement Balance into the Closing Statement Balance field

• Press the Reconcile button. This should then allow you to undo the 'fake' reconciliation and any other future dated transactions.

If the last reconciled dates in the Reconcile Accounts window and the bank reconciliation report are the same please let me know so that I can troubleshoot further.

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