Payroll - QTD Information does NOT match total of Checks

Posted By SageUser_001 over 8 years ago

MAS 100 - P/R Module - Level 5

I am reconciling for quarter end.

When I run a Perpetual History Report, the total (for one fixed amount deduction) for one employee does not match the QTD total (for the deduction) within the "Voluntary Deduction Maintenance."

I have verified all of the other QTD Information in the Employee Maintenance fields (Gross, Fed Taxes, FICA taxes, State taxes..and other voluntary deductions) and all of the other items tie to the penny.

I do not see a place to verify the net check QTD, so I am unable to verify this.

If the net check ties...... then I would think I have a fairly large issue inside the database since the amounts will not balance.

Any ideas on how to fix this?

0 TomTarget over 8 years ago

Do the totals for the perpetual history report show an amount less than the summarized QTD total in the employee's deduction maintenance?

I have seen one instance where a record (for medicare wages or withholding I think) was missing from the perpetual history files. Probably a corrupted record that then got removed from the file during a rebuild key files.

In that particular case I had to assume that the QTD totals were OK in which case I didn't fix anything.

If you can identify a check from the perpetual history report which seems to be missing an expected deduction, go back to your copies of your payroll data entry audit report for the payroll in question to verify and confirm.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Gina Thompson over 8 years ago

You can use the Payroll Check History report to compare the Net Check amount, located under the Payroll > Reports menu.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 SageUser_001 over 8 years ago in reply to Gina Thompson

Thanks for your reply Gina. I may have been unclear. Report wise, I have the net check amount on the Perpetual History Report. However, under the employee (maintenance) record I do not have an item to compare it to.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 SageUser_001 over 8 years ago in reply to TomTarget

The Perpetual History Report is a lower amount. The lower amount is the correct amount. For some reason, the Employee Maintenance field is higher.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Gina Thompson over 8 years ago in reply to SageUser_001

Did you look at the Quarterly Pay Period Recap report, it will not show each employee but will break out totals (including net check amount) by pay period and also by department?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Payroll - QTD Information does NOT match total of Checks

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING