Partner Zone

Bank rec following upgrade this morning

Annie3267
4 Posts
User
Australia

4Posts

0Kudos

0Solutions

Bank rec following upgrade this morning

I did the latest AR upgrade earlier this morning and reconciling a bank account and have a very strange problem. My account has gone out of balance by a September transaction and I can only reconcile if I exclude this transaction, it is like it is including it in the opening balance somehow, where is the best place to report this to Myob? Rerunning the bank rec reports they balance as at end of August. The account is in balance as per the ledger and I can only now reconcile if I exclude this valid transaction?

I have posted this on the Myob Partner page too.

3 REPLIES 3
Komal_S
MYOB Moderator
5,411 Posts
MYOB Moderator
MYOB Moderator

5,411Posts

508Kudos

800Solutions

Re: Bank rec following upgrade this morning

Hi @Annie3267 

 

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:

 

  1. Check the 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 to undo the 'fake' reconciliation and any other future dated transactions without showing out-of-balance figures.

    Let me know how you go on. 

 

Kind regards,
Komal

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Annie3267
4 Posts
User
Australia

4Posts

0Kudos

0Solutions

Re: Bank rec following upgrade this morning

Hi Komal

Thank you for the reply, I actually spoke with support this morning and it has been escalated as it appears to be a system error in that the transaction is added into the balance twice for some reason.

I had exhausted all avenues of manually finding it, support did try your suggestion this morning too. But we are pretty confident it is an error in the system Smiley Happy

Komal_S
MYOB Moderator
5,411 Posts
MYOB Moderator
MYOB Moderator

5,411Posts

508Kudos

800Solutions

Re: Bank rec following upgrade this morning

Hi @Annie3267 

Thanks for letting us know! Feel free to post should you have other questions or concerns. 

Kind regards,
Komal

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post