Go AD-Free with CAclubindia Pro and Daily Mobile Updates. Subscribe Now!

Excel for kerala professional tax calculator

14 March 2014

Sir,

I belong to kerala state, for the purpose of preparing professional tax of employees i need a excel sheet for professional tax in kerala. so i request you to give an excel calculator for that.

Yours faithfully

Sreejith.K

Reply
Follow
Share

1 Replies

Arun Sathyanarayanan (Practising Cost and Management Accountan) (27 Points)
Replied 25 July 2018

Dear Sreejith,

Acording to the latest slab rates such as:-

Half Yearly Income	Half Yearly Tax
Less than 12000	Nil
12000-17999	120
18000-29999	180
30000-44999	300
45000-59999	450
60000-74999	600
75000-99999	750
1,00,000-1,24,999	1000
Above 1,25,000	1250

The formula can be calculates as: =IF(AND(T15>=12000,T15<18000),120,IF(AND(T15>=18000,T15<30000),180,IF(AND(T15>=30000,T15<45000),300,IF(AND(T15>=45000,T15<60000),450,IF(AND(T15>=60000,T15<75000),600,IF(AND(T15>=75000,T15<100000),750,IF(AND(T15>=100000,T15<125000),1000,IF(T15>=125000,1250,0))))))))

Where T15 stands for Total half yearly salary

Also pointing out the fact that salary = ( Basic+DA+All alowances+ Leaves surendered - LOP - Professional tax collected by Employer) and excludes any amount paid to Provident fund, ESI, and Labour welfare. Further pointing out the fact that Half yearly payment of tax is calculated on the basis of 3 month actual salary and 3 month approx salary, ie; On the Month of july where the tax is paid, April, May, June will have actual salaries paid and July, August , September will be approximated with the salary drawn on June. (April+May+ 4x June)

Due date for payment is July and January of every year.

Wishing a great day

CMA. Arun Sathyanarayanan

A.G & Associates

Thrissur- Kerala

........................................................................................................................................................................................

1 Like