Forum Discussion

FPM2012op

3 years ago

Bank Reconciliation report shows past transactions

Hello, I am trying to understand what is going on with my Reconciliation Report. Every time I reconcile the accounts and I print the report I get also the cleared cheques and deposits for the pr...

LRBooks61

Ultimate Cover User

3 years ago

You say you print the report but do you then reconcile?

Check what the last reconciled date is - In the reconcile bank screen just under the account name.

If the transactions for the previous months are showing and the last dat reconciled is prior to Oct 21 then you need to reconcile. ( the options are print report or reconcile) So print report first and then reconcile, That will clear the transactions for future reconciliations

If that isn't the issue not sure how to help sorry, hope this is some use though.

Screen shots help if there is a different issue

Lisa

Komal_S

MYOB Staff

3 years ago

Hi FPM2012op

It would be worthwhile to follow the troubleshooting steps given by LRBooks61

Besides this, if you're using MYOB AccountRight, sometimes this can happen due to a glitch in the reports. So we can confirm that's the issue, can you please do the following:

Check Last Reconciled date on Reconcile Accounts window.
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

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

Go to Banking > Reconcile Accounts
Enter a fake date after the latest statement date: e.g. 01/08/2023. 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 then allow you undo the 'fake' reconciliation and any other future dated transactions and the transactions should show up for you to reconcile again.

Let us know how you go on.

Julish007
Contributing User
3 years ago
Worked perfectly - thanks for the tip!
- Komal_S
  MYOB Staff
  3 years ago
  Hi FPM2012op
  
  Generally the issue with report is sorted upon doing a future reconciliation and then undoing it. If it hasn't fixed the problem for you, please send me a screenshot of the report and the reconciliation window by Private message, so we can investigate further.
FPM2012op
3 years ago
Hi

Thank you I tried what you had outlined but this didn't solve the problem as the transaction don't show on the bank reconcile screen only when printing the report, the date and balance of reconciliation are correct

Bank rec 1.pdf29 KB
- Komal_S
  MYOB Staff
  3 years ago
  Hi FPM2012op
  
  Can you please confirm if you have tried to reconcile the October period again and these transactions are still appearing as unreconciled? Also , the screenshot you attached is from the browser version, please confirm if you are using MYOB AccountRight or MYOB Essentials?
  - FPM2012op
    3 years ago
    Hi
    
    Yes I have re-reconciled October these transacatuion do not appear on the screen to reconciled they only appear when I report the reconcilliation report. I'm using the MYOB Account Right. (I just send the rec from online while I was away form my computer)