๐
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.