Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GL reconciliation to B...
Microsoft Dynamics GP (Archived)

GL reconciliation to Bank Balance

(0) ShareShare
ReportReport
Posted on by Paula Camara 40

I have a client with cash payments being imported as well as internet payments being processed.  In GP they enter the Payable at month end and on the voucher entry window enter the cash payment for the next month.  This is causing a considerable difference in the reconciling difference between the GL balance and the Bank balance at month end.  Shy of enterin th liability and posting and then a step 2 of entering the payment is there a work around in GP to show the liability for one month and the payment in another?

 

Thanks

*This post is locked for comments

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Re: Re: GL reconciliation to Bank Balance

    Aha - accruals the way they're supposed to be used!! :)

  • Paula Camara Profile Picture
    Paula Camara 40 on at
    Re: Re: GL reconciliation to Bank Balance

    Thanks Frank.  I was hoping there was some little "trick" that would allow them to enter and pay at once.  They did not want to enter accruals at month end...C'est la vie!

    My workaround was to have them enter an accrual entry and them enter the entire entry the following month and have the reversal of the accrual take care of the expense account for them.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: GL reconciliation to Bank Balance

    Are they changing the date on the payment (blue expansion arrow) to the subsequent month?  If so, then the transaction posting to the cash account is going into the GL on the date that the Payables transaction is being posted but the payment transaction isn't hitting the checkbook until the following period.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans