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/2022Why 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

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 transactionin 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

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

Hiit 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 tabdetailed general ledger reportselect the account in question and change the dates to the Start date of the account to today this should bring up all the entriesyou 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 offsethope that helps lisa

Hi Lisa, thank you for your response. The detailed ledger report opening balance as zero, shows debits and credits matching, and balance of the account as at 25/05/2022 is $0.00 - so everything looks good from that view. The reconciliation won't balance though, the calculated statement balance is still -$3528.62 but should be zero.Myob won't let me complete the reconciliation due to this. Please see attached file, it shows two snapshots: first is the rec screen, the second is the bottom of the detailed ledger report. Any suggestions?

Hi Yes indeed it all looks perfectly okay The balances all match up It looks like you have unreconciled the entire account as the GL ledger and the reconciliation figures match You said the starting balance of the gl detail report showed zero also Could you go into the gl account and just check that an opening balance was not entered when the account was created. Somethimes a refresh in the reconciliation field ( green arrow) can solve a balancing issue too. ( this has worked for me in the past when I was about to pull my hair out!!) Try refreshing the screen and see what happens. it's odd that the out of balance figure has changed too. Let me know how that goes Lisa

Calculated balance incorrect for an account

LRBooks61
Ultimate Cover User
3 years ago
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
  Trusted Cover User
  3 years ago
  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
    Ultimate Cover User
    3 years ago
    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

Forum Discussion

Calculated balance incorrect for an account

Looking for something else?

Related content

Calculated Statement Balance is incorrect

Reconcilation - Calculated Statement Balance is incorrect

Calculated Statement Balance is incorrect from the very beginning

Sick Leave Calculator percentage showing incorrect

The Historical Balancing account balance is incorrect

Long Service Leave Incorrect Balances

Multiple account balances incorrect

Calculated balance differs to closing statement balance