CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (20)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Hi Team,

I am working with one of Implementation and working on Bank reconciliation. I found that one of client has some excess deposits credited into Bank and Client doesn't know what this Deposit is. Previously client was doing Bank reconciliation manually and now we have implemented GP 2015R2. I am not aware how I should show this excess Receipt transactions which credited in bank account and not a part of business transaction. Please advise how it can be adjusted.

Regards,

Sanjay
Mohamed El-Tohamy 305 on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Dear Rabia,

I've updated the snapshot here and sent the document to your email, so please feedback and don't hesitate to contact for any kind of support.
Community Member Microsoft Employee on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Dear Soma, i dont have access to the sql, i have reported this to the IT dept. Once i get a solution on this i will surely update it here,

Thanks
soma 24,410 on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Have you checked the query(select RECOND,VOIDED, * from cm20200 WHERE TRXAMNT = '75.750')?
Community Member Microsoft Employee on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Please find my email : rabia@iws-e.net
soma 24,410 on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Run the below query in SQL server and attach the result. And also verify the first two columns (RECOND & VOIDED), it should be zero.

select RECOND,VOIDED, * from cm20200 WHERE TRXAMNT = '75.750'

Hope this helps!!!
Mohamed El-Tohamy 305 on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

First no need for sir, second send me your email to send you a document that have all the snapshot and description.
Community Member Microsoft Employee on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

sir i cannot view the snapshots
Suggested answer

Mohamed El-Tohamy 305 on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Dear Rabia,
You have 2 options to handle your case

Option 1:

As I noticed that you already have one journal with 75.750 if your sure that journal is wrong do the following:

1. Open SQL management studio.

2. Right click on CM20100 table then select "Edit top 200 Rows" and add checkbook in the filter for that field "CHEKBKID" and the transaction number in that field "CMTrxNum" as per the snapshot

3. Then right click on CM20200 table then select "Edit top 200 Rows" and add checkbook in the filter for that field "CHEKBKID" and the transaction number in that field "CMTrxNum" maybe you will find more than 1 line as per the below

4. To know which transaction should be deleted you can search by your amount in that field "TRXAMNT"

5. Know which "CMRECNUM" to differentiate between the other transactions.

6. Highlight the lines that contains "75.750" then delete from both tables using where "CMRECNUM" are the same in the both tables.

Option 2:
Open "Checkbook Balance" following this path Inquiry>>Financial>>Checkbook Balance then select checkbook and select in the from "Date" the first date you used the system or that module or you can make it 00/00/0000 if do you find difference in the opening balance do the following:
1. Open SQL management studio.
2. Right click on CM00100 table then select "Edit top 200 Rows" and add your checkbook in the filter for that field "CHEKBKID" your check book ID as per the snapshot

3. You will find in the highlight field the wrong balance so you need to adjust it manually and write the correct balance, then run the inquiry and you will find it solved.

Wish that this will solve your issues, I noticed that your using BHD so your a neighbor, so you can contact for any kind of support we are so near.

Thanks
Community Member Microsoft Employee on at

Like (0)

Report

RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Dear All, Appreciated your fast response. kindly please i am posting here my update to the progress. i have manually checked both the reports i.e.. the cash account GL report & the check book report. Please find below the shots & i appreciate if someone can provide appropriate solutions to the issue. Please note that the correct balance is 5.585.

1- Trial balance amount is correct i.e. 5.585

2- CBM BALANCE (the difference here 81.335-5.585=75.750)

3- GL report balance = 5.585

4- checkbook report balance = 5.585

5- there is a trx exactly with the same amount as of the difference amount 75.750, but it is appearing in both the reports i manually checked in excel. Is this something to do for that.

Your support is highly appreciated.

Thanks