# What actually goes wrong on a payroll spreadsheet

URL: https://skillsforce.com.sg/insights/payroll-spreadsheet-risk-cpf-ir8a-singapore
Title: Payroll spreadsheet risk: CPF and IR8A errors in Singapore | Skillsforce
Description: The exact mechanics of a payroll spreadsheet failure in Singapore: the CPF ceiling trap, the age-band error, and which Income Tax Act penalty actually applies.
Updated 07 August 2026. First published 07 August 2026. Author: Skillsforce (People-operations team)
Category: payroll-cpf

Anyone can say spreadsheets are risky. This names the exact mechanisms: the wage split that catches people out, the ceiling CPF EZPay will not enforce for you, and which Income Tax Act penalty actually applies to an honest mistake.

## What actually goes wrong when payroll runs on a spreadsheet in Singapore?

The specific failures are mechanical: self-capping the Ordinary Wage/Additional Wage ceiling instead of declaring actual wages, missing an age-band change, and a formula error that repeats silently every month. CPF's one-year window to fix an overpayment, and the Income Tax Act's section 95 penalty for a negligent return, make an unnoticed error costly.

## Key points

- The Ordinary Wage/Additional Wage ceiling is the single most common spreadsheet failure: CPF Board wants actual, uncapped wages declared, and applies the ceiling itself, not a formula that pre-caps the figure.
- CPF EZPay's own auto-computation does not cap contributions above the Additional Wage ceiling either, so the tool will not catch what the spreadsheet already got wrong.
- The Income Tax Act's penalty for a negligent incorrect return, section 95, double the tax undercharged, is the tier that fits an honest spreadsheet mistake. Section 96, treble the tax plus a fine and possible imprisonment, requires wilful evasion and is a different offence entirely.
- A CPF over-contribution must be corrected within one year of payment. Caught at next year's audit is often too late.
- The most-cited academic spreadsheet-error study is real but measures general US and UK financial spreadsheets audited between 1997 and 2004, not Singapore payroll, and its own authors call the estimate unreliable.
- A small, stable payroll on a spreadsheet is genuinely low-risk. The real trigger points for outgrowing one are a work-pass holder, variable pay, a bonus month, or losing the person who understands the file.

A spreadsheet does not know that CPF Board wants uncapped wages, that the Additional Wage ceiling changes every time this year's Ordinary Wages change, or that a Permanent Resident's contribution rate steps up on a date nobody put in the calendar. It only knows what the formula tells it, and the formula is usually right, until the month it stops being right and nobody notices, because a spreadsheet with a wrong formula does not throw an error. It just keeps computing the wrong number, correctly, every month.

That is the actual risk, and it is more specific and more fixable than "spreadsheets are risky". What follows is the exact list: the ceiling trap CPF Board itself warns employers about, the rate changes a static formula does not track, the levy that applies to staff CPF does not cover, and the difference, precisely, between an honest mistake and an offence, because the two carry very different penalties under the Income Tax Act.

This is not the CPF EZPay walkthrough; that is [how to submit CPF contributions](/insights/how-to-submit-cpf-contributions-singapore), which assumes you already know the submission steps, nor the full [Singapore payroll compliance calendar](/insights/singapore-employer-payroll-compliance-calendar) of deadlines. This article asks a narrower question: what feeds into that submission, before it ever reaches CPF EZPay, and how does it go wrong.

## What are the most common payroll spreadsheet mistakes?

### The Ordinary Wage/Additional Wage ceiling trap

The Additional Wage ceiling for 2026 is S$102,000 minus the year's Ordinary Wages already subject to CPF, and CPF Board wants you to declare actual wages, not a figure your spreadsheet has already capped. [CPF Board is explicit about this](https://www.cpf.gov.sg/employer/employer-obligations/declaring-accurate-wage-information): "You should declare the actual wages payable to your employee(s) to CPF Board, without applying the Ordinary Wage (OW) and Additional Wage (AW) ceilings." Its own worked example: an employee with actual OW of S$8,500 and actual AW of S$100,000 in a month should be declared exactly as S$8,500 and S$100,000, not capped down first. A spreadsheet built by someone trying to be helpful, hard-coding the ceiling into the AW formula, reports the wrong number. CPF Board applies the ceiling on its own side, and it wants the uncapped input specifically so an employee can check the declaration against their own payslip.

Nor does the tool save you if the declaration is right but the computation is not: CPF EZPay's own auto-computation "does not impose a cap on CPF contributions that exceed the additional wage ceiling." A spreadsheet that over-contributes on a bonus month sails through auto-computation unchallenged.

### The Ordinary Wage ceiling on monthly pay

Separately, monthly Ordinary Wages above S$8,000 (from 1 January 2026) do not attract CPF at all past that point. A spreadsheet built before the ceiling's last step-up, and never revisited, keeps computing CPF on the full salary above S$8,000, month after month, for a senior hire earning above that figure. The full rate table and ceiling sit on our [CPF contribution rates](/compliance/cpf-rates) page; the point here is narrower. A static formula does not know a statutory ceiling moved unless someone tells it. If you are unsure on a specific employee, check the figure directly on our [CPF contribution calculator](/free-tools/cpf-calculator).

### Age-band rate changes

CPF Board's own published list of common employer errors names "overlooked the change of age group" as a recurring mistake requiring later adjustment. A spreadsheet that keys an employee's rate once, at hiring, and never revisits it, silently keeps applying the wrong age band once that employee crosses 55, 60, 65 or 70. The current rates by band are on our [CPF contribution rates](/compliance/cpf-rates) page; the risk here is not the rate itself, it is a formula with no trigger built in to check it.

### Permanent Resident graduated rates and the year rollover

A first or second-year Singapore Permanent Resident is on graduated rates, stepping up again in year three, unless the employer and employee have jointly applied for, and CPF Board has approved, full rates from the start. CPF's own error list separately names "applied full CPF contribution rates for 1st and 2nd year Singapore Permanent Residents" as a common mistake. In CPF EZPay itself, the field that drives this is a PR Start Date plus a graduated or full-rate selection, and the system then tracks the PR year automatically. A spreadsheet has no equivalent auto-tracking. It depends entirely on someone remembering that a PR's contribution year rolled over, on the date it actually rolled over, a fact that lives in a person's memory rather than in the file.

### SDL covering staff CPF does not

Skills Development Levy is where the CPF instinct actively misleads a spreadsheet builder. CPF contributions are payable only for Singapore Citizens and Permanent Residents earning more than S$50 a month; CPF Board's own guidance sets SDL as payable for every employee working in Singapore, foreign work-pass holders included, at 0.25% of monthly total wages, with a S$2 floor and an S$11.25 ceiling as at August 2026. A spreadsheet modelled on "who gets CPF" rather than "who gets SDL" quietly excludes an entire category of staff from a levy they are not exempt from.

### Mid-month joiners, leavers and no-pay leave

Proration for a joiner or leaver partway through the month, and no-pay leave, both change the Ordinary Wage a spreadsheet needs to compute from correctly. CPF Board's own error list names delayed notification of a resignation or a spell of no-pay leave as a recurring source of adjustments; the wage figure a formula is working from was already wrong by the time it ran. This is less a formula error than a data-freshness error, and it is the one a bureau or software helps with, since it forces the change to be entered before the run rather than remembered afterwards.

### The structural killer: silent replication

None of these six mechanisms is dramatic on its own. What makes a payroll spreadsheet different from a one-off mistake is that a formula error does not correct itself. Get the AW ceiling formula wrong once, and it recomputes the same wrong figure every single month until a bonus run, an audit, or a departing employee's tax clearance forces someone to open the file and actually look. By then it may have run for months, sometimes across more than one calendar year, quietly compounding.

## What it actually costs

Two consequences make an unnoticed spreadsheet error expensive rather than embarrassing, and they run on different clocks.

On the CPF side, any application to refund or adjust a CPF contribution must be made no later than one year from the date of payment. An over-contribution from a March bonus, caught in the following year's audit, may already be out of time to fix. CPF Board also runs periodic audits and investigations specifically to check the accuracy of wage information submitted, so "nobody noticed" is not the same as "nobody will".

On the tax side, the Income Tax Act sets out three separate tiers, and confusing them is where most writing about spreadsheet risk goes wrong. Section 94 is the general penalty for simply not filing at all: a fine of up to S$5,000, and in default of payment, imprisonment of up to six months. Section 95 covers a negligent or unreasonable incorrect return, at a penalty equal to double the tax undercharged; on its wording this extends to the employer's own required return under section 68, and it is the tier that actually fits a genuine spreadsheet mistake, not intent to deceive. Section 96, treble the tax undercharged plus a fine of up to S$10,000 and up to three years' imprisonment, requires wilful evasion. An honest formula error sits under section 95. It does not sit under section 96, and no honest article about spreadsheet risk should imply otherwise.

A wrong IR8A or Auto-Inclusion Scheme submission is not necessarily stuck once filed. IRAS offers a Revision method, re-enter every field correctly, and an Amendment method, submit only the difference from what was already filed, and its own worked example covers a case with several prior submissions to the same employee. The forms themselves, IR8A and its appendices, are covered in full in our [IR8A employer guide](/compliance/ir8a-employer-guide). A caught error is generally fixable; an error caught late is the one with the one-year CPF window against it.

Two separate regimes govern how long you keep records that would let you check this later. The Employment Act requires employee and salary records to be kept at least two years for current staff, and a former employee's last two years of records to be kept for at least a year after their last day. The Income Tax Act's standard is five years from the relevant Year of Assessment. IRAS explicitly welcomes Excel spreadsheet exports as audit evidence, which is a point in the spreadsheet's favour: the format itself is not the problem.

## What the 94% spreadsheet-error statistic actually measures

The most-cited academic figure on spreadsheet errors is real, and worth using correctly rather than not at all. A [2008 peer-reviewed synthesis in *Decision Support Systems*](https://mba.tuck.dartmouth.edu/spreadsheet/product_pubs_files/literature.pdf), reviewing field audits from 1997 to 2004, reported that 94% of 88 audited operational spreadsheets contained at least one error, with an average cell error rate of 5.2%.

Two things belong in the same breath as that number, not a footnote later. None of the underlying spreadsheets were Singapore spreadsheets, and none were specifically payroll: the studies covered general financial, tax and capital-budgeting models, mostly at organisations in the US and UK. And the paper's own authors question their own synthesis: 70% of the sample behind the 5.2% cell-error-rate figure actually came from one study that measured "issues" auditors raised on an initial draft, not confirmed errors in a finished spreadsheet, and the authors conclude plainly that "the evidence behind the estimates in the literature does not provide sufficient grounds for a reliable, quantitative estimate."

Use it as a reason to build spreadsheets carefully. It is not a Singapore payroll error rate.

## The honest case for staying on a spreadsheet

None of these spreadsheet risks means every spreadsheet is a problem waiting to surface. A handful of employees on fixed monthly salaries, no work-pass holders, no shift pay, and no bonus month, is genuinely low-risk territory for a careful spreadsheet builder who understands the OW/AW mechanics above. [IRAS's own guidance on errors in returns](https://www.iras.gov.sg/taxes/individual-income-tax/basics-of-individual-income-tax/consequences-of-non-compliance/errors-in-tax-returns) states that using proper accounting software and better record-keeping is a mitigating factor when it assesses a penalty, not that a spreadsheet is inherently non-compliant, and IRAS separately says producing records "in Microsoft Excel spreadsheet format will help expedite any audit review." The format is not the risk. An unreviewed formula, left to run unchanged through a rate change or a first bonus month, is.

## What to actually do about it

The fixes for these spreadsheet risks are cheaper, in order, than the alarm the topic usually generates.

Start with a written checklist against CPF's own published list of common errors: the Relevant Month and Year, the CPF Submission Number, each employee's citizenship and PR year, and whether OW and AW have been declared uncapped rather than pre-capped. It costs nothing beyond the time to build it once.

Add a second pair of eyes before submission, ideally someone who did not build the formula. A fresh set of eyes catches exactly the kind of error a formula's own builder stops seeing.

Review the file specifically before any bonus, AWS or off-cycle run, since that is where the Additional Wage ceiling actually bites, and where CPF EZPay's own auto-computation will not stop an over-contribution for you.

Only after those, if headcount, work-pass mix or shift pay have outgrown what a spreadsheet can track safely, move to software that computes the OW/AW split and generates the submission file, or to a service that takes the whole function over. We [compare all four ways of running payroll](/insights/payroll-in-house-software-or-outsourced-singapore) honestly, including this one.

We run [payroll processing](/services/payroll) for employers who have reached that point. A spreadsheet is not the mistake. An unreviewed one is.

## Frequently asked questions

### What happens if I submit the wrong CPF amount because of a spreadsheet error?

You can apply to CPF Board for a refund or adjustment, but only within one year of the date the contribution was paid. CPF Board also runs periodic audits to check the accuracy of wage information submitted, so an error is checked against eventually whether or not you catch it first.

### Is a formula error in my payroll spreadsheet an offence?

Not by itself. Section 95 of the Income Tax Act turns on negligence or the absence of a reasonable excuse, and carries a penalty equal to double the tax undercharged; whether a given error meets that bar is IRAS's assessment, not the employer's. Wilful evasion, under section 96, is a separate and harsher offence that requires intent.

### How do I amend a submitted IR8A or AIS record?

IRAS offers two methods. Revision re-enters the full, correct figures for every required field. Amendment has you calculate the difference between the total of all prior submissions and the actual income earned, and submit only that difference. Which one applies depends on what was wrong.

### How long do I need to keep payroll and CPF records?

Two separate regimes apply. Employment Act records (personal particulars, salary, leave) run at least two years for current staff, and a former employee's last two years of records for at least one year after their last day. Income Tax Act records run at least five years from the relevant Year of Assessment, and IRAS explicitly accepts Excel spreadsheet exports as audit evidence.

### Is a spreadsheet a legally acceptable way to run payroll in Singapore?

Yes. Nothing in CPF or IRAS rules requires software or an outsourced provider. IRAS's own guidance even names Excel spreadsheet exports as a format that helps expedite an audit review. What matters is whether the formulas are right and checked, not the tool itself.

## Sources

- [CPF Board: Declaring accurate wage information](https://www.cpf.gov.sg/employer/employer-obligations/declaring-accurate-wage-information) (Accessed 05 August 2026)
- [CPF Board: CPF EZPay detailed user guide (PDF)](https://www.cpf.gov.sg/content/dam/web/employer/making-cpf-contributions/documents/CPFEZPayDetailedUserGuide.pdf) (Last updated October 2024; accessed 04 August 2026)
- [CPF Board: Common mistakes which require subsequent adjustments (PDF)](https://www.cpf.gov.sg/content/dam/web/employer/faq/employer-obligations/documents/Common%20Mistakes%20Which%20Require%20Subsequent%20Adjustments%20To%20Employers.pdf) (Information correct as at April 2024; accessed 04 August 2026)
- [CPF Board: Applying for refund of CPF contributions](https://www.cpf.gov.sg/employer/compliance-and-rectifications/applying-for-refund-of-cpf-contributions) (Accessed 04 August 2026)
- [CPF Board: Skills Development Levy](https://www.cpf.gov.sg/employer/employer-obligations/skills-development-levy) (Accessed 05 August 2026)
- [CPF Board: Who should receive CPF contributions](https://www.cpf.gov.sg/employer/employer-obligations/who-should-receive-cpf-contributions) (Accessed 04 August 2026)
- [Income Tax Act 1947, section 68 (returns by employer)](https://sso.agc.gov.sg/Act/ITA1947?ProvIds=pr68-) (Current version as at 05 August 2026)
- [Income Tax Act 1947, section 94 (general penalties)](https://sso.agc.gov.sg/Act/ITA1947?ProvIds=pr94-) (Current version as at 05 August 2026)
- [Income Tax Act 1947, section 95 (penalty for incorrect return)](https://sso.agc.gov.sg/Act/ITA1947?ProvIds=pr95-) (Current version as at 05 August 2026)
- [Income Tax Act 1947, section 96 (tax evasion)](https://sso.agc.gov.sg/Act/ITA1947?ProvIds=pr96-) (Current version as at 05 August 2026)
- [IRAS: Amend Submitted Records](https://www.iras.gov.sg/taxes/individual-income-tax/employers/auto-inclusion-scheme-(ais)-for-employment-income/amend-submitted-records) (Accessed 05 August 2026)
- [IRAS: Errors in tax returns](https://www.iras.gov.sg/taxes/individual-income-tax/basics-of-individual-income-tax/consequences-of-non-compliance/errors-in-tax-returns) (Accessed 05 August 2026)
- [IRAS: Keeping proper records and accounts](https://www.iras.gov.sg/taxes/individual-income-tax/self-employed-and-partnerships/keeping-proper-records-and-accounts) (Accessed 05 August 2026)
- [MOM: Employment records](https://www.mom.gov.sg/employment-practices/employment-records) (In force from 1 April 2016; accessed 05 August 2026)
- [Powell, Baker and Lawson, 'A critical review of the literature on spreadsheet errors', Decision Support Systems 46 (2008)](https://mba.tuck.dartmouth.edu/spreadsheet/product_pubs_files/literature.pdf) (Published 2008; underlying field-audit studies conducted 1997 to 2004)

## Related

- [Singapore payroll compliance calendar](https://skillsforce.com.sg/insights/singapore-employer-payroll-compliance-calendar)
- [In-house, software or outsourced](https://skillsforce.com.sg/insights/payroll-in-house-software-or-outsourced-singapore)
- [How to submit CPF contributions](https://skillsforce.com.sg/insights/how-to-submit-cpf-contributions-singapore)
- [CPF contribution rates 2026](https://skillsforce.com.sg/compliance/cpf-rates)
- [IR8A: the employer's guide](https://skillsforce.com.sg/compliance/ir8a-employer-guide)
- [CPF contribution calculator](https://skillsforce.com.sg/free-tools/cpf-calculator)
- [Payroll processing](https://skillsforce.com.sg/services/payroll)