web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 107
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

I have the same question (0)
  • callen Profile Picture
    callen 4,595 on at

    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?

     

  • Q Factor Profile Picture
    Q Factor 107 on at
    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!
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    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

  • L Vail Profile Picture
    L Vail 65,271 on at

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

  • Q Factor Profile Picture
    Q Factor 107 on at
    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
  • Q Factor Profile Picture
    Q Factor 107 on at
    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).
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    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

  • Pete72 Profile Picture
    Pete72 540 on at

    Hello Sandip,

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

    Thanks

  • NelsonC Profile Picture
    NelsonC 282 on at

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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans