Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Bank reconciliation

Posted on by 1,600

While reconciling our bank account, I encountered a problem. In April we received a double payment from a customer in the amount of $438.60 which was sent back to the customer. I used Bank Transaction Entry window to debit and credit the same cash account for the same amount of 453.60. My A/R General Ledger balance is correct but I cannot reconcile the bank statement – on the Reconcile Bank Statement window I have the debit side of my transaction and no credit side of it.

Can you please tell me if my postings were done incorrectly and how I can correct it now?

Thank you for your help.

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Bank reconciliation

    That was absolutely one of the common mistake dealing with Check books, by doing a bank transaction, you will only affect the check book once either on the debit or the credit, the other account included on the distribution of the transaction will not affect the check book balance.

    You cash account should be just fine by now and your AR as well as you have described above. Although, if you go to check book balance inquiry, you will find that the cash account are not in balance with the check book balance. Further illustration on this common mistake can be found Bank Reconciliation - Check book versus Cash Account Balance

    Now to get your check balance corrected, you need to consider a corrective transaction on the bank reconciliation module level, to do so, it depends on one of two scenarios;

    • In case you want to increase your check balance to get it corrected, consider the deposit without receipt document type on the bank deposit window, which will increase your check book balance without affecting the general ledger.
    • In case you want to decrease your check balance to get it corrected, you need to do a bank transaction (decrease adjustment type), the second distribution should be any offset account that you need to delete after posting the transaction. Additionally, before posting the decrease adjustment, make sure to stop the (post through general ledger option) in order NOT  to affect your cash account balance on the general ledger level
    Your feedback is highly appreciated, 

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans