<
🧾

Bulk Professional Tax (PT) Calculator

Upload your employee list and download state-wise Professional Tax for every employee

βœ” 100% Free  β€’  βœ” Instant results  β€’  βœ” Processed in your browser β€” data never leaves your device

Step 1 β€” Download Input Template

⬇️

Download the Excel template, fill in employee details, then upload it below.

Columns in your file:
employee_id employee_name location gender gross

location must match a city name in our database (see the Cities sheet in the template)
gender accepts: male, female, other (blank is treated as male)
gross is the monthly gross salary in β‚Ή and is used as PT wages

Step 2 β€” Upload Filled File

⬆️
πŸ“

Drag & drop your Excel file here, or click to browse

Supports .xlsx and .xls files

Step 3 β€” Calculate & Download

⚑

How It Works

πŸ“–
1
Download & Fill the Template

One row per employee: ID, name, work location, gender and monthly gross.

2
Upload Your File

A preview shows your data and flags unknown locations, invalid gender values or bad gross amounts before processing.

3
Calculate & Download

The city is mapped to its state and PT is picked from that state's slab for the employee's gender and gross. Rows with issues are marked ERROR; everything else is still calculated.


Output Excel:
πŸ“„ PT Results
Employee IDNameLocationStateGenderGrossProfessional TaxSlab AppliedStatusRemarks
πŸ“Š Summary by State
EmployeesEmployees with PTTotal Monthly PT