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

There are two common reasons why the Microsoft Dynamics GP Bank Reconciliation Checkbook Balance and the General Ledger Checkbook Balance do not match.

Originally Posted 7/31/2012

Microsoft Dynamics GP User Group.

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

There are two common reasons why the Microsoft Dynamics GP Bank Reconciliation Checkbook Balance and the General Ledger Checkbook Balance do not match.

Most Common Reasons for Variances in Balances
There are two common reasons why the Microsoft Dynamics GP 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.

 

Author: Belinda Allen

Belinda Allen (Microsoft MVP) is both a Microsoft Certified Professional for Dynamics GP (MCP) and a Microsoft Certified Trainer (MCT). She is also the co-founder of Smith & Allen Consulting, Inc. (www.saci.com), a business management software consulting firm for over 24 years. Belinda began implementing ERP systems so long ago that Windows was not an operating system, but an application. Larger businesses used old Main Frames with monitors that were Green and Black and smaller business did accounting by hand. Having seen the evolution that has taken place over the years from pieces of paper to analytics, Belinda still gets excited every time she helps a business improve. Belinda is also well known for her Blog www.BelindaTheGPcsi.com. Her blog is about sharing really useful information about the product quickly and succinctly. She has earned the nickname GP CSI because she excels at reviewing GP problems and figuring what went wrong and why. With followers all over the Globe she is able to share knowledge and achieve her mission: “To Improve the Lives and Business Success of my Followers.” In her time off, Belinda enjoys sailing, woodturning, crochet/knitting, sewing/quilting, reading and playing the ukulele (Belinda often participates in Ukulele Jams in NYC.)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s