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 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
Hi Lisa
There is no opening balance on the account - I created the account as a clearing account so there is definitely no opening balance - please also see attached screenshot of the general ledger showing opening balance.
There is no green arrow on my reconciliation screen, so don't understand what you mean by refresh?
Please advise what you mean, thanks Lisa
I have attached a file with a screenshot and an arrow showing the green arrow
Lisa
Thanks Lisa, just learned a new skill :-) but it didn't help :-(
What should I do now?
Contact Myob direct?
Thank you so much for your help with this, I really do appreciate your time, effort and patience
