Bank Rec glitch / error
I have just been attempting reconciliation of a bank account and, after numerous failed attempts, I looked back at the previous report and noticed it did not match the amount on the actual bank state...
Forum Discussion
Hi megan__,
I understand you've been dealing with reconciliation issues. No worries, let's work together to get everything back on track. On your screenshots, it should have the last reconciliation figures and it will adjust depending on the transactions ticked. If there are no modifications made from the previous date transactions, it should have the last reconciliation figures. The calculated closing balance is like your own tally based on what transactions you've marked off, but you still need to compare it with the official bank statement balance, especially for the date you're reconciling. You can also click the link here for more information. If you require further assistance, feel free to drop us a post again.
Best regards,
Doreen
Hi Doreen,
Thanks for your reply, yes you are correct it SHOULD show the previous reconciliation balance - but the system is CHANGING the balance by itself.For clarity in my document:
Screenshot 1 - shows the balance -726.32 being both the actual bank statement balance AND the calculated balance in my system after I have checked off all the transactions.
Screenshot 2 - this is after I have clicked [RECONCILE] note the 2 balances are still the same $-726.32
Screenshot 3 - this is the report generated when I click [EXPORT] after I have clicked [RECONCILE] - note the balance here has changed now $-884.31 - to reiterate no actions have been made I simply clicked RECONCILE received the "Successfully reconciled" popup then clicked [EXPORT] and the report shows a different figure to what was the figure on screen when I clicked [RECONCILE]
Screenshot 4 - this was taken when I attempted to reconcile the next period - the calculated balance should show the same as was seen in screenshot 1 & 2 - no transactions were recorded, nothing was touched anywhere in the system the balance is now just different to what it should be.
Hi megan__,
Thanks for the detailed explanation. It looks like the 'RECONCILE' button is tweaking the balance a bit, which is strange. I'd recommend going through your transactions again for any odd ones. If it all checks out, try doing a future-dated reconciliation. Just head to Banking > Reconcile Accounts > Account, set the bank statement date to December 31, 9998, and copy the calculated statement balance to the closing statement balance box. Then hit Reconcile and undo reconciliation. This should help you spot any transactions that might be hiding in the reconcile accounts window. However, if neither of these scenarios apply, you may need to visit help sites like myob.com/support or myaccount.myob.com to find MOCA, our virtual assistant. Use MOCA for immediate queries and assistance. If MOCA can't help, you'll be automatically directed to our live chat team.
Kind regards,
Shella
Thanks Shella, I have contacted support (posting for anyone else who might also have this issue) w tried the future dated reconcile / undo and she ran scripts which still did not fix the issue - it is being further investigated and I am waiting on their response. Will update the thread once it's resolved with what was the eventual fix.
