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)

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mohamed El-Tohamy 305 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

Have you checked the query(select RECOND,VOIDED, * from cm20200 WHERE TRXAMNT = '75.750')?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Please find my email : rabia@iws-e.net

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

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!!!

Was this reply helpful? Yes No
Mohamed El-Tohamy 305 on at

Like (0)

Report
Copy link

Link copied!

First no need for sir, second send me your email to send you a document that have all the snapshot and description.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

sir i cannot view the snapshots

Was this reply helpful? Yes No
Suggested answer

Mohamed El-Tohamy 305 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No