Salary Calculation Master Combo | eBook + Excel Calculator

Salary Calculation Master Combo | eBook + Excel Calculator

Learn the rules. Apply them in Excel. Updated for the New Labour Codes — law as on 30 September 2026.

Knowing the salary calculation rules is one thing. Building a compliant salary structure and getting every number right is another.

This combo gives you both:

The Salary Calculation Under New Labour Codes eBook (Third Edition, 81 pages) + The Comprehensive Salary Breakup Calculator (Excel)

First understand why each number is calculated the way it is, then use Excel to calculate it for any salary in seconds.

Learn → Understand → Calculate → Verify → Apply

Why This Combo Works

• The eBook explains: the rules, the reasoning and worked examples for every component.
• The calculator applies: the same rules to your own figures, automatically.
• Both use the same method: the 50% rule as clarified in the Ministry of Labour's FAQs of 16 March 2026, the ₹25,000 PF wage ceiling, and the same statutory bases. The numbers in the book and in the sheet agree.

What You Learn from the eBook

• Salary fundamentals: Total Remuneration, Gross Salary, Net Pay and CTC, and how they connect
• Wages under the New Labour Codes: Section 2(y), the listed exclusions, and why wages drive every statutory number
• The 50% wage rule: the correct method, worked scenarios, and what happens when the limit is breached
• Minimum wage compliance, full wages vs disguised wages, and in-kind remuneration vs reimbursements
• Statutory components: PF (EPF, EPS, EDLI and the ₹25,000 ceiling), ESI, gratuity (including fixed-term employees), statutory bonus, leave encashment, overtime and Professional Tax
• TDS on salary: Tax Year 2026-27 under the Income-tax Act 2025, both regimes
• Tax optimisation: HRA, LTA, meal vouchers, NPS and perquisites, plus a complete ₹25 lakh CTC example
• Practical tools: a ₹40,000 CTC salary sheet, CTC-based vs Total Remuneration-based structuring, FBP design, dos and don'ts, and a documentation checklist

Every chapter is calculation-first, with one running example that connects Total Remuneration, wages, deductions, net pay and CTC.

An Important Distinction the Book Explains

The 50% rule is never applied on CTC. It is tested on Total Remuneration plus the employer's PF contribution and statutory bonus, as the Ministry's FAQ requires. Gratuity, ESI and other employer costs stay out of it. Getting this wrong is one of the most common structuring errors, and both the book and the calculator handle it correctly.

Then Apply It in Excel

The calculator has two calculators in one workbook:

• CTC-based: start from an offer budget and break it into components
• Total Remuneration-based: start from what the employee receives and build up to CTC

Each calculator covers:

• Earnings: Basic + DA, HRA, Conveyance, Gross Salary
• In-kind: Meal Voucher and Transport Facility, within the 15% rule
• Employer cost: PF, ESI, Statutory Bonus, Gratuity, Monthly and Annual CTC
• Employee side: PF, ESI, Professional Tax, Total Deductions, Net Pay
• PF Ceiling vs No PF Ceiling, side by side

Built-in compliance checks: a minimum wage check, a 50% rule test and a structure check, each showing PASS or FAIL with guidance on what to fix.

Simple formulas that work the same in Excel, Google Sheets and LibreOffice, with no macros.

Employer Cost vs Employee Take-Home

The combo helps you calculate both sides, and explain them clearly to employees, management and clients.

Who Is This Combo For?

• HR professionals, HR executives, HR generalists and HR managers
• Payroll executives, managers and consultants
• Compensation and benefits professionals
• HR consultants
• Business owners and employers
• Professionals learning Indian payroll who want real calculation skills, not just definitions

What You Receive

1. Salary Calculation Under New Labour Codes: eBook (PDF, 81 pages), with clickable contents, bookmarks, charts, a glossary and official source links
2. Comprehensive Salary Breakup Calculator: Excel workbook, with 2 calculators and built-in compliance checks

Why Buy the Combo Instead of Only the Calculator?

The calculator gives you the number. The eBook gives you the reason behind it. Together they answer both "What is the number?" and "Why is it calculated this way, and is it compliant?"

The eBook also covers what the calculator doesn't: TDS, tax optimisation and a ₹25 lakh CTC case study.

Important Note

This is an educational and calculation resource. It is not payroll software, does not connect to EPFO, ESIC, banks or government portals, and is not legal or tax advice. Labour law is stated as on 30 September 2026 and income tax for Tax Year 2026-27. Minimum wages and Professional Tax vary by State. Verify current rates, thresholds and notifications before using any calculation in live payroll.