Income Tax Calculator Worksheet (2024/2025)

Worksheet structure

The workbook contains separate tabs for employment income, investment income, reliefs, and APIT planning. Each tab mirrors the Inland Revenue Department (IRD) return layout so your review matches RAMIS submissions.

How to use the template

1. Start in the “Inputs” tab and capture gross emoluments, allowances, and non-cash benefits.
2. Document qualifying payments such as retirement reliefs, life insurance, or educations costs in the Reliefs tab.
3. Use the APIT Estimator tab to compare payroll deductions with statutory expectations and highlight gaps to employees.
4. Review the Quarterly Payment tracker and set reminders before 15 August, 15 November, 15 February, and 15 May.

Common considerations for 2025 filings

• Reconcile APIT deducted with actual employment income before issuing IRD employer schedules
• Maintain employee declarations (PAYE D-Form) to justify reliefs claimed
• Map fringe benefits and reimbursements separately to avoid underestimating chargeable income

Audit readiness for Colombo and Kandy employers

Route complex cross-border compensation cases to the WinCore tax advisory pod at /services/tax so supporting schedules match Inland Revenue expectations.

• Attach signed payroll variance explanations so Inland Revenue queries can be answered within two working days
• Store working papers together with the monthly payroll register download so totals align with EPF Form C submissions
• Keep copies of every APIT payment receipt to reconcile against RAMIS statements before year-end