...
En este ejemplo, con ingresos laborales de 40,000,000, se observa que a partir de Abril llega al tope de los 1340 UVT's por lo que los restantes meses ya no aplica los conceptos de deducción y rentas exentas.
|
| Con | Enero | Febrero | Marzo | Abril | Mayo | Junio | Julio | Agosto | Septiembre | Octubre | Noviembre | Diciembre |
| Total ingresos laborales | 501 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 | 40,000,000 |
| Viáticos ocasionales que constituyen reembolso de gastos soportados |
|
|
|
|
|
|
|
|
|
|
|
|
|
4% | Aportes obligatorios a salud efectuados por el trabajador | 505 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 |
4% | Aportes obligatorios a fondos de pensiones | 502 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 |
| Aporte Voluntario a Fondo de Obligatorio | 504 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 |
| Veces SMMLV |
| 34.48 | 34.48 | 34.48 | 34.48 | 34.48 | 34.48 | 34.48 | 34.48 | 34.48 | 34.48 | 34.48 | 34.48 |
| Aporte FSP | 503 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 |
| Medios de transporte distintos del subsidio de transporte |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Demás pagos que no incrementan el patrimonio del trabajador |
|
|
|
|
|
|
|
|
|
|
|
|
|
| (-) Ingresos no constitutivos de renta ni ganancia ocasional |
| 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 | 4,065,000 |
| Subtotal No Constitutivo de Renta | 506 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 |
40% | 40% sin topar |
| 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 | 14,374,000 |
| Acumulado Anual mes anterior |
| - | 14,374,000 | 28,748,000 | 43,122,000 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 |
| Tope de 1340 UVT |
| 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 |
| 40% topado a 1340 UVT's |
| 14,374,000 | 14,374,000 | 14,374,000 | 13,710,080 | - | - | - | - | - | - | - | - |
115,162 | Intereses Vivienda | 507 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 |
262,300 | Medicina Pre pagada | 508 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 |
1 | Dependientes | 509 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 | 1,357,184 |
| Deducciones sin topar |
| 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 |
| Deducciones topadas al 40% |
| 1,734,646 | 1,734,646 | 1,734,646 | 1,734,646 | - | - | - | - | - | - | - | - |
| Subtotal Deducciones | 510 | 34,200,354 | 34,200,354 | 34,200,354 | 34,200,354 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 |
55,000 | Apo Voluntaria AFC | 511 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 |
60,000 | Apo Voluntaria AFP Empleado | 512 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 |
50,000 | Indemnización Accidente Trabajo | 514 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 |
| Indemnización Licencia Maternidad | 515 | - | - | - | - | - | - | - | - | - | - | - | - |
| Gastos Entierro | 516 | - | - | - | - | - | - | - | - | - | - | - | - |
50,000 | Otras Rentas Exentas | 517 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 |
| Rentas Exentas sin topar |
| 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 |
| Rentas Exentas topadas al 40% |
| 215,000 | 215,000 | 215,000 | 215,000 | - | - | - | - | - | - | - | - |
| Subtotal Rentas Exentas | 518 | 33,985,354 | 33,985,354 | 33,985,354 | 33,985,354 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 |
| 25% rentas exentas sin topar |
| 8,496,339 | 8,496,339 | 8,496,339 | 8,496,339 | 8,983,750 | 8,983,750 | 8,983,750 | 8,983,750 | 8,983,750 | 8,983,750 | 8,983,750 | 8,983,750 |
| acum mes anterior 25% rentas exentas |
| - | 8,496,339 | 16,992,677 | 25,489,016 | 33,985,354 | 42,969,104 | 51,952,854 | 60,936,604 | 69,920,354 | 78,904,104 | 87,887,854 | 96,871,604 |
790 | 790 UVT's |
| 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 |
| 25% rentas exentas topadas a 790 UVT's y 40% PL |
| 8,496,339 | 8,496,339 | 8,496,339 | 8,016,465 | - | - | - | - | - | - | - | - |
| Subtotal Rentas Exenta 25% | 519 | 25,489,016 | 25,489,016 | 25,489,016 | 25,968,890 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 | 35,935,000 |
24% | Retención Procedimiento 2 |
| 6,117,364 | 6,117,364 | 6,117,364 | 6,232,533 | 8,624,400 | 8,624,400 | 8,624,400 | 8,624,400 | 8,624,400 | 8,624,400 | 8,624,400 | 8,624,400 |
Ejemplo de Cálculo Nómina LIQ ingresos laborales bajos.
En este ejemplo, se observa que en todo el año no se excede de los 1340 UVT's y 790 UVT's (25% Renta Exenta), por lo que aplican los conceptos de descuentos y restas exentas todos los meses.
|
| Con | Enero | Febrero | Marzo | Abril | Mayo | Junio | Julio | Agosto | Septiembre | Octubre | Noviembre | Diciembre |
| Total ingresos laborales | 501 | |
5 5 5 5 5 5 5 5 5 5 5 52,000,000 |
| Viáticos ocasionales que constituyen reembolso de gastos soportados |
|
|
|
|
|
|
|
|
|
|
|
|
|
4% | Aportes obligatorios a salud efectuados por el trabajador | 505 |
200 200 200 200 200 200 200 200 200 200 200 200 80,000 |
4% | Aportes obligatorios a fondos de pensiones | 502 |
200 200 200 200 200 200 200 200 200 200 200 200 80,000 |
| Aporte Voluntario a Fondo de Obligatorio | 504 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 | 65,000 |
| Veces SMMLV |
| |
431 431 431 431 431 431 431 431 431 431 431 431 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 |
| Medios de transporte distintos del subsidio de transporte |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Demás pagos que no incrementan el patrimonio del trabajador |
|
|
|
|
|
|
|
|
|
|
|
|
|
| (-) Ingresos no constitutivos de renta ni ganancia ocasional |
| |
515 515 515 515 515 515 515 515 515 515 515 515225,000 |
| Subtotal No Constitutivo de Renta | 506 | |
4485 4485 4485 4485 4485 4485 4485 4485 4485 4485 4485 4485 1794, 1,794 1,794 1794, 1,794 1794, 1,794 1,794 1,794 1794, 1794, 1794,000 |
| Acumulado Anual mes anterior |
| - | 710,000 | 1, |
794 3588 5382 7176 8970 10764 12558 14352 16146 19,734, 17,940,000 | 7,810,000 |
| Tope de 1340 UVT |
| 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 | 56,832,080 |
| 40% topado a 1340 UVT's |
1794, 1,794 1794, 1794, 1794, 1,794 1794, 1,794 1794, 1794, 1,794 1,794 710,000 |
115,162 | Intereses Vivienda | 507 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 | 115,162 |
262,300 | Medicina Pre pagada | 508 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 | 262,300 |
1 | Dependientes | 509 |
- | - | - | - | - | - | - | - | - - | - | - | Deducciones sin topar | 377,462 | 377,462 | 377,462 | 377,462 | 377,462 | 377,462 | 377,462 | 377,462 | 377,462 | 377,462 | 377,462 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 |
| Deducciones sin topar |
| 577,462 | 577,462 | 577,462 | 577,462 | 577,462 | 577,462 | 577,462 | 577,462 | 577,462 | 577,462 | 577,462 | 577 |
377,462 |
| Deducciones topadas al 40% |
| |
377 377 377 377 377 377 377 377 377 377 377 377577,462 |
| Subtotal Deducciones | 510 | |
4107 4107 4107 4107 4107 4107 4107 4107 4107 4107 4107 4107197,538 |
55,000 | Apo Voluntaria AFC | 511 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 |
60,000 | Apo Voluntaria AFP Empleado | 512 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 |
Apo Voluntaria AFP Compañía | 513 | - | - | - | - - | - | - | - | - | - | - | - | 50,000 | Indemnización Accidente Trabajo | 514 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 |
| Indemnización Licencia Maternidad | 515 | - | - | - | - | - | - | - | - | - | - | - | - |
| Gastos Entierro | 516 | - | - | - | - | - | - | - | - | - | - | - | - |
50,000 | Otras Rentas Exentas | 517 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 |
| Rentas Exentas sin topar |
| 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 |
| Rentas Exentas topadas al 40% |
215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 | 215,000 |
| Subtotal Rentas Exentas | 518 | |
3892 3892 3892 3892 3892 3892 3892 3892 3892 3892 3892 3892197,538 |
| 25% rentas exentas sin topar |
| |
973135 973135 973135 973135 973135 973135 973135 973135 973135 973135 973135 973135385 |
| acum mes anterior 25% rentas exentas |
| - | |
973135 1,946,269 | 2,919,404 | 3,892 4865673 5838807 6811942 7785 8758211 9731345 10704480230 |
790 | 790 UVT's |
| 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 | 33,505,480 |
| 25% rentas exentas topadas a 790 UVT's y 40% PL |
| |
973135 973135 973135 973135 973135 973135 973135 973135 973135 973135 973135 973135Renta
| Subtotal Rentas Exenta 25% | 519 |
2,919,404 | 2,919,404 | 2,919,404 | 2,919,404 | 2,919,404 | 2,919,404 | 2,919,404 | 2,919,404 | 2,919,404 | 2,919,404 | 2,919,404 | 898,154 | 898,154 | 898,154 | 898,154 | 898,154 | 898,154 | 898,154 | 898,154 | 898,154 | 898,154 | 898,154 | 898,154 |
0% | Retención Procedimiento 2 |
| - | - | - | - | - | - | - | - | - | - | - | - |
2,919,404