Forum Discussion

JoanneMcG's avatar
JoanneMcG
Trusted Cover User
3 years ago

Calculated balance incorrect for an account

I have a clearing account that for some reason will not reconcile.

The calculated balance is -$2613.63 whereas I need for it to be nil, otherwise it won't balance.

I have undone all recs on this account, back to June 2020 but there error is still there, even though the transaction for that amount does not appear in my records until 24/11/21, and the matching record is dated 01/03/2022

Why is Myob not calculating the balance as zero?  Why is Myob showing -2613.63 instead of zero once I clear off all matching transactions?

I don't think that there is any point going back further to undo other recs, is there?

I will be grateful for any help to get this resolved, thank you

 

18 Replies

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

    Hi 

     

    Try and find the transaction by either

     

    Changing the reconciliation date to 2099 and see if it appears in the rec

     

    Do a find transaction

    in the account tab change to all accounts change date range from 2000 - 2099

     

    put in the amount and search

     

     

    If the clearing account doesn't reconcile to zero it just means that the corresponding entry has not been coded to the clearing account or has not been entered.

     

    The Calculated balance shows what is in the ledger waiting to be reconciled. But will only show transactions in the period you enter.

     

    hope this helps

     

    Lisa

     

     

    • JoanneMcG's avatar
      JoanneMcG
      Trusted Cover User

      Hi, thanks for that, and sorry for the delay in reply.

      I got Myob to run scripts through our file one night to see if that would fix the problem, but didn't.

      I did what you suggested, to 2099, but there is no wrongly dated transaction (i even changed date to 24/05/9999)

      I have unreconciled the account back to day one, and re-reconciled every month right up to today 24/05/2022.  All transactions are reconciled (my debits = my credits down the cent). When I say reconcile I don't mean that the account is reconciled, rather that all my transactions are accounted for, I can't reconcile as Myob thinks the account is unbalanced.

      The problem remains - my calculated statement balance is -$3528.62 but all transactions are accounted for.

      I don't know what to do now, any suggestions?

      If not, I will have to contact Myob direct for a solution.

      thanks in advance for any help that can be provided to me

      • LRBooks61's avatar
        LRBooks61
        Ultimate Cover User

        Hi

        it looks like the calculated balance has changed also an additional 914.99

         

        have you done a find on this amount? 

         

        is there an opening balance that was entered when the account was originally opened?

         

        I would suggest that you do a report

         

        select account tab

        detailed general ledger report

        select the account in question and change the dates to the Start date of the account to today

         

        this should bring up all the entries

        you will be able to see if there was a staring balance as it will show at the top of the page

         

        you will have debit and credit totals also

         

        i would suggest you export to excel and manually reconcile

         

        just do a sum on the debits and on the credits ( try year by year to begin) until you find where the problem starts

         if you are sure that it reconciled at a certain date do the sum for both debits and credits at that date to ensure that it does balance.

         

        move on month by month until you find the entries that have not been offset

        hope that helps

         

         

         

        lisa