Planilla Resumen

DATOS GENERALES DEL APORTANTE

Identificación dv Razon Social Clase Aportante Sucursal Principal Direccion Ciudad-Departamento Teléfono Exonerado SENA e
ICBF
NIT 900928345 4 SEG CONSTRUCCION Y CONSULTORIA B - MENOS DE 200 COTIZANTES SEG CONSTRUCCION Y CLL 105 24 129 PISO 2 BUCARAMANGA-SANTANDER 6952795 Si
S.A.S CONSULTORIA S.A.S

DATOS GENERALES DE LA LIQUIDACION

Periodo Clave Tipo Fecha Pago
Pensión Salud Pago Planilla Planilla Limite Pago Banco Dias Mora Valor
2023-08 2023-09 160307878 9456280158 E 2023/09/12 2023/09/14 BANCOLOMBIA 2 $12,592,400

LIQUIDACION DETALLADA DE APORTES

EMPLEADO NOVEDADES PENSION SALUD CCF RIESGOS PARAFISCALES
No. Identificación Nombre Codigo Días IBC Aporte Codigo Dias IBC Aporte Codigo Días IBC Aporte Codigo Días IBC Tarifa Aporte Días IBC Aporte Exonerado Total Aportes
ing ret tde tae tdp tap vsp cor vst sln ige lma vac avp vct irl vip SENA e ICBF

SUCURSAL: SEG CONSTRUCCION Y CONSULTORIA S.A.S (26 Afiliados) $40,190,455 $6,481,100 $41,350,455 $1,647,300 $41,350,455 $1,647,300 $41,350,455 $2,019,400 $0 $0 $11,795,100

Centro de Trabajo: ADMINISTRATIVOS 1 (8 Afiliados) $11,994,018 $1,919,200 $13,154,018 $526,400 $13,154,018 $526,400 $13,154,018 $69,000 $0 $0 $3,041,000

Ciudad: BUCARAMANGA Depto: SANTANDER (8 Afiliados) $11,994,018 $1,919,200 $13,154,018 $526,400 $13,154,018 $526,400 $13,154,018 $69,000 $0 $0 $3,041,000

1 CC 91531084 ESPITIA PINTO 23030 30 $1,566,000 $250,600 EPS010 30 $1,566,000 $62,700 CCF40 30 $1,566,000 $62,700 14-11 30 $1,566,000 0.522% $8,200 30 $0 $0 Si $384,200
EDWARD 1

2 CC 1104068589 FORERO AGUDELO 23030 30 $2,078,684 $332,600 EPS010 30 $2,078,684 $83,200 CCF40 30 $2,078,684 $83,200 14-11 30 $2,078,684 0.522% $10,900 30 $0 $0 Si $509,900
HENRY EDHER 1

3 CC 63559354 GALVAN MEDINA 25-14 30 $3,000,000 $480,000 EPS010 30 $3,000,000 $120,000 CCF40 30 $3,000,000 $120,000 14-11 30 $3,000,000 0.522% $15,700 30 $0 $0 Si $735,700
GINA MARCELA

4 CC 93398229 MENDOZA JIMENEZ 23020 30 $2,000,000 $320,000 EPS010 30 $2,000,000 $80,000 CCF40 30 $2,000,000 $80,000 14-11 30 $2,000,000 0.522% $10,500 30 $0 $0 Si $490,500
MILTON HARLEY 1

5 CC 1098795510 MORENO SANCHEZ 23030 30 $1,508,000 $241,300 EPS005 30 $1,508,000 $60,400 CCF40 30 $1,508,000 $60,400 14-11 30 $1,508,000 0.522% $7,900 30 $0 $0 Si $370,000
ANDRES JULIAN 1

6 CC 37837018 PINTO 0 $0 $0 EPS010 30 $1,160,000 $46,400 CCF40 30 $1,160,000 $46,400 14-11 30 $1,160,000 0.522% $6,100 30 $0 $0 Si $98,900
CASTIBLANCO
CARMEN JULIA

7 CC 1007775633 SANCHEZ REYES X X 23020 14 $541,334 $86,700 EPS037 14 $541,334 $21,700 CCF40 14 $541,334 $21,700 14-11 14 $541,334 0.522% $2,900 14 $0 $0 Si $133,000
MARIA CAMILA 1

8 CC 1005151796 TELLEZ PINEDA 23030 30 $1,300,000 $208,000 EPS005 30 $1,300,000 $52,000 CCF40 30 $1,300,000 $52,000 14-11 30 $1,300,000 0.522% $6,800 30 $0 $0 Si $318,800
EVELYN MARIANA 1

Centro de Trabajo: ADMINISTRATIVOS 2 (11 Afiliados) $18,764,924 $3,052,500 $18,764,924 $750,800 $18,764,924 $750,800 $18,764,924 $1,306,600 $0 $0 $5,860,700

Ciudad: BUCARAMANGA Depto: SANTANDER (11 Afiliados) $18,764,924 $3,052,500 $18,764,924 $750,800 $18,764,924 $750,800 $18,764,924 $1,306,600 $0 $0 $5,860,700

9 CC 91485734 ESPITIA PINTO 23030 30 $5,000,000 $850,000 EPS010 30 $5,000,000 $200,000 CCF40 30 $5,000,000 $200,000 14-11 30 $5,000,000 6.960% $348,000 30 $0 $0 Si $1,598,000
ALEXANDER 1

10 CC 1005179652 FONSECA BARRERA 23100 30 $1,160,000 $185,600 EPS002 30 $1,160,000 $46,400 CCF40 30 $1,160,000 $46,400 14-11 30 $1,160,000 6.960% $80,800 30 $0 $0 Si $359,200
MILTON DUVAN 1

11 CC 1098702072 FUENTES LUNA 23020 30 $1,640,240 $262,500 EPS005 30 $1,640,240 $65,700 CCF40 30 $1,640,240 $65,700 14-11 30 $1,640,240 6.960% $114,200 30 $0 $0 Si $508,100
LUIS RAFAEL 1

12 CC 1101696370 GALVIS MATEUS 23020 30 $1,700,000 $272,000 EPS037 30 $1,700,000 $68,000 CCF40 30 $1,700,000 $68,000 14-11 30 $1,700,000 6.960% $118,400 30 $0 $0 Si $526,400
JAIME LEONARDO 1

13 CC 1122414411 LOPEZ GONZALEZ 23030 30 $1,160,000 $185,600 CCFC5 30 $1,160,000 $46,400 CCF40 30 $1,160,000 $46,400 14-11 30 $1,160,000 6.960% $80,800 30 $0 $0 Si $359,200
SILFREDO DE JESUS 1 5

14 CC 1052410706 MESA RICO 23030 30 $1,600,000 $256,000 EPS041 30 $1,600,000 $64,000 CCF40 30 $1,600,000 $64,000 14-11 30 $1,600,000 6.960% $111,400 30 $0 $0 Si $495,400
ADRIANA ISABEL 1

15 CC 1057599854 MOLANO TRUJILLO 23030 30 $1,700,000 $272,000 EPS041 30 $1,700,000 $68,000 CCF40 30 $1,700,000 $68,000 14-11 30 $1,700,000 6.960% $118,400 30 $0 $0 Si $526,400
ANGIE LISETH 1

16 CC 1007765753 PASTRANA PUCHE 23020 30 $1,300,000 $208,000 MIN002 30 $1,300,000 $52,000 CCF40 30 $1,300,000 $52,000 14-11 30 $1,300,000 6.960% $90,500 30 $0 $0 Si $402,500
JOSE DAVID 1

17 CC 1140821633 PEÑARANDA 25-14 30 $2,078,684 $332,600 EPS037 30 $2,078,684 $83,200 CCF40 30 $2,078,684 $83,200 14-11 30 $2,078,684 6.960% $144,700 30 $0 $0 Si $643,700
SALAZAR LEYDY
CONSUELO

18 CC 1098748257 ROJAS X 23030 3 $150,000 $24,000 EPS002 3 $150,000 $6,000 CCF40 3 $150,000 $6,000 14-11 3 $150,000 6.960% $10,500 3 $0 $0 Si $46,500
CASTELLANOS 1
JUAN PABLO

19 CC 1193568921 ROSAS TORRES 23030 30 $1,276,000 $204,200 EPS017 30 $1,276,000 $51,100 CCF40 30 $1,276,000 $51,100 14-11 30 $1,276,000 6.960% $88,900 30 $0 $0 Si $395,300
WILSON JOHAN 1

Página 1 de 3 2023/09/14 03:12 PM

 Planilla Resumen
Centro de Trabajo: OPERATIVOS (7 Afiliados) $9,431,513 $1,509,400 $9,431,513 $370,100 $9,431,513 $370,100 $9,431,513 $643,800 $0 $0 $2,893,400

Ciudad: BUCARAMANGA Depto: SANTANDER (7 Afiliados) $9,431,513 $1,509,400 $9,431,513 $370,100 $9,431,513 $370,100 $9,431,513 $643,800 $0 $0 $2,893,400

20 CC 88269887 CELY VIVAS ERWIN X 23100 17 $1,073,426 $171,800 EPS042 17 $1,073,426 $43,000 CCF40 17 $1,073,426 $43,000 14-11 17 $1,073,426 6.960% $74,800 17 $0 $0 Si $332,600
ALISON 1

21 CC 91506409 HORTUA FABIAN X 23030 2 $186,667 $29,900 EPS037 2 $186,667 $0 CCF40 2 $186,667 $0 14-11 2 $186,667 0.000% $0 2 $0 $0 Si $29,900
ANDRES 1

22 CC 91506409 HORTUA FABIAN 23030 28 $2,613,334 $418,200 EPS037 28 $2,613,334 $104,600 CCF40 28 $2,613,334 $104,600 14-11 28 $2,613,334 6.960% $181,900 28 $0 $0 Si $809,300
ANDRES 1

23 CC 92229364 LANS MORENO 25-14 30 $1,742,823 $278,900 EPS037 30 $1,742,823 $69,800 CCF40 30 $1,742,823 $69,800 14-11 30 $1,742,823 6.960% $121,400 30 $0 $0 Si $539,900
NARCILO
GUILLERMO

24 CC 91262235 ROSAS AVELLA X 23100 19 $1,199,711 $192,000 EPS037 19 $1,199,711 $48,000 CCF40 19 $1,199,711 $48,000 14-11 19 $1,199,711 6.960% $83,500 19 $0 $0 Si $371,500
WILLIAM 1

25 CC 1048265499 SILVERA MEJIA 23030 30 $1,289,568 $206,400 EPS042 30 $1,289,568 $51,600 CCF40 30 $1,289,568 $51,600 14-11 30 $1,289,568 6.960% $89,800 30 $0 $0 Si $399,400
EDINSON RAFAEL 1

26 CC 1007893303 TORRES MALAGON X 25-14 3 $165,984 $26,600 EPS002 3 $165,984 $6,700 CCF40 3 $165,984 $6,700 14-11 3 $165,984 6.960% $11,600 3 $0 $0 Si $51,600
JESUS DAVID

27 CC 91298461 VILLAMIZAR ORTIZ 25-14 30 $1,160,000 $185,600 EPS041 30 $1,160,000 $46,400 CCF40 30 $1,160,000 $46,400 14-11 30 $1,160,000 6.960% $80,800 30 $0 $0 Si $359,200
CESAR AUGUSTO

LIQUIDACION DETALLADA DE APORTES

EMPLEADO NOVEDADES PENSION SALUD CCF RIESGOS PARAFISCALES
No. Identificación Nombre Codigo Días IBC Aporte Codigo Dias IBC Aporte Codigo Días IBC Aporte Codigo Días IBC Tarifa Aporte Días IBC Aporte Exonerado Total Aportes
ing ret tde tae tdp tap vsp cor vst sln ige lma vac avp vct irl vip SENA e ICBF

SUCURSAL: COMFANORTE (2 Afiliados) $2,482,400 $397,200 $2,482,400 $99,300 $2,482,400 $99,300 $2,482,400 $172,900 $0 $0 $768,700

Centro de Trabajo: RIESGO V (2 Afiliados) $2,482,400 $397,200 $2,482,400 $99,300 $2,482,400 $99,300 $2,482,400 $172,900 $0 $0 $768,700

Ciudad: CUCUTA Depto: NORTE DE SANTANDER (2 Afiliados) $2,482,400 $397,200 $2,482,400 $99,300 $2,482,400 $99,300 $2,482,400 $172,900 $0 $0 $768,700

28 CC 1093792496 LUNA DUQUE JUAN 23030 30 $1,322,400 $211,600 ESSC24 30 $1,322,400 $52,900 CCF37 30 $1,322,400 $52,900 14-11 30 $1,322,400 6.960% $92,100 30 $0 $0 Si $409,500
PABLO 1

29 CC 1126710980 NEIRA CARLOS 23030 30 $1,160,000 $185,600 EPS037 30 $1,160,000 $46,400 CCF37 30 $1,160,000 $46,400 14-11 30 $1,160,000 6.960% $80,800 30 $0 $0 Si $359,200
NEPTALI 1
Total Afiliados( 28) $42,672,855 $6,878,300 $43,832,855 $1,746,600 $43,832,855 $1,746,600 $43,832,855 $2,192,300 $0 $0 $12,563,800

Página 2 de 3 2023/09/14 03:12 PM

 Planilla Resumen
DATOS GENERALES DEL APORTANTE
Identificación dv Razon Social Clase Aportante Sucursal Principal Direccion Ciudad-Departamento Teléfono Exonerado SENA e
ICBF
NIT 900928345 4 SEG CONSTRUCCION Y CONSULTORIA B - MENOS DE 200 COTIZANTES SEG CONSTRUCCION Y CLL 105 24 129 PISO 2 BUCARAMANGA-SANTANDER 6952795 Si
S.A.S CONSULTORIA S.A.S

DATOS GENERALES DE LA LIQUIDACION

Periodo Clave Tipo Fecha Pago
Pensión Salud Pago Planilla Planilla Limite Pago Banco Dias Mora Valor
2023-08 2023-09 160307878 9456280158 E 2023/09/12 2023/09/14 BANCOLOMBIA 2 $12,592,400

RESUMEN DE PAGO
RIESGO CODIGO NIT DV AFILIADOS VALOR LIQUIDADO INTERESES MORA SALDOS E VALOR A PAGAR
INCAPACIDADES
AFP (ADMINISTRADORAS: 4) 27 $6,878,300 $15,400 $0 $6,893,700

COLFONDOS 231001 800,227,940 6 3 $549,400 $1,300 $0 $550,700

COLPENSIONES 25-14 900,336,004 7 5 $1,303,700 $2,900 $0 $1,306,600

PORVENIR 230301 800,224,808 8 14 $3,876,000 $8,600 $0 $3,884,600

PROTECCION 230201 800,229,739 0 5 $1,149,200 $2,600 $0 $1,151,800

ARL (ADMINISTRADORAS: 1) 28 $2,192,300 $4,800 $0 $2,197,100

ARL SURA 14-11 890,903,790 5 28 $2,192,300 $4,800 $0 $2,197,100

CCF (ADMINISTRADORAS: 2) 28 $1,746,600 $4,000 $0 $1,750,600

COMFANORTE CCF37 890,500,516 3 2 $99,300 $300 $0 $99,600

COMFENALCO SANTANDER CCF40 890,201,578 7 26 $1,647,300 $3,700 $0 $1,651,000

EPS (ADMINISTRADORAS: 10) 28 $1,746,600 $4,400 $0 $1,751,000

CAJACOPI CCFC55 901,543,211 6 1 $46,400 $200 $0 $46,600

COOSALUD EPS EPS042 900,226,715 3 2 $94,600 $300 $0 $94,900

COOSALUD MOVILIDAD ESSC24 900,226,715 3 1 $52,900 $200 $0 $53,100

EPS SURA (ANTES SUSALUD) EPS010 800,088,702 2 6 $592,300 $1,300 $0 $593,600

FAMISANAR EPS017 830,003,564 7 1 $51,100 $200 $0 $51,300

FOSYGA RÉGIMEN DE EXCEPCIÓN MIN002 901,037,916 1 1 $52,000 $200 $0 $52,200

NUEVA E.P.S. EPS037 900,156,264 2 7 $441,700 $1,000 $0 $442,700

NUEVA EPS MOVILIDAD EPS041 900,156,264 2 3 $178,400 $400 $0 $178,800

SALUD TOTAL EPS002 800,130,907 4 3 $59,100 $200 $0 $59,300

SANITAS EPS005 800,251,440 6 3 $178,100 $400 $0 $178,500

TOTAL 28 $12,563,800 $28,600 $0 $12,592,400

Página 3 de 3 2023/09/14 03:12 PM