Attendance import
Upload consolidated attendance Excel · calendar month pay cycle (1st–end of month)
Required columns: Employee ID, Employee Name, Date, Status — one row per employee per day present. Download the attendance template to give to whoever consolidates the fingerprint machine export each month.
📋
No attendance data
Upload your fingerprint CSV or load sample data
Employees
All changes save automatically to AWS S3
Bulk import: Download employee template CSV → fill in → click Bulk import CSV above.
👤
Loading...
EPF: Employee 8% · Employer 12% · ETF: Employer 3% · APIT personal relief LKR 1,800,000/yr · Shop & Office Act: 14 casual + 7 sick + 14 annual leave days/yr
Monthly payroll run
Draft → review & edit → approve · pay cycle 1st–end of month
Basic salary covers the full calendar month, including weekends and public holidays. After calculating, every employee defaults to full pay. If finance has confirmed an unauthorised absence, enter the number of No-pay days directly in that employee's row below — it will recalculate their pay immediately.
⚙️
Payroll not calculated
Load attendance · confirm employees · process leave · then calculate
Visiting faculty
Master list · session log · payment calculation · dual cycle
Dual cycle: Session 1st–15th → paid 30th same month · Session 16th–end → paid 15th following month
Faculty master list
Register faculty once — details pre-fill when logging sessions
👨🏫
No faculty registered
Add faculty above to enable dropdown selection when logging sessions
Leave requests
Approve before running payroll · saves to AWS S3
🗓️
No leave requests
Shop and Offices Act No. 19 of 1954: 14 casual · 7 sick · 14 annual leave days per year.
Payroll history
All approved payroll runs · click any month to view full breakdown
📊
No approved payroll runs yet
Approve a payroll run to see it here
Leave policy & entitlement
Shop and Office Employees Act No. 19 of 1954 · automatically calculated from employee start dates
Casual leave
Covers illness, personal matters, and all non-annual leave
Year 1 — accrual basis
½ day per completed month of service
= 1 day per every 2 completed months
= 1 day per every 2 completed months
Year 2 onwards — full entitlement
7 days per calendar year
Resets 1 January each year. No carryover.
Annual leave
Earned leave · pro-rated in year 2 by joining quarter
Year 1: No annual leave entitlement
Year 2: Pro-rated by joining quarter (4–14 days)
Year 3+: 14 days per calendar year (full entitlement)
At least 7 consecutive days must be taken. Resets 1 January each year.
Annual leave — year 2 entitlement by joining quarter
Source: §6 Shop and Office Employees Act No. 19 of 1954
| Joining quarter (calendar year 1) | Annual leave in year 2 | Year 3 onward | Months of service in year 1 |
|---|---|---|---|
| Q1 January – March | 14 days (full) | 14 days | 9 – 12 months |
| Q2 April – June | 10 days | 14 days | 6 – 9 months |
| Q3 July – September | 7 days | 14 days | 3 – 6 months |
| Q4 October – December | 4 days | 14 days | 1 – 3 months |
Casual leave — year 1 accrual by joining month
Formula: floor(completed months of service ÷ 2) = casual days entitlement for year 1
| Joining month | Completed months in year 1 | Casual leave entitlement (year 1) |
|---|
Probation provisions
Minimum Retirement Age of Workers Act No. 28 of 2021 · Shop and Office Employees Act
What probation affects
· Maximum 180 days (6 months)
· Employer can terminate without notice
· No statutory termination protections
· Employer assesses suitability
· Employer can terminate without notice
· No statutory termination protections
· Employer assesses suitability
What probation does NOT affect
· Casual leave accrual — starts day one
· Annual leave calculation — probation counts as service
· EPF / ETF contributions
· Statutory holiday entitlement
· Annual leave calculation — probation counts as service
· EPF / ETF contributions
· Statutory holiday entitlement
If an employee is terminated during probation, any accrued casual leave must be paid out. The annual leave entitlement for year 2 is calculated including any probation months served.
Leave entitlement calculator
Enter any start date to see exact entitlement for this calendar year
Employee leave status —
Entitlements calculated automatically from start dates · used days tracked from approved leave requests
📅
Loading...
Start dates must be entered on each employee record for entitlements to calculate. Click Edit on an employee to add their start date.
Payslips
Full itemised statements · print to PDF
📄
No payslips yet
Run and approve payroll to generate payslips
Settings
Company defaults · statutory rates
User management
Change passwords for each account · Admin and MD only
Database connection
AWS S3 via Lambda · always on
Data saves automatically to AWS S3 on every action.
Phase 3 — planned improvements
◦ Payslip email distribution via AWS SES
◦ Staff self-service payslip portal in Teams
◦ EPF / ETF / APIT statutory reports
◦ Date-matched leave validation
◦ Annual leave balance reset
◦ Staff self-service payslip portal in Teams
◦ EPF / ETF / APIT statutory reports
◦ Date-matched leave validation
◦ Annual leave balance reset
APIT slabs — Y/A 2025/2026
Inland Revenue (Amendment) Act No. 2 of 2025
| Annual taxable income | Rate |
|---|---|
| First LKR 1,800,000 | Tax-free |
| Next LKR 1,000,000 | 6% |
| Next LKR 500,000 | 18% |
| Next LKR 500,000 | 24% |
| Next LKR 500,000 | 30% |
| Above LKR 4,300,000 | 36% |
Statutory rates
Fixed by statute — not editable
| Item | Rate | Paid by |
|---|---|---|
| EPF employee | 8% | Employee |
| EPF employer | 12% | Employer |
| ETF | 3% | Employer |
| WHT on faculty | 5% | Withheld |
Leave entitlements
Shop and Offices Act No. 19 of 1954
| Type | Days/year |
|---|---|
| Casual leave | 14 |
| Sick leave | 7 |
| Annual leave (after 1 yr) | 14 |
| Maternity leave | 84 working days |