Get HR Software

No Tags Found!


How Do I Calculate Professional Tax in Excel for Different Income Brackets?


Dear all, Now P.Tax is Rs.1 to 9,999 is zero, 10,000 to 14,999 -Rs.150, 15000- above Rs.200 Then how can i calculate in excel sheet?
From India, Bangalore
Acknowledge(1)
Amend(0)

Enclosed the PT Slab along with the formulae in excel.
From India, Chennai
Attached Files (Download Requires Membership)
File Type: xls PT Formula.xls (17.5 KB, 513 views)

Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.

Other Discussions That May Be Relevant
Professional tax calculation and gujarat pt slab analysis
Professional tax hello all please let me know a professional tax calculation example according to gujarat state. i want to know whether pt is calculated on gross income or net...
9 Replies 0 Files 5 Participants
Professional tax slab calculation for maharashtra: guidelines and comparison
Dear seniors please provide the details for the current year pt slab details. thanks laxmi...
2 Replies 0 Files 3 Participants
Professional tax registration procedure for multiple branches in gujarat
What is the procedure for the registration of a pt in gujarat? if there are 5 branches rajkot surat vadodara ahmedabad bhavnagar in gujarat can we register separately for each...
2 Replies 0 Files 3 Participants
Insights on professional tax calculation, pt registration, and labor welfare fund
Hi i am seeking anybody s kind attention in this regard. our company is registered under the p.t. act in the month of november though we started functioning in september....
11 Replies 0 Files 7 Participants
Effective excel formulas for salary deductions: pt and esic calculations
Dear hr members i am working on salary calculations in excel and require assistance with formulas for calculating pt and esic deductions. if the gross amount is more than 5000...
2 Replies 0 Files 3 Participants
Understanding professional tax deduction for new employees: calculation and guidelines
Hi everyone i am confused about one thing regarding pt for new employees. we have two new employees in the month of february and according to my company s accounts...
2 Replies 0 Files 3 Participants
Understanding professional tax calculation and due dates for payment in india
Hi friends can anybody tell me the procedure for the calculation of professional tax? thanks in advance. regards skg...
3 Replies 0 Files 3 Participants

Related Files & Downloads Shared By Members
 Professional Tax SLAB[AI].pdf
 PT - Company Tax - Slab - TN.JPG
 Professional tax hyderabad.doc


Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 440814)

India, Bangalore
25 November 2012 12.53.50 AM
Views: 18176 Replies: 1 Appreciations: 2
Professional Tax Calculation
Understanding Professional And Income Tax Calculation Methods With State Variations
How To Calculate Professional Tax? - Xls Download
Professional Tax Calculation [Thread 81903]
Professional Tax Calculation [Thread 260507]
Professional Tax Calculation [Thread 51672]
P Tax Calculated On CTC Or Gross Or Net Pay

Excel Spreadsheet
Attendance Sheet In Excel - XLS Download - Employee Attendance
Comprehensive Guide To HR-MIS Report Format And Preparation In Excel
Effective Strategies For Enhancing Employee Engagement Through Excel Spreadsheets: Part 3 - Comprehensive Guide With Practical Solutions
How To Calculate Attrition - Xls Download
Efficient Training Record Keeping With Excel Spreadsheet And Training Tracker
Effective Employee Leave Management With Leave Tracker Excel Spreadsheet






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.