Updated for the CPF contribution rates from 1 January 2026.
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 |
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:
- 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.
