Does QuickBooks or Xero Do Sri Lankan Payroll?
No. QuickBooks and Xero handle the ledger, but neither calculates EPF, ETF or APIT for Sri Lanka. What they cover, and how to fill the gap.
On this page
- What each product actually supports in this region
- The five Sri Lankan calculations they cannot do
- The spreadsheet workaround firms use, and where it breaks
- Option: local payroll plus a journal export into the ledger
- What the integration should post, line by line
- Frequently asked questions
- Can QuickBooks or Xero pay staff in USD?
- Does either product handle contractor payments differently from employee payments?
- Can I file the T10 or the Annual Statement of Employer from QuickBooks or Xero?
- Is there a Sri Lanka edition of QuickBooks or Xero coming?
- Do I still need an accountant if I use local payroll software?
No. QuickBooks and Xero are accounting software. Both are good at the ledger, invoices and bank feeds. Neither calculates EPF, ETF or APIT for a Sri Lankan employee, because neither builds payroll for this region. See five main statutory payroll payments in Sri Lanka for what a Sri Lankan payroll actually has to cover.
What each product actually supports in this region
QuickBooks Payroll natively supports the US, UK, Canada and Australia. Xero’s native payroll is built the same way, for its own home markets. Sri Lanka is not on either list. You can still use QuickBooks or Xero as your accounting system in Sri Lanka. You just cannot run Sri Lankan payroll inside them.
The five Sri Lankan calculations they cannot do
- EPF: 8% from the employee, 12% from the employer, on total monthly earnings.
- ETF: 3% from the employer only, on the same total monthly earnings.
- APIT: income tax withheld from pay, using the Inland Revenue Department’s own monthly bands.
- Gratuity: half a month’s wage or salary, at the rate last drawn, for each completed year of service, for staff who qualify.
- The T10 certificate for each employee, and the employer’s Annual Statement of Employer filed with the Inland Revenue Department.
Neither product has a Sri Lankan tax table, an EPF/ETF rate built in, or a T10 form. See Payroll Journal Entries for Sri Lankan Employers for how these figures are meant to be posted once you have them.
The spreadsheet workaround firms use, and where it breaks
Many firms keep client pay in a spreadsheet. They work out EPF, ETF and APIT by hand, then key the totals into QuickBooks or Xero as a journal. A rate change, a new joiner mid-month, or one wrong formula cell can throw off every client on the sheet. The spreadsheet also has no audit trail of who changed what. See when to switch from Excel to payroll software for the signs it is time to stop.
Option: local payroll plus a journal export into the ledger
The common fix is to run payroll in a system built for Sri Lanka, then send the totals into QuickBooks or Xero as a journal. Payroll handles EPF, ETF, APIT, gratuity and the T10. QuickBooks or Xero stays the single source of truth for the accounts. Neither product needs to know how EPF is calculated, only what the month’s totals were.
What the integration should post, line by line
A clean export gives you one payroll cost line, and separate lines for each liability:
| Line | What it is |
|---|---|
| Payroll cost | Gross wages plus employer EPF (12%) and ETF (3%) |
| EPF payable | Employee 8% plus employer 12%, due to the EPF Department |
| ETF payable | Employer 3%, due to the ETF Board |
| APIT payable | Tax withheld from staff pay, due to the Inland Revenue Department |
| Net pay payable | What actually goes to staff bank accounts |
If your export from any payroll tool does not split these lines out, ask why. A single lump “payroll” figure hides errors instead of catching them.
A bookkeeping firm running 20 client payrolls by hand in a spreadsheet pays in staff time instead. Someone recalculates EPF and ETF for every rate change, and rebuilds APIT bands each 1 April. Local payroll software with the calculations built in moves that cost from staff hours to a monthly subscription, priced per client rather than per hour. See Outsource Payroll or Run It In-House in Sri Lanka? for the wider cost comparison.
Do this automatically in Humanised. Payroll software for accountants is a local payroll engine that posts each month’s salary journal into QuickBooks Online, Xero or Zoho Books. It calculates EPF, ETF and APIT, and prepares the C-form, R4 and bank files for every client from one login. Plans start at LKR 10,000 a month for up to 15 staff, with a free 7-day assisted trial, 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
Can QuickBooks or Xero pay staff in USD?
That is a currency question for your accounting system. It is separate from EPF, ETF and APIT, which are worked out on the employee’s rupee earnings either way.
Does either product handle contractor payments differently from employee payments?
Both can record a contractor invoice like any other bill. Neither one decides whether someone is legally a contractor or an employee for EPF and ETF purposes. See Contractor or Employee? EPF, ETF and Gratuity for that distinction.
Can I file the T10 or the Annual Statement of Employer from QuickBooks or Xero?
No. The T10 goes to each employee and the Annual Statement goes to the Inland Revenue Department. Both come from payroll records, not the ledger.
Is there a Sri Lanka edition of QuickBooks or Xero coming?
Neither vendor has published Sri Lanka as a payroll region. Check their own sites for the current list before assuming otherwise.
Do I still need an accountant if I use local payroll software?
Yes. Payroll software handles the statutory calculations and prepares the filings. Your accountant still owns the wider ledger, tax position and financial statements.
Was this article helpful?
Your feedback helps us improve these guides.