75,730
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?
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?
How does it compute the current checkbook balance based on date? All transactions checked out with nothing in transit.
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?
#1
André Arnaud de Cal...
283,860
Test role Public
#2
Ludwig Reinhard
229,831
Microsoft Employee
#3
Martin Dráb
225,155
Moderator
Share
Report
All responses (
Answers (
