Nomina Excel Junio
Nomina Excel Junio
Nomina Excel Junio
NIT 8.081.234-0
DEDUCIDO
APORTES A SALUD APORTES A PENSION
CEDULA APORTE ABLIGATORIO A
ENTIDAD A LA QUE ESTA SALUD ENTIDAD A LA QUE APORTE VOLUNTARIO
AFILIADO ESTA AFILIADO A FONDOS DE
PENSION
4%
1 CAFESALUD 32,275 PORVENIR
2 CAFESALUD 35,140 PORVENIR
3 CAFESALUD 88,133 PORVENIR
4 CAFESALUD 36,019 PORVENIR
5 CAFESALUD 41,438 PORVENIR
6 CAFESALUD 51,050 PORVENIR
7 CAFESALUD 39,100 PORVENIR
8 CAFESALUD 147,653 PORVENIR 100,000
9 CAFESALUD 38,275 PORVENIR
10 CAFESALUD 82,520 PORVENIR
11 CAFESALUD 57,880 PORVENIR
12 CAFESALUD 50,480 PORVENIR
13 CAFESALUD 41,773 PORVENIR
14 CAFESALUD 103,008 PORVENIR
15 CAFESALUD 268,529 PORVENIR
16 CAFESALUD 52,042 PORVENIR
17 CAFESALUD 54,700 PORVENIR
18 CAFESALUD 93,375 PORVENIR
19 CAFESALUD 59,990 PORVENIR
20 CAFESALUD 54,875 PORVENIR
21 CAFESALUD PORVENIR
22 CAFESALUD 54,000 PORVENIR
23 CAFESALUD 46,958 PORVENIR
24 CAFESALUD 46,538 PORVENIR
25 CAFESALUD 15,338 PORVENIR
TOTALES 1,591,090 100,000
SALUD CAFESALUD 4%
CEDULA NOMBRE DEL EMPLEADO IBC TOTAL
1 CRISTINA BECERRA 806,878 32,275
2 LEIDY MOLANO 878,510 35,140
3 ROCIO CHAPARRO 2,203,333 88,133
4 LINA JIMENEZ 900,476 36,019
5 JONATAN BARRAGAN 1,035,938 41,438
6 YULY BECERRA 1,276,250 51,050
7 YOHANA TORRES 977,500 39,100
8 DAYANA GOMEZ 3,691,333 147,653
9 PAOLA GARCIA 956,880 38,275
10 JOHANA SALAMANCA 2,063,000 82,520
11 LUISA PALENCIA 1,447,000 57,880
12 YESICA GOMEZ 1,262,000 50,480
13 ADRIANA ALBARRACIN 1,044,331 41,773
14 XIMENA PLAZAS 2,575,200 103,008
15 MICHELLE CUESTA 6,713,225 268,529
16 SANDRA AYALA 1,301,042 52,042
17 ALEJANDRO TENJO 1,367,500 54,700
18 MAYRA JOYA 2,334,375 93,375
19 JENNIFER BERDUGO 1,499,750 59,990
20 PATRICIA TORRES 1,371,875 54,875
21 NATALIA ALARCON 750,012 30,000
22 ALEJANDRA SANABRIA 1,350,000 54,000
23 JENNY GOMEZ 1,173,958 46,958
24 SONIA SOTO 1,163,438 46,538
25 CARLOS GAMBASICA 383,459 15,338
TOTALES 40,527,263 1,621,091
PENSION
CEDULA NOMBRE DEL EMPLEADO IBC 12% 4%
1 CRISTINA BECERRA 806,878 96,825 32,275
2 LEIDY MOLANO 878,510 105,421 35,140
3 ROCIO CHAPARRO 2,203,333 264,400 88,133
4 LINA JIMENEZ 900,476 108,057 36,019
5 JONATAN BARRAGAN 1,035,938 124,313 41,438
6 YULY BECERRA 1,276,250 153,150 51,050
7 YOHANA TORRES 977,500 117,300 39,100
8 DAYANA GOMEZ 3,691,333 442,960 147,653
9 PAOLA GARCIA 956,880 114,826 38,275
10 JOHANA SALAMANCA 2,063,000 247,560 82,520
11 LUISA PALENCIA 1,447,000 173,640 57,880
12 YESICA GOMEZ 1,262,000 151,440 50,480
13 ADRIANA ALBARRACIN 1,044,331 125,320 41,773
14 XIMENA PLAZAS 2,575,200 309,024 103,008
15 MICHELLE CUESTA 6,713,225 805,587 268,529
16 SANDRA AYALA 1,301,042 156,125 52,042
17 ALEJANDRO TENJO 1,367,500 164,100 54,700
18 MAYRA JOYA 2,334,375 280,125 93,375
19 JENNIFER BERDUGO 1,499,750 179,970 59,990
20 PATRICIA TORRES 1,371,875 164,625 54,875
21 NATALIA ALARCON 750,012
22 ALEJANDRA SANABRIA 1,350,000 162,000 54,000
23 JENNY GOMEZ 1,173,958 140,875 46,958
24 SONIA SOTO 1,163,438 139,613 46,538
25 CARLOS GAMBASICA 383,459 46,015 15,338
TOTALES 40,527,263 4,773,270 1,591,090
PRESTACIONES SOCIALES
INTERES PRIMA DE
CEDULA NOMBRE DEL EMPLEADO CESANTIAS
CESANTIAS SERVICIOS
BONIFICACIONES TOTAL
SALARIO RTN, DEVENGADO
AUXILIO TRANSPORTE COMISIONES Y PRIMA
DEVENGADO SUPLEMENTARIO
HABITUAL
CIDO
PORTES A PENSION
APORTE DESCUENTOS
ABLIGATORIO A APORTE A FONDO DE RETENCIÓN TOTAL NETO
POR
PENSION SOLIDARIDAD EN LA FUENTE DEDUCIDO PAGADO
PRESTAMOS
PENSIONAL
4%
32,275 - 64,550 825,468
35,140 - 200,000 270,281 691,370
88,133 - 123,000 299,267 1,904,067
36,019 - 72,038 911,578
41,438 - 82,875 1,030,660
51,050 - 102,100 1,243,433
39,100 - 182,000 260,200 800,440
147,653 36,913 432,220 3,259,113
38,275 - 76,550 963,470
82,520 - 165,040 1,897,960
57,880 - 115,760 1,411,609
50,480 - 100,960 1,244,180
41,773 - 83,546 1,043,924
103,008 - 206,016 2,452,324
268,529 67,132 867,521 1,471,711 8,118,610
52,042 - 104,083 1,280,098
54,700 - 109,400 1,341,240
93,375 - 186,750 2,147,625
59,990 - 119,980 1,462,910
54,875 - 109,750 1,345,265
- - 750,012
54,000 - 108,000 1,316,826
46,958 - 93,917 1,163,182
46,538 - 93,075 1,153,503
15,338 - 30,677 383,267
1,591,090 505,000 867,521 4,758,747 40,142,133
PARAFISCALES 4% 2%
CAJA DE COMPENSACION
FAMILIAR SENA
CRISTINA BECERRA 806,878 32,275
LEIDY MOLANO 878,510 35,140
ROCIO CHAPARRO 2,203,333 88,133
LINA JIMENEZ 900,476 36,019
JONATAN BARRAGAN 1,035,938 41,438
YULY BECERRA 1,276,250 51,050
YOHANA TORRES 977,500 39,100
DAYANA GOMEZ 3,691,333 147,653
PAOLA GARCIA 956,880 38,275
JOHANA SALAMANCA 2,063,000 82,520
LUISA PALENCIA 1,447,000 57,880
YESICA GOMEZ 1,262,000 50,480
ADRIANA ALBARRACIN 1,044,331 41,773
XIMENA PLAZAS 2,575,200 103,008
MICHELLE CUESTA 6,713,225 268,529 134,264
SANDRA AYALA 1,301,042 52,042
ALEJANDRO TENJO 1,367,500 54,700
MAYRA JOYA 2,334,375 93,375
JENNIFER BERDUGO 1,499,750 59,990
PATRICIA TORRES 1,371,875 54,875
NATALIA ALARCON 750,012
ALEJANDRA SANABRIA 1,350,000 54,000
JENNY GOMEZ 1,173,958 46,958
SONIA SOTO 1,163,438 46,538
CARLOS GAMBASICA 383,459 15,338
- 40,527,263 1,591,090 134,264
RIESGOS
TOTAL NOMBRE DEL EMPLEADO TARIFA VALOR
129,100 CRISTINA BECERRA 0.522% 4,212
140,562 LEIDY MOLANO 0.522% 4,586
352,533 ROCIO CHAPARRO 0.522% 11,501
144,076 LINA JIMENEZ 4.350% 39,171
165,750 JONATAN BARRAGAN 0.522% 5,408
204,200 YULY BECERRA 0.522% 6,662
156,400 YOHANA TORRES 0.522% 5,103
590,613 DAYANA GOMEZ 0.522% 19,269
153,101 PAOLA GARCIA 4.350% 41,624
330,080 JOHANA SALAMANCA 0.522% 10,769
231,520 LUISA PALENCIA 0.522% 7,553
201,920 YESICA GOMEZ 0.522% 6,588
167,093 ADRIANA ALBARRACIN 4.350% 45,428
412,032 XIMENA PLAZAS 0.522% 13,443
1,074,116 MICHELLE CUESTA 0.522% 35,043
208,167 SANDRA AYALA 0.522% 6,791
218,800 ALEJANDRO TENJO 0.522% 7,138
373,500 MAYRA JOYA 0.522% 12,185
239,960 JENNIFER BERDUGO 0.522% 7,829
219,500 PATRICIA TORRES 0.522% 7,161
- NATALIA ALARCON 0.522% 3,915
216,000 ALEJANDRA SANABRIA 0.522% 7,047
187,833 JENNY GOMEZ 0.522% 6,128
186,150 SONIA SOTO 0.522% 6,073
61,353 CARLOS GAMBASICA 4.350% 16,680
6,364,360 TOTALES 337,308
VACACIONES
30,738
36,605
66,667
32,397
30,852
35,634
35,417
136,444
31,993
62,296
46,863
51,750
30,738
94,800
41,667
50,729
75,000
51,240
41,667
40,500
42,882
35,417
4,379
1,106,674
SALARIO
MINIMO 737,717
AUXILIO DE
TRANSPORTE 83,140
IBC
806,878
878,510
2,203,333
900,476
1,035,938
1,276,250
977,500
3,691,333
956,880
2,063,000
1,447,000
1,262,000
1,044,331
2,575,200
6,713,225
1,301,042
1,367,500
2,334,375
1,499,750
1,371,875
750,012
1,350,000
1,173,958
1,163,438
383,459
40,527,263
RECIBI
CONFORME
FIRMA Y CC
3%
ICBF
201,397
201,397
HORA EXTRA ORDINARIA
CEDULA NOMBRE DEL EMPLEADO SALARIO BASICO VALOR HORA N°DE
HORAS
1 CRISTINA BECERRA 737,717 3,074 18
2 LEIDY MOLANO 850,000 3,542
3 ROCIO CHAPARRO 1,600,000 6,667 34
4 LINA JIMENEZ 737,717 3,074
5 JONATAN BARRAGAN 850,000 3,542
6 YULY BECERRA 1,200,000 5,000 40
7 YOHANA TORRES 850,000 3,542
8 DAYANA GOMEZ 3,200,000 13,333 25
9 PAOLA GARCIA 737,717 3,074
10 JOHANA SALAMANCA 1,600,000 6,667 11
11 LUISA PALENCIA 1,200,000 5,000
12 YESICA GOMEZ 1,200,000 5,000
13 ADRIANA ALBARRACIN 737,717 3,074 35
14 XIMENA PLAZAS 1,200,000 5,000 48
15 MICHELLE CUESTA 9,590,321 39,960
16 SANDRA AYALA 1,000,000 4,167 13
17 ALEJANDRO TENJO 1,200,000 5,000
18 MAYRA JOYA 1,800,000 7,500 57
19 JENNIFER BERDUGO 1,200,000 5,000
20 PATRICIA TORRES 1,000,000 4,167
21 NATALIA ALARCON 737,717 3,074 16
22 ALEJANDRA SANABRIA 1,200,000 5,000
23 JENNY GOMEZ 1,000,000 4,167 25
24 SONIA SOTO 850,000 3,542 26
25 CARLOS GAMBASICA 737,717 3,074
ORA EXTRA ORDINARIA HORA EXTRA NOCTURNA DOMINICAL Y FESTIVO DOMINICALY FESTIVO NOCT
F/RESULTADO N°DE F/RESULTADO N°DE F/RESULTADO N°DE F/RESULTADO
1.25 HORAS 1.75 HORAS 1.75 HORAS 2.10
69,161 - - -
- - - -
283,333 - - -
- - - -
- - - -
250,000 - - -
- - 16 99,167 -
416,667 - - -
- - 8 43,033 -
91,667 22 256,667 - 12 168,000
- - 18 157,500 12 126,000
- - - -
134,480 - 32 172,134 -
300,000 - - -
- - - -
67,708 - 32 233,333 -
- - - -
534,375 - - -
- - 24 210,000 -
- 51 371,875 - -
61,476 - - -
- - 24 210,000 -
130,208 - 2 14,583 -
115,104 - 32 198,333 -
- - 18 96,825 -
EXTRA DIURNO FESTIVO EXTRA NOCTURNO FESTIVO RECARGO NOCTURNO TOTAL
N°DE F/RESULTADO N°DE F/RESULTADO N°DE F/RESULTADO TRABAJO
HORAS 2.00 HORAS 2.50 HORAS 0.35 SUPLEMEN
TARIO Y
- - - RECARGOS
69,161
- - 23 28,510 28,510
24 320,000 - - 603,333
- 16 122,953 37 39,806 162,759
18 127,500 13 115,104 - 242,604
- - 15 26,250 276,250
4 28,333 - - 127,500
- - 16 74,667 491,333
- 19 146,006 28 30,123 219,163
- - - 516,333
- - 2 3,500 287,000
2 20,000 - 24 42,000 62,000
- - - 306,614
- - - 300,000
- - - -
- - - 301,042
- - 10 17,500 17,500
- - - 534,375
6 60,000 - 17 29,750 299,750
- - - 371,875
- - - 61,476
6 60,000 - - 270,000
- - 20 29,167 173,958
- - - 313,438
- - 15 16,138 112,963
FONDO DE SOLIDARIDAD PENSIONAL
RANGO RANGO
PORCENTAJE INICIAL FINAL