Determine why payroll is posting to an account

(0) Share

Report

Posted on by Community Member

We have one employee in one company that keeps having an inconsistent dollar amount post to a clearing account. I'm trying to figure out how to track this down. I've been manually looking at each deduction and payroll code to ensure something is not falling into the catch all posting account, but I cannot see it if it's there.

Is there a report or SQL script to run showing where/why payroll dollars are going to the various GL accounts?

Thanks,

George

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Sherlene Sorenson 967 on at

Like (0)

Report

Hi George,

I would start with looking at the Reprint Check Posting Register and search for the account number of your suspense account. Find the employee(s) who have items posting into that account and determine if there is a pattern, but looking at the Inquiry >Payroll >Check History, look at the Transactions on the check to see if the amount for that employee matches up to anything exactly from the check transaction detail. You can also view the Distributions from the Check History window. If nothing matches exactly, analyze each distribution of the check.. it is likely a DR for Employer Share of Benefits or Employer Share FICA taxes. Those items are using a proportional Department and Position Split to post to, dependent on where Gross Wages posted. Hope this helps!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sherlene,

Thank you for the suggestions. The amount does not match up to anything I can find. I will look into the DR for Employer Share of Benefits and Employer Share of FICA, but I have other employees with the same department and position, so wouldn't they be effected as well?

Was this reply helpful? Yes No
Sherlene Sorenson 967 on at

Like (0)

Report

If it is the same department/position/paycode, yes.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

We found the problem. Our person doing the payroll had some entries in a saved batch. Seems that batch was created before some changes were done to the position/dept info on the employee card, so it was using the old info.

Sherlene, thanks for the tip in looking at the Distributions from the Check History. That helped us track it down.

Was this reply helpful? Yes No
Suggested answer

Thomas Franz 1,105 on at

Like (0)

Report

One thought ... You can turn on detail posting long enough to troubleshoot the issue.

Go to Tools > Setup > Posting > Posting

Series: Payroll

Origin: All

Select to "Post in Detail"

Select to Save

Build & Calculate a payroll for the affected employee

Go to Payroll > Transactions > Posting Edit List

Filter the page to the affected employee

This may help you identify the pay code, deduction, benefit, tax, etc. that is causing the issue.

Good luck!

Tom Franz

Product Manager

Integrity Data, Inc.

Was this reply helpful? Yes No
Thomas Franz 1,105 on at

Like (0)

Report

Just realized you already had your answer ... whoopsies!

Was this reply helpful? Yes No