Payslip Template Ivory Coast (Free Excel Download)

Ivory Coast Payslip Template (Free Excel Download)

A ready-to-use payslip template for Ivorian employers, with the country's statutory deduction lines built in: the CNPS old-age employee contribution, PAYE income tax withheld under the DGI's progressive brackets, and the employer-only levies (old-age, family allowances, work accidents, training and housing). Copy it into Excel or Google Sheets and it is ready for your monthly payroll run.

How to Use This Template

1. Fill in the employer and employee header fields once — they stay the same every month.
2. Enter gross monthly earnings (basic salary plus allowances and overtime).
3. Apply the CNPS and income-tax lines exactly as shown — the formulas are described beside each line.
4. Issue one copy to the employee and keep one for your payroll records.

Ivory Coast Payslip Template

Employer: [Company Name] | CNPS Employer No.: [] Employee: [Full Name] | National ID No.: [] Designation: [] | CNPS Member No.: [] Pay Period: [Month / Year] | Payment Date: [DD/MM/YYYY]

Employer contributions (not deducted from employee):

Worked Example

Monthly gross salary: XOF 300,000 (no other allowances).

• CNPS old-age employee: 6.3% × 300,000 = XOF 18,900 (deducted)
• Income tax: withheld per the DGI's progressive monthly tables for the employee's bracket (deducted)
• Net pay: 300,000 − 18,900 − income tax
• CNPS old-age employer: 7.7% × 300,000 = XOF 23,100 (employer cost)
• CNPS family allowances: 5.75% × 300,000 = XOF 17,250 (employer cost)
• Vocational training tax: 1.2% × 300,000 = XOF 3,600 (employer cost)
• Housing fund: 1.5% × 300,000 = XOF 4,500 (employer cost)
• Work-accident insurance: 2% (the minimum of the verified 2–5% sector range — confirm your rate with the CNPS) × 300,000 = XOF 6,000 (employer cost)
• Total employer cost: 300,000 + 23,100 + 17,250 + 3,600 + 4,500 + 6,000 = XOF 354,450 (18.15% on top of salary, before income tax)

Statutory Notes for Ivory Coast Payroll

• CNPS old-age insurance is financed jointly: 6.3% employee, 7.7% employer, on the salary subject to contributions.
• Family allowances (5.75%), maternity insurance, and work-accident insurance (2–5%) are employer-only; the employee contributes nothing to these branches.
• Income tax is withheld monthly by the employer under the PAYE system using the DGI's progressive brackets (0% to 32%).
• Contributions apply from the first day of employment; employers must register each employee with the CNPS from day one.
• The old-age branch applies up to a monthly contribution ceiling — confirm the current ceiling with the CNPS before each payroll year, as published ceilings and thresholds change.
• Always verify current rates against the DGI and the CNPS before each payroll year, as rates, brackets and ceilings are revised periodically.

Pro Tips

• Show employer contributions on the slip. Staff often don't realise the company pays roughly 18% on top of their salary — printing it builds trust and reduces disputes.
• Keep the CNPS member number on every payslip. It is the single identifier auditors and the fund ask for.
• Confirm the work-accident rate for your sector. It varies from 2% to 5% by activity — don't default to the minimum without checking.
• Register new hires on day one. CNPS registration is due from the first day of employment, not after probation.
• Reconcile monthly. Gross minus deductions must equal net pay to the franc; small rounding drifts repeated across staff compound fast.

Frequently Asked Questions

Q1: What is the CNPS on an Ivorian payslip? A: The CNPS (Caisse Nationale de Prévoyance Sociale) is Ivory Coast's social security fund. The old-age branch shows two lines: 6.3% deducted from the employee's salary and 7.7% paid by the employer. Family allowances, maternity and work-accident branches are employer-only.

Q2: How much does the employer pay on top of salary in Ivory Coast? A: Roughly 18–22%: 7.7% old-age, 5.75% family allowances, 2–5% work accidents, 1.2% vocational training tax and 1.5% housing fund — all employer-only.

Q3: Is there income tax on salaries in Ivory Coast? A: Yes. The employer withholds personal income tax each month under the PAYE system, using the DGI's progressive brackets ranging from 0% to 32%.

Q4: Does CNPS apply from the first day of work? A: Yes. Employers must register employees with the CNPS from the first day of employment, and contributions start immediately.

Q5: Is there a ceiling on CNPS contributions? A: The old-age branch applies up to a published monthly ceiling — earnings above it are not subject to further old-age deductions. Confirm the current ceiling with the CNPS, as it is revised periodically.

Q6: What is the CMU line sometimes seen on Ivorian payslips? A: The CMU (Couverture Maladie Universelle) is the universal health coverage scheme. Contributions are shared between employer and employee — check the current CMU rules with the CNPS before adding the line.