Key takeaways
- A free CPF calculator works out contributions for one employee for one month. It does not run payroll.
- Payroll also needs itemised payslips, salary records, year-end filing and rules that change with age, residency status and the time of year.
- Spreadsheets break quietly. A copied formula or an old rate can be wrong for months before anyone notices.
- Payroll spreadsheets carry salaries, NRIC and bank details, which are hard to protect when files travel by email.
- Time to switch is when you pay bonuses or variable pay, hire PRs or foreign staff, add a second entity or country, or when the founder is still doing payroll.
What a free CPF calculator does, and what it does not
The CPF Board's contribution calculator answers one question well: how much CPF is due for one employee, for one month, at one wage.
Payroll asks many more questions than that:
| Payroll needs | Free CPF calculator | Spreadsheet |
|---|---|---|
| CPF for one month at one wage | â | â if the formula is right |
| Yearly ceilings on additional wages such as bonuses | â | Only if you build and maintain it |
| Rates that change with age band and PR status | One case at a time | Manual updates |
| SDL and self-help group contributions | â | Manual |
| Unpaid leave, overtime, back pay and final pay | â | Manual |
| Itemised payslips for every employee | â | Mail merge or by hand |
| Salary records kept over time | â | Files and folders |
| AIS by 1 March, IR21 when foreign staff leave | â | Separate work |
The calculator is a good way to check a number. It is not a way to run payroll.
Why spreadsheets break quietly
Spreadsheets rarely fail loudly. They drift.
- A formula is copied one row short, and the new hire's CPF is missing.
- A rate changes in January, and last year's file is copied forward. In 2026 the CPF Ordinary Wage ceiling rose to S$8,000, so a file built in 2025 can be wrong without any error showing.
- Someone types over a formula to fix one case, and the fix stays for months.
- Only one person knows how the file works.
None of these shows up until an employee asks, an audit samples a month, or CPF writes in. Late CPF carries interest of 1.5% a month from the day after the due date.
The data in a payroll spreadsheet
A payroll file holds salaries, NRIC or passport numbers, bank accounts and sometimes medical leave. In a spreadsheet it is emailed, downloaded and saved on laptops. Access is all or nothing, and there is no record of who opened or changed what.
Payroll software keeps the same data behind roles and logs every change.
Hong Kong has the same problem, with different rules
In Hong Kong, MPF contributions follow minimum and maximum levels of relevant income. Statutory holiday pay and annual leave pay are based on average daily wages over the previous 12 months. Employers file IR56 forms when people join, leave or leave Hong Kong. Each one is easy to get wrong in a spreadsheet, and late MPF contributions carry a 5% surcharge.
Signs it is time to switch
A spreadsheet can be enough for a handful of employees on fixed monthly pay in one country. It stops being enough when:
- pay changes month to month, with bonuses, overtime, commission or unpaid leave
- you hire PRs or foreign staff, whose rates and exit filings differ
- you add a second entity or a second country
- employees start asking how their pay was worked out
- the founder is still the one doing payroll at month end
What to look for in payroll software
- Statutory rules kept current for you, not set up once and forgotten
- Itemised payslips and salary records produced from the same data
- Year-end filing prepared from the year's payroll, not rebuilt from files
- A record of how each figure was calculated, so you can explain it later
- Pricing that works for a small team, with a path as you grow
Questions
Can I run payroll in Excel in Singapore?
You can, and many small companies start that way. But you still need itemised payslips, salary records, CPF paid on time and AIS filed by 1 March, and a spreadsheet does not do those for you.
Is the CPF contribution calculator enough to run payroll?
No. It works out contributions for one employee for one month. It does not track yearly ceilings, pay bonuses, issue payslips, keep records or prepare year-end filing.
When should a small company move to payroll software?
Usually when pay stops being the same every month, such as with bonuses, overtime or unpaid leave, when you hire PRs or foreign staff, when you add a second entity or country, or when payroll is taking the founder's time.
Can I run Hong Kong payroll in a spreadsheet?
You can for a few employees with fixed pay, but MPF contribution limits, holiday and leave pay based on 12-month average wages, and the IR56 forms add up quickly. Late MPF contributions carry a 5% surcharge.
Sources
- CPF Board â When is the due date for CPF contributions?
- CPF Board â How much CPF contributions to pay
- IRAS â Auto-Inclusion Scheme (AIS) for Employment Income
- Ministry of Manpower â Itemised payslips
- MPFA â Enforcement measures and penalties
This guide is general information, not legal or tax advice. Check the official sources for your situation.