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!

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 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 http://intellisoft.com.sg/blog/docs/CPF_Calculator.xls

    cheers – Vinai
    Intellisoft Training

Leave a Reply


  • RSS
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube
Javascript

Advantages of JavaSc

Speed: Being client-side, JavaScript is very fast because any code ...

Adv_Excel

Do You Use These Adv

Most people hardly use the huge number of features available ...

wordpress

Creating Your Own Wo

WordPress software has come a long way. It started as ...

Adv_Excel

Conditional Formatti

In Microsoft Excel 2010, new features are sparklines and slicers, ...

Adv_Excel

Pivot Tables in Micr

In Microsoft Excel 2010, new features are sparklines and slicers, ...

Sponsors

  • 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