HRIS

Excel Payroll or Software? When to Switch in SL

Switch from Excel to payroll software when headcount, statutory filings or turnover make a spreadsheet error likely. What Excel does well, and its limits.

Updated September 23, 2026 Reviewed by Anudi Imesha, Customer Success Consultant, Humanised HR and Payroll 3 min read

HRIS software Sri Lanka, humanised payroll, payroll service provider, human resource
On this page
  1. What Excel does perfectly well
  2. The four things it cannot do
  3. What an error costs: surcharge, then trust
  4. Headcount and complexity thresholds
  5. What to check before choosing software
  6. Migrating mid-year without losing cumulative figures
  7. Frequently asked questions
  8. Does an accountant running payroll for us still need software?
  9. Can one system run payroll for several related companies?
  10. Can staff keep working offline part of the time?
  11. What about leave tracked separately from payroll?
  12. Is there a safe way to trial software before committing?

Switch when headcount, statutory filings or staff turnover make a spreadsheet error likely. Below that point, Excel does the job fine. Above it, one wrong cell runs through every month until someone notices.

What Excel does perfectly well

For a handful of staff on fixed salaries, a spreadsheet works. You can build formulas once for the five main statutory payroll payments in Sri Lanka, check them carefully, and reuse them every month. With few staff, a mistake reaches few payslips. Plenty of small businesses stay on Excel for years.

The four things it cannot do

  • Update itself when a rate or tax band changes. The IRD republishes APIT tables from 1 April each year. A spreadsheet formula does not know that happened.
  • Stop someone reusing last month’s numbers for a joiner or leaver by mistake.
  • Warn you before a mistake becomes a late payment. See how to avoid errors in payroll processing for the checks a spreadsheet cannot run on its own.
  • Produce the bank file that ETF employers with 15 or more staff have needed since the July 2026 contribution, due 31 August 2026.

What an error costs: surcharge, then trust

Pay EPF before the last working day of the month after the pay month. ETF is due on or before that day. Miss it, and a surcharge applies on top of what was owed. It rises from 5% for a short delay up to 50% for a delay of over a year. That is on top of the shortfall itself. A wrong or late payslip also costs you trust with staff.

Delay after the due dateEPF/ETF surcharge
1 to 10 days5%
11 days to 1 month15%
1 to 3 months20%
3 to 6 months30%
6 to 12 months40%
More than 12 months50%

Headcount and complexity thresholds

There is no fixed headcount where Excel stops working. Watch for these signs instead:

  1. You have 15 or more employees, so ETF payment must be electronic and manual payment is not accepted.
  2. You have joiners and leavers most months, so cumulative figures change constantly.
  3. More than one person edits the payroll sheet, with no record of who changed what.
  4. You have had an EPF or ETF surcharge in the last year.

Any one of these is a reason to look seriously at software, even with a small headcount.

What to check before choosing software

Before you sign up for anything, check it against your own numbers. Confirm it calculates EPF, ETF and APIT to the current rates, and that it produces the remittance forms your headcount needs. Confirm it also exports a journal your accountant can use. See whether QuickBooks or Xero handles Sri Lankan payroll first, since accounting software alone will not do this part.

Migrating mid-year without losing cumulative figures

Moving mid-year needs your year-to-date gross pay, APIT deducted so far, and EPF/ETF member history carried over correctly. Get this wrong and the new system can double-count or reset someone’s figures. See Migrating Payroll Mid-Year Without Losing YTD Data for the full checklist.

Do this automatically in Humanised. The trigger is usually the first EPF surcharge; payroll software in Sri Lanka removes that class of error. Plans start at LKR 10,000 a month for up to 15 staff. The free 7-day assisted trial is set up by the Humanised team on your own data.

This is general payroll guidance. Every case is different. For your own case, speak to a payroll practitioner or a lawyer.

Frequently asked questions

Does an accountant running payroll for us still need software?

Yes, if headcount or filing complexity has grown. The accountant’s own time is worth protecting from repetitive, error-prone recalculation every month.

Look for this specifically before choosing, since not every product separates companies cleanly. It matters if you run more than one registered employer.

Can staff keep working offline part of the time?

Attendance can often be captured offline and synced later. Payroll calculations themselves still need the current month’s full data before you can run them.

What about leave tracked separately from payroll?

That is its own common failure point. See Tracking Leave in Excel: Template and Limits for where a separate leave spreadsheet usually breaks.

Is there a safe way to trial software before committing?

Ask for a trial set up on your own real data, not sample data. Then check the numbers against what you already pay before you switch fully.

Do this in Humanised

Humanised is HR software in Sri Lanka: one HRIS for records, leave, attendance and payroll with EPF, ETF and APIT built in.

Payroll deadlines & law changes, in your inbox

EPF/ETF due dates, APIT updates, and new employment-law guides for Sri Lankan employers. One email a month, no fluff.

Was this article helpful?

Your feedback helps us improve these guides.

Keep reading

More posts in HRIS.