St. Kitts & Nevis Social Security Calculator

Enter an employee wage and select the pay period to calculate Social Security, employee levy, employer levy, severance, and totals.

Inputs

The original sheet contains four schedules: Weekly, Every Two Weeks, Twice Per Month, and Monthly.
Based on your uploaded 2014 sheet

Results

Entered Wage
EC$0.00
Monthly Equivalent Wage
EC$0.00
Grand Total
EC$0.00
Item Formula Amount
Employee Social Security Wages × 5% EC$0.00
Employer Social Security Wages × 6% EC$0.00
Total Social Security Employee SS + Employer SS EC$0.00
Employee Levy Tiered monthly levy EC$0.00
Employer Levy Wages × 3% EC$0.00
Severance Wages × 1% EC$0.00
Total Due to Accountant General Employee Levy + Employer Levy + Severance EC$0.00
Social Security Remittance Total Social Security EC$0.00
Grand Total Due Accountant General Total + Social Security Remittance EC$0.00
How employee levy is handled here: the calculator converts the entered wage to a monthly equivalent, applies the three monthly levy tiers progressively, then converts the levy back to the selected pay frequency. This is the safest interpretation of the tier setup found in your sheet. If you want, I can also make a version that matches a different rule exactly.