Forum Discussion

Stonegalleria's avatar
Stonegalleria
Experienced User
3 years ago

old Unbalanced Reconciliation and ways to fix it.

Hi All,

I recently joined a new company from this month. When I looked at the Account Reconciliation, its last date of reconciliation was 2019 with havoc Out of balance and Calculated Statement Balance. We use MYOB AccountRights and do the manual entry.

Can somebody plase help me sort this out;

1) How to clear those unmatched transactions (Bcoz there are lot of it).

2) How to fix that Out of Balance and Calculated Statement Balance.

And also if you could provide some Journal Entry guidance for that, it would be great help.

 

Thanks.

Dan.

  • Hi

    Interesting problem

     

    Are the unmatched entries older than the last reconciled date?

     

    Really you need to reconcile the bank month by month year by year

     

    There are issues around existing transactions if BAS has been lodged etc 

    If BAS has been reported but you need to add transactions or delete transactions this will lead to amendments to the previous BAS lodgements. This can of course be done in the next BAS .

    An issue that you can deal with by running GST reports before and after you made the amendments ( You should have previous BAS reports but ensure you do)

     

    I would make sure that the bank  does balance as at the last date reconciled in 2019.

     

    Then manually reconcile month by month and year by year ( are bank feeds being used? make sure they are all matched or allocated) - go into the reconcile bank screen or reconcile from bank feeds 

     

    Enter the date you want to reconcile - the transactions relevant to that date will be shown 

     

    If they are ticked you can see if it reconciles to the statement , if they don't it may need to be manually checked to see the error. Something it is evident that there is a double up in transactions. Anyway I am sure you know what to do 

     

    Work through it and any transactions that are left once reconciled need to be investigated and dealt with

     

    Hope that helps 

     

    Lisa

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User

    Hi

    Interesting problem

     

    Are the unmatched entries older than the last reconciled date?

     

    Really you need to reconcile the bank month by month year by year

     

    There are issues around existing transactions if BAS has been lodged etc 

    If BAS has been reported but you need to add transactions or delete transactions this will lead to amendments to the previous BAS lodgements. This can of course be done in the next BAS .

    An issue that you can deal with by running GST reports before and after you made the amendments ( You should have previous BAS reports but ensure you do)

     

    I would make sure that the bank  does balance as at the last date reconciled in 2019.

     

    Then manually reconcile month by month and year by year ( are bank feeds being used? make sure they are all matched or allocated) - go into the reconcile bank screen or reconcile from bank feeds 

     

    Enter the date you want to reconcile - the transactions relevant to that date will be shown 

     

    If they are ticked you can see if it reconciles to the statement , if they don't it may need to be manually checked to see the error. Something it is evident that there is a double up in transactions. Anyway I am sure you know what to do 

     

    Work through it and any transactions that are left once reconciled need to be investigated and dealt with

     

    Hope that helps 

     

    Lisa

    • Stonegalleria's avatar
      Stonegalleria
      Experienced User

      Hi Lisa,

      Thank You for your support.

      Followed the Month-by-Month reconciliation approach.

       

      Thanks!

      Dan.