Bank reconciliation opening imbalance
Hi Tracey_H , got another one... trying to reconcile a clients bank and since the last one done 30/6/2021, somethings happened to the Calculated Balance since the previous reconciliation. Every time ...
Forum Discussion
Hi
the imbalance is due to an entry prior to the closing date , so trying to reconcile going forward will always have that balance
can you do a find transaction on the amount and see if you can locate the amount
it looks like a deposit which has possibly been doubled up
so look backwards not forwards
hope that helps until Tracey gets back to you
Lisa
Thanks LRBooks61 but no couldnt find that amount as a prior transaction. I dont get why it changes the previous reconciled Calculated Closing Balance, yet in the prior year Balance Sheet its the correct reconciled amount, and none of the prior year balances have changed.
Its very odd. Hope Tracey_H can help.
Thanks again
Darren
Hi Darren
Can you do a future dated reconciliation, then undo it and check if the calculated balance refreshes.
If that doesn't work go to Reconcile accounts, enter statement date same as opening balance date in the file and check if the calculated closing balance is correct. Also check the calculated closing balance with the statement date entered as 1 day before the opening balance date.
In Bank Transaction screen, filter by the bank account and unallocated transactions for wider date range and check if there are any unallocated transactions before the last reconciled date.
If those steps don't find the issue, send me the serial number in a private message and I'll have a look into it for you.
