Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Reconciling Payroll to...
Microsoft Dynamics GP (Archived)

Reconciling Payroll to the GL

(0) ShareShare
ReportReport
Posted on by Q Factor 105
Is there anyone here to posts Payroll to the GL in summary and still has a process to reconcile the Payroll subledger to the general ledger? I have a customer who is having trouble with this: their payroll subledger appears to have at least one or two transactions each payrun that aren't making it to the GL. I've tried comparing the UPR30401 table to the GL20000 table, but I can't get them to match up either. Any ideas are welcome.

*This post is locked for comments

  • NelsonC Profile Picture
    NelsonC 280 on at
    RE: Reconciling Payroll to the GL

    Was wondering if you ever found a way to run a report to reconcile the pay codes to the GL?

  • Pete72 Profile Picture
    Pete72 540 on at
    RE: Reconciling Payroll to the GL

    Hello Sandip,

    Did you ever determine a way of doing this? Specifically, reconciling by paycode?

    Thanks

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Re: Re: Re: Reconciling Payroll to the GL

    Hello Q factor, (Constant ?)

    I am doing good ... Thanks much for your reply, can you give me your personal email id ?

     You can mail me at : sandipdjadhav@hotmail.com

     Thanks

    Sandip

  • Q Factor Profile Picture
    Q Factor 105 on at
    Re: Re: Re: Reconciling Payroll to the GL
    It's the UPR40500 table (UPR payroll posting accounts) - you can connect this to the UPR40600 (paycode setup) table by paycode, then pull the GL distribution detail from the ytd trx open table (GL20000).
  • Q Factor Profile Picture
    Q Factor 105 on at
    Re: Re: Reconciling Payroll to the GL
    Hi, Sandip: I hope things are going well for you. You should be able to open that report in report writer to determine what tables are behind it. You can then link by the GL account index to the payroll code master table. Constance
  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Reconciling Payroll to the GL

    No, I am not aware of any report in GP like you described.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Reconciling Payroll to the GL

    Hello,

    I am looking for report where I want to reconcile my PAYCODE Amt with GL.

    e.g. PAYCODE - OT has assign GL Account -001-01-01

    Is there any report which will give me Paycode wise GL Distribution with Date criterial ? In GP-->Payroll-->Report--History-->Distribution BreakDown History is available but it didn't show the Paycode.

    Waiting for your reply.

    Thanks
    Sandip

  • Q Factor Profile Picture
    Q Factor 105 on at
    Re: Re: Reconciling Payroll to the GL
    I don't think they've been checking these things at the time of payroll. They want to include them in their month-end processes. I will raise this issue. Thanks!
  • callen Profile Picture
    callen 4,595 on at
    Re: Reconciling Payroll to the GL

    When they post to GL, do they check the GL batch to the payroll posting report?

    Do the payroll reports match? Does the cash entry on the posting journal match the check register?

     

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