Troubleshooting Very High Tax on Pay Run

Modified on Fri, 30 Aug at 4:41 PM

Troubleshooting Very High Tax on Pay Run

ISSUE: Pay run is completed and one or multiple employees are experiencing extremely high taxation on the Pay Register. 

 

PAY REGISTER

A close-up of a pay register

Description automatically generated

 

Troubleshooting Steps

  1. Subject Entity Maintenance
  2. Pay Run Debug File
    1. Verify Tax section
  3. Payroll > Employee > Stat Deductions
    1. Tax Restart = Y? 
    2. Is Taxable Income being redirected to OTHER_TAX_GROSS = Y? 
  4. Check Employee Pay Records for this Pay Period to see whether Gross Tax is in REG_TAX or OTHER_TAX or a mix of both
  5. If it is a special Pay Run, 100% of Income is under OTHER_TAX_GROSS
  6. Verify Employee Position
    1. Is there one position or both, if multiple; which is Primary/Home Group? 
  7. Payroll > Employee > Recurring Payments
    1. Verify Other Payments setup correctly in SEMs

 

PAYROLL > GROUP DATA > SUBJECT ENTITY MAINTENANCE > EMP_GROUP

A screenshot of a computer

Description automatically generated

**Review REG_TAX_GROSS and OTHER_TAX_GROSS records**

 

PAY RUN DEBUG FILE > TAX Section

**Verify Tax calculations and amounts which produce Tax amount in PAYREG**

 

PAYROLL > EMPLOYEE > STAT DEDUCTIONS > EID

A screenshot of a computer

Description automatically generated

**Taxable Income from Secondary Group to OTHER_TAX_GROSS = N/A**

 

EC_EMPLOYEE_PAY_RECORDS > EID + PAYNUM

select * from EC_EMPLOYEE_PAY_RECORD

where EMPLOYEE_ID = 'xxxxx'

and PAY_NUMBER = 'YYYYNN'

A screen shot of a computer

Description automatically generated

TAX = high amount

OTHER TAX / OTHER_TAX_GROSS is basically 0 

 

STAFFING > POSITION & ASSIGNMENT > 10048 

A screenshot of a computer

Description automatically generated

**Verify Position setup, number of Positions & FTE for each (if multiple)**

 

NOTE: Employee has 1 Position, but 2 Salary Earning Codes in PAYREG

A screenshot of a computer screen

Description automatically generated

 

PAYROLL > EMPLOYEE > RECURRING PAYMENT > EID

A screenshot of a computer

Description automatically generated

**Salary was being paid from this module – Not usually a good way**

Sometimes Earning Code might be incorrect. Example: was SALARY but should be REMEDY Payment for previous years

A screenshot of a computer

Description automatically generated

**Replace SALARY with REMEDY for same amount**

 

ABORT PAYRUN > SCHEDULE > PAY RUN > PAY REG

**Verify if Earning Code has updated & if Tax has normalized**

Assuming Tax is still high, check what results occur if Recurring Payment is deleted

  • Does this normalize the Taxation?
    1. If so, perhaps Subject Entity Maintenance issue

 

ABORT PAYRUN > DELETE REMEDY PAYMENTS > EID

A screenshot of a computer

Description automatically generated

**REMEDY payments are deleted**

 

DELETED REMEDY PAYMENTS > RERUN PAY REGISTER

A screenshot of a document

Description automatically generated

**Tax amounts normalize**

This indicates a Subject Entity Maintenance issue where Other Payments > Remedy is being mishandled

NOTE: Important to remember to input the REMEDY payments back in, removing them was simply to see if the system would generate any change

 

PAYROLL > SUBJECT ENTITY MAINTENANCE > EMP_GROUP

A screenshot of a computer

Description automatically generated

FIX: Delete the REG_TAX_GROSS + REMEDY line

Its telling HRP to include it twice in taxable income

 

A screenshot of a computer

Description automatically generated

 

RE-ADD REMEDY PAYMENTS > DELETE SEM RECORD > RE-RUN PAY > PAY REG

A screenshot of a computer screen

Description automatically generated

**Tax has completely normalized**

 

 

 

 

 

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article