ABOUT THE PAGE

๐Ÿ“… FY2025-26 is the first bonus year under the Code on Wages, 2019.
The Payment of Bonus Act was repealed on 21 November 2025, "wages" has a new definition, and S.O. 4710 & 4711 (25 Aug 2026) changed the eligibility and calculation rules. โš ๏ธ Last year's bonus sheet will get this year wrong.

๐Ÿงฎ This Excel calculator does it right, employee by employee and month by month, so you can pay the right people the right amount by 30 November 2026.

โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”
โœจ WHAT IT DOES
โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”
โœ‚๏ธ Splits the year automatically: old Act up to 20 Nov 2025, Code on Wages from 21 Nov 2025 (November split 20:10)
๐Ÿ’ผ Applies the new s.2(y) wages definition, including the 50% rule (special allowance now counts)
โœ… Checks โ‚น21,000 eligibility month by month (S.O. 4711)
๐Ÿ“ Caps calculation at โ‚น7,000 or the minimum wage, whichever is higher (S.O. 4710)
๐Ÿ’ฐ Calculates bonus at 8โ…“% (or โ‚น100 minimum) up to 20%, with the 30-day rule and disqualifications
โš–๏ธ Shows the rupee impact of Central vs State minimum wage, so you can record your decision
๐Ÿ”ง Wage Builder to test what counts as "wages" for any pay structure
๐Ÿ“Š Department-wise summary, days left to the deadline, and a one-page bonus statement for each employee

โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”
๐Ÿ“ฆ DETAILS
โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”
๐Ÿ“ Format: Excel (.xlsx), works in Microsoft Excel and LibreOffice
๐Ÿ‘ฅ Capacity: up to 500 employees per file
๐Ÿงญ Comes with sample data and a Start Here guide. Fill the yellow cells and paste your employee data.
โšก Instant download after payment

โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”
๐ŸŽ ADD THE COMPLETE KIT AT CHECKOUT
โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”
Tick the add-on to also get:
๐Ÿ“’ Allocable Surplus & Set-on/Set-off workbook
๐Ÿงพ Bonus Register & Payment Tracker
โœ‰๏ธ 7 ready-to-issue letter templates
๐Ÿšจ Non-Compliance Exposure Calculator
๐Ÿ“• 15-page Legal Implications guide
๐Ÿ“˜ S.O. 4710/4711 explainer with a 37-point checklist and FAQs

โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”
๐Ÿ‘ค BUILT BY
โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”
Ranjeet Singh, CHRO and founder of ElevHR, with 20+ years of Indian labour law practice.

โ„น๏ธ A compliance tool based on the Code on Wages, 2019, the Central Rules, 2026 and S.O. 4710(E) & 4711(E), as understood on 7 Oct 2026. Not legal advice.

CONTACT ME FOR ANY ISSUES OR QUERIES
updateddigitally@gmail.com
Invite your network