0
Former Member
Jun 30, 2010 at 11:08 AM

# Issue with Tax calculation on Bonus

213 Views

Hi Friends,

1. Configuration has been done for off-cycle payroll run

2. Created wage type for bonus and included in table V_T7INA9 as per the allowance grouping of the employee

3. Wage type mapped for Tax Code SBON in table V_T7INT9.

4. In table V_T511K value for BNTDS maintained as 30%

5. Infotype 0267 maintained with bonus amount.

When running through off-cycle it's working fine and also deducting 30% of tax at source for all the employees grouped under allowance grouping.

Say an employees who is getting bonus Rs 50,000/- and for him the tax is getting deducted in Off cycle Payroll itself as per the requirement. Tax deducted is 15000 which is 30% of bonus amount 50000. Till here its fine.

Now when I run the regular payroll the tax deducted in off cycle run is cumulated in /456 u2013 tax deducted so far. Hence for the current month it is showing Tax Payable u2013 Tax Deducted / Projection factor. This is wrong. I do not want the tax deducted in Off Cycle run to get accumulated in /456 u2013 tax deducted so far wage type.

How can we handle the situation please guide me.

Eg

For April Month

/458 Net Tax Payable is 9847

460 Income tax for April is 9847 / 12 = 821

On 15 May Bonus is Paid i.e 50000 via Off Cycle

Value for BNTDS maintained as 30% so tax deducted is 15000

For May Month Regular Run

Bonus Paid is added in Irregular Income u2013 50000

Tax Payable is 14997 as bonus is added to Irregular income

/456 Tax Deducted so 15821 (i.e tax of april 821 + tax on bonus 15000)

Income tax for the month 14997 u2013 15821 / 11 (projection) = - 824

Since it is negative value /460 monthly tax is not generating which is wrong.

Actually /460 for May should be 821.

Please Guide me solve this problem

Regards,

Koutilya A.K