About Advanced Foreign APIT Calculator - Cumulative APIT for Foreign Employer Income (Sri Lanka)

This tool computes Advance Personal Income Tax (APIT) for Sri Lankan residents who receive employment income from a foreign employer, using the Inland Revenue Department’s cumulative method for the Year of Assessment (YOA: April → March). Unlike simple monthly estimators, it tracks cumulative income in LKR across months and calculates the monthly payable APIT as the difference between current cumulative liability and the prior cumulative liability.

Who this is for

• Sri Lankan resident employees paid by a foreign employer while physically in Sri Lanka
• People who must withhold and remit APIT according to the IRD table “Rate for the deduction of tax from the employment income received from foreign employer”
• Users who need an accurate, month-by-month cumulative calculation across the YOA (Apr–Mar)

Key features

• True cumulative method (Apr–Mar): Sorts months in fiscal order and applies cumulative liability at each step
• Per‑month entries: Add up to 12 months with foreign amount, payment date, and exchange rate
• Exchange‑rate lookup with override: Auto-finds the rate for the selected date from our dataset, lets you edit or reset per month
• Supported currencies: AUD, CAD, EUR, GBP, NZD, SGD, USD (single currency per calculation)
• Clear results: Overview cards (Total Income, Total APIT, Effective Rate) and a detailed month-by-month table
• Export & print: One-click CSV export and a nicely formatted PDF (A4) with header, summary boxes, and breakdown table
• Quality‑of‑life: Editable month labels, add/remove rows, Load Example, and Reset

Inputs you’ll provide

• Tax Year (Start Year): The April year of the YOA (e.g., enter 2025 for Apr 2025–Mar 2026)
• Foreign Currency: One of AUD, CAD, EUR, GBP, NZD, SGD, USD
• Monthly Entries (up to 12) for the chosen currency:
  • Foreign Currency Income (gross for that month)
  • Date Received (YYYY‑MM‑DD) used to fetch the historical exchange rate
  • Exchange Rate (to LKR) auto-fetched with controls to edit, refresh, or reset to the fetched rate
  • Month Label is editable (default labels run Apr → Mar)

Use the floating “+” button to add a month (max 12). You can remove individual months, load an example set, or reset the whole form.

Exchange‑rate handling

• Auto‑fetch: When you set a valid date, the tool pulls the closest available historical rate for the selected currency and date from our curated dataset
• Per‑month control: You can fully override, refresh, or reset the rate for each row
• Transparency: The fetched rate is stored so you can revert after manual edits

Note: The calculator uses one currency per run. If your income spans multiple currencies, either convert externally before input, or run separate calculations.

How the calculation works

For each active month (foreign amount > 0):

1. Convert to LKR: LKR Amount = Foreign Amount × Exchange Rate
2. Cumulative LKR: Add the month’s LKR amount to the running total for the YOA
3. Cumulative liability: Apply Sri Lanka’s foreign‑employer APIT thresholds to the cumulative income:
   • 0% on the first Rs. 1,800,000
   • 6% on the next Rs. 1,000,000 (effective offset Rs. 108,000)
   • 15% on the balance (effective offset Rs. 360,000)
4. Monthly payable: Current cumulative liability − previous cumulative liability
5. Monthly effective rate: Monthly payable ÷ LKR Amount × 100

At the end, you’ll see totals for Total Income (LKR), Total APIT (LKR), and Overall Effective Rate (%).

What the results show

• Overview cards:
  • Total Income (LKR)
  • Total APIT (LKR)
  • Effective Rate (%)
• Breakdown table per month:
  • Month label
  • Foreign Amount (in the selected currency)
  • Exchange Rate (to LKR)
  • LKR Amount
  • Cumulative LKR
  • Cumulative Liability
  • Monthly Payable
  • Monthly Effective Rate (%)
• Totals row consolidating income, tax, and effective rate

Export and print

• CSV export: Download a CSV including all monthly rows and a totals row (filename advanced-foreign-apit-{taxYear}.csv)
• PDF print: Generate a polished A4 PDF with a header, three summary boxes, and the full breakdown table (filename advanced-foreign-apit-{taxYear}.pdf)

Tips for accurate use

• Use the actual payment date: Rates are fetched against your selected date; choose the date funds were received
• Double‑check edited rates: If you override a rate, ensure it matches bank or contractual rates you intend to apply
• One currency per run: Keep calculations per currency for clarity; combine outside the tool if needed
• Apr → Mar order: The tool sorts months by the Sri Lankan YOA even if you rename labels

Important notes & limitations

• This tool is country‑specific (Sri Lanka) and implements the cumulative APIT method for foreign employer income
• It does not model allowances, deductions, reliefs, or other tax credits beyond the foreign‑employer APIT table
• Always refer to official IRD guidance and consult a qualified tax professional for personal advice

Reference

• IRD Sri Lanka: “Rate for the deduction of tax from the employment income received from foreign employer”