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 / Finance | Project Operations, Human Resources, ... / Bank Reconciliation Mo...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Bank Reconciliation Module Does Not Tie to G/L

(0) ShareShare
ReportReport
Posted on by Susan B 5

Hi, we use the bank reconciliation module, and record all cash entries as either a reconciliation transaction or a bank transaction. 

(1) No variance within the Bank Rec Module:

pastedimage1615849788810v1.png

(2) G/L account is off by $887K

pastedimage1615849857906v2.png

(3) I know the main difference, which is a Purchasing item.  HATB and G/L for AP tie.  I have run all suggested fixes. If I need to book at adjusting JE to the GL, what other side do I use, since the AP subledger matches the GL?

pastedimage1615851443590v3.png

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 921 Super User 2025 Season 2 on at

    Have you run the Reconcile to GL for the Checkbook?  (Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL.)

    Was the check voided?  I find the most common issue is when a check is voided that had cleared the bank and/or there is a problem with the void date versus the GL posting date.

    [I'm unclear on some of your screen captures:  Do they account for outstanding items?  The difference in the first screen capture doesn't match the second screen capture.]

  • Leng Papio Profile Picture
    Leng Papio 855 on at

    Most likely the issue is on the dates, void date specifically.

    I suggest you look for a BR transaction on that amount, that had been cleared but voided after it got cleared or something like that...

    But if you want a quick fix and is just looking for the GL contra account for the BR transaction, usually, you can use the same Cash account so it will only affect BR and not GL.

  • Suggested answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick on at

    Hello Susan B.

    Since the Bank Reconciliation matches the Bank statement, you can't post anything in Bank Rec.  That ties.   However, the GL cash account is over by the amount of a check that you have identified.  Normally when a check is posted, it credits the GL cash account (which is what you need) and debits the A/P account, but you can't hit that because that ties to GL.  So you stated that you know you need to credit the GL Cash account, but want to know what GL account to debit?

    What you need to do is to go to Purchasing and drill back on the check, and see what GL accounts were used.   It should have credited cash and debited AP.    So if it did not credit cash, see what account was credited, and that will now be the account that you need to debit or reverse out in your adjusting JE, so you can credit Cash.     So look up what the original JE was when the check was posted and that will give you what account needs to be used as your offset.

    Hope that helps!

    Cheryl

    Microsoft Dynamics GP Support

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans