Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Issue Reconciling Cash...
Microsoft Dynamics GP (Archived)

Issue Reconciling Cashbook Subledger to GL

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

 

I am having issues reconciling my cashbook Subledger to GL, subsequent I also have a variance when Reconciling the bank statement in this case the Adjusted Book Balance is greater than the Adjusted Bank Balance.

 

Is there a way to post entries into the Subledger without affecting the GL or the Cashbook in order to correct the difference.

 

And is it correct to post a an adjusting General Journal posting to eliminate the Book and Bank Balance differences?

 

Adjusted Bank Balance $ 23,530.56 (same as Bank Statement)

Adjusted Book Balance $696,563.70
SL Ending Balance            $ 117,074.69
GL Ending Balance           $ 178,761.12

[Post edited by moderator for clarity of terminology.]

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Issue Reconciling Cashbook SL-GL

    Hi Kyle,

    Thanks for the suggestions.

    Can you elaborate on how one can post a bank transaction without posting through the G/L, is there specifics steps that needs to be followed?

  • Verified answer
    kmalone43 Profile Picture
    kmalone43 880 on at
    RE: Issue Reconciling Cashbook SL-GL

    My mind must be shot for the day as I can't put the acronym 'SL' to anything but assuming you're referring to the bank rec module...

    Is there a way to post entries into the SL without affecting the GL or the Cashbook in order to correct the difference.

    - Yes.  Try a bank deposit (positive or negative) OR a bank transaction whilst debiting and crediting the same account OR a bank transaction and NOT posting through to G/L

    And is it correct to post a an adjusting General Journal posting to eliminate the Book and Bank Balance differences?

     - Situational but sure.  You're ultimately left w/ 2 options, update bank rec or update G/L.  During the reconciliation process, there is the "adjustments" window that'd let you adjust your bank balance.  You obviously want to track down what's causing your outage before making adjustments...

    One tool that I always recommend is the reconcile to GL tool under Financial>>Routines>>Reconcile to GL.  With this tool, you can pick your cash account, your checkbook, & then view everything that hit either side to look for variances or exceptions.

    Let me know if you have any questions.

    Thanks,

    Kyle

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans