Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
