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
Just realized you already had your answer ... whoopsies!
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.
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.
If it is the same department/position/paycode, yes.
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?
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!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (