Forum Discussion

DTull's avatar
DTull
Trusted Partner
3 years ago

Bank reconciliation opening imbalance

Hi Tracey_H , got another one... trying to reconcile a clients bank and since the last one done 30/6/2021, somethings happened to the Calculated Balance since the previous reconciliation. Every time I try to reconcile, no matter what quarter I use after the 30/6/21 reconciliation, its out by the same amount.

 

Even when I try to do a 1 day reconciliation from 30/6/21-1/7/21, with no transactions, its again out by the same amount.

 

I have put further description and screenshots in the attached.

 

Have also found this similar related post, but no solution is suggested as it went to a private message.  https://community.myob.com/t5/MYOB-Essentials-Accounting-MYOB/Bank-reconciliation-issues-new-Essentials/td-p/692575

 

Really need to get this reconcilation to the auditors soon so I look forward to your reply.

Kind regards

Darren

 

3 Replies

Replies have been turned off for this discussion
  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi

     

    the imbalance is due to an entry prior to the closing date , so trying to reconcile going forward will always have that balance 

     

    can you do a find transaction on the amount and see if you can locate the amount

     

    it looks like a deposit which has possibly been doubled up

     

    so look backwards not forwards

     

    hope that helps until Tracey gets back to you

     

    Lisa

  • DTull's avatar
    DTull
    Trusted Partner
    3 years ago

    Thanks LRBooks61 but no couldnt find that amount as a prior transaction. I dont get why it changes the previous reconciled Calculated Closing Balance, yet in the prior year Balance Sheet its the correct reconciled amount, and none of the prior year balances have changed.

     

    Its very odd. Hope Tracey_H can help.

    Thanks again

    Darren

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    3 years ago

    DTull 

     

    Hi Darren

     

    Can you do a future dated reconciliation, then undo it and check if the calculated balance refreshes.

     

    If that doesn't work go to Reconcile accounts, enter statement date same as opening balance date in the file and check if the calculated closing balance is correct. Also check the calculated closing balance with the statement date entered as 1 day before the opening balance date.

     

     In Bank Transaction screen, filter by the bank account and unallocated transactions for wider date range and check if there are any unallocated transactions before the last reconciled date.

     

    If those steps don't find the issue, send me the serial number in a private message and I'll have a look into it for you.