Forum Discussion

4 years ago

Reconciliation

I accidently reconciled one of the credit cards accounts on 30.11.2021. The actual reconciled dated should have been 30.11.2020. I have tried unreconciling the transactions to their original date of transaction ( they were from mid October to November 2020) but the reconciled transactions ( that were reconciled on 30.11.2021) does not come up. Every time I print the reconciliation report, it comes up in the reconciliation report. How do I fix this and reconcile it on 30.11.2020?

Thank you.

Tracey_H
4 years ago
Hi Sushil-Shrestha

Thanks for confirming that for me. Can I get you to perform these steps:

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

Select Advanced Filters

Select the bank account in the Accounts field > OK

Select Change Entered Statement Date to List of Recorded Statement Dates and Run Report

Click on Statement Date to see all statement dates, make a note of the last statement date

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

Click on Reconcile

Now undo that reconciliation and check if those transactions are appearing in the Reconcile Accounts window as unreconciled

Please let me know how you go with this.

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

Tracey_H
Former Staff
4 years ago
Hi Sushil-Shrestha

Thanks for your post. Can you clarify if you have undone the incorrect bank reconciliation in the Reconcile Accounts window>>click Undo Reconciliation? If not, you will need to undo that reconciliation: Undo bank rec

If you have undone the reconciliation can you please send a screenshot of the Reconcile Accounts window. Make sure any sensitive information is removed from screenshots prior to posting on the forum.

Please let me know how you go with this.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
- Sushil-Shrestha
  4 years ago
  Hi Tracey
  
  Yes I have done the undo reconciliaition. Please see the snip below.
  
  I have done Undo Reconciliation till october 2020, but the transactions that are showing in the reconciliation report as reconciled on 30/11/2021 does not appear.
  
  If you see on the Reconcile Account snapshot, after the transaction from 09/10/2020, it straight goes to 1/11/2020.
  
  Thank you
  
  SushilReconciliation ReportReconcile Account
  - Tracey_H
    Former Staff
    4 years ago
    Hi Sushil-Shrestha
    
    Thanks for confirming that for me. Can I get you to perform these steps:
    
    Go to Reports > Banking > Cheques and Deposits > Reconciliation Report
    
    Select Advanced Filters
    
    Select the bank account in the Accounts field > OK
    
    Select Change Entered Statement Date to List of Recorded Statement Dates and Run Report
    
    Click on Statement Date to see all statement dates, make a note of the last statement date
    
    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
    
    Click on Reconcile
    
    Now undo that reconciliation and check if those transactions are appearing in the Reconcile Accounts window as unreconciled
    
    Please let me know how you go with this.
    
    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.