web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / In Checkbook Balance I...
Microsoft Dynamics GP (Archived)

In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

(0) ShareShare
ReportReport
Posted on by Karen Kaiser 280

When I open the Checkbook Balance Inquiry, my Current Checkbook Balance is correct, it ties to my bank statement.  The Current Cash Account Balance does not equal the Current Checkbook Balance, so I did a GL inquiry, and per the GL, the Cash Account Balance DOES equal the Current Checkbook Balance.

Can anyone give me insight on where the Current Cash Account Balance number in Checkbook Balance Inquiry pulls from, and what could be causing this to happen?  I can't find any consistency in the variances (I have approximately 85 checkbooks, I stopped looking in detail after 5 of 5 had variances).  I have the same numbers reporting in the Checkbook Maintenance screen as well.

The upshot is, my GL balance IS correct, it ties to my bank statment, but whatever is populating the Cash Balance field in Checkbook Balance Inquiry is incorrect.

*This post is locked for comments

I have the same question (0)
  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at

    Could there be some unposted transactions?    The Current Checkbook Balance is the current balance (including unposted).  

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • Karen Kaiser Profile Picture
    Karen Kaiser 280 on at

    But if there were unposted transactions, wouldn't the balance per the GL be different?  My GL balance is correct, but what's being reported as the Current Cash Balance in the Checkbook Inquiry and Checkbook Maintenance screens is different that what the GL says.

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at

    If the transactions are not posted, it is not reflected in the GL balance.  The GL only reflects posted balances.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • Karen Kaiser Profile Picture
    Karen Kaiser 280 on at

    Right, so it's not that.  My GL is correct.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Karen,

    Are there any pending bank deposits? In case of deposits, GL account is updated when you posted the transaction (say cash receipt) but checkbook balance is not updated unit deposit is posted. Check Bank Deposit Entry window (Transactions >> Financial >> Bank Deposits),

    Rubal,

    http://dynamicsgphelp.com/

  • Karen Kaiser Profile Picture
    Karen Kaiser 280 on at

    When I run a GL inquiry, the cash balance is the same as the checkbook balance.  It's just in the Checkbook Inquiry that the Cash balance is DIFFERENT from the Cash balance per the GL.

  • Community Member Profile Picture
    Community Member on at

    Take a backup of the databases and Try running check links for CM Setup

    Rubal,

    http://dynamicsgphelp.com/

  • Patricia Bennett Profile Picture
    Patricia Bennett 115 on at

    Karen I have the exact situation with one of my customers. I run check links and reconcile and it did not fix the problem. If you have a solution please let me know otherwise if  I figure it out I will post the solution.

  • michelle brayton Profile Picture
    michelle brayton 95 on at

    I am not sure if this applies but the cash balance listed in the checkbook inquiry is the balance in the general ledger as of the moment of inquiry.  Even when the checkbook is filtered to an earlier point in time, the general ledger balance in the checkbook inquiry window is as of right now and not the filtered date. Additionally, the gl balance is irrespective of whether the fiscal year has been closed. In other words it does include the beginning balance of the previous year.

    If in fact you are viewing that balance in the inquiry window and comparing "apples to apples" (meaning you have no other transactions in your GL after you reconcile) then my next question is are all 85 checkbooks in the same company database?  If so, it is possible that their is an error in the SQL stored procedure used to populate the view for this.  

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 921 Super User 2025 Season 2 on at

    I came across this for the first time ever -- and I've worked with GP since 1.0 beta -- and didn't believe it until I dug into it.

    The problem was the client had a bad GL year-end close.  I needed to manually remove prior year entries from GL10110.  (The table should only have open year entries.  I previously had to clean up GL20000 and GL30000 and reconcile the financial years, but reconcile wasn't "fixing" the prior year entries that were still in the open summary table.)

    The clue was the entry was off by the amount of the current year Beginning Balance.

    Now the Checkbook's GL Cash Balance matches the GL Summary Inquiry.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans