Forum Discussion

Shell4's avatar
Shell4
Cover User
4 years ago

Urgent Help Needed please - Out of Balance & undoing a reconciled report/s

Hi all,

I am in desperate help, guidance or assistance with undoing a reconciled report to find a out of balance.

I have checked, correct amounts have been added to closing bank statement, dates and so on, so i gather it must be in a previous reconciled month /s 

 

I did go to undo previous months through the command centre, reports, banking, reconcile etc, put dates in from the statement i wanted to undo and recheck, saved it in a backup pressed undo or ok i think and nothing come up - meaning no transactions were there at all for the whole month. Is this right? What did I do wrong? I need help so i can continue as i need to fix this out of balance eventually so i would like to do it now if i can, but i need assistance with it.

Thankyou in advance

Michelle

  • Hi Shell4 

     

    There are a number of possible reasons for a reconciliation to be out of balance - usually a reconciled transactions has been edited or deleted - these are hardest to track. See this Support Note.

     

    Before you go undoing too many reconciliations, generate a Balance Sheet as at end of the next FY - check the BS balances, ie Net Assets = Equity. If not this means there is a corruption in your file - and this is the likely cause of the reconciliation issue. Refer the file to MYOB for repair. Then address the reconciliation issue - if it still exists.

     

    Regards

    Gavin

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User

    Hi Michelle

     

    Before you undo your reconciliations try to  find where the descrepancy is.

     

    Just as an aside the undo reconciliation , while having those fields ( date etc) only undoes the last reconciliation done

     

    So a couple of things to look at

    Go into the reconcile bank screen and check the following

    Are there any unreconciled entries? 

    If there are :

    Are they genuine transactions that have been unticked?

     

    Next

    What is the amount you are out?

     

    Do a find transaction on that amount 

     

    If you find a transaction  is it dated correctly - for instance if the bank feed has the transaction as 31/1 but the myob transaction is dated 1/2 it will not show in the recon bank screen 

    the reverse is also true if the bank feed shows the transaction as 1/2 and it is dated 31/1 - it appears reconciled in the recon screen but will put the balance out - you can untick and reconcile ( just remember to tick it again when you are done)

     

    Always refresh the screen after you do something too ( big green arrow) I have found that sometimes the amounts differ in the calcukated boxes

     

    Hope these suggestions help

     

    Lisa