We occasionally get this question from our Microsoft Dynamics GP users: how do I post cash receipts automatically as deposits? To post cash receipts as deposits, first navigate to Administration > Setup > Company > Company. Next, click Options. Then mark the box next to “Automatically post cash receipt deposits.” Click OK, and then OK again in the Company Setup window. Please note this is a configuration per company, you will need to pick the option for each database if you have more than one database.
Once you mark this option, a deposit will be automatically created when a user posts a cash receipt or cash receipts batch from Sales > Transactions > Cash Receipts. If you post an individual transaction, the deposit amount will be in the amount for that one transaction. If you post a batch of cash receipts, the deposit will be in the batch amount. The Bank Deposit Posting Journal will print once you post the cash receipts, which can be used for the deposit to the bank.
Next, if your posting setup allows for transactional posting, when you merge your bank statement to Dynamics GP’s bank reconciliation module, your bank statement may show less deposits versus the deposits in the system. To change the posting setting to only allow users to post cash receipts by batch, go to Administration > Setup> Posting; select Sales as the series, and Receivables Cash Receipts as the Origin. Then unselect “Allow Transaction Posting.”
If you instruct posting cash receipts in batches, the bank reconciliation module in Dynamics GP may display several deposits per each deposit on the bank statement. This can pose an obstacle based on each specific need of businesses- if it does please reach out to Crestwood Support and they can help!