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 ac...
Forum Discussion
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
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
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
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
