Launch Offer: Extra 20% Off Everything With Code LAUNCH20 · Instant Download
Excel & SheetsNew

New Labour Code Salary Kit: 50% Wage Rule, PF & Gratuity (Excel)

Under the new labour codes, basic + DA must be at least half of total pay. Check one salary or your whole team, see what changes in PF, gratuity and in-hand pay, and get a compliant structure in minutes.

₹299₹799Save ₹500 (63%)
Inclusive of all taxes · One-time payment · Instant download
Extra 20% off with code LAUNCH20 at checkout
Instant downloadOn screen + email
Secure paymentUPI · Cards · Net Banking
7-day helpFix or refund if faulty
Perfect for
Small business owners with employeesHR and payroll staffAccountants and CAsEmployees who want to understand their new salary
What you get2 × .xlsx (blank + sample) + guide PDF + Word letter
Works withMicrosoft Excel · Google Sheets · WPS Office · Microsoft Word · Any PDF reader
DeliveryInstant download
LicencePersonal & own-business use
Draftstack Mega Bundle: Everything – bundle preview Get everything we makeDraftstack Mega Bundle: Everything · ₹1,999 · you save ₹7,965See →

Since the labour codes came into force in November 2025, many salary structures with a low basic and high allowances need a second look. If allowances are more than half of total pay, the extra counts as wages – and PF and gratuity are worked out on wages.

This kit shows exactly what that means for each employee, in rupees.

What it does

  • Salary Check: type one salary – see whether it meets the 50% rule, how much is added back to wages, and PF, ESI, gratuity, in-hand pay and cost before vs under the Code
  • Suggested structure: same total pay, basic + DA at 50% or more, allowances reduced in the same ratio
  • Team Check: up to 100 employees; who is below the rule and the total monthly cost change
  • Salary Slip: pick an employee and month, print or save as PDF
  • Settings: PF %, PF wage ceiling (on/off), ESI, professional tax and gratuity values you can edit

Also included

  • Guide (PDF): the 50% rule with a worked example, what changes, a step-by-step plan and employee FAQs
  • Revision letter (Word): two versions – when the structure changes and when nothing changes

General information, not legal advice. Labour codes apply through central and state rules – confirm with your accountant.

What's inside

Everything you get

01

Salary Check

One employee: 50% test, before vs after, suggested structure

02

Team Check

100 employees with PF, gratuity, in-hand and cost change

03

Salary Slip

Printable A4 slip showing wages under the Code

04

Settings

PF, ceiling, ESI, professional tax, gratuity – all editable

05

Guide (PDF)

5 short chapters in plain English

06

Revision Letter (Word)

Two ready versions

Files in your download

  • New_Labour_Code_Salary_Kit.xlsx193 KB
  • New_Labour_Code_Salary_Kit_SAMPLE.xlsx193 KB
  • New_Labour_Code_Guide.pdf154 KB
  • Salary_Structure_Revision_Letter.docx37 KB
How to use

Start in 5 simple steps

A step-by-step guide is also included inside your download.

  1. 1

    Check Settings

    PF, ESI and professional tax for your state

  2. 2

    Add your team

    One row per employee

  3. 3

    Fix red rows

    Use the suggested structure

  4. 4

    Inform employees

    Use the Word letter

  5. 5

    Print slips

    From the Salary Slip tab

FAQ

Questions about this product

Will this reduce in-hand salary?

It can, if PF goes up. The sheet shows the exact change. If PF is paid only up to the ₹15,000 ceiling and wages are already above it, PF does not change.

Does it cover state minimum wages?

No. It focuses on the wage definition, PF, ESI and gratuity. Check minimum wages for your state separately.

Which Excel do I need?

Excel 2016 or later, Microsoft 365, or Google Sheets (free).

How do I get the files after payment?

A download button appears on screen right after payment, and the link is emailed to you. You can also download again any time from My account.

Can I use it on my phone?

Yes. It works with Microsoft Excel, Google Sheets, WPS Office, Microsoft Word, Any PDF reader. Free mobile apps are enough.

What if something does not work?

Write to us within 7 days with your order number. We will fix it, send a working file, or refund you.

Our promiseEvery file is tested before launch. If something doesn't work, we fix it or refund you within 7 days. Refund policy
More to explore

You may also like

See all
₹299₹799