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

Follow Me

MICROSOFT DYNAMICS GP COMMUNITY

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

Loading

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

Is your Dynamics GP GL Cash Balance Right?

  
  
  
  
  

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 everyday, 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!

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Comments

Currently, there are no comments. Be the first to post one!
Post Comment
Name
 *
Email
 *
Website (optional)
Comment
 *

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