Announcements
No record found.
We have a situation where you reconcile the Adjusted Book Balance does not equal the Adjusted Bank Balance.We have tripled checked all transactions and the Adjusted Bank Balance is correct. Can anyone provide some insight into what goes into calculating the Adjusted Book balance?
Richard,
Here is what the GP help guide said:
Bank Balance - The amount in this field is calculated by taking the bank statement ending balance, minus outstanding checks, and plus deposits in transit.
Book Balance - The amount in this field is calculated by taking the current checkbook balance as of the cutoff date, plus any adjustments entered using the Reconcile Bank Adjustments window.
Could you possibly have some amounts in transit or something of that nature that is causing it to be off? Did everything reconcile correctly last month?
How does it compute the current checkbook balance based on date? All transactions checked out with nothing in transit.
I have the scripts that compute the adjusted book balance. When run the number agrees with the Adjusted Bank Balance. The GP reconciliation screen is the only place where I get the incorrect figure. Is there some other table involved besides the CM20200 table?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 681
André Arnaud de Cal... 446 Super User 2026 Season 1
Syed Haris Shah 202 Super User 2026 Season 1
