“What isn’t tried won’t work.” – Claude McDonald
Has your Microsoft Dynamics GP General Ledger Cash Account Balance not matched your Bank Reconciliation Checkbook Balance before and you weren’t sure where to look?
Here are 4 common reasons why they might not add up and things you might want to try for a solution to this problem.
Unposted batches in the General Ledger. There are some transactions (e.g. Payables Management Computer Checks) that post to both the Bank Reconciliation and the General Ledger. When these items are posted in their originating module, they automatically post in Bank Reconciliation affecting the balance; HOWEVER, depending on how you have your posting options setup, they may sit in an unposted batch in the General Ledger. This is easy to solve: Simply post your batches in the General Ledger.
Deposits haven’t been created in the General Ledger. This is a similar scenario to the previous reason, but somewhat in reverse. When payments received are entered in Receivables Management, Sales Order Processing and as receipts in Bank Reconciliation, they are sent directly to the General Ledger but placed in a holding spot to be entered on a deposit. Why? For easier bank balancing (and easier bank transactions analysis). Deposits in the Bank Reconciliation module should match the actual deposits with the bank. However, the General Ledger module may need to be setup to show the detail of receipts or set to “summary” depending upon your needs or desires. The solution: Check your Bank Deposit Entry window for any receipts not deposited.
Coding Error: You should never manually enter the Cash GL account. It will always default automatically when the Checkbook ID is referenced.
- A General Ledger journal entry was coded to the GL Cash account. If you are using Bank Reconciliation, this is a BIG NO NO!
- A Distribution Entry for a non-GL module was coded to the Cash GL account for a line other than CASH for the Distribution Type. Also a BIG NO NO!
Date Error: Document dates and the GL posting date span different fiscal periods. To find errors, pull up the Checkbook Balance Inquiry and compare to the General Ledger Trial Balance for the same date range.
I hope you find these 4 reasons useful and my tips helpful. I also invite you to download an upbeat and engaging new white paper, “25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics ERP”. This report includes 25 examples from real companies – from non-profits to distributors and many in between.
For a high level estimate of your investment in Microsoft Dynamics GP, please use our “FREE” Microsoft Dynamics GP Quick Quote Tool. It will give you a great starting point for assessing your potential investment in a project like this.
If you have additional questions or would like to learn more about what Microsoft Dynamics GP can do for your organization, please contact us today to setup a “Free Discovery Call” at 636-237-2280 or email at email@example.com .
By Michael Ramatowski, at Turnkey Technologies, Inc. – Missouri, Illinois, and Kentucky Microsoft Gold Certified Dynamics GP and CRM Partner
February 28, 2013 by Turnkey Technologies, Inc.