Bank Reconciliation in Great Plains 2010

(0) Share

Report

Posted on by Community Member

Hi,

I am trying to reconcile our bank statements with our general ledger but while reconciling I see a few transactions that are recorded on the General Ledger are not in the bank reconciliation selection window. Therefore I am unable to select those missing transactions to reconcile completely. I know those transactions were recorded on the General Ledger as journal and brought over through an external module/subsidiary ledger but is there some way I can make them appear in the bank reconciliation window by making a change somewhere so I can select those transactions to complete my reconciliation?

Please let me know. Any help would be greatly appreciated.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

sueconrod 337 on at

Like (0)

Report

1. If these are receipts that are not appearing, you need to go in and create a deposit to match your bank deposits. (Trx>>Financial>>Bank Deposits) If that is why they are not appearing.

2. You can create Increase and Decrease adjustments in the Bank Transaction Entry window against the account. The first line of the entry goes into Bank Reconciliation, the second line of the distribution can be the same account so that it does not effect your GL but this way you get it into your Bank Reconciliation module.

Was this reply helpful? Yes No
Verified answer

Victoria Yudin 22,769 on at

Like (0)

Report
The Bank Reconciliation module will never see anything entered directly in the General Ledger in Dynamics GP. Information flows from Bank Rec to the GL, but not from the GL to Bank Rec.

If you want to be able to use the Bank Rec module to reconcile your bank statement, your options are:

Reverse the GL entries and enter the transactions in the Bank Rec module (or another subledger that flows into Bank Rec).

Enter transactions in the Bank Rec module that mimic the 'bank' side of the transactions, but use the same Cash account for the debit and credit. This will let you add these transactions into the Bank Rec module without additional changes to the General Ledger. If there are too many of these, a variation of this would be to enter one transaction for all the GL changes.

By the way, one small, but very important distinction - the Bank Rec module does not actually reconcile your bank statement to the General Ledger. It reconciles your bank statement to the Bank Reconciliation module/subledger. You will still need to perform a separate reconciliation of the Bank Rec module to your General Ledger.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thank you for your reply. This helps.

Was this reply helpful? Yes No