Upload
natalia-andrea-mejia-diaz
View
214
Download
1
Embed Size (px)
DESCRIPTION
ejemplo de nómina
Citation preview
Funcionario Salario basePorcentaje Salario Dias
Salario real Horas extrasnominal liquidados diurnas
Tecnico de operación 850,000.0 0.98 833,000.00 30 833,000.0 - Supervisor 2,658,400.0 0.98 2,605,232.00 30 2,605,232.0 - Servicio genrerales 664,350.0 0.98 651,063.00 30 651,063.0 3.0 Jefe de bodega 1,327,900.0 0.98 1,301,342.00 20 867,561.3 - Aux de bodega 776,000.0 0.98 760,480.00 30 760,480.0 - Aux de mercadeo 824,500.0 0.98 808,010.00 15 404,005.0 4.0 Gerente almacen 4,700,000.0 0.98 4,606,000.00 30 4,606,000.0 - Jede de cajeros 1,331,200.0 0.98 1,304,576.00 20 869,717.3 -
Funcionario Horas extras Horas jornada laboral Sub Transporte Prima tecnica Valor por horas extrasdom. noct. Diurna Nocturna mensual HED
Tecnico de operación 5.0 4.0 4.0 74,000.0 - - Supervisor - 8.0 - - 300,000.0 - Servicio genrerales 3.0 2.0 6.0 74,000.0 - 10,172.9 Jefe de bodega 3.0 - 8.0 - - - Aux de bodega - 8.0 - 74,000.0 - - Aux de mercadeo 4.0 8.0 - 37,000.0 - 16,833.5 Gerente almacen - 4.0 4.0 - 1,000,000.0 - Jede de cajeros - 8.0 - - - -
Funcionario Valor horas extras Recargo Total Salud PensionFondo de
domin. nocturnas nocturno Devengado solidaridadTecnico de operación 43,385.4 4,859.2 973,466.5 35,978.66 35,978.66 - Supervisor - - 2,943,225.0 117,729.00 117,729.00 29,432.2 Servicio genrerales 20,345.7 5,696.8 761,278.4 27,491.14 27,491.14 - Jefe de bodega 40,666.9 15,182.3 961,366.4 38,454.66 38,454.66 - Aux de bodega - - 834,480.0 30,419.20 30,419.20 - Aux de mercadeo 33,667.1 - 526,856.1 19,594.24 19,594.24 - Gerente almacen - 26,868.3 5,632,868.3 225,314.73 225,314.73 56,328.7 Jede de cajeros - - 869,717.3 34,788.69 34,788.69 -
FuncionarioSindicato
PrestamoTotal Total a
1% deducciones pagarTecnico de operación 8330 0 104,623.98 868,842.5 Supervisor 0 150000 488,470.87 2,454,754.1 Servicio genrerales 6510.63 0 80,524.86 680,753.5 Jefe de bodega 13013.42 70000 183,956.89 777,409.5 Aux de bodega 7604.8 0 89,305.20 745,174.8 Aux de mercadeo 8080.1 0 60,439.99 466,416.1 Gerente almacen 0 0 647,779.86 4,985,088.5 Jede de cajeros 13045.76 0 104,366.08 765,351.3
TOTAL DEVENGADO 13,503,257.9 APORTES:TOTAL SUB TRANSPORTE 259,000.0 Salud 1103688.161337TOTAL DEDUCCIONES 1,759,467.73 Pension 1103688.161337TOTAL A PAGAR 11,743,790.2 Fondo de sol. 85,760.9
TOTAL 2293137.255674
PARAFISCALES PRESTACIONES SOCIALESARP 69135.0264261375 Cesantias 1,103,688.2 ICBF 397327.73808125 Int. Cesantias 11,036.9 SENA 264885.158720833 Prima 1,103,688.2 CAJA COM. FAM. 529770.317441667 Vacaciones 554,036.0 TOTAL 1261118.24066989 TOTAL 1,657,724.2
Horas extrasnocturnas
3.0 2.0 - 4.0 - 6.0 - -
Valor por horas extrasHEN 18,221.9 37,993.0 - 37,955.8 - 35,350.4 - -
Cooperativa 2.50%
24,336.7 73,580.6 19,032.0 24,034.2 20,862.0 13,171.4 140,821.7 21,742.9
11,816,764.93
833,000.0 833,000.00 2,605,232.0 2,605,232.00 651,063.0 651,063.00 1,301,342.0 867,561.33 760,480.0 760,480.00 808,010.0 404,005.00
4,606,000.0 4,606,000.00 1,304,576.0 869,717.33
833,000.00 2,605,232.00 651,063.00 867,561.33 760,480.00 404,005.00
4,606,000.00 869,717.33