Intellisoft Training Blog

Learning Skills & Techniques For Life to Improve Productivity!

Most countries have some kind of mandatory deduction to the income. It could be income tax – tax deducted at source,or it could be Provident Fund, or some other voluntary contribution.

Singapore CPF Rules
In Singapore, all salaried employees need to contribute 5-20% of their salary, depending on age into their Central Provident Fund ( also called as CPF). The employer contributes 6.5 to 16% of the salary to the CPF Fund, depending on the age of the worker.

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. Employer also needs to know their total payroll expenses so as to know their Payroll Liability each month.

Calculating CPF Rates for Employee & Employer 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 Singapore-salary-template, you can fill in your own employees details, their age & basic pay, and the following is automatically calculated:excel training

  • Employee’s contribution,
  • The employer contribution,
  • Total payable to CPF,
  • Net salary to employee
  • Gross Salary expense of employer

Download the CPF Calculator Spreadsheet (Microsoft Excel Format) here.

CPF Calculator in Excel 2007, Excel 2010 or Excel 2013 format

The spreadsheet uses simple formulas that are already pre-programmed. So you can just begin to use this spreadsheet for your company.  It has been tested for CPF Contribution Rates in 2013 and beyond, and  everything will work smoothly.

If you need any enhancements in calculating CPF contribution and 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 2010 Course ( 2 Days)  – with SDF Funding

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

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

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

Excel for HR Professionals

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

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 5000 students in over 18 countries, and regularly conducts Excel Workshops in Singapore, Malysia, Indonesia, Australia, India, Dubai, Egypt, Zimbabwe, South Africa etc.

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

2 Responses so far.

  1. Sher says:

    Hi, I would like to have a copy for the template.
    Thank you.

  2. Hi Sherry, you can download the CPF Calculator Template at

    cheers – Vinai
    Intellisoft Training

Leave a Reply

  • RSS
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube
Choosing a Career in IT

Choosing A Career in

Thinking of starting a career in IT? Love to play with ...

Top 3 Features of Mi

Microsoft Excel is heavily used in Banking, Sales, Finance, Marketing, ...

3 Reasons Why You Sh

Whether you work in Business, Finance, IT, Services, Sales, Marketing, ...

The PMP Exam is Chan

The PMP Exam is changing on Jan 12, 2016. Although it ...

Creating Management

Today, Microsoft Excel has become extremely power tool for any ...


  • Microsoft Excel 2010 Hands On Training
  • Microsoft PowerPoint 2010 Hands On Training
  • Microsoft Project 2010 Hands On Training
  • Communication Skills Training
Facebook Iconfacebook like buttonYouTube IconSubscribe on YouTubeTwitter Icontwitter follow button
Simply dummy text of the printing and typesetting industry.
%d bloggers like this: