Colombia Payroll & Severance Calculator (Liquidación 2026)

Calculate Colombian labor settlements and payroll figures through an API: liquidación de contrato, salario neto, costo de un empleado, horas extra y recargos, indemnización and seguridad social de independientes. The rules are current for 2026, including the Ley 2466 de 2025 labor reform (Sunday surcharge 90% and night work from 7 p.m.) and the 42-hour week in force since 15 July 2026.

Every result comes with the formula, the days counted and the legal article behind each line, so you can show it to an employee, an accountant or a judge.

What can it calculate?

Calculation	Typical use
liquidacion	Final settlement when a contract ends: cesantías, intereses, prima, vacaciones, unpaid salary and, if applicable, indemnización.
salario_neto	Net monthly pay: health 4%, pension 4%, solidarity fund and withholding tax (procedimiento 1).
costo_empleado	Total monthly and yearly cost of an employee: social security, parafiscales, ARL and benefit provisions, with or without the ET art. 114-1 exemption.
horas_extras	Overtime and surcharges with the right hourly divisor (210 h since 15-jul-2026) and the Sunday surcharge in force on that date.
indemnizacion	Severance for dismissal without just cause (CST art. 64) for open-ended, fixed-term and specific-job contracts.
seguridad_social_independiente	What a contractor pays on PILA: 40% contribution base, health 12.5%, pension 16%, solidarity fund and ARL.
parametros	Official values per year: minimum wage, transport allowance and UVT.

Who is it for?

• HR and payroll software that needs a reliable Colombian calculation engine without maintaining the rules.
• AI agents and chatbots that answer labor questions and must not guess numbers. This Actor works as a tool through the Apify MCP server.
• Accountants and lawyers who process many settlements and want a breakdown they can audit.
• Fintechs and lenders estimating disposable income.

How to use it

1. Choose a Calculation and fill in the fields it needs (salary, dates, contract type, termination reason).
2. Run the Actor. Each calculation becomes one row in the dataset.
3. To process many people at once, put a list in Batch. Each item uses the same field names and may carry your own id.

Example batch input:

{
  "operation": "liquidacion",
  "batch": [
    { "id": "EMP-001", "operation": "liquidacion", "salary": 2500000, "startDate": "2024-06-10", "endDate": "2026-10-23", "terminationReason": "despido_sin_justa_causa", "vacationDaysTaken": 10 },
    { "id": "EMP-002", "operation": "salario_neto", "salary": 8000000, "date": "2026-10-23" },
    { "id": "CTR-114", "operation": "seguridad_social_independiente", "monthlyIncome": 5000000 }
  ]
}

Output example

{
  "id": "EMP-001",
  "operation": "liquidacion",
  "status": "ok",
  "currency": "COP",
  "rulesVersion": "2026-10-23",
  "summary": {
    "cesantias": 2237458,
    "interesesCesantias": 218525,
    "prima": 862910,
    "vacaciones": 2131944,
    "indemnizacion": 4787037,
    "totalEarned": 10237874,
    "totalDeductions": 0,
    "netToPay": 10237874
  },
  "result": {
    "lineas": [
      { "concepto": "Cesantías", "formula": "$ 2.749.095 × 293 / 360", "valor": 2237458, "norma": "CST art. 249" }
    ]
  },
  "warnings": ["Se incluyó el auxilio de transporte en la base de cesantías y prima porque el salario no supera 2 SMMLV."]
}

Rules included

• Minimum wage 2026: COP 1,750,905; transport allowance COP 249,095; UVT COP 52,374 (Decretos 1469 y 1470 de 2025, Resolución DIAN 000238 de 2025). 2025 values are also loaded.
• Weekly hours by date under Ley 2101 de 2021: 47 h, 46 h, 44 h and 42 h from 15-jul-2026 (hour divisor 210).
• Sunday and holiday surcharge under Ley 2466 de 2025: 80% from 1-jul-2025, 90% from 1-jul-2026, 100% from 1-jul-2027. Night work starts at 7 p.m. since 25-dic-2025.
• Commercial 360-day year, transport allowance in the benefits base up to 2 minimum wages, integral salary with a 70% contribution base.
• Withholding tax procedimiento 1 (ET arts. 383, 387, 388, 206-10, 336) with the 790 UVT yearly cap on the 25% exempt income.

When the 2027 minimum wage and UVT are published (late December 2026), they are added here, and older dates keep using the values of their own year.

Use cases

• HR and payroll teams: check a liquidación before signing it, or run the whole staff in one batch.
• Labor lawyers and accountants: get the breakdown (cesantías, intereses, prima, vacaciones, indemnización) with the legal article behind each line.
• HR software and fintechs: add Colombian severance and net-salary math to your product through the API.
• AI assistants: answer "how much is my liquidación?" with a deterministic calculation instead of a guess.

Use with AI agents (MCP)

Every Apify Actor is also a tool for AI agents. Add this Actor to Claude, Cursor, VS Code or any MCP client with the Apify MCP server:

https://mcp.apify.com?tools=ceibadata/colombia-payroll-calculator

Or run it locally:

$npx -y @apify/actors-mcp-server --tools ceibadata/colombia-payroll-calculator

Then just ask, for example:

Calculate the severance (liquidación) for an employee in Colombia who earned 3,000,000 COP a month from 2023-02-01 to 2026-11-04 and was dismissed without just cause.

Example input (API / AI agents)

{
  "operation": "liquidacion",
  "salary": 3000000,
  "startDate": "2023-02-01",
  "endDate": "2026-11-04",
  "contractType": "indefinido",
  "terminationReason": "despido_sin_justa_causa"
}

From code, one call returns the results:

curl -X POST "https://api.apify.com/v2/acts/ceibadata~colombia-payroll-calculator/run-sync-get-dataset-items?token=$APIFY_TOKEN" \
  -H 'Content-Type: application/json' -d @input.json

Pricing

You pay per calculation that finishes successfully. Calculations that fail validation are free. There are no monthly fees.

FAQ

Is the result legally binding? No. It is an informational calculation that follows the law as of the rules version in each row. For disputes, check with an accountant or labor lawyer.

Why does my result differ from another calculator? The usual causes are the transport allowance in the base (it applies up to 2 minimum wages), the 360-day commercial year, the hourly divisor after the 2026 reduction, or vacation days already taken. Every row shows the formula and days used.

Do you store my data? Inputs and results stay in your own Apify storage. Ceiba Data does not see them.

---

En español

Calculadora laboral de Colombia por API. Liquidación de contrato, salario neto, costo de un empleado, horas extra y recargos (dominical 90% y nocturno desde las 7 p. m.), indemnización por despido sin justa causa y seguridad social de independientes (IBC 40%). Actualizada con la Ley 2466 de 2025 y la jornada de 42 horas. Cada resultado trae la fórmula, los días y el artículo de ley. Ideal para software de nómina, chatbots de recursos humanos, contadores y abogados laborales.

---

Built and maintained by Ceiba Data, a studio that publishes Latin American data tools on Apify. Ceiba Data is operated with AI; rules are reviewed against official sources before each update. Found a mistake or need another calculation? Open an issue on this Actor and we will answer within 24 hours.