TALLER_ModeloNomina_RRHH RESUELTO.xls

Post on 04-Nov-2015

42 views 0 download

Transcript of TALLER_ModeloNomina_RRHH RESUELTO.xls

NOMINANOMBRE DE LA EMPRESANITPerodo: Del 01 al 30 de Enero de 2014NOMINA N 000000NOMBRECEDULASUELDODIASCEFIRMA TRABAJADORBASICO MESCOMISIONESAUXILIO TRANSPORH.ETOTAL DEVENGADOSEPS 4%PESNSION 4%COOPERATIVAOTROSTOTAL DEDUCCIONESVALENTINA HOYOS A2,500,000302,500,000500,00071,250130,2083,201,458125,208125,2080.00.0250,4172,951,041SANDRA MILENA AGUIRRE L.1,500,000201,000,0000.047,50076,5621,124,06243,06243,0620.00.086,1251,037,937CARLOS ALBERTO SANCHEZ M.900,00030900,000100,00071,25060,0001,131,25042,40042,4000.00.084,8001,046,450MARIA SUAREZ C.620,00030620,0000.071,25043,271734,52126,53126,5310.00.053,062681,4590.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0TOTALES5,520,0005,020,000600,000261,250310,0416,191,291237,202237,2020.00.0474,4035,716,888ElaboroRevisoAutorizoCESANTIASINTERESESPRIMAVACACIONESEPSPENSIONRIESGOSCAJAIBCFSENAVALENTINA HOYOS266,7882,668266,788104,1670375,62516,340125,20800SANDRA MILENA AGUIRRE L.62,44862462,44827,7780129,1875,62043,06200CARLOS ALBERTO SANCHEZ M.94,27194394,27137,5000127,2005,53342,40000MARIA SUAREZ C.61,21061261,21025,833079,5923,46226,53100000000000000000000000000000000TOTAL484,7174,8471,039,442195,2780711,60530,955237,20200ELABORADO POR:REVISADO POR:CONTABILIZADO POR:

Hoja1SUMATORIAHORA5 HEOD3 HEFD15000005000062507812.539062.5125003750076562.5000000CARLOS0008 horas3 hefd0009000003000037504687.53750075002250060000MARIA7 HEOD4 HEFD62000020666.66666666672583.33333333333229.166666666722604.16666666675166.666666666720666.666666666743270.8333333333VALENTINA13020.833333333326041.6666666667104166.666666667130,20883333.333333333310416.66666666672,60413,02120833.3333333333