Forum Discussion

bec_m's avatar
bec_m
User
3 years ago
Solved

reconciliation

When doing reconcilliations (for the past 6 months) all transactions are accounted for and balances reconcile.

 

My problem is that everytime I print out the report it includes december 2020 transactions.

 

Annoying as I have not found anything amiss or any way to resolve the problem.

 

My last resort is this post, please send help before I lose the last skeric of sanity that remains !!

  • Hi bec_m 

     

    This can happen at times due to a glitch in the reports. So we can confirm that's the issue, can you please do the following:

     

    1. Check Last Reconciled date on Reconcile Accounts window.
    2. Go to Reports > Banking > Cheques and Deposits > Reconciliation Report
    3.  Select Advanced Filters
    4.  Select Individual bank account > OK
    5.  Select Change Entered Statement Date to List of Recorded Statement Dates and Run Report
    6. Click on Statement Date to see all statement 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. In order to correct it, 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 correct transactions should appear in the reconciliation window. 

     

    Let us know how you go on.

2 Replies

Replies have been turned off for this discussion
  • Komal_S's avatar
    Komal_S
    MYOB Moderator

    Hi bec_m 

     

    This can happen at times due to a glitch in the reports. So we can confirm that's the issue, can you please do the following:

     

    1. Check Last Reconciled date on Reconcile Accounts window.
    2. Go to Reports > Banking > Cheques and Deposits > Reconciliation Report
    3.  Select Advanced Filters
    4.  Select Individual bank account > OK
    5.  Select Change Entered Statement Date to List of Recorded Statement Dates and Run Report
    6. Click on Statement Date to see all statement 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. In order to correct it, 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 correct transactions should appear in the reconciliation window. 

     

    Let us know how you go on.

    • bec_m's avatar
      bec_m
      User

      thank you very much, this appears to have resolved the issue