Monday, May 11, 2009

Unacceptable Tax Balance Report

The Unacceptable Tax Balance Report identifies employees with
potential incorrect withheld amounts for the following taxes:

• Federal Tax:- FIT, Medicare, SS, FUTA
• State Tax:- SIT, SUI, SDI
• Local Income Tax (LIT)

This report identifies incorrect withheld on following conditions

Tax Type
Possible Warning Messages
FIT FIT gross earnings <> FIT reduced subject whable

FIT reduced subject whable = 0 and FIT withheld > 0

FIT subject whable <= 0 and FIT withheld > 0

FIT subject whable <> FIT reduced subject whable

FIT gross earnings not = Medicare taxable + Section 125 pretax + Dependent care +401k pretax
FUTA FIT gross earnings <> FUTA taxable
Medicare FIT gross earnings <> Medicare EE taxable

Medicare EE withheld not equal to Medicare ER liability

FIT gross earnings not equal to Medicare taxable + Section 125 pretax + Dependent care +401k pretax
Social Security FIT gross earnings <>Medicare EE taxable

SS EE withheld not equal to Medicare ER liability
SIT SIT subject whable <= 0 and SIT withheld > 0

FIT subject whable <= 0 and SIT withheld > 0

SIT subject whable <>SIT reduced subject whable

FIT subject <> SIT Subject

Ensure SIT Withheld = 0 when State has no SIT withheld rule
SUI SUI EE/ER sbject whable <=0 and SUI EE/ER witheld > 0

FIT gross earnings <> SUI ER taxable

FIT subject whable <= 0 and SDI EE/ER withheld > 0
SDI FIT gross earnings <> SDI EE taxable

SDI EE subject whable = 0 and SDI EE withheld > 0

FIT subject whable <= 0 and SDI EE/ER withheld > 0
LIT LIT subject = 0 and LIT withheld > 0

FIT subject whable <= 0 and LIT withheld > 0

LIT subject whable <>LIT reduced sbject whable


SS Withheld does not = 6.2% of Taxable Balance
Medicare Withheld does not = 1.45% of Taxable Balance
FUTA Withheld does not = X% of ER FUTA Liability (X = value derived from JIT)
SUI Withheld does not = X% of SUI ER Liability (X = value derived from JIT)
SDI Withheld does not = X% of SDI Liability (X = value derived from JIT)

This report is really helpful at year end and should be run. All the error messages in report output should be resolved before running year end preprocess.

No comments:

Post a Comment