Belinda Allen, Smith & Allen Consulting, Inc. (SACI) aka Belinda the GP CSI.  Microsoft Professional, MCT and MVP.describe the imagedescribe the image

Belinda supports

Follow Me


If you are not a member of the Microsoft Dynamics GP Community, you should be, I am a member.

There is loads of good information, including a forum that I actively answer.

Click on this link to go to the Microsoft Dynamics Community!

Search this Blog


Subscribe by Email

Your email:

Need Microsoft Dynamics GP Forms?

Purchase Deluxe Products

Click on the image above to find your compatible Microsoft Dynamics GP forms from Deluxe For Business.

Click HERE to download Brochure.

This is all about how I use GP, based on what I learned in my investigations with clients...

Current Articles | RSS Feed RSS Feed

Microsoft Dynamics GP Bank Rec out of balance to your GL?


The following is an exerpt from the GPUG Tech Tips for August 2012.

Most Common Reasons for Variances in Balances
There are two common reasons why the Bank Reconciliation Checkbook Balance and the General Ledger Checkbook Balance do not match.

  1. There are 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.
  2. 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.

How to Find Other Variances

What are some of the other reasons that the two would be out of balance?

Coding Error: You should never manually enter the Bank Account GL account. It will always default automatically when the Checkbook ID is referenced.

  1. A General Ledger was coded to the GL account that represents the Checkbook. If you are using Bank Reconciliation, this is a BIG NO NO!
  2.   A Distribution Entry for a non-GL module was coded to the GL account that represents the Checkbook 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 window referenced above starting with the first day of the month or perhaps the first 10 days of the month and compare to the GP Report, the General Ledger Trial Balance for the same date range. Keep adding a day(s) until you find the entry that is causing the problem.

Bank Rec comparison to GL Trial Balance

Belinda (the GP CSI) Allen


Hi Belinda: I am very thankful for the great demos, helping others through many an issue. 
Please continue these series of quick demos! 
Tanks & Regards, 
Posted @ Monday, April 08, 2013 8:45 AM by David
Thanks David!
Posted @ Tuesday, April 09, 2013 6:43 AM by Belinda Allen
Hello, I have a error showing up when I am trying to add a new checkbook, when I put the account number the message that appers says: The Cash Account for a Checkbook cannot be a SPARC allocatior. Can someone help me  
Thank you  
Posted @ Friday, January 16, 2015 3:43 PM by catherine
Do you get this same error for all accounts you try to add in a new checkbook in Checkbook Maintenance or is it just with one accounht?
Posted @ Friday, January 16, 2015 5:32 PM by Belinda
It is just with the some of the cash accounts
Posted @ Friday, January 16, 2015 6:55 PM by Catherine
Can you send me a screen shot of one of the accounts that does not work and a screenshot of an account that does work?
Posted @ Monday, January 19, 2015 6:34 AM by Belinda Allen
Post Comment
Website (optional)

Allowed tags: <a> link, <b> bold, <i> italics