ejemplo de una nomina

2
Datos E N2 D Devengado Deducciones N Cedula Nombre Apellidos Sueldo Básico Aux Trans H.E Comisiones T. Devengad Salud Pensión 1 101010 Stella Garcia $980,000 15 $490,000 $31,800 $168,438 $0 $690,238 $26,338 $26,338 2 202020 German Garzon $750,000 30 $750,000 $63,600 $0 $345,000 $1,158,600 $43,800 $43,800 3 303030 Javier Castillo 3,450,000 30 $3,450,000 $0 $0 $0 $3,450,000 $138,000 $138,000 4 404040 Paola Gutierrez $535,600 20 $357,067 $42,400 $135,016 $0 $534,483 $19,683 $19,683 5 505050 Katherine Ramirez $645,000 30 $645,000 $63,600 $124,297 $0 $832,897 $30,772 $30,772 6 606060 Hernando Chamorro $750,000 29 $725,000 $61,480 $0 $450,000 $1,236,480 $47,000 $47,000 7 707070 Rafael arrasquilla $750,000 30 $750,000 $63,600 $0 $289,000 $1,102,600 $41,560 $41,560 8 808080 Richard Espitia $850,000 19 $538,333 $40,280 $109,792 $0 $688,405 $25,925 $25,925 9 909090 Cristian Gonzalez $654,000 30 $654,000 $63,600 $95,375 $0 $812,975 $29,975 $29,975 10 1101010 Franco Gomez $850,000 30 $850,000 $63,600 $0 $0 $913,600 $34,000 $34,000 11 4041102 Jair Martinez $654,000 30 $654,000 $63,600 $95,375 $0 $812,975 $29,975 $29,975 12 516146514 Jose Jimenez $750,000 29 $725,000 $61,480 $0 $450,000 $1,236,480 $47,000 $47,000 13 461516522 sandra Visbal $654,000 30 $654,000 $63,600 $95,375 $0 $812,975 $29,975 $29,975 14 1001444241 Andres Ramirez $750,000 30 $750,000 $63,600 $0 $289,000 $1,102,600 $41,560 $41,560 15 12232244 Sofia Medina $750,000 30 $750,000 $63,600 $0 $289,000 $1,102,600 $41,560 $41,560 16 36242220 Patricia Miranda $750,000 30 $750,000 $63,600 $0 $125,400 $939,000 $41,560 $41,560 17 144222155 Isabel Garcia $750,000 30 $750,000 $63,600 $0 $95,250 $908,850 $41,560 $41,560 18 1143134122 Luis Gonzalez $2,300,000 30 $2,300,000 $0 $0 $0 $2,300,000 $105,800 $105,800 Totales $17,572,600 502 $16,542,400 $937,040 $823,668 $2,332,650 ### $816,043 $816,043

description

nomina de 15 empleados con horas extras

Transcript of ejemplo de una nomina

Page 1: ejemplo de una nomina

Datos Empleado N2 D Devengado Deducciones NetoN Cedula Nombre Apellidos Sueldo Básico Aux Trans H.E Comisiones T. DevengadoSalud Pensión Total Deducciones

1 101010 Stella Garcia $980,000 15 $490,000 $31,800 $168,438 $0 $690,238 $26,338 $26,338 $52,676 $637,5622 202020 German Garzon $750,000 30 $750,000 $63,600 $0 $345,000 $1,158,600 $43,800 $43,800 $87,600 $1,071,0003 303030 Javier Castillo 3,450,000 30 $3,450,000 $0 $0 $0 $3,450,000 $138,000 $138,000 $276,000 $3,174,0004 404040 Paola Gutierrez $535,600 20 $357,067 $42,400 $135,016 $0 $534,483 $19,683 $19,683 $39,366 $495,1175 505050 Katherine Ramirez $645,000 30 $645,000 $63,600 $124,297 $0 $832,897 $30,772 $30,772 $61,544 $771,3536 606060 Hernando Chamorro $750,000 29 $725,000 $61,480 $0 $450,000 $1,236,480 $47,000 $47,000 $94,000 $1,142,4807 707070 Rafael Carrasquilla $750,000 30 $750,000 $63,600 $0 $289,000 $1,102,600 $41,560 $41,560 $83,120 $1,019,4808 808080 Richard Espitia $850,000 19 $538,333 $40,280 $109,792 $0 $688,405 $25,925 $25,925 $51,850 $636,5559 909090 Cristian Gonzalez $654,000 30 $654,000 $63,600 $95,375 $0 $812,975 $29,975 $29,975 $59,950 $753,025

10 1101010 Franco Gomez $850,000 30 $850,000 $63,600 $0 $0 $913,600 $34,000 $34,000 $68,000 $845,60011 4041102 Jair Martinez $654,000 30 $654,000 $63,600 $95,375 $0 $812,975 $29,975 $29,975 $59,950 $753,02512 516146514 Jose Jimenez $750,000 29 $725,000 $61,480 $0 $450,000 $1,236,480 $47,000 $47,000 $94,000 $1,142,48013 461516522 sandra Visbal $654,000 30 $654,000 $63,600 $95,375 $0 $812,975 $29,975 $29,975 $59,950 $753,02514 1001444241 Andres Ramirez $750,000 30 $750,000 $63,600 $0 $289,000 $1,102,600 $41,560 $41,560 $83,120 $1,019,48015 12232244 Sofia Medina $750,000 30 $750,000 $63,600 $0 $289,000 $1,102,600 $41,560 $41,560 $83,120 $1,019,48016 36242220 Patricia Miranda $750,000 30 $750,000 $63,600 $0 $125,400 $939,000 $41,560 $41,560 $83,120 $855,88017 144222155 Isabel Garcia $750,000 30 $750,000 $63,600 $0 $95,250 $908,850 $41,560 $41,560 $83,120 $825,73018 1143134122 Luis Gonzalez $2,300,000 30 $2,300,000 $0 $0 $0 $2,300,000 $105,800 $105,800 $211,600 $2,088,400

Totales $17,572,600 502 $16,542,400 $937,040 $823,668 $2,332,650 $20,635,758 $816,043 $816,043 $1,420,486 $19,003,672