Is your Dynamics GP GL Cash Balance Right?

Originally Posted March 2012

We all know Reconciling our cash to the Bank is important, and if you are using the Microsoft Dynamics GP Bank Reconciliation Module… YOU’RE A HERO! But, it is equally important to make sure the sub-module of Bank Reconciliation (BR) balance the GL accounts for the cash in the General Ledger (GL.) Remember we can prove the BR balance, and the BR proof is the GL proof; so this is VERY IMPORTANT!

This is super easy to achieve, open the checkbook card (Cards-Financial-Checkbook) and look at the amounts in the top right-hand corner. The top one is what the bank account balance and the bottom is the GL balance. They should be the same!

If they vary there are 2 possible (non-problem) reasons.

1. The cash receipts were entered in Receivables and posted (therefore updating the balance in the GL) but not put on a deposit in BR (not updating the bank balance yet.)
2. Checks were printed in the Payables module (therefore updating the BR module) but the batch was not posted yet in the GL (not updating the GL balance yet.)

Make sure all GL batches are posted and all BR deposits are made, check your balances again. They should match now. If not, you have some research to do!

If you check this every day, you’ll keep things in balance. Making your life easier and your annual audits more painless! This is too easy of a step to do daily and it could save you hours of consultant costs and agony.

If any of you followers want more detail on where to look for discrepancies!

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.) View all posts by Belinda Allen