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) / Adjusted Bank Balance ...
Microsoft Dynamics GP (Archived)

Adjusted Bank Balance Incorrect

(0) ShareShare
ReportReport
Posted on by TKu 80

I'm not sure if my problem is unique or not, but when I'm reconciling my bank accounts, every account works fine except for one.  Regardless of the number that I put in, in the "Bank Statement Ending Balance" it always comes up with the amount of my unchecked transactions.

 To clarify, for example:  I have 2 uncleared transactions for $20 and $30 respectively.  My bank statement has the account at 0, so i put in 0.  Instead of having the "adjusted bank balance" show up as zero, it shows up as 50.  This particular account is the only one that does this. 

 Any ideas?  Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Clear the 2 transactions.  Your adjusted bank balance will then be zero.

  • TKu Profile Picture
    TKu 80 on at

    Sorry, I think what I failed to mention is that, it throws off the "Difference" column.  Here's a graphic of what I mean:

     

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    The difference should change.  The 'Adjusted Bank Balance' is the total of your bank statement balance plus deposits in transit minus outstanding (uncleared) checks.  The 'Adjusted Book Balance' is the balance in your checkbook plus any adjustments (bank fees, etc).  The Difference is the difference between the two.  So, if the Adjusted Bank Balance changes, the Difference will change.  When the difference is zero, your bank statement and checkbook are reconciled.

    Does that help?

  • TKu Profile Picture
    TKu 80 on at

    Hm, I think we might be just slightly missing each other.  I understand what you're saying though and thank you for that.  I guess my main problem is, when I type in the Bank Statement balance in the reconcile window, it does not show up properly in the transaction window. 

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Sorry, I'm a little 'thick' sometimes.  I see what you're saying now, I think.  The reason the numbers are different is because the 'Adjusted Bank Balance' reflects the Bank Statement balance PLUS any uncleared transactions.

    Is this a ZBA account where transactions are cleared daily, by chance?  If not, I'm not sure why you would ever see the Adjusted Bank Balance equal to the Bank Statement balance, as you seem to infer about your other accounts.  Are you other accounts ZBA accounts where the transactions are cleared daily (or at least cleared prior to you running the Bank Rec)?

  • TKu Profile Picture
    TKu 80 on at

    Ok, mystery solved.  What happened was complete and total human error during the entry process.  Thanks for going through all this with me.  I'll be sure to double check the human side of the issue first next time.  Thanks again!

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Aha!  PICNIC!!

    Problem In Chair Not In Computer :)

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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans