Your Colombia Payroll, PILA, and DIAN Reports Don’t Match: Which Number Is Actually Wrong?

A Colombian employer closes August payroll with COP 41,896,380 in employee earnings. Its electronic payroll documents submitted to DIAN show COP 41,696,380. Its PILA filing contains COP 40,300,000 in contribution bases. Its bank statement shows only COP 38,074,380 paid to employees.

Which number is wrong?

Not necessarily the smallest one.

The four amounts measure different things. DIAN’s electronic payroll reporting records earnings and deductions associated with employment. PILA determines social-security and related contributions using legally applicable contribution bases. The internal payroll ledger records what employees earned and what was deducted. The bank establishes what was actually transferred.

An employer that forces all four totals to match can introduce errors instead of correcting them.

The better approach is to reconcile the underlying transactions, identify legally required differences, and isolate amounts that cannot be explained.

Ivvora built the following synthetic 10-employee payroll audit to demonstrate that process. The model contains six intentionally introduced reconciliation exceptions, including four genuine errors and two differences that do not require amendments.

The result is a financial reconciliation that connects employee compensation, social-security contributions, electronic payroll reporting, and bank settlement.

1. PILA vs Nómina Electrónica: What Is Supposed to Match?

Colombia’s Planilla Integrada de Liquidación de Aportes (PILA) and DIAN’s Documento Soporte de Pago de Nómina Electrónica (DSPNE) serve different statutory purposes.

DIAN’s electronic payroll document supports qualifying employment-related costs and deductions for tax purposes. It contains payroll earnings (devengados), deductions (deducciones), and the difference between them.

PILA is the mechanism through which employers declare and pay contributions to the social-protection system, including applicable health, pension, occupational-risk, and parafiscal contributions.

The UGPP expressly identifies discrepancies between payroll-reported remuneration and PILA contribution bases as a potential indication of contribution inaccuracy. That does not mean every difference constitutes underpayment.

Sources: DIAN, Resolution 000227 of 2025 and UGPP, Frequently Asked Questions on Parafiscal Contributions.

Record	What it measures	What must be reconciled
Internal payroll	Contractual wages, variable remuneration, benefits and employee deductions	Employee-level earnings and payable amounts
DIAN electronic payroll	Reportable earnings, deductions and net payroll amounts	Payroll concepts and DIAN-validated documents
PILA	Applicable contribution bases, contribution days, classifications and contributions	Statutory IBC and amounts paid to each subsystem
Bank	Actual outgoing payments	Net employee payments, payment dates and beneficiaries
General ledger	Recognized expenses, liabilities and settlements	Payroll expense, statutory liabilities and unpaid balances

The central distinction is that PILA’s IBC is not the same measure as DIAN’s total payroll earnings.

A correct reconciliation therefore needs a bridge between them.

2. The 2026 Rules Used in This Audit

The model uses August 2026, with the following statutory values and assumptions.

Parameter	2026 value or treatment
Monthly legal minimum wage (SMMLV)	COP 1,750,905
Monthly transportation allowance	COP 249,095
Two-SMMLV threshold	COP 3,501,810
Employee health contribution	4% of applicable IBC
Employee pension contribution	4% of applicable IBC
Ordinary employer pension contribution	12%
Ordinary employer health contribution before applicable exemptions	8.5%
Pension solidarity contribution threshold	From 4 SMMLV, subject to applicable rules
Reporting period	August 1–31, 2026

The 2026 minimum wage was established under Decree 1469 of 2025. After a temporary judicial suspension and the issuance of Decree 0159 of 2026, the Council of State revoked the suspension in July 2026. The COP 1,750,905 wage figure remained unchanged.

The transportation allowance was established separately under Decree 1470 of 2025.

Sources: Decree 1469 of 2025, Decree 1470 of 2025, and Council of State, July 2026 decision.

Assumptions that make the model reproducible

The fictional company employs ten full-time, ordinary-salary workers for the entire month. No employee receives an integral salary, enters or leaves employment, takes leave, or has an incapacity during the period.

All overtime and commission amounts are assumed to have been calculated correctly from approved underlying records. The exercise audits reporting rather than recalculating lawful working hours or overtime premiums.

Employees eligible for the transportation allowance receive the full August amount. No employee earns enough to trigger the pension solidarity contribution.

The model includes only employee health and pension deductions, plus one authorized loan repayment. Income-tax withholding, garnishments, additional benefits, voluntary contributions and other payroll-specific items are excluded from this controlled dataset. Real employers must determine those independently.

All currency amounts are Colombian pesos (COP). PILA-specific rounding and any late-payment interest must be applied using the actual operator’s rules when settling corrections.

These assumptions deliberately eliminate unrelated exceptions so each discrepancy can be traced to a specific cause.

3. The Original 10-Employee Payroll Register

The starting point is the company’s approved compensation register, before any DIAN or PILA reporting error.

Table A. Contractual wages, variable earnings and contribution bases

Employee	Base salary	Overtime	Commissions	Transport allowance	Correct IBC
E01	2,000,000	0	0	249,095	2,000,000
E02	2,400,000	200,000	0	249,095	2,600,000
E03	3,000,000	0	600,000	0	3,600,000
E04	2,800,000	0	0	249,095	2,800,000
E05	4,000,000	300,000	0	0	4,300,000
E06	5,000,000	0	0	0	5,000,000
E07	5,300,000	0	700,000	0	6,000,000
E08	3,400,000	0	0	249,095	3,400,000
E09	6,200,000	0	0	0	6,200,000
E10	4,600,000	400,000	0	0	5,000,000
Total	38,700,000	900,000	1,300,000	996,380	40,900,000

The contractual salary total is COP 38,700,000.

Employees earned another COP 900,000 in overtime and COP 1,300,000 in commissions. These amounts represent salary for the model because they remunerate employees’ services.

The company also owes COP 996,380 in transportation allowances.

Consequently:

Total salary remuneration

38,700,000 + 900,000 + 1,300,000 = 40,900,000

Total payroll earnings

40,900,000 + 996,380 = 41,896,380

Correct modeled contribution base

40,900,000

The transportation allowance explains why correctly reported DIAN earnings can exceed PILA contribution bases.

Under Colombian law, the statutory transportation allowance does not form part of the ordinary social-security contribution base, although it has separate treatment for certain employment benefits.

Source: Article 17 of Law 344 of 1996, discussed in the Colombian public administration’s legal guidance.

An important detail: Employee E03

Employee E03 receives COP 3,000,000 in contractual salary and COP 600,000 in commissions.

The employee’s total salary remuneration is COP 3,600,000, above the two-SMMLV transportation threshold of COP 3,501,810.

The model therefore does not assign E03 a transportation allowance.

An employer that evaluates transportation eligibility solely against contractual basic salary could reach an incorrect conclusion when variable earnings change the relevant remuneration. The actual circumstances and statutory entitlement must be reviewed.

4. What Employees Should Receive: The Authorized Payroll Ledger

Employee health and pension deductions are calculated at 4% each of the correct modeled IBC.

For this controlled example:

Employee social-security deduction = Correct IBC × 8%

Employee E06 also has an authorized COP 400,000 loan repayment deducted from payroll.

Table B. Employee deductions and approved net payroll

Employee	Gross earnings	Health + pension	Other deductions	Correct net pay
E01	2,249,095	160,000	0	2,089,095
E02	2,849,095	208,000	0	2,641,095
E03	3,600,000	288,000	0	3,312,000
E04	3,049,095	224,000	0	2,825,095
E05	4,300,000	344,000	0	3,956,000
E06	5,000,000	400,000	400,000	4,200,000
E07	6,000,000	480,000	0	5,520,000
E08	3,649,095	272,000	0	3,377,095
E09	6,200,000	496,000	0	5,704,000
E10	5,000,000	400,000	0	4,600,000
Total	41,896,380	3,272,000	400,000	38,224,380

The control equation is:

41,896,380 − 3,272,000 − 400,000 = 38,224,380

That means the company should transfer COP 38,224,380 to employees, assuming all wages are settled in the reviewed period.

It must separately account for the employee contributions withheld, applicable employer contributions and E06’s loan deduction payable to the authorized recipient.

Employee deductions are not reductions in employer gross payroll expense merely because they reduce employees’ bank deposits.

5. The Submitted Reports: Where the Numbers Stop Matching

The fictional company’s initial reports contain deliberate mistakes.

Its DIAN documents omit one employee’s overtime and another employee’s authorized loan deduction.

Its PILA filing omits part of a commission earner’s contribution base.

Its bank file underpays one employee.

A separate bank-transaction split and the legitimate exclusion of transportation allowances generate two additional reconciliation exceptions.

Table C. What the three external records actually show

Employee	DIAN earnings filed	DIAN deductions filed	PILA IBC filed	Bank wages paid
E01	2,249,095	160,000	2,000,000	2,089,095
E02	2,649,095	208,000	2,600,000	2,641,095
E03	3,600,000	288,000	3,000,000	3,312,000
E04	3,049,095	224,000	2,800,000	2,825,095
E05	4,300,000	344,000	4,300,000	3,956,000
E06	5,000,000	400,000	5,000,000	4,200,000
E07	6,000,000	480,000	6,000,000	5,520,000
E08	3,649,095	272,000	3,400,000	3,227,095
E09	6,200,000	496,000	6,200,000	5,704,000
E10	5,000,000	400,000	5,000,000	4,600,000
Total	41,696,380	3,272,000	40,300,000	38,074,380

The bank column contains only payments received by employees. It excludes transfers to contribution administrators and E06’s loan recipient.

The DIAN figures represent the fictional documents as originally transmitted and validated, not the corrected documents.

The PILA column represents filed contribution bases, not the monetary amount of contributions paid.

Comparing the PILA IBC total directly with bank deposits would therefore be a category error.

The first reconciliation result

Control	Correct amount	Initially recorded	Difference
Gross payroll earnings vs DIAN earnings	41,896,380	41,696,380	−200,000
Payroll deductions vs DIAN deductions	3,672,000	3,272,000	−400,000
Correct IBC vs filed PILA IBC	40,900,000	40,300,000	−600,000
Net wages owed vs bank wages paid	38,224,380	38,074,380	−150,000

Four distinct numerical variances are present.

But the audit has six exceptions because some differences only appear when comparing transaction details or when comparing unlike statutory measures.

6. Six Discrepancies: Which Ones Are Errors?

Discrepancy 1: Transportation Allowance Appears in DIAN but Not PILA

Classification: Legitimate statutory difference

Affected employees: E01, E02, E04 and E08.

Each receives the COP 249,095 transportation allowance under the model’s eligibility assumptions.

Consider E01:

• Contractual salary: COP 2,000,000
• Transportation allowance: COP 249,095
• DIAN earnings: COP 2,249,095
• Correct PILA IBC: COP 2,000,000

The difference is COP 249,095.

Across four qualifying employees:

249,095 × 4 = 996,380

This difference is legitimate because the allowance is included in the employee’s payroll earnings but excluded from the ordinary contribution base.

Correction procedure: No DIAN or PILA correction is required.

The employer should retain the eligibility calculations, applicable attendance or working-arrangement evidence, and payroll concept classification.

The reconciliation engine should map transportation allowances to reported payroll earnings without automatically adding them to the PILA contribution base.

Audit result: COP 996,380 is an explained difference, not missing contributions.

This is an important control. Automatically treating every DIAN-to-PILA difference as underreported contributions would produce a false positive for these four workers.

Discrepancy 2: Overtime Was Paid and Included in PILA but Omitted from DIAN

Classification: DIAN reporting error

Affected employee: E02.

Approved payroll shows:

Component	Correct payroll	DIAN initially reported
Basic salary	2,400,000	2,400,000
Overtime	200,000	0
Transportation allowance	249,095	249,095
Total earnings	2,849,095	2,649,095
Employee deductions	208,000	208,000
Net amount	2,641,095	2,441,095

The employee received the correct net amount of COP 2,641,095, and the correct COP 2,600,000 contribution base was used in PILA.

Only the electronic payroll submission is wrong.

The missing COP 200,000 does not create a new unpaid wage or an additional PILA liability. It creates an inaccurate DIAN payroll record.

Correction procedure

The employer should:

1. Retrieve the original DIAN-validated document and its CUNE.
2. Confirm the COP 200,000 overtime using approved time records and the finalized payroll register.
3. Prepare a nota de ajuste of type Reemplazar, including the corrected complete set of earnings and deductions.
4. Reference the document being replaced and submit the adjustment through the authorized electronic payroll system.
5. Confirm DIAN validation and retain both the original and replacement records in the audit history.

The corrected employee record contains COP 2,849,095 in earnings, COP 208,000 in deductions and COP 2,641,095 net.

DIAN’s guidance distinguishes replacement notes used for arithmetic or content corrections from deletion notes generally used for documents transmitted in error, including duplicate documents.

Source: DIAN, Oficio 904276 of 2022.

Audit result: Increase DIAN-reported earnings by COP 200,000. No second bank payment is due.

Discrepancy 3: The Commission Is Correct in DIAN but Missing from PILA

Classification: PILA contribution-base error

Affected employee: E03.

The employee earns:

• Contractual salary: COP 3,000,000
• Commission: COP 600,000
• Correct salary remuneration: COP 3,600,000

DIAN correctly reports COP 3,600,000.

However, PILA was filed using only COP 3,000,000.

Measure	Filed PILA	Correct PILA
IBC	3,000,000	3,600,000
Employee health at 4%	120,000	144,000
Employee pension at 4%	120,000	144,000
Combined employee contributions	240,000	288,000

The missing IBC is COP 600,000.

The employee contribution shortfall in the filing is COP 48,000.

This is not a DIAN error. The payroll register and DIAN document already contain the correct commission.

The employer also deducted the correct COP 288,000 from the employee’s wages. Therefore, the missing COP 48,000 in employee contributions represents an amount already withheld but not fully accounted for through the original PILA filing.

The employer must resolve that contribution liability rather than deducting the same COP 48,000 from the employee again.

Correction procedure

First verify that the commission is remuneration for services and belongs in the contribution base. Colombian labor law generally treats commissions and other direct remuneration as salary.

Next, retrieve the original PILA filing, contribution period, employee identification, contribution days and applicable subsystem bases.

Correct the August filing through the appropriate PILA operator workflow, ordinarily using a Planilla N – Correcciones for the identified IBC inaccuracy.

Recalculate the affected contributions, settle the additional amounts and applicable interest, and retain the corrected payment evidence.

The UGPP specifically instructs employers to correct contribution-base inaccuracies through Planilla N, with a separate correction for each applicable period or fraction.

Source: UGPP, Frequently Asked Questions on Parafiscal Contributions.

What does the missing COP 600,000 cost?

The impact extends beyond the employee’s COP 48,000 contribution share.

The following is an illustrative calculation assuming ordinary dependent-worker rates, an applicable 4% compensation-fund contribution, occupational risk class I at 0.522%, and eligibility for the employer health-contribution exemption.

Contribution	Additional amount before PILA rounding
Employee health, 4%	24,000
Employee pension, 4%	24,000
Employer pension, 12%	72,000
Compensation fund, 4%	24,000
Employer occupational risk, 0.522%	3,132
Combined additional contributions	147,132

Of the COP 147,132, COP 48,000 is the employee share already deducted in the approved payroll.

The illustrative incremental employer contribution expense is COP 99,132.

The exact additional PILA payment must be established through the operator using the applicable rates, contribution-base rules, rounding and correction date. This illustration excludes late-payment interest.

If the employer does not qualify for the relevant health-contribution exemption, an additional employer health component may apply. At 8.5% of COP 600,000, that component would be COP 51,000 before rounding.

Other employer exemptions or classification differences must be assessed separately.

Audit result: Increase the filed PILA contribution base by COP 600,000 and settle the corresponding contributions.

No change to the employee’s original net salary is needed.

Discrepancy 4: An Authorized Loan Deduction Was Left Out of DIAN

Classification: DIAN deduction reporting error

Affected employee: E06.

Employee E06 earned COP 5,000,000.

The authorized payroll deductions were:

• Employee health: COP 200,000
• Employee pension: COP 200,000
• Authorized loan repayment: COP 400,000

Total deductions: COP 800,000.

Correct net salary: COP 4,200,000.

The employer transferred COP 4,200,000 to the employee, but its DIAN document recorded only COP 400,000 in deductions.

Measure	DIAN initially reported	Correct amount
Earnings	5,000,000	5,000,000
Deductions	400,000	800,000
Net	4,600,000	4,200,000

The difference is COP 400,000.

PILA is not wrong because an ordinary authorized loan repayment does not reduce the employee’s social-security contribution base.

The error sits in the electronic payroll deduction record.

Correction procedure

The company must verify the written authorization, loan documentation, applicable statutory deduction restrictions and evidence supporting the repayment.

It should then identify the correct DIAN technical category for the deduction. A qualifying libranza should not automatically be treated as interchangeable with every other form of employee debt deduction.

A replacement adjustment note should update the complete DIAN document to show COP 800,000 in deductions and COP 4,200,000 net.

Separately, the employer should confirm that the withheld amount was paid to the authorized loan recipient.

The Colombian libranza framework contains specific employer obligations regarding authorized deductions and transfer of funds.

Source: Law 1527 of 2012.

Audit result: Increase DIAN-reported deductions by COP 400,000.

No additional salary transfer or PILA correction is needed solely because of this reporting omission.

Discrepancy 5: One Employee Appears Underpaid Because Payroll Was Split Across Bank Transfers

Classification: Legitimate transaction-level reconciliation difference

Affected employee: E07.

Employee E07 has approved net salary of COP 5,520,000.

The bank contains two separate salary payments:

Payment date	Amount
August 15, 2026	3,000,000
August 31, 2026	2,520,000
Total	5,520,000

Suppose an accounting reconciliation matches the DIAN document to the August 31 bank transaction alone.

It reports a difference of COP 3,000,000.

But the earlier bank transfer is part of the same month’s wage settlement.

The apparent shortfall disappears when both transfers are linked to the same employee and payroll period.

Correction procedure: Neither DIAN nor PILA needs amendment.

The company should maintain a payment-allocation table connecting the employee identifier, payroll period, payment date, transaction reference and allocated amount.

The reconciliation should operate at the employee-period level while preserving individual bank transactions.

Audit result: COP 3,000,000 is a transaction-matching exception, not unpaid compensation.

The lesson is broader than Colombia: one payroll document does not necessarily correspond to one bank transfer.

Discrepancy 6: The Bank Actually Paid Less Than the Approved Payroll

Classification: Genuine salary settlement error

Affected employee: E08.

The payroll records show:

• Gross earnings: COP 3,649,095
• Employee deductions: COP 272,000
• Net salary owed: COP 3,377,095

DIAN reflects the same net amount.

PILA correctly uses COP 3,400,000 as the contribution base.

But the bank transfer was only COP 3,227,095.

The unpaid amount is:

3,377,095 − 3,227,095 = 150,000

Unlike the E07 example, no second transfer or valid deduction explains the difference.

The bank is genuinely short.

Correction procedure

The company should confirm that no separate payment, reversal, bank rejection or properly authorized adjustment accounts for the amount.

Once the shortfall is verified, it should transfer COP 150,000 to E08, preserve the bank confirmation and clear the corresponding employee-payable balance in its general ledger.

Because the earnings, deductions and contribution base were originally calculated and reported correctly, this payment correction does not, by itself, require a DIAN replacement note or PILA correction.

However, the employer must assess whether the delayed wage payment creates any additional employment-law obligation.

Audit result: COP 150,000 remains payable until the corrective transfer settles.

This is the only discrepancy in the model requiring additional payment directly to an employee.

7. The Reconciliation Bridge: Explaining the Entire DIAN–PILA Gap

The most useful result is not the list of six exceptions. It is the mathematical bridge explaining the difference between two reported systems.

Initially:

DIAN-reported earnings: COP 41,696,380

PILA-reported IBC: COP 40,300,000

The apparent difference is COP 1,396,380.

An employer looking only at these totals might suspect that PILA is missing COP 1,396,380 in contributions.

That conclusion would be incorrect.

Table D. Reconstructing the difference

Reconciliation item	Effect on DIAN-minus-PILA gap
Legitimate transportation allowance difference	+996,380
Overtime omitted from DIAN	−200,000
Commission omitted from PILA	+600,000
Unexplained opening gap reconstructed	1,396,380

The equation is:

996,380 − 200,000 + 600,000 = 1,396,380

The actual underreported PILA contribution base is COP 600,000, not COP 1,396,380.

The DIAN omission separately understates earnings by COP 200,000.

The remaining COP 996,380 is legally explained by transportation allowances.

After correcting the two reporting errors:

Correct DIAN earnings: COP 41,896,380

Correct PILA IBC: COP 40,900,000

Remaining difference: COP 996,380

That remaining gap is expected.

It should remain visible in the reconciliation report with its explanation rather than being removed through an artificial adjustment.

8. Reconcile Net Pay Separately from Contribution Bases

The gross-earnings bridge does not establish whether employees were paid correctly.

For that, the employer needs a second equation.

Before corrections, DIAN shows:

41,696,380 earnings − 3,272,000 deductions = 38,424,380 reported net payroll

The approved internal payroll shows:

41,896,380 earnings − 3,672,000 deductions = 38,224,380 actual net payable

The DIAN net amount is overstated by COP 200,000.

This is the combined result of two offsetting errors:

• Missing overtime reduces DIAN net by COP 200,000.
• Missing loan deductions increase DIAN net by COP 400,000.

Therefore:

−200,000 + 400,000 = +200,000

The bank initially paid only COP 38,074,380.

The apparent DIAN-to-bank difference is:

38,424,380 − 38,074,380 = 350,000

But the actual amount still owed to employees is only COP 150,000.

The remaining COP 200,000 is a DIAN reporting variance, not a wage liability.

After the DIAN corrections and the supplemental bank payment:

Correct net payroll = Correct bank settlement = COP 38,224,380

This illustrates why the financial reconciliation needs at least two independent bridges:

1. Earnings to contribution bases
2. Net payroll payable to actual settlement

Combining the two into a single unexplained variance obscures the true liability.

9. The Corrected Financial Ledger

The final reconciliation should be reflected in accounting records as well as regulatory submissions.

Table E. Audit adjustments and financial consequences

Adjustment	System affected	Financial impact	Required action
Transportation allowance distinction	Reconciliation mapping	No correction liability	Document legitimate difference
E02 missing overtime	DIAN	No new wage expense	Replacement adjustment note
E03 omitted commission IBC	PILA	Additional statutory contributions	Planilla N and payment
E06 missing loan deduction	DIAN	No new wage expense	Replacement adjustment note
E07 two bank transfers	Bank matching	No additional payment	Link both transactions
E08 salary shortfall	Bank and payroll payable	COP 150,000 still owed	Supplemental wage payment

The PILA correction increases the liability for unremitted contributions.

That does not mean the entire corrective cash payment is a new employer expense. The portion properly withheld from the employee is already reflected in the payroll liabilities.

Similarly, correcting the DIAN document for E02 does not create COP 200,000 of new payroll expense because the overtime was already recognized and paid.

A reliable accounting process distinguishes:

• Previously recognized expense
• Previously withheld liability
• Additional employer contribution expense
• Outstanding employee wage payable
• Regulatory reporting correction with no new cash movement

Without that separation, the same mistake can produce duplicate journal entries or double-counted costs.

10. What a Correct DIAN Adjustment Note Must Do

DIAN’s framework provides a mechanism for adjusting previously transmitted electronic payroll documents.

Under Resolution 000227 of 2025, which consolidated the relevant electronic payroll provisions, a note of adjustment can replace an existing document or eliminate one that was transmitted in error.

The two functions are not interchangeable.

When to use Reemplazar

A replacement note is appropriate where an existing payroll document needs correction for arithmetic, content or accounting inaccuracies.

In this model:

• E02 requires replacement because an overtime component is missing.
• E06 requires replacement because a payroll deduction is missing.

The replacement should represent the corrected document, not merely a separate negative or positive transaction in the employer’s spreadsheet.

The associated original document identifiers, CUNE reference, document numbering and DIAN validation response must be retained.

When Eliminar may be appropriate

An elimination note addresses circumstances such as an entirely erroneous or duplicate document.

It should not be used as the automatic solution to every incorrect field.

DIAN’s doctrine explains the distinction between replacement and elimination, including treatment of duplicate submissions.

Source: DIAN, Oficio 904276 of 2022.

What if the error is discovered after the original reporting deadline?

Electronic payroll is generally generated monthly, with transmission within the first ten days of the following month under the applicable DIAN framework.

A subsequently discovered error should be addressed through the proper adjustment mechanism rather than ignored because the original transmission was validated.

An adjustment note does not automatically eliminate any consequences of the underlying error or a late compliance action.

The employer must preserve evidence of the original filing, correction date and accepted replacement.

DIAN validation establishes that a document passed applicable electronic validation rules. It does not independently prove that every underlying wage, deduction or contribution calculation was correct.

11. How to Correct PILA Without Creating a Second Error

The PILA correction follows a different workflow.

For E03, the employer must reconstruct the correct contribution base before submitting the adjustment.

Step 1: Identify the original filing

Retrieve the paid planilla number, contribution period, employee identification, reported IBC, contribution days, employee classification and relevant subsystem details.

Step 2: Rebuild the statutory IBC

The correct modeled base is:

3,000,000 salary + 600,000 commission = 3,600,000

Do not simply copy DIAN’s gross earnings field into PILA.

First determine which payroll components legally form part of the base and whether any contribution-specific rules, caps or reported novelties apply.

Step 3: Calculate the omitted contributions

The employee health and pension shortfall is COP 48,000.

Applicable employer contributions and any other affected payments must be recalculated independently.

Step 4: Submit the proper correction

Use the authorized operator’s Planilla N workflow for the relevant contribution-period correction.

The corrected values must identify the same employee and period as the original error.

Step 5: Settle the outstanding amount

Pay the additional contributions and any applicable interest or other legally due charges calculated for the actual payment date.

Step 6: Verify settlement

Keep the original planilla, correction planilla, payment receipts and final reported bases.

Step 7: Reconcile the employee’s withholding liability

Because the employer already withheld the correct contribution amount in the payroll ledger, the shortfall in remittance should be accounted for without charging the employee twice.

The UGPP warns that contribution inaccuracies can be detected through comparison of PILA records with payroll and other official information.

Source: UGPP, Parafiscal Contribution Guidance.

12. The Monthly Reconciliation Framework Employers Should Implement

A reconciliation performed only after an authority requests information is a weak control.

A better system reviews the payroll ledger, DIAN documents, PILA filings and bank settlements at each monthly close.

Control 1: Employee identity

Match every record using a stable employee identifier and validated government-identification information.

Do not rely solely on employee names.

Control 2: Payroll period

Match records by the relevant earning, contribution and payment periods.

Actual transfer dates should be recorded separately from the period to which wages relate.

PILA systems may distinguish subsystem contribution periods. Employers should not assume every displayed period field is identical across health, pension and electronic payroll exports.

Control 3: Earnings classification

Reconstruct each employee’s reported earnings from the internal ledger.

Separate salary, overtime, commissions, transportation allowances, qualifying non-salary payments, benefits and other concepts according to their applicable legal treatment.

Control 4: Contribution base

Build an independent statutory IBC calculation.

Do not use total bank payments, contractual basic salary alone or DIAN gross earnings as an automatic substitute for IBC.

For more complex payrolls, assess the applicable treatment of non-salary payments, the statutory 40% limitation, absences, incapacity, vacation, integral salary and contribution ceilings.

Control 5: Employee deductions

Compare each employee’s calculated statutory and authorized deductions with the DIAN document.

Then compare statutory withholdings against the corresponding PILA payments and employee liability accounts.

Control 6: Net settlement

Aggregate all bank transfers allocated to an employee’s payroll period.

Investigate unreconciled differences after considering legitimate split payments, bank rejections, reversals and payment timing.

Control 7: Filing evidence

Retain the DIAN validation response and document identifier, PILA paid-planilla evidence, and relevant bank transaction references.

Control 8: Accounting closure

Ensure every unresolved difference is classified as a statutory contribution payable, employee payable, reporting error, justified timing item or other supported exception.

A reconciliation is not complete merely because an accountant entered an adjustment that makes the spreadsheet equal zero.

13. A Reproducible Payroll Reconciliation Formula

For ordinary payroll situations where the modeled assumptions apply, the following equations provide a useful starting point.

Employee gross earnings

Basic salary + salary-based variable compensation + reportable non-salary earnings and allowances

Employee contribution base

Applicable salary remuneration + any legally required contribution-base additions − applicable exclusions or adjustments

Employee net payroll

Gross earnings − statutory employee deductions − authorized other deductions

Bank settlement variance

Net payroll payable − allocated employee bank transfers

DIAN-to-PILA bridge

DIAN reported earnings − expected statutory contribution base = documented non-IBC earnings and other legitimate differences, adjusted for reporting errors

This last equation requires concept-level reconciliation rather than an assumption that the difference should always equal zero.

A software implementation should also track a correction state for each discrepancy:

State	Meaning
Explained	Legitimate difference supported by evidence
Investigating	Difference lacks enough evidence
DIAN correction required	Incorrect electronic payroll document
PILA correction required	Incorrect contribution information or payment
Payment required	Employee or other beneficiary has an outstanding balance
Closed	Corrective action completed and verified

This prevents a reporting correction from being mistaken for a completed financial settlement.

14. Audit Evidence: What Should Be Preserved?

A defensible reconciliation needs more than four spreadsheets.

For every employee-period record, the employer should be able to reconstruct the underlying compensation, the classification used to determine the contribution base, the reported deductions, and the amounts transferred.

For the six exceptions in this audit, the evidence package would include approved overtime records for E02, the commission calculation and corrected PILA receipt for E03, the authorized loan-deduction documentation for E06, both bank references for E07, and the corrective bank receipt for E08.

Transportation allowance eligibility evidence should be retained for E01, E02, E04 and E08.

The company should also retain original and corrected DIAN document identifiers, validation responses and the reconciliation approval history.

Where corrections affect accounting liabilities, the journal entry reference should be connected to the same exception identifier.

The practical objective is to make the review reproducible by someone who did not prepare the original payroll.

15. The Final Audit Result: All Four Systems Reconciled

After completing the necessary reporting corrections and paying the outstanding wages, the company reaches the following position.

Measure	Original amount	Corrected or settled amount
DIAN gross earnings	41,696,380	41,896,380
DIAN deductions	3,272,000	3,672,000
DIAN net	38,424,380	38,224,380
PILA aggregate IBC	40,300,000	40,900,000
Bank wages paid	38,074,380	38,224,380
Legitimate gross-earnings/IBC gap	996,380	996,380
Employee salary shortfall	150,000	0

The result is not four identical numbers.

It is four records that now agree according to their individual purposes.

Correct gross earnings exceed the correct contribution base by COP 996,380 because of transportation allowances.

Correct employee deductions exceed basic health and pension deductions by COP 400,000 because of an authorized loan repayment.

Employee bank transfers equal approved net compensation after the COP 150,000 supplemental payment.

The original PILA contribution-base shortfall has been corrected, with the additional statutory contribution payment and any applicable charges handled separately.

The model’s four genuine errors required two DIAN replacement notes, one PILA correction and one supplemental salary payment.

The two legitimate exceptions required documentation and matching improvements, not regulatory corrections.

16. Why a Perfect-Match Payroll Dashboard Can Be Misleading

A dashboard that flags every difference between DIAN gross earnings and PILA IBC as an error will generate false positives.

A dashboard that simply accepts every difference risks missing underreported wages or contributions.

The correct control lies between those two extremes.

For each employee and month, the system must identify:

• What was contractually owed
• What was earned during the period
• What legally forms part of the contribution base
• What was deducted from the employee
• What was transmitted to DIAN
• What contributions were declared and paid through PILA
• What money was transferred
• What remains outstanding

The original employer records should determine the expected outcome, subject to independent legal and payroll validation. Neither DIAN nor PILA should be treated as automatically correct merely because a submission was accepted.

In the Ivvora model, the most important discovery is that the original COP 1,396,380 difference between DIAN earnings and PILA contribution bases contains only COP 600,000 of underreported IBC.

Another COP 200,000 is a separate DIAN omission.

The remaining COP 996,380 is legitimate.

Treating the entire difference as a PILA error would misstate the contribution liability.

Ignoring the entire difference would leave an actual underpayment unresolved.

The employer needs a classification-based reconciliation, not just a totals comparison.

17. Frequently Asked Questions

Should PILA and DIAN electronic payroll totals match exactly?

No. DIAN payroll earnings and PILA contribution bases measure different things. A legitimate transportation allowance, for example, can appear in electronic payroll earnings while being excluded from the ordinary PILA IBC.

The employer should nevertheless be able to explain the difference at the employee and payroll-concept level.

Can UGPP compare electronic payroll information with PILA?

Yes. UGPP guidance identifies differences between contribution bases and employer payroll or official tax information as potential indications of contribution inaccuracy.

A detected difference is a reason for review, not automatic proof that every reported peso should be subject to contributions.

Are commissions included in PILA?

Commissions that constitute remuneration for the employee’s services generally form part of salary and must be evaluated for inclusion in the applicable contribution base.

In the model, E03’s COP 600,000 commission is salary remuneration and belongs in the modeled IBC.

Does the transportation allowance form part of PILA?

The statutory transportation allowance is generally excluded from the ordinary social-security contribution base.

Its separate treatment for certain employment benefits should not be confused with its PILA treatment.

How do employers correct electronic payroll submitted to DIAN?

For an already validated document containing incorrect amounts or concepts, employers generally use an electronic payroll adjustment note of type Reemplazar.

The adjustment must reference the appropriate predecessor document and satisfy the applicable DIAN technical and validation requirements.

How do employers correct an incorrect PILA IBC?

An employer normally uses the applicable PILA correction procedure, including Planilla N where appropriate, after verifying the correct contribution period, worker classification and contribution bases.

The operator must calculate the correct payment and any legally applicable charges.

Does a DIAN payroll adjustment automatically update PILA?

No. The systems have separate reporting and correction mechanisms.

Correcting an electronic payroll document does not itself settle unpaid contributions through PILA.

Likewise, a PILA correction does not automatically replace an inaccurate DIAN payroll document.

What happens when the bank paid less than DIAN reports?

The employer should reconcile the documented employee entitlement, deductions and payment allocations.

If the employee was genuinely underpaid, the outstanding wage should be settled, and any applicable consequences assessed.

A correct original DIAN document need not be changed merely because the bank transfer was incomplete.

Can employers reconcile PILA and DIAN using only monthly totals?

Monthly totals can identify potential exceptions, but they cannot reliably determine their causes.

A defensible audit requires employee-level records, payroll concepts, contribution calculations and evidence of actual payments.

18. Conclusion: The Right Payroll Number Depends on the Question

A Colombian employer can have accurate payroll earnings, a smaller but accurate PILA contribution base, lower bank wage payments because of legitimate employee deductions, and a separate set of employer contribution liabilities.

Those differences are not inherently errors.

But a system that cannot explain them creates real compliance and financial risk.

The ten-employee audit demonstrates why Colombia payroll reconciliation must operate across four layers: compensation, electronic reporting, statutory contributions and settlement.

In the fictional company, the reconciliation identifies COP 600,000 of omitted PILA IBC, COP 200,000 of omitted DIAN earnings, COP 400,000 of omitted DIAN deductions and COP 150,000 in unpaid employee wages.

It also explains COP 996,380 in legitimate transportation allowance differences without creating an unnecessary correction.

The objective is not to force payroll, PILA, DIAN and bank totals to become identical. It is to make every difference explainable, legally supportable and financially traceable.

For employers evaluating Colombian payroll costs, Ivvora’s approach starts with the same principle: reconstruct the actual employment cost and liability before comparing reports, invoices or payment totals.

Official Sources and Methodology

The legal analysis and model reference the following Colombian government and regulatory materials:

1. DIAN — Resolution 000227 of 2025. Consolidated regulatory framework for electronic payroll documentation, transmission, validation and adjustment notes. Official regulation.
2. DIAN — Resolution 000013 of 2021. Original electronic payroll framework, including monthly reporting, earnings, deductions and adjustment procedures, with provisions subsequently compiled into Resolution 000227 of 2025. Official regulation.
3. DIAN — Oficio 904276 of 2022. Interpretation of replacement and elimination notes for electronic payroll documents. Official doctrine.
4. UGPP — Frequently Asked Questions on Parafiscal Contributions. Guidance on IBC inaccuracies, differences against payroll and official information, and corrections using Planilla N. Official guidance.
5. Ministry of Labor — Decree 1469 of 2025. Minimum wage for 2026, considered alongside the subsequent 2026 judicial developments. Official legal text.
6. Ministry of Labor — Decree 1470 of 2025. Transportation allowance applicable in 2026. Official legal text.
7. Council of State — July 9, 2026 judicial decision. Revocation of the provisional suspension concerning Decree 1469 of 2025. Judicial decision.
8. Colombian public administration legal guidance — Article 17 of Law 344 of 1996. Treatment of non-salary arrangements and transportation allowances for contribution purposes. Legal guidance.
9. Law 1527 of 2012. Legal framework for qualifying authorized payroll-deduction arrangements. Official legal text.

Methodology note: All employee identities, compensation records, submission errors and bank transactions are synthetic. The numerical dataset is an original illustrative reconciliation model, not a sample of actual Colombian employer filings. Contribution illustrations exclude operator-specific rounding, interest, individual tax withholding and employment circumstances not specified in the assumptions.

Regulatory review date: October 15, 2026. Employers should verify subsequent statutory, administrative and judicial changes before using the model for an actual filing.