Dear Fellow GP Consultant,
My client has problem with Reconcile Bank Statement.
Their last reconcile was 31th July 2017, the amount still tally with their manual.
But then when they tried to do reconcile in august, they found that their checkbook is no longer balance.
There is problem with their checkbook beginning balance.
But we managed to fixed that with some scripts.
what we found out later that, turns out they have made a Reconcile Bank Statement for current checkbook in save mode.
the adjusted book balance is until now has about 1B difference with their total and checkbook balance inquiry.
Correct me if I'm wrong.
What I read about field Adjusted Book Balance is supposed to be has same amount with Checkbook Balance Inquiry.
Here is reconcile bank statement
Here are the checkbook balance inquiry and selected bank transactions
please tell me what went wrong or what table should we checked and fixed.
Thanks a lot for your attention
thanks
*This post is locked for comments
Hi Leslie,
Thanks for your feedback.
No we did not try Reconcile to GL.
because their account balance and checkbook is fine.
they only have problems in reconcile bank statement.
in my knowledge there are possibility that they void in different period.
when I do a simulation in local, adjust book balance did not tally with checkbook balance
but reconcile bank successful with no difference.
Thanks
Have you tried running the Reconcile to GL routine in Financials?
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156