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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Cash Ledger to General Ledger Variance

(0) ShareShare
ReportReport
Posted on by 245

Our company uploaded prior data when we integrated into GP.  As a result, all cash entries during the integration were general entries.  Since then, all entries were used using the cash module and a general true-up was made to make the GL and the cash module to agree.  Now, almost a year later, after everyclose and all cash accounts are reconciled, there is always a variance between the GL and the Module balance.  Is there a way to true-up the GL balance to the reconciled cash module and no longer have to make general entries to the GL- meaning that they will remain in sync going forward after every monthly cash reconciliation?  Please let me know, as we no longer ever want to make general cash entries to the GL. It seems they been out of sync and we have been chasing a ghost at the end of everymonth as we know the module balance is accurate and the GL balance never agrees. Thank you

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    65,271 on at

    Make a one-time adjusttment to bring the two ledgers into balance and then go forward.

    If the out of balance amount changes month to month, something else is not being entered properly.

    Probably, the beginning balance was off. It should still be off by that amount if all cash trx were entered properly. Never making a journal entry to cash is a good plan. In fact, you should also go into Account Maintenance and uncheck the box to allow entry o the cash accounts.

    Does the out-of-balance amount change month-to-month?

    Kind regards,

    Leslie

  • Justin N Profile Picture
    245 on at

    Thanks a lot Leslie. This seemed to help.

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…

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