Bank Reconciliation Book balance different than Bank Balance

(0) Share

Report

Posted on by Richard Wheeler

75,842 Moderator

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?

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (0)

Richard Wheeler 75,842 Moderator on at

Like (0)

Report

RE: Bank Reconciliation Book balance different than Bank 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?
Richard Wheeler 75,842 Moderator on at

Like (0)

Report

RE: Bank Reconciliation Book balance different than Bank Balance

How does it compute the current checkbook balance based on date? All transactions checked out with nothing in transit.
RJarrell 303 on at

Like (0)

Report

RE: Bank Reconciliation Book balance different than Bank 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?