CTC Salary Structure Calculator Free Excel Template for Indian Businesses

Enter any CTC amount. Get the complete salary breakup Basic, HRA, PF, ESI, Gratuity, Professional Tax, and exact in-hand salary. Updated for FY 2025-26. Works for every industry.

Enter CTC, get instant in-hand salary with full component breakup
Old vs New tax regime comparison see which saves more for each employee
Team salary register for up to 50 employees in one sheet

No spam. Instant download link to your email.

Petpooja presents

CTC Salary Structure Calculator

For Indian Businesses

Sheets · Excel template

FY 2025-26

What's Inside

Six sheets covering every part of your salary structure.

CTC-to-In-Hand Calculator

Enter annual CTC and select your state. The sheet auto-calculates monthly and annual in-hand salary after all deductions PF, ESI, PT, and TDS.

Full Salary Component Breakup

Basic, HRA, Special Allowance, Employer PF (3.67% EPF + 8.33% EPS), Employer ESI (3.25%), and Gratuity provision (4.81%) every component with its formula visible.

Team Salary Register (50 Employees)

Bulk view with per-employee CTC, gross salary, all deductions, and in-hand salary. Use for payroll budgeting, offer letter preparation, or annual salary reviews.

Old vs New Tax Regime Comparison

Side-by-side tax calculation under both FY 2025-26 regimes. Factors in standard deduction (₹75,000 New / ₹50,000 Old), 80C, 80D, and HRA exemption.

State-wise Professional Tax Table

All 28 states covered with correct PT slabs, monthly deduction amounts, and legal references to respective state PT Acts.

Instructions + Assumptions Sheet

Clear documentation of every formula, every assumption, and every statutory reference used. No black-box calculations everything is transparent and auditable.

Why This Matters

The CTC Confusion Every Indian Business Owner Faces

You post a job with "CTC ₹4,00,000 per annum." The candidate asks, "What's the in-hand?" You open a calculator, punch some numbers, and still aren't sure if you've accounted for PF, ESI, Gratuity, and Professional Tax correctly.

Every month, thousands of Indian business owners from restaurant chains in Mumbai to garment factories in Surat face the same question: how much does an employee actually cost, and how much do they actually take home?

The gap between CTC and in-hand salary in India ranges from 12% to 35%, depending on the salary level and structure. For an employee with ₹6,00,000 CTC, the in-hand could be ₹5,28,000 or ₹4,50,000 depending entirely on how Basic salary is set and whether PF is capped at ₹15,000.

Getting this wrong creates real problems. Offer a candidate ₹5 lakh CTC, and if they expected ₹38,000/month in-hand but get ₹33,000, you start the employment relationship with disappointment. Set Basic too low to inflate take-home, and you risk non-compliance with minimum wages under the Minimum Wages Act, 1948. Set Basic too high, and PF contributions increase great for retirement, but the employee complains about lower take-home.

This calculator removes the guesswork. Enter CTC, select Basic %, choose the state for Professional Tax, and the entire structure calculates automatically. All statutory rates PF (12% employee, 12% employer split as 3.67% EPF + 8.33% EPS), ESI (0.75% employee, 3.25% employer for gross up to ₹21,000), Gratuity (4.81% of Basic) are updated for FY 2025-26 with references to the respective Acts and EPFO/ESIC notifications.

Sample Preview

What the calculator shows for a ₹6,00,000 CTC.

Here's a preview of what you'll get inside:

Basic Salary (40% of CTC): ₹2,40,000/year | ₹20,000/month configurable between 30-50% with a dropdown

Employer PF (12% of Basic): ₹28,800/year split as ₹8,808 to EPF (3.67%) and ₹19,992 to EPS (8.33%, capped at ₹15,000 Basic)

Employee PF Deduction (12% of Basic): ₹28,800/year | ₹2,400/month deducted from gross salary

Professional Tax (Maharashtra): ₹2,500/year ₹200/month for 11 months + ₹300 in February, per Maharashtra PT Act

Net In-Hand Salary: ₹44,030/month | ₹5,28,356/year highlighted in green with "This is what reaches the bank account" label

... plus HRA, Special Allowance, ESI (if applicable), Gratuity, TDS, and Old vs New regime comparison across 5 sheets.

Key Stats

Why CTC breakup accuracy matters.

12-35%

The gap between CTC and in-hand salary in India depending on Basic % and applicable deductions. Without a calculator, most businesses estimate this incorrectly.

Source: Statutory deduction calculations based on EPF Act 1952, ESI Act 1948, Payment of Gratuity Act 1972

₹15,000/month

PF wage ceiling employer PF is mandatory on Basic wages. If Basic exceeds ₹15,000, PF can be capped (voluntary). This single setting changes in-hand salary by ₹1,800-3,600/month.

Source: EPFO notification on wage ceiling

28 states

Each with different Professional Tax slabs, rates, and filing frequencies. Using the wrong state's PT rate means incorrect deductions and compliance risk.

Source: Respective State PT Acts

Common Mistakes

7 CTC Breakup Mistakes Indian Businesses Make

Setting Basic below minimum wages

To maximize take-home, some employers set Basic at 25-30% of CTC. If the resulting Basic falls below the state minimum wage, the entire salary structure is non-compliant under the Minimum Wages Act, 1948.

Applying ESI to all employees regardless of salary

ESI is applicable only when gross monthly wages are ₹21,000 or below. Deducting ESI from higher-earning employees means over-deduction and a refund headache.

Calculating PF on gross instead of Basic + DA

PF contribution is 12% of Basic wages + Dearness Allowance, not gross salary. This is the most common payroll error in Indian businesses.

Ignoring the employer PF split (EPF vs EPS)

Employer's 12% is not all PF. It splits as 3.67% to EPF and 8.33% to EPS (capped at ₹15,000 Basic). Getting this wrong affects employee PF passbook balances.

Using the wrong state for Professional Tax

PT rates vary dramatically Maharashtra charges ₹2,500/year max, Karnataka charges ₹2,400/year, some states have no PT. Using the wrong state's slab is a compliance error.

Not provisioning Gratuity in CTC

Gratuity (4.81% of Basic) is an employer cost from day one under the Payment of Gratuity Act, 1972. Not including it in CTC calculations understates true employee cost.

Not comparing Old vs New tax regime for employees

Since FY 2023-24, the New Regime is the default. But employees with HRA, 80C, and 80D deductions may save more under the Old Regime. Not offering this comparison leaves money on the table.

Comparison

CTC Calculation: Manual vs This Calculator.

Aspect	Manual Calculation	With This Calculator
Time per employee	15-20 minutes	Under 30 seconds
PF split accuracy	Often wrong (EPF vs EPS not separated)	Auto-calculated with correct 3.67% + 8.33% split
ESI applicability	Frequently applied incorrectly	Auto-checks ₹21,000 wage ceiling
Professional Tax	Looked up manually, often outdated	28-state PT table built in with current slabs
Gratuity provision	Usually forgotten in CTC	Auto-included at 4.81% of Basic
Tax regime comparison	Not done	Side-by-side Old vs New with recommendation
Bulk processing	One employee at a time	50 employees in Team View sheet

Stop guessing the in-hand salary.

Download the free CTC Calculator and know the exact breakup in 30 seconds.

FAQ

Frequently asked questions.

What is CTC and how is it different from in-hand salary?

CTC (Cost to Company) is the total annual expense an employer incurs on an employee. It includes salary, employer PF, employer ESI, gratuity, and other benefits. In-hand salary is what the employee actually receives after deducting employee PF, ESI, Professional Tax, and TDS. Typically, in-hand salary is 65-88% of CTC depending on the salary structure.

What percentage of CTC should Basic salary be?

Most Indian companies set Basic at 40-50% of CTC. A higher Basic means higher PF contributions (better for retirement savings but lower take-home). A lower Basic means higher take-home but lower PF. For compliance, Basic should not be below minimum wages set by the state government under the Minimum Wages Act, 1948.

Is ESI applicable to all employees?

No. ESI applies only to employees whose gross monthly wages do not exceed ₹21,000 per month (as per ESIC notification dated 06-10-2016). If gross wages exceed this ceiling, neither the employer nor the employee pays ESI. The employee contribution is 0.75% and employer contribution is 3.25%.

How is gratuity calculated in CTC?

Gratuity is calculated as (15/26) x Basic Salary x Years of Service under the Payment of Gratuity Act, 1972 (Section 4). For CTC purposes, employers provision 4.81% of Basic annually (equivalent to 15/26 days = approximately 15 days' wages per year). Gratuity is payable to the employee only after completing 5 continuous years of service.

Which tax regime is better Old or New?

It depends on your deductions. If you claim HRA exemption, Section 80C (₹1.5 lakh), 80D (medical insurance), and home loan interest, the Old Regime may save more tax. If you don't have many deductions, the New Regime (with its higher standard deduction of ₹75,000 and lower slab rates) is usually better. This calculator calculates both and tells you which saves more.

About Petpooja

Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement Petpooja helps Indian businesses run better, every day.

Automate salary structure for your entire team

Petpooja Payroll auto-calculates CTC breakup, PF, ESI, PT, and TDS for every employee and sends salary slips via WhatsApp. No spreadsheets needed.

Book a Free Demo Call: +91-72280 34343