nominas basicas en excel
DESCRIPTION
Nomina resuelta en excel con todos sus campos y requeridos.TRANSCRIPT
AGENCIA PINTURA MAS LTDA.LIQUIDACION DE NOMINA PERIODO DEL 1 AL 31 DE DICIEMBRE
SALARIO MINIMO DEL AÑO 2015 $644,350.00AUXILIO DE TRANPORTE $74,000.00
EMPLEADO CARGO SUELDO BASICO
DEVENGADO
VALOR DIA VALOR HORA COMISION
NICOLAS NIETO GERENTE $2,850,000.00 $95,000.00 $11,875.00 $2,850,000.00MARIA TERESA LARA CONTADORA $1,720,000.00 $57,333.33 $7,166.67 $1,720,000.00ELIZABETH ERAZO SECRETARIA $890,000.00 $29,666.67 $3,708.33 $9,270.83 $25,958.33 $51,916.67 $14,833.33 $74,000.00 $1,065,979.17ALVARO AREVALO VENDEDOR $644,350.00 $21,478.33 $2,684.79 $1,908,000.00 $74,000.00 $2,626,350.00DAVID DIAZ VENDEDOR $966,525.00 $32,217.50 $4,027.19 $378,024.00 $74,000.00 $1,418,549.00FRANCISCO BLANCO ALMACENISTA $1,600,000.00 $53,333.33 $6,666.67 $1,600,000.00GERARDO QUIÑONES MENSAJERO $1,288,700.00 $42,956.67 $5,369.58 $74,000.00 $1,362,700.00
TOTAL $9,959,575.00 $331,985.83 $41,498.23 $9,270.83 $25,958.33 $51,916.67 $14,833.33 $2,286,024.00 $296,000.00 $12,643,578.17
EMPLEADO VR VENTA PORCENTAJE COMISION APORTES SEGURIDAD SOCIALALVARO AREVALO $23,850,000.00 8% $1,908,000.00 SALUD 8.5% $1,049,544.14DAVID DIAZ $4,725,300.00 8% $378,024.00 PENSION 12% $1,481,709.38
RIESGOS 0.52% $64,454.36
PROVISIONES PARA PRESTACIONES SOCIALES APORTES PARAFISCALESCESANTIAS 8.33% $1,053,210.06 SENA 2% $25,774.00INT. CESANTIAS 1% $126,435.78 ICBF 3% $38,661.00PRIMA 8.33% $1,053,210.06 CAJA COMP. 4% $51,548.00VACACIONES 4.17% $527,237.21
TOTAL DEVENGADO
VR HRS EXT.
DIURNASVR HRS EXT. NOCTURNAS
VR HRS EXT. DIURNAS
DOMINICALES
VR HRS EXT. DIURNAS FESTIVAS
AUX. TRANSP.
AGENCIA PINTURA MAS LTDA. LIQUIDACION DE NOMINA PERIODO DEL 1 AL 31 DE DICIEMBRE
DEDUCCIONES
NETO PAGADOPENSION SALUD RETEFUENTE COOPERATIVA LIBRANZA
$114,000.00 $114,000.00 $31,064.05 $142,500.00 $250,000.00 $651,564.05 $2,198,435.95$68,800.00 $68,800.00 $86,000.00 $100,000.00 $323,600.00 $1,396,400.00$39,679.17 $39,679.17 $44,500.00 $123,858.33 $942,120.83
$102,094.00 $102,094.00 $32,217.50 $236,405.50 $2,389,944.50$53,781.96 $53,781.96 $48,326.25 $155,890.17 $1,262,658.83$64,000.00 $64,000.00 $80,000.00 $200,000.00 $408,000.00 $1,192,000.00$51,548.00 $51,548.00 $64,435.00 $167,531.00 $1,195,169.00
$493,903.13 $493,903.13 $31,064.05 $497,978.75 $550,000.00 $2,066,849.05 $10,576,729.11
TOTAL DEDUCIDO