Forum Discussion

Stonegalleria's avatar
Stonegalleria
Experienced User
3 years ago
Solved

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 Bala...
  • LRBooks61's avatar
    3 years ago

    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