CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

(0) Share

Report

Posted on by Community Member

Dear Professionals, The ending balance of the book is 5.485, after reconciling please see in the screen shot the details. The difference comes from where i am not able to understand.

I have done all the entries for the year 2014, now in the last step i.e. bank reconciliation i am facing this issue. i have checked the checkbook report & general ledger report i found no difference in both. The CBM showing a below

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report

Hello Rabia

One question, have you checked whether you have any outstanding receipts to be deposited ?

Go to Bank Deposit (Transactions > Financial > Bank Deposit). Can you find any receipts which are not deposited yet ? If so, this could be the reason for the variance.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

Which of your balance is wrong? Bank Balance(5.485)? or Book Balance(81.335)?

Please check if any GL batches are not posted in Financial module and also have a look on the below link to verify if you have missed anything.

support.microsoft.com/.../864652

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your reply sir i dont have any O/S receipts.i have even checked the GL report & the checkbook report for any variance. but nothing i found.

Does void transactions will create such difference ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi there, book balance is wrong (81.335)

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Do you have access to SQL ? Can you run some scripts ?

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

What is your GP version?

If you are in GP 2013 R2, follow the below steps to generate GL vs Bank report and check which transaction having difference in Book balance.

1. Go to MS Dynamics GP-->Tools-->Routines-->Financial-->Reconcile To GL

2. Now select the module: Bank Reconciliation, From & To date, Checkbook ID and output file path.

3. Then click process.

4. Now it will generate the GL vs Checkbook reconciliation report. Then you can find out the mismatch transactions easily.

Hope this helps!!!

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (1)

Report

This feature was added with the release of GP 2013. As I can see that version stated under this case is GP 2010.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

no sir i don't have access to the sql

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes sir, i have the version gp 2010. any other possible solutions to it.

there was one unposted trx i posted it now the cash account balance (ie the GL) seems to be ok but the check book balance showing 81.335. the difference id 75.750 & there is one CMTRX for the same amount but what is wrong with it i cannot find out

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (1)

Report
Okay then, lets break down the big problems into smaller pieces. According to Microsoft support Article ID: 864652

Here are the potential causes of such mismatch between GL and Bank reconciliation:

The outstanding information (ie. checkbook balance) was incorrect when you started using Bank Reconciliation.

A deposit was posted in Bank Reconciliation (that did not have receipts), and did not post to the general ledger.

(This is quite common)Receipts were posted to the general ledger. However, the deposit has not been made to Bank Reconciliation.

A 'Deposit to Clear' Receipts deposit was posted to Bank Reconciliation, and those receipts came from Receivables Management or from another module. In this situation, the general ledger may have been updated. However, the checkbook balance may not have been updated.

(This is common as well)General ledger transactions may still be sitting in a Financial batch waiting to be posted. However, the deposit was made in Bank Reconciliation.

The same general ledger cash account is used for more than one checkbook.

Posting interruptions occurred.

After a posting interruption occurred, the module that had the posting interruption was restored. However, the Bank Reconciliation files were not restored.

Non-cash transactions were posted to the general ledger cash account.

Posting setup was not set to post to the general ledger for the Bank Reconciliation origins.

Bank Reconciliation is not registered.

Other modules do not post to the general ledger. However, the modules do update Bank Reconciliation.

You entered a transaction to the cash account in the general ledger. However, you did not enter a transaction in Bank Reconciliation.

The cash account is coming from a customer, from a vendor, or from a employee instead of from a checkbook.

The starting checkbook balance is not equal to the last reconciled balance.

A deposit is saved. However, the deposit is not posted.

The transaction was edited in a financial batch before it was posted to the general ledger.

The same cash account was debited and credited. In this situation, the checkbook balance is updated. However, the general ledger cash account has $0 posted to it.

Timing differences; the transaction in Bank Reconciliation was posted to General Ledger with a different date.

Since you don't have access to SQL, and you don't have the reconciliation utility. You are left with a manual work around solution:

1- Go To smart list > Financial > Account transaction.

2- Filter by the specific cash account to retrieve all the journal entries recorded on this account

3- Go to Smart list > Financial > Bank Transactions.

4- Filter by the specific check book to retrieve all the transactions recorded on this specific checkbook.

5- Calculate the balances "manually" for the GL account and the checkbook, does it give the same balance on the check book maintenance window ? If not, you will have to run financial reconciliation to correct the balances. Otherwise, move to the next step

5- Manually match the GL journals from the first report with the transactions in the second report.

6- proceed with recording the corrective transaction to tie the balances between the module and the General Ledger.

Your feedback is highly appreciated,

Was this reply helpful? Yes No