GL is showing correct balance for Bank Account however, Bank Rec is out by $3047.95

Question

If I do a jnl it effects the Ledger and this becomes unbalanced but the Bank Rec balances ? how can this be ??

I have 'undone' ALL the Bank Recs and there is an amount in the Bank Rec tab of $3,047.95 ? how can this be when the Ledger is Zero ! serious problem - can someone please assist asap as we are Accountants and this is one of our clients MYOB file inwhich I would like to show them 'How to Reconcile' but obviously cant with this problem.

Bank Rec Unbalanced.PNG

Shella_A · Answer

Hi @Katie28,

Thanks for the response,

My apologies for the late reply. We recommend checking the General Ledger report from the conversion date month and year until 01/01/9999. This process will show us if there is a transaction for that chart of accounts. You may also check the opening balance of the account as well.

If you still find a discrepancy, let me know, or please provide a screenshot hiding important details. If there's none, then it means that your general ledger report is all good.

Kind regards,

Shella

Katie28 · Answer

HI Shella,

Thank you for your Reply.  However, I have checked that there isnt any Unallocated transactions going back from 2018 to 2023 and everything has been allocated, so this isn't the problem.  I can only ascertain that maybe when the Accounts were rolled over the balance has got caught up in that incorrectly somehow.  Is there anyway that MYOB Help Desk behind the scenes can fix the Bank Reconciliation screen manually ?

thank you,

Shella_A · Answer

Hi @Katie28,

I hope this message finds you well today. I just wanted to follow up if you're still having difficulties dealing with your bank account transactions. If you still need assistance with this, please don’t hesitate to reply, as we’re always delighted to assist you further.

Otherwise, if my response has answered your inquiry, please click "Accept as Solution" to help other users find this.

Kind regards,

Shella