Friday, 22 November 2013 13:00

Why Aren't My Cash Receipts Displaying in The Bank Reconciliation?

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Often, clients will ask why a particular Cash Receipt is not displaying in the Bank Reconciliation when it comes time to close the month.  Many times, users will forget that a Bank Deposit is required before the transactions will display in the Chequebook subledger.  This is an important security step as the same person receiving funds should not be the same person depositing those funds into the bank.  Further, cash receipts are often grouped together when deposited into the bank, thus, making one single large bank transaction instead of many small transactions which may need to be reconcile.

To complete a Bank Deposit, navigate to Transactions > Financial > Bank Deposit.  In this window, you will find three Types:  Deposit with Receipts, Deposit without Receipts, Clear Unused Receipts.  We recommend all clients use only Deposits with Receipts as this forces users to perform Cash Receipts from a Customer in order to deposit funds into the Bank.  Depositing without Receipts can cause differences between the General Ledger and the Chequebook subledger due to the fact that the Bank Deposit Entry window does not have General Ledger distributions associated with it.  Clear Unused Receipts only applies to situations where a Cash Receipt should not be deposited in the Bank which can also lead to differences between the General Ledger and the Chequebook subledger.

[caption id="attachment_1518" align="aligncenter" width="300"]Bank Deposit Bank Deposit[/caption]

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Winner.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.