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 SL (Archived) / GL out of balance at m...
Microsoft Dynamics SL (Archived)

GL out of balance at month end

(0) ShareShare
ReportReport
Posted on by dbou 195

Every month when I reconcile our operating account, the bank rec sum/detail summary will show the Cash Manager Balance as balanced, but the GL Balance is always out of balance by several hundred dollars and usually not the same amount.  Can anyone help with this?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hello,

    Is this the Cash Manager module?  (other option is the Bank Rec module (not screen))

    Verify that the GL balance you are seeing in Cash Manager>Bank Rec is the same ytd balance you see in GL>Acct History.  If not, then do this.

    1. Go into Initialization mode

    2. Open GL>Acct History screen

    3.  Change the Beginning balance at the bottom left by a small amt. Save. Change it back and save again.  In a single currency database, this updates the Curyacct table which is where the GL balance is pulled from in Cash Manager>Bank Rec.

    If the balance in GL matches the batch in Cash Manager>Bank Rec,  then there was likely a posting to the cash acct that did not update Cash Manager.

    This can happen, for instance, if you post to the cash acct on an invoice our voucher.  Or, you can make a GL entry that doesn't update cash manager.  There is a box to select in Cash Acct Maintenance that says to bring GL entries over to Cash Manager.

  • dbou Profile Picture
    dbou 195 on at

    The Bank Rec and the GL Acct. History balance are the same.  I have also confirmed the box was checked in the Cash Acct Maintenenace to bring the GL entries over to Cash Manager ( I even unchecked it, saved it, then checked again and saved).  The GL Balance is still out of balance for the 7/2014 Bank Rec.  Should I wait until August is reconciled to see if any of this has helped since I have already closed out July?

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 SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans