Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Bank Transaction Entry & Bank Reconciliation - 2 questions

(0) ShareShare
ReportReport
Posted on by 5

Hello,

I was doing the month end bank reconciliation and the Adjusted Bank Balance was $0.01 greater than the Adjusted Book Balance, i.e. $100.09 vs $100.08.  I didn't want to go through all the month's bank statements so I just did a Bank Transaction Entry Increase Adjustment (DR checking account $0.01, CR office expense account $0.01).  When I went back to bank reconciliation, BOTH adjusted balances were $0.01 higher, i.e. $100.10 vs $100.09.

Went back and voided the IAJ.

Then decided to find the transaction & found it: a book transfer between our 2 bank accounts was miskeyed.  This bank rec was for Account A and we have another checking account, Account B.  The Book Transfer from Account A to Account B was entered $0.01 higher than it should have been.  So I did a bank transaction entry to move the penny from Account B back to Account A (for Account A, selected IAJ with the offset as Account B).  Went back to reconcile Account A and it was back to $100.09 vs $100.08 (assuming because I voided that first bank transaction), checked the IAJ for $0.01, and reconciled it.

I moved on to reconcile Account B and it was a penny off & the IAJ I just did wasn't in the transactions list.  I entered the ending bank balance correctly & the IAJ bank transaction entry was within the cut off date.

My questions are:

1. Why was the Adjusted Bank Balance increased by the first bank transaction IAJ but not by the second IAJ?

2. Why didn't the Increase Adjustment Bank Transaction entry show up in my bank reconciliation for Account B? 

(To resolve the Account B discrepancy I just wrote the difference off to the office expense account from the reconciliation window and proceeded with reconciliation.  Wasn't really concerned since I found it and it was only a penny anyway; I am more interested in why these transactions behaved the way they did.)

Thank you very much!

Categories:
  • Sam1033 Profile Picture
    Sam1033 5 on at
    RE: Bank Transaction Entry & Bank Reconciliation - 2 questions

    Got it, thank you for your help & for the link!

  • Verified answer
    RE: Bank Transaction Entry & Bank Reconciliation - 2 questions

    The Adjusted Bank Balance is a calculation at the bottom of the bank reconciliation window.   It starts with TODAY'S current checkbook balance, so today's current checkbook balance would have been updated at the time the adjustment was posted.   And then it looks at your CUTOFF date you entered for the bank reconciliation.   If the adjustment is dated AFTER the cutoff date, then it backs it out of the balance.  However, if the adjustment is dated prior to the cutoff date, then it leaves it in the balance.  The system is just figuring out what the 'adjusted checkbook balance' was as of the cutoff date.  So it starts with today's balance and backs out all the transactions from today back to the cutoff date to arrive at a checkbook balance as of the cut off date.   Here is the KB article link on how this balance calculates: 

    http://support.microsoft.com/help/854081

    Hope that helps

    Cheryl

  • Sam1033 Profile Picture
    Sam1033 5 on at
    RE: Bank Transaction Entry & Bank Reconciliation - 2 questions

    Hi Cheryl,

    Thanks for your reply! Yes for the first instance, when it changed to $.10 and .09 I don't recall checking the IAJ; if I had checked it it would have balanced out.  I was confused why the adjustment affected the adjusted bank balance since I thought the bank's balance would be static - $0.09 was correct and we had $0.08 on our books because of an internal error.  Do you know why an adjustment would affect the bank's balance?

    For the second, I don't think I closed the window but since it showed up when I went to reconcile Account A I thought it should have shown in Account B which I did afterwards. I suppose it will show in next month's bank reconciliation and I can clear it out then.

    Thank you for your help!  I will mark this as the answer.

    **edited to add a question in the first paragraph

  • Verified answer
    RE: Bank Transaction Entry & Bank Reconciliation - 2 questions

    Hello, 

    The Adjusted bank balance amount will only be increased by the amount if you did not mark the IAJ as cleared in the bank reconciliation.  If you are carrying it as an outstanding item, then it will be added in to this balance, so you must not have marked the first one as cleared since it increased the adjusted balance, and then did mark the 2nd one as cleared if it wasn't added to the adjusted bank balance. 

    If the IAJ is in the right checkbook and before your cutoff date, and not marked as reconciled or voided (in the CM20200 table), then it should be listed on your bank reconciliation.  If you had the bank reconciliation window open, be sure to refresh it, or save/close and reopen it again to have it refresh.  Otherwise, if you started the bank recon brand new after keying the adjustment, it should be there if it's in the right checkbook, is dated prior to the cutoff date used, and is not already reconciled or voided.

    I hope that helps.   Be sure to mark any post that helps you as 'answer' to help other readers in the future. 

    Cheryl Waswick

    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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,492 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans