Remaining AW Ceiling Calculator (2026 & 2027)
S$8,000/mo OW Ceiling • S$102,000 Annual Limit- 1. Monthly Ordinary Wage capped at S$8,000/monthS$8,000.00
- 2. Annual Ordinary Wages subject to CPFS$96,000.00
- 3. Remaining AW ceiling (S$102,000 − Annual OW)S$6,000.00
- 4. Bonus subject to CPF vs. excess above ceilingS$6,000.00 / S$6,000.00 excess
Why CPF EZPay Won’t Catch Bonus Overpayments
CPF Board’s CPF EZPay Detailed User Guide states explicitly that automatic calculation "does not impose a cap on CPF contributions that exceed the additional wage ceiling."
For an employee earning S$8,500/month all year who receives a S$12,000 December bonus, keying the bonus uncapped produces S$2,220 in excess CPF (S$1,020 unnecessary employer cash outflow and S$1,200 over-deducted from the employee’s pay). Mid-year bonuses, salary changes, and mid-year resignations also require year-end recomputation — and any shortfall must be rounded as a standalone payment.
Track Year-to-Date Ceilings Automatically Across Your Whole Team
Checking bonuses one employee at a time breaks down as soon as pay varies during the year or staff join and leave partway through.
Skedula’s Monthly Payroll Pack (S$49/year) — or the Complete SME Suite (S$98/year) — handles the entire calendar year in one offline, macro-free Microsoft Excel workbook (requires Microsoft 365 or Excel 2024, up to 200 staff, single UEN):
- Automatic YTD ceiling tracking: Classifies Ordinary and Additional Wages and carries each employee’s year-to-date total forward month by month, capping bonuses automatically at their remaining AW room.
- 2027 CPF rates built in: Applies the 1 January 2027 senior worker increases, age-band birthday transitions, PR-year graduations, SHG deductions, and local/foreign SDL automatically.
- Payslips & EZPay cross-check: Generates printable A4 itemised payslips and an EZPay preview sheet so you catch ceiling issues before submitting (preview; not yet compared with a live EZPay entry; Skedula files nothing).
Stop Reconciling Bonus CPF Ceilings by Hand
Flat S$49/yr (Pack 1) or S$98/yr (Complete SME Suite) for up to 200 staff; S$1,470/yr for accounting practices covering unlimited client entities. Q4 orders cover the rest of 2026 plus all of 2027.
Skedula is independent and not affiliated with, approved or endorsed by CPF Board, MOM or IRAS. Reference calculations only, not tax, legal or payroll advice. Related tools: 2027 CPF Table • SHG Contribution Lookup • 2026 IR8A Guide • Incomplete Month Calculator.