Professional tax calculation for Karnataka

[Former Member]

Hi friends,

Professional tax is deducting more. for those employee who comes under 15000/- salary slab. Actually for them PT should calculate 150/- but it is taking 200/-. I have checked the slabs and it is correct.

here is the details of wage types.

Employee :XYZ

/118 is reflecting twice: as 10940 and 12700

/119 is 10940

/3P1 Prof Tax - 01100103 I 200.00

/3P2 Professiona01100103 23,640.00

/3P3 Prof Tax - 200.00

/101 Total gross 12,700.00

here /3p2 should be 150/-.

what might be the problem.

Geetanjali K.A

[Vivek_V · Accepted solution]

Hi,

The Professional Tax in this case is being deducted based on salary of Rs 23640. In case this basis is incorrect then check the Cumulation Class 18 of your payment WTs. Untick this for the WTs which are not to be taken for calculating P.Tax amount.

VK

[Former Member · Accepted solution]

Hi VK.

Yes I have already checked the cumulation classes, and those are correct. And this problem is not for one employee, thi sis for all those employee who comes under 15000/- can you suggest me some other points.

Geet

[former_member583520 · Accepted solution]

Hi,

Pls check ur slabs again. I think you have mistaken there.

Thanks and Regards,

Revathi.

[sikindar_a · Accepted solution]

Check the below one

Slab rates

groupuing of ur slab rates to PSA

and is it comeing to one employe or for some other

[Vivek_V · Accepted solution]

Hi,

But in the case that you have given, the salary for P.Tax of the employee is 23640 which is not less than 15000. Check the slab for amount 23640, it must be 200.

Also you have given that WT /101 for the employee is 12700 whereas /118 or /3P2 (P.Tax Basis) is 23640 which means there are certain other amounts that are getting added to the P.Tax Basis.

As far as I understand, the basis is incorrect which is due to incorrect description of Cumulation Class 18 for your WTs.

VK

[Former Member · Accepted solution]

HI Sikindar,

Yes I have checked all configurations, and it is correct.

This problem is for all who comes under 150 slab

Geet

[Former Member · Accepted solution]

Hi VK,

Yes his salary is 12700/- and other than /3P2, all amounts are Rs.12700/- only. But only this /3P2 is coming as 23640/- Which I am not getting from where it is picking. I have checked the all probabilities.

Geet

[Vivek_V · Accepted solution]

Hi,

The value of WT /118 is also 23640 (12700 + 10940 in two splits).

Check how the value of 10940 is coming in WT /118 in the payroll log. The WT /118 is created by rule X023 which checks Processing Class 20 of the WTs.

This will solve your problem.

VK

[Former Member · Accepted solution]

HI,

I have checked with Log Tree again.. and found that /3M3 is generating, that is reflecting in /118.

As I told earlier I am getting /118 two times,

One is same as /101:Gross

and second one amount is exactly /3M3 value.

Can anybody suggest me what I have to do?

Geet

[Former Member · Accepted solution]

Hi geet,

Check for the processing class setting of the /3M3 wage types.

PCL 5 (Create net remuneration and tot ) spec 9

PCL 6 (Enter wage type from old payrol) spec 0

PCL 30 (Cumulation update) spec 2

and check if u have ticked cum class 18 for /3M3 (it shud not be checked as taken care by INPT rule).

hope it will help.

[Former Member · Accepted solution]

Hi Praveen,

I have checked that PCL's also for /3M3 also and it is same as you mentioned. any other suggestions.

Pls suggest any other possibility.

--Thanks

Geet

[Former Member · Accepted solution]

Check in 0015 for the wage types that you are using to pay medical reimbursement. Ensure that the total sum for the finacial year is 15000 and delete the excess amount.

ie ensure that in IT0015, medical reimbursement wage type will not have amount in excess of 15000. then run the payroll and check if PT is coming properly.

Regards

[Former Member · Accepted solution]

Hi,

No we are mot maintaining medical reimbursement under IT 0015. Will maintain that under 0582only and for this employee there no such record also.

Thanks

Geet

[Former Member · Accepted solution]

In 582 you mention the exemption amount. if you are not checking on a Production system, then increase the exemption amount in 582 from 15000 to 18000, and run payroll and see.

[Former Member · Accepted solution]

No for this employee there is no exemption.

Rgds

Geet

[Former Member · Accepted solution]

then create a record in exemption infotype and run payroll and check.

[Former Member · Accepted solution]

Then, can u plz explain how the /3M3 is bening generated.

One more thing, can u send me the screenshots of the RT with /118, /119, /3P1, /3P2 and /3P3.

[Former Member · Accepted solution]

Hi praveen,

Can you send me your personal ID, for that I can send you screen shots.

Thanks

Geet

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

srry posted twice by mistake so removed the second 1

Edited by: Praveen Kr Tiwari on Apr 16, 2009 8:33 PM

[Former Member · Accepted solution]

Hi Praveen,

Thanks. I have changed the rule accordingly and it is working fine.

Thanks

Geetanjali

[Former Member · Accepted solution]

Hi Gurus,

I have an issue with Ptax in karnataka too..

We have mantained the IT0008 as

Basic Pay 17,000.00

D.A. 550.00

T.L / L.L Allow. 1,200.00

Child Edu. Allow. 800.00

U.M. Allow. 600.00

Super Ann.Allow 2,550.00

LTA Basis 8,400.00

As per the Ptax slabs in Karnataka the slab that he should fall in in >15000 and hence the Ptax deducted should be INR 200.

However the tax being deducted is only INR 150 and the basis is /118 ..and the /118 WT formed is with the amount 11465, and /119 P Tax basis nominal is 28465/- (my assumption is 17000/-+11465/-)

I need to understand how is the system calculating 11465 for /118.

and hows the slab amount coming wrong for ptax (ie 150 INR instead of 200 INR)

Kindly help in this regard.

any further details needed will be provided.

[sikindar_a · Accepted solution]

hey

firstly check ur Slab rates and there ranges

next

Check the Cumulation Classes of the wage types for PT basis once

but first check the PT slabs and Groupings

[Former Member · Accepted solution]

Hi sikandar

thanks fr the quick reply the slabs are as follows

KA03 1 9,999.99 INR

KA03 2 14,999.99 150.00 INR

KA03 3 9,999,999.99 200.00 INR

Which Wage types would you want me to check?

[Former Member · Accepted solution]

H Ankush,

Pls check cumulation classes for your wagetypes which falls under PT and recheck.

Rgds

Geetanjali

[Former Member · Accepted solution]

Hi Ankush,

tell me the value of /3P2. anyway hopefully its 11465/-. Meanwhile check the cum. class 18 for all the wage types which u want for the Ptax basis (It shud be ticked)

[Former Member · Accepted solution]

Dear Pravin,

the value of /3P2 Professiona01100103 = INR 9,665.00

Also we did not change any config related to calculation the only changes that were made were for the table to maintain slabs and the assignment of the latest tax slabs.

V_T7INP4 and V_T7INP3.

Regards,

Ankush

[Former Member · Accepted solution]

Sorry the same reply was posted twice due to some errors.

I have deleted that msg.

Edited by: ankush bhagra on Apr 21, 2009 1:31 PM

[Former Member · Accepted solution]

Hi Geetanjali,

I have also a same problem.

At the end of the financial year (means in March Payroll) /3M3 wage type has been generating amt of Rs. 15000/- which same as Medical Reimb. amt provide to Employee & In march payroll that /3m3 wagetype added in PATX BASIS /3P2 because of that wrong calculation of Profession tax slab.

I have check the the INPT rule. i think which is standard one having the logic for generating /3M3 & /3RH

Actually as per my knowledge, /3M3 will generate only when you are giving more than 15000 medical reimb to employee...

Pls correct me if am wrong...

What changes can we do in INPT OR is there any other solution for the same???

Regards,

Mahesh

[Former Member]

Hi Geetanjli,

/118 is reflecting twice: as 10940 and 12700.

That means there are two splits in WPBP or Ptax. (which is not correct as /101 has 1 split)

But then how /119 has only 1 entry (that is the first one).

Plz note that the /3P2 is cumulating the 2 splits of /118 and hence generating the basis as 23640.

As per ur description basis is 12700 (same as /101).

Check the PCR INPT and INPB (or equivalent PCR in customer name range). also check for the reason why there are two /118 for 1 basis.

It wud be better if u can mention /118 and /119 entries with C1, C2, C3 splits. becaz it seems like difference of one of these.

Regards,

Praveen

[Former Member]

Hi Praveen,

this is my PCR INPB.

INPB Cumulation of PTax basis

*

B101 Bonus - Regular

INPRG? Query for PT Regio

**

ADDWT * OT Output table

10

ADDWT * OT Output table

ELIMI R3 Elim.time period ID

ZERO= NR AmtNumRteTime = 0

ADDWT /118 OT Output table

12

ADDWT * OT Output table

ELIMI R3 Elim.time period ID

ZERO= NR AmtNumRteTime = 0

ADDWT /119 OT Output table

B201 Bonus - Regular

INPRG? Query for PT Regio

**

ADDWT * OT Output table

10

ADDWT * OT Output table

ZERO= NR AmtNumRteTime = 0

ADDWT /118 OT Output table

12

ADDWT * OT Output table

ZERO= NR AmtNumRteTime = 0

ADDWT /119 OT Output table

B301 Ex-gratia - Regular

INPRG? Query for PT Regio

**

ADDWT * OT Output table

10

ADDWT * OT Output table

ZERO= NR AmtNumRteTime = 0

ADDWT /118 OT Output table

12

ADDWT * OT Output table

ZERO= NR AmtNumRteTime = 0

ADDWT /119 OT Output table

and INPT

INPT Cumulation of PTax basis

*

/3M3 Incremental Medical perk

ADDWT * OT Output table

ZERO= NR AmtNumRteTime = 0

ELIMI R Elim.time period ID

ADDWT /118 OT Output table

ADDWT /119 OT Output table

/3RH Positive diff.Rent & CLA

ADDWT * OT Output table

ZERO= NR AmtNumRteTime = 0

ADDWT /118 OT Output table

ADDWT /119 OT Output table

think it is STD only. I have not done any changes for this.

[Former Member]

Hey Geetanjali/Praveen,

Can you please give me the solution. What changes should be done to the PCR since i am facing the same problem.

[former_member583520]

Hi,

If employee data base has not updated the currect place then also some time its occur.

Thanks and Regards,

Revathi.

[sikindar_a]

Firstly did this employee has been transfered pls let us know

u are getting 50 Rs right once check the slab rates throughly is it getting to one emloyee or for some other employees too

can repaste the RT table once again