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 > EID

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**