Inventory Management Software

Kardex Tauro

Kardex Tauro® Inventory Software is designed to efficiently manage your warehouse or storage facility, and it is quick and easy to learn.

Kardex Tauro is free for non-commercial use.
It does not require an internet connection; it runs on Windows.

Electronic payroll in Colombia: how it is calculated and sent to DIAN

Electronic payroll in Colombia: how it is calculated and sent to DIAN

Paying payroll is the easy part. Calculating it correctly, accruing what the law requires and filing the XML that DIAN validates before the deadline is where things get complicated. Many Colombian SMEs pay on time and leave the supporting document for later; the problem surfaces months afterwards, when the expense has already been recorded and the tax deduction falls apart for lack of a document. What follows is the full calculation —gross pay, deductions, employer contributions and accruals—, the filing cycle and an example you can replicate with your own figures.

What electronic payroll is and how it differs from an invoice

Electronic payroll is the document that supports salary payments and is sent to DIAN (the Colombian tax authority) in XML format for validation. It is not the electronic sales invoice. It is a different document, with a different format, a different enablement process and a different set of rules. Confusing the two is the first configuration mistake a company makes when it starts working on this.

It does not replace the payslip the employee signs either, nor the internal calculation. It is the structured version of that calculation, with every concept identified by a code, and it serves as the supporting document for salary payments for deduction and cost purposes. Without it the expense exists in the accounting records, but DIAN can reject it when assessing income tax.

And it is not an annual formality. It is generated per period —monthly, fortnightly or weekly, depending on how you pay— and each period has its own filing and its own deadline.

Who is required to file it and what happens if you don't

Every employer that pays salaries is required to file, regardless of size. It applies to companies and to individuals who hire, and also to someone with a single employee. There is no minimum headcount that exempts you.

The consequences come in two parts and they add up. The first is tax-related: a salary payment without a valid supporting document loses its deductibility for income tax, so the company ends up paying tax on a profit it actually spent. The second is punitive: DIAN can penalise late filing or omission.

It helps to separate "I didn't file" from "I filed it wrong". A rejected XML is useless as support even if payroll was paid in full. The system reports the error, you correct it and resubmit; until the document is validated, the period is incomplete.

The structure of payroll: gross pay, deductions and net pay

Payroll has four blocks, and only two of them show up on the employee's payslip. Understanding all four is what separates a correct calculation from one that unbalances your cash flow at year end.

BlockWhat it includesWho pays itWhen it leaves the bank
Gross payBase salary, overtime and surcharges, commissions, transport allowance, travel expenses, bonuses and occasional paymentsEmployerOn the period's payment date
DeductionsEmployee contributions to health (4 %) and pension (4 %), withholding tax, loans, wage garnishments and payroll loansDeducted from the employeeThey do not leave the company: they are transferred to third parties
Employer contributionsHealth 8.5 %, pension 12 %, ARL, SENA 2 %, ICBF 3 % and family compensation fund 4 %Employer, on top of salaryThe month after the period
AccrualsService bonus 8.33 %, severance 8.33 %, interest on severance and vacation 4.17 %Employer, accrued monthlyThey do not leave now: they are liabilities

The transport allowance is the concept that causes the most confusion. It does not count as salary under Colombian law, so it is not part of the base for health and pension contributions or for withholding tax. It is, however, included in the base for the service bonus and severance. Treat it as salary for everything and you overpay contributions; ignore it everywhere and you understate accruals.

Net pay is a simple subtraction between gross pay and deductions, but only when the deductions are correctly set up. A loan or a payroll loan with the wrong parameters throws off net pay and forces a recalculation, adjustment note included.

The employer contributions that never appear on the payslip

The payslip shows what is deducted from the employee. It does not show what the employer pays on top of salary, and that is the block that weighs most on the real cost.

On salary, excluding the transport allowance, the employer pays: health 8.5 %, pension 12 %, ARL according to the risk level of the workplace, SENA 2 %, ICBF 3 % and family compensation fund 4 %. With those percentages, a salary of $2,500,000 generates $750,550 in contributions in the example below.

ARL is the only one without a fixed rate: it depends on the activity and the assigned risk level, which is why it differs between a services company and a manufacturer. SENA, ICBF and family compensation fund percentages are calculated on payroll and are subject to exemptions, explained further down.

Two warnings. First: these contributions are transferred the following month, so in the current month they are a liability, not a cash outflow. Second: exemptions exist and depend on the type of employer and the employee's salary; they are not something to budget by default.

Accruals: money that is already committed

The service bonus, severance, interest on severance and vacation are not paid every month, but they accrue every month. That gap explains why many companies reach December without the money to pay the bonus.

Monthly accruals are: service bonus 8.33 %, severance 8.33 %, interest on severance 12 % per year —equivalent to 1 % per month— and vacation 4.17 %. On a salary of $2,500,000 they add up to $545,900 per month.

This is not available cash. It is a liability: the company owes the amount, but payment happens later. If that money is used as working capital and then the bonus falls due in June or severance on the employee's departure, the shortfall appears all at once. In accounting terms the accrual is an expense of the period, even though the disbursement is in the future.

Overtime, surcharges and Sundays: where mistakes cluster

Ordinary hours, night hours and Sunday or holiday hours carry different surcharges, and that is where calculation errors concentrate. The classic percentages are these:

SituationSurchargeHow to read it
Daytime overtime25 %On the value of the ordinary hour
Night-time overtime75 %On the value of the ordinary hour
Sunday or holiday work100 %On the value of the ordinary hour
Combinations: night work on a Sunday, overtime on a holidayCheck the current tableIt is not the simple sum of the two surcharges

Each surcharge applies to the value of the ordinary hour, obtained by dividing the monthly salary by the hours of the agreed schedule, not by a fixed number. Ordinary night work also carries its own surcharge, different from night-time overtime; do not mix them up.

When a combination is not clear in your table, check the current table before calculating. Percentages and combinations have been changed by law and may change again, so a formula copied from a previous year is a source of silent error.

A practical control: overtime must be authorised in writing and recorded with start and end times. Without that support, the payment is an expense you cannot defend in a review.

A complete monthly payroll example

The exercise uses a base salary of $2,500,000, no overtime and a transport allowance. The allowance and the ARL values are examples: the allowance changes every year by decree and ARL depends on the risk level, so verify both before using these figures.

Step 1, gross pay: $2,500,000 in salary plus $200,000 in transport allowance gives $2,700,000.

Step 2, contribution base: it is calculated on salary, without the allowance, because the allowance does not count as salary. The base is $2,500,000.

Step 3, deductions: health 4 % = $100,000 and pension 4 % = $100,000. Withholding tax applies according to the year's table and the employee's deductions; in this example it is $0.

Step 4, net pay: $2,700,000 minus $200,000 in deductions gives $2,500,000.

Step 5, employer contributions on $2,500,000: health 8.5 % = $212,500; pension 12 % = $300,000; ARL 0.522 % = $13,050; SENA 2 % = $50,000; ICBF 3 % = $75,000; family fund 4 % = $100,000. Total, $750,550.

Step 6, accruals on $2,500,000: bonus $208,325; severance $208,325; interest $25,000; vacation $104,250. Total, $545,900.

Step 7, total cost: $2,700,000 + $750,550 + $545,900 = $3,996,450.

This is how the complete calculation looks, with all four blocks in one view:

ConceptBase or percentageAmount
Gross pay
Base salary—$2,500,000
Transport allowance (example value)—$200,000
Total gross pay$2,700,000
Employee deductions
Health4 % of $2,500,000-$100,000
Pension4 % of $2,500,000-$100,000
Withholding taxYear's table; not applicable in this example$0
Net pay to the employee$2,500,000
Employer contributions
Health8.5 %$212,500
Pension12 %$300,000
ARL (example risk level)0.522 %$13,050
SENA2 %$50,000
ICBF3 %$75,000
Family compensation fund4 %$100,000
Total contributions$750,550
Accruals for the month
Service bonus8.33 %$208,325
Severance8.33 %$208,325
Interest on severance12 % per year (1 % per month)$25,000
Vacation4.17 %$104,250
Total accruals$545,900
Total employer cost$3,996,450

Accruals were calculated on base salary to keep the exercise simple. In practice the transport allowance is part of the base for the service bonus and severance, so the real figure will be somewhat higher and it is worth confirming the base with your accountant.

Salary is not the cost: what actually leaves the bank

The employee receives $2,500,000 and the company disburses $3,996,450. The difference, $1,496,450, is not a calculation error: it is the labour cost that never appears on the payslip.

If your company qualifies for contribution exemptions, the number drops. Health 8.5 %, SENA 2 % and ICBF 3 % add up to $337,500 in this example; without them, contributions come to $413,050 and total cost to $3,658,950. But the exemption does not cover every employer or every salary: it depends on the type of employer, the employee's salary level and the exceptions set by law. Confirm whether your company qualifies before budgeting with the reduced figure, because a budget built on the exempt cost breaks the month the exemption does not apply.

So budget on total cost, not salary. And do it employee by employee: cost changes with the risk level, the allowance and the deductions in each contract.

How it is sent to DIAN and what the CUNE is

Filing is not an email with an attachment. It requires prior enablement as a filer, a signed XML and transmission through the service DIAN provides. The document goes into validation and, if it passes, the system returns the CUNE, the Unique Electronic Payroll Code.

The CUNE is the proof that the document was validated. Without a CUNE there is no support, even if the XML was transmitted. That is why sending is not enough: you have to confirm the response and keep the acknowledgement.

Deadlines are tied to the payroll period and to the tax calendar, which changes every year. Do not set the date from last year's: check the current calendar and schedule the filing with margin, because a validation error forces a correction and resubmission within the same deadline.

One detail that gets overlooked: electronic payroll is filed per employee and per period, not as a company-wide consolidated file. If an employee was left out of the file, the support for that payment does not exist, even if all the others were validated.

Adjustment notes: how to correct payroll already filed

Payroll that has been validated is not deleted or edited. It is corrected with an electronic payroll adjustment note, which is linked to the original document and leaves a trail of what changed and why.

Typical cases are a miscalculated amount, a missed deduction, an employee included in the wrong period or a surcharge applied incorrectly. It also applies when a retroactive difference is paid after a salary correction.

The practical rule: if the document was rejected, correct it and resubmit; if it was validated and has a CUNE, correct it with an adjustment note. The note does not erase the previous document, it complements it. That trail is exactly what a review expects to find.

How payroll is recorded in the books

The expense for salaries and benefits is recognised in the period in which the obligation arises, not when it is paid. Contributions and withholdings deducted from the employee remain liabilities until transferred; net pay remains a payroll liability until disbursed.

Accruals follow the same logic: the bonus paid in December is recognised as an expense month by month during the year, with its counterpart in an accrual account. When payment comes, the liability is settled; no new expense is recognised.

If accounting does not separate those moments, the month's result is distorted: in months without a bonus payment a profit appears that does not exist, and in December an expense that was already recognised. Reconciling payroll against accounting every month avoids the surprise and makes the XML match the books.

The mistakes that cost the most

These are the common stumbles, with the symptom they show up as and what they cost when nobody corrects them in time.

SymptomFrequent causeConsequence
It was filed and the CUNE never arrivedXML with a validation error or a badly configured signatureThe period has no support even though payroll was paid
Net pay does not match what the employee expectedAllowance included in the contribution base or deductions set up wrongRecalculation and adjustment note
Real cost exceeds the budgetBudgeted on gross pay without contributions or accrualsCash shortfall in June and December
The deduction was disallowed for income taxSalary payment without a validated documentHigher tax and a penalty
There is no money for the bonusAccruals were used as working capitalCash shortfall at payment time
Final settlement incomplete on departureVacation and interest were never accruedLate recalculation or a claim from the former employee

None of these mistakes is technical. They are process failures: nobody defined who checks the base, who confirms the CUNE and who reconciles the accrual before using it.

An honest closing before you decide

This walkthrough covers the mechanics, not your particular case. If you have variable salaries, commissions, shift work, apprentices or collective agreements, the calculation needs a case-by-case review. And if your company is going through enablement, confirm with your accountant which supporting document you need before paying the first period.

What is not open to debate is the order: first calculate with support, then accrue, and file last. If you also need inventory, invoicing and accounting to work from the same data, Kardex Tauro covers those three areas for Colombian SMEs; payroll keeps its own path and integrates with your accountant.

Keep reading

Share
Link copied
Microsoft Store from Microsoft StoreDownload free
Chatea por WhatsApp