Upload one pay sheet. Get journals and EPF, ETF and APIT schedules.
Ganana's payroll is import-first: upload one pay sheet per pay run from any HR system, payroll bureau or spreadsheet, and Ganana checks it, posts it to the ledger and tracks what you owe staff, the EPF and ETF funds and the IRD until each is paid. Native pay calculation and Ganana's own HR system come later.
| Account | Debit | Credit |
|---|---|---|
| 6010 Salaries (gross) | 4,50,000.00 | |
| 6020 EPF employer 12% | 54,000.00 | |
| 6030 ETF employer 3% | 13,500.00 | |
| 2410 Net salaries payable | 3,94,500.00 | |
| 2420 EPF payable | 90,000.00 | |
| 2430 ETF payable | 13,500.00 | |
| 2440 APIT payable | 13,500.00 | |
| 1250 Staff loans recovered | 6,000.00 |
- Excel, CSV or PDF, one row per employee
- EPF 8% + 12% and ETF 3% rechecked for every employee
- Only payroll roles see individual salaries
What can I upload?
- Excel, CSV or PDF pay sheets in any layout, one row per employee. The AI maps the columns the first time and remembers the mapping for that source.
- Typical columns: employee ID, name, NIC, EPF number, department or cost centre, basic, allowances, overtime, gross, EPF (employee 8%, employer 12%), ETF (employer 3%), APIT, loan or advance recoveries, other deductions and net pay. Any extra column can become a new pay component.
- If you build your pay sheet by hand, start from the free pay sheet template.
What does Ganana check before posting?
All checks are warnings; none of them blocks you, because special cases are legitimate.
- Each row's gross less deductions equals net pay, and the column totals agree with any totals row in the file.
- EPF is recomputed at 8% and 12% and ETF at 3% of EPF-liable earnings, and any difference is highlighted per employee.
- APIT is compared with the current IRD table.
- New, missing or changed employees since the last run, and salary changes above a percentage you set.
How does a pay run post to the ledger?
Each pay component maps to a ledger account, optionally per department or cost centre. You choose one summary journal per run or one journal per employee. A typical summary journal:
| Account | Debit (LKR) | Credit (LKR) |
|---|---|---|
| 6010 Salaries and wages (gross) | 4,50,000.00 | |
| 6020 EPF employer contribution 12% | 54,000.00 | |
| 6030 ETF employer contribution 3% | 13,500.00 | |
| 2410 Net salaries payable | 3,94,500.00 | |
| 2420 EPF payable (8% + 12%) | 90,000.00 | |
| 2430 ETF payable (3%) | 13,500.00 | |
| 2440 APIT payable | 13,500.00 | |
| 1250 Staff loans and advances (recovered) | 6,000.00 |
What happens after a pay run is posted?
- The salary transfer, EPF payment, ETF payment and APIT remittance appear as items to pay, and are matched automatically when they show up on your bank statement.
- EPF and ETF contribution schedules and the monthly APIT schedule are produced from the imported rows.
- Per-employee detail is kept for year-to-date reports, the APIT annual statement and the audit.
- A posted run can be reversed and re-imported. Corrections never edit the original.
Who can see salaries?
Only roles with payroll permission can see individual salaries; everyone else sees totals. Salaries are also stored with field-level encryption. See security.
Frequently asked questions
Does Ganana calculate salaries?
Not at launch. You calculate pay in your HR system, bureau or spreadsheet and import the result; Ganana checks it and does the accounting. Native pay calculation comes later.
Can I correct a pay run after posting it?
Yes. Reverse the run and import the corrected file. The original is never edited, so the audit trail stays complete.
How do I check EPF and ETF for one employee?
Use the free EPF and ETF calculator, or the APIT calculator for income tax.
Last reviewed:
Let the books do themselves.
Start on the Free plan. No card needed.