CPF Contribution Calculator 2026: Free Excel Template for Employers

How To Calculate CPF Contribution Using Microsoft Excel - Free Template in Excel

Updated for the CPF contribution rates from 1 January 2026.

How To Calculate CPF Contribution Using Microsoft Excel - Free Template in Excel
How To Calculate CPF Contribution Using Microsoft Excel – Free Template in Excel

Learn how to Calculate CPF contribution for Employees and Employers in Singapore by using Microsoft Excel. This covers Singapore Citizens and Singapore Permanent Residents SPRs.

If you want to join our Excel course in Singapore & improve your skills, we have multiple courses – Basic Excel for Analytics, Advanced Excel Courses in Singapore & VBA Macro Programming Courses.

Singapore CPF Rules
In Singapore, all salaried employees need to contribute 5-20% of their salary, depending on age to their Central Provident Fund or CPF. The employer contributes 7.5% to 17% of the salary to the CPF Fund, depending on the age of the worker.

The CPF contribution calculator for employers and employees can be done using Microsoft Excel.

CPF contribution calculator Excel File is available for download below.

Employee’s age
(years)
CPF contribution rates from 1 Jan 2026
(monthly wages above $750), CPF Board
Total
(% of wage)
By employer
(% of wage)
By employee
(% of wage)
55 & below 37 17 20
Above 55 to 60 34 16 18
Above 60 to 65 25 12.5 12.5
Above 65 to 70 16.5 9 7.5
Above 70 12.5 7.5 5
Excel for HR Professionals
Excel for HR Professionals

So payroll executives from Finance or HR professionals need to calculate the correct amount for the contribution to CPF, and provide the net salary to the employees who are Singapore Citizens or Singapore Permanent Residents (SPR). The employer also needs to know their total payroll expenses so as to know their Payroll Liability each month.

Calculating CPF Rates for Employees & Employers in Singapore
I have created a simple Excel spreadsheet to calculate the CPF Rates and Amounts in Singapore in this matter. If you wish to use this you can fill in your own Singapore Citizen & PR employee’s details, their age & basic pay, and the following is automatically calculated:

Learn Microsoft Excel 2019
Learn Advanced Excel 2019 @Intellisoft
  • Employee’s contribution,
  • The employer contribution,
  • Total CPF contributions,
  • Total payable to CPF,
  • Net salary to the employee
  • Gross Salary expense of the employer

The spreadsheet uses simple formulas that are already pre-programmed. So you can just begin to use this spreadsheet for your company.  It uses the CPF Board rates from 1 January 2026 and the S$8,000 Ordinary Wage ceiling, and rounds the way CPF does.

What changed on 1 January 2026

CPF contribution rates went up for employees aged above 55 to 65: 34% in total for ages 55 to 60 and 25% for 60 to 65. The Ordinary Wage ceiling rose from S$7,400 to S$8,000 a month, so CPF is now paid on the first S$8,000 of monthly ordinary wages. Rates for older employees rise again on 1 January 2027; we will update the template then.

If you need any enhancements in calculating employee CPF & contributions payable for Payroll expenses for companies in Singapore or have any comments, do let us know. You can leave a comment below this post.

And of course, if you wish to learn how to create such excel spreadsheets, and use simple Microsoft Excel formulas and functions, you can also attend our Microsoft Excel Training classes in Singapore.

Advanced Excel 2019 Course (2 Days) – with SDF Funding

Basic / Intermediate Excel 2019 Training (2 Days) – With SDF Funding

Advanced Excel for HR Professionals (2 Day Classroom Training)

Hope you like this CPF Calculator Singapore Excel Template for calculating the CPF in Singapore. If you like it, I would appreciate it if you Like Us on Facebook, and leave a comment below!

Cheers,
Vinai Prakash, MBA, PMP, ITIL, GAP, Six Sigma
Master Trainer, Intellisoft Systems

Vinai teaches Advanced Excel Techniques, Dashboard Techniques using Excel, Data Interpretation and Analysis Training courses at Intellisoft. He has trained over 25,000 students in over 28 countries and regularly conducts Excel Workshops in Singapore, Malaysia, Indonesia, Australia, India, Dubai, Egypt, Zimbabwe, South Africa etc.

Contact Intellisoft to book a Certified Microsoft Excel Trainer for your Training needs.

DOWNLOAD EXCEL CPF CALCULATOR

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!