Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Reconcile to GL Bank account

Posted on by Microsoft Employee

2016_2D00_02_2D00_15-10_5F00_29_5F00_38_2D00_HTOPER_5F00_255_5F00_012016-_2D00_-Excel.png2016_2D00_02_2D00_15-10_5F00_09_5F00_26_2D00_HTOPER_5F00_255_5F00_012016-_2D00_-Excel.jpgHey guys,

I am having a very difficult time getting my rec to balance to a 0 difference between the GL and the sub ledger bank module.  I am off

that is the potentially matched transactions. It doesn't have a gl side entry to it, to me that doesn't make sense. Any ideas? I matched deposits to receipts in batches, which is why those deposits are in the potentially matched and not in the matched section.  What is baffling is that there is no matched entry on the gl side. Let me know.

Update - I Figured out why there were potentially matched transactions on the left, its because my date range was from 1/1/16 and didn't go back far enough. Now im seeing that the deposit amount isn't matching the receipt amount on the deposits. Any help is appreciated.

Update 2 -

I found out that for some reason the deposit isn't matching the receipts dollar for dollar, they are off $3262 which is why it is under potentially matched. That still doesn't explain why I am roughly 10k off. Has anyone run into this? What can I do? can I create a deposit to adjust the balance? Should my subledger module match my bank account balance or should the gl module?


Thanks,

Jordan

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reconcile to GL Bank account

    Hey guys, Turns out that the reconcile to GL was never 0 to start with! a small detail that can get overlooked.  My boss thought and swore it was, but its not in the end. I am not sure what we are going to do, but probably going to create a deposit without receipt to adjust the balance to 0. Sorry for the trouble!

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