informatica.xlsx
TRANSCRIPT
PLANILLA DE REMUNERACIONES ENERO 2013
DATOS DEL PERSONAL Y SUELDO
CODIGO APELLIDOS Y NOMBRES DNI Nacionalidad OCUPACION
0095001 Curo Sifuentes, Carmen 41764585 Peruana S 1 Administrador0095002 Salvador Diaz, Jenny 12345678 Peruana N 0 Secretaria0095003 Acosta Cardenas, Maria 09831675 Peruana S 2 Analista0095004 Acevedo Carhuas, David 08788490 Peruana N 0 Obrero0095005 Tarazona Vega, Jhony 08788490 Peruana S 2 Programador0095006 Vargas Machuca, Jose 08804598 Peruana S 1 Contador0095007 Carpio Conde, Lesly 07045617 Peruana S 3 Secretaria0095008 Infante Castro, Jorge 085964523 Peruana N 0 Contador0095009 Prado Baca, Jair 01156325 Peruana S 1 Gerente0095010 Benites Paredes, Angelica 019856311 Peruana S 1 Operador
CONCEPTO MONTOREFRIGERIO 50MOVILIDAD 5%C, VIDA 10%ONP 13%CTS 8.33%ESSALUD 9%
EN AFP
CODIGO DE AFP
PLANILLA DE REMUNERACIONES ENERO 2013
DATOS DEL PERSONAL Y SUELDO INGRESOS DEL TRABAJADOR SUELDO Y BONIFICACIONES
CATEGORIA SUELDO BASICOREFRIGERIO MOVILIDAD
A S/. 1,500.00 S/. 300.00 S/. 50.00 S/. 75.00 S/. 150.00 S/. 2,075.00C S/. 700.00 S/. 84.00 S/. 50.00 S/. 35.00 S/. 70.00 S/. 939.00B S/. 1,200.00 S/. 180.00 S/. 50.00 S/. 60.00 S/. 120.00 S/. 1,610.00D S/. 400.00 S/. 32.00 S/. 50.00 S/. 20.00 S/. 40.00 S/. 542.00C S/. 700.00 S/. 84.00 S/. 50.00 S/. 35.00 S/. 70.00 S/. 939.00B S/. 1,200.00 S/. 180.00 S/. 50.00 S/. 60.00 S/. 120.00 S/. 1,610.00C S/. 700.00 S/. 84.00 S/. 50.00 S/. 35.00 S/. 70.00 S/. 939.00B S/. 1,200.00 S/. 180.00 S/. 50.00 S/. 60.00 S/. 120.00 S/. 1,610.00A S/. 1,500.00 S/. 300.00 S/. 50.00 S/. 75.00 S/. 150.00 S/. 2,075.00C S/. 700.00 S/. 84.00 S/. 50.00 S/. 35.00 S/. 70.00 S/. 939.00
CATEGORIA SUELDO BONID. X CAT COD. AFP
A 1500 20% 0B 1200 15% 1C 700 12% 2D 400 8% 3
BONIFICACION POR CATEGORIA
BONIF. COSTO VIDA TOTAL
INGRESOS
PLANILLA DE REMUNERACIONES ENERO 2013SUELDO ANUAL 19600SUELDO MENSUAL PROM 1400
APORTACIONES APORTES DEL EMPLEADOR
ONPAPORTE AFP CTS 8,33% ESSALUD 9%
13%
S/. 0.00 S/. 249.00 S/. 311.25 S/. 560.25 S/. 1,155.15 S/. 172.85 S/. 186.75S/. 122.07 S/. 0.00 S/. 0.00 S/. 122.07 S/. 654.20 S/. 78.22 S/. 84.51
S/. 0.00 S/. 207.21 S/. 241.50 S/. 448.71 S/. 882.28 S/. 134.11 S/. 144.90S/. 70.46 S/. 0.00 S/. 0.00 S/. 70.46 S/. 377.61 S/. 45.15 S/. 48.78
S/. 0.00 S/. 120.85 S/. 0.00 S/. 120.85 S/. 655.42 S/. 78.22 S/. 84.51S/. 0.00 S/. 193.20 S/. 241.50 S/. 434.70 S/. 896.29 S/. 134.11 S/. 144.90S/. 0.00 S/. 122.07 S/. 0.00 S/. 122.07 S/. 654.20 S/. 78.22 S/. 84.51
S/. 209.30 S/. 0.00 S/. 241.50 S/. 450.80 S/. 880.19 S/. 134.11 S/. 144.90S/. 0.00 S/. 249.00 S/. 311.25 S/. 560.25 S/. 1,155.15 S/. 172.85 S/. 186.75S/. 0.00 S/. 112.68 S/. 0.00 S/. 112.68 S/. 663.59 S/. 78.22 S/. 84.51
%
0%12%
12.87%13%
TOTAL APORTACIONES
SUELGO A PAGAR
DESCUENTO 5 CATEGORIA
KHOLER INVERSIONES SACRUC 20479105104
Jr. Bernardo Alcedo 217 - Lince
BOLETA DE PAGO DEL TRABAJADOR
Art. 18 /D.S. Nº 001-98-TR , D.S. Nº017-2001-TR
DATOS DEL TRABAJADORCodigo 0095002 Cargo u Ocup.:Nombre Salvador Diaz, Jenny Sis. Pensiòn:Documento de identidad 12345678 NacionalidadCategoria C REMUNERACIONES ENERO -2012
REMUNERACIONES DESCUENTOSConcepto S/. Concepto Trabajador
Sueldo Mensual S/. 700.00 Seguro salud ESSALUDHoras Extras S/. 0.00 Sist. Nac. Pens. ONP 122.07Bonif. Costo de Vida S/. 70.00 AFP Aporte Obligatorio 0Refrigerio S/. 50.00 AFP Comis. VariableBonif. Por categoria S/. 84.00 AFP Prima de seguroMovilidad S/. 35.00 DESCUENTO CAT 0Vacaciones S/. 0.00 Renta 5ta. Categoria
InasistenciaCTSTOTAL DESCUENTOS 122.07
TOTAL INGRESOS S/. 939.00 NETO RECIBIDO
Lince, 31 de Enero del 2012
Empleador Trabajador
KHOLER INVERSIONES SACRUC 20479105104
Jr. Bernardo Alcedo 217 - Lince
BOLETA DE PAGO DEL TRABAJADOR
Art. 18 /D.S. Nº 001-98-TR , D.S. Nº017-2001-TR
SecretariaONPPeruana
REMUNERACIONES ENERO -2012
DESCUENTOSEmpleador
84.51
78.2187162.7287
S/. 654.20
Trabajador
CODIGO X01PRODUCTO PANETON DONOFRIO 1KGPRECIO S/. 15.00
CLIENTE RUC CLIENTE Nº RECIBO CANTCONDICIONES
INTERES%
1/1/2008 BETA 24585178 95001 20 S/. 300.00 10%1/2/2008 SIGMA 24585179 95002 50 S/. 750.00 5%1/3/2008 NORKYS 24585180 95003 100 S/. 1,500.00 10%1/4/2008 TELEFONICA 24585181 95004 5000 S/. 75,000.00 0%1/5/2008 LUZ DEL SUR 24585182 95005 2000 S/. 30,000.00 10%1/6/2008 TIPTOP 24585183 95006 50 S/. 750.00 0%1/7/2008 LUZ DEL NORTE 24585184 95007 50 S/. 750.00 0%1/8/2008 TOPY TOP 24585185 95008 100 S/. 1,500.00 10%1/9/2008 MUN LIMA 24585186 95009 500 S/. 7,500.00 10%
1/10/2008 MUN CALLAO 24585187 95010 500 S/. 7,500.00 0%1/11/2008 BANCO WIESSE 24585188 95011 1000 S/. 15,000.00 0%1/12/2008 SOUTHERN PERU 24585189 95012 1500 S/. 22,500.00 5%1/13/2008 ORION 24585190 95013 20 S/. 300.00 0%1/14/2008 BANCO LATINO 24585191 95014 300 S/. 4,500.00 0%1/15/2008 CESAR VALLEJO 24585192 95015 20 S/. 300.00 0%1/16/2008 NISSAN 24585193 95016 100 S/. 1,500.00 10%1/17/2008 ORTIZ DE ZEVALLOS 24585194 95017 30 S/. 450.00 0%1/18/2008 TOYOTA 24585195 95018 40 S/. 600.00 0%1/19/2008 IBM 24585196 95019 100 S/. 1,500.00 10%1/20/2008 DISKIT 24585197 95020 50 S/. 750.00 10%1/21/2008 PERU MERCANTIL 24585198 95021 25 S/. 375.00 10%1/22/2008 PERU SOFT 24585199 95022 50 S/. 750.00 10%1/23/2008 MICRO CHIP 24585200 95023 25 S/. 375.00 5%1/24/2008 COSTA VERDE 24585201 95024 50 S/. 750.00 5%1/25/2008 OMEGA 24585202 95025 50 S/. 750.00 5%1/26/2008 CARSA 24585203 95026 100 S/. 1,500.00 0%
TIPO DE OPERACIÓN DCTO INTERESC CONTADO 5% 0%CR CREDITO 0% 10%CL CONTADO Y CREDITO 0% 5%IGV 18%
FECHA DE VENTA
PRECIO MERCADERIA
D´Onofrio - Registro de Venta
CONDICIONESIGV PRECIO VENTA
FORMA DE PAGOINTERES DESCUENTOS
CONTADOMONTO % MONTO
S/. 30.00 0% S/. 0.00 S/. 330.00 S/. 59.40 S/. 389.40 CR S/.0S/. 37.50 0% S/. 0.00 S/. 787.50 S/. 141.75 S/. 929.25 CL S/. 464.63
S/. 150.00 0% S/. 0.00 S/. 1,650.00 S/. 297.00 S/. 1,947.00 CR S/.0S/. 0.00 5% S/. 3,750.00 S/. 71,250.00 S/. 12,825.00 S/. 84,075.00 C S/. 84,075.00
S/. 3,000.00 0% S/. 0.00 S/. 33,000.00 S/. 5,940.00 S/. 38,940.00 CR S/.0S/. 0.00 5% S/. 37.50 S/. 712.50 S/. 128.25 S/. 840.75 C S/. 840.75S/. 0.00 5% S/. 37.50 S/. 712.50 S/. 128.25 S/. 840.75 C S/. 840.75
S/. 150.00 0% S/. 0.00 S/. 1,650.00 S/. 297.00 S/. 1,947.00 CR S/.0S/. 750.00 0% S/. 0.00 S/. 8,250.00 S/. 1,485.00 S/. 9,735.00 CR S/.0
S/. 0.00 5% S/. 375.00 S/. 7,125.00 S/. 1,282.50 S/. 8,407.50 C S/. 8,407.50S/. 0.00 5% S/. 750.00 S/. 14,250.00 S/. 2,565.00 S/. 16,815.00 C S/. 16,815.00
S/. 1,125.00 0% S/. 0.00 S/. 23,625.00 S/. 4,252.50 S/. 27,877.50 CL S/. 13,938.75S/. 0.00 5% S/. 15.00 S/. 285.00 S/. 51.30 S/. 336.30 C S/. 336.30S/. 0.00 5% S/. 225.00 S/. 4,275.00 S/. 769.50 S/. 5,044.50 C S/. 5,044.50S/. 0.00 5% S/. 15.00 S/. 285.00 S/. 51.30 S/. 336.30 C S/. 336.30
S/. 150.00 0% S/. 0.00 S/. 1,650.00 S/. 297.00 S/. 1,947.00 CR S/.0S/. 0.00 5% S/. 22.50 S/. 427.50 S/. 76.95 S/. 504.45 C S/. 504.45S/. 0.00 5% S/. 30.00 S/. 570.00 S/. 102.60 S/. 672.60 C S/. 672.60
S/. 150.00 0% S/. 0.00 S/. 1,650.00 S/. 297.00 S/. 1,947.00 CR S/.0S/. 75.00 0% S/. 0.00 S/. 825.00 S/. 148.50 S/. 973.50 CR S/.0S/. 37.50 0% S/. 0.00 S/. 412.50 S/. 74.25 S/. 486.75 CR S/.0S/. 75.00 0% S/. 0.00 S/. 825.00 S/. 148.50 S/. 973.50 CR S/.0S/. 18.75 0% S/. 0.00 S/. 393.75 S/. 70.88 S/. 464.63 CL S/. 232.31S/. 37.50 0% S/. 0.00 S/. 787.50 S/. 141.75 S/. 929.25 CL S/. 464.63S/. 37.50 0% S/. 0.00 S/. 787.50 S/. 141.75 S/. 929.25 CL S/. 464.63
S/. 0.00 5% S/. 75.00 S/. 1,425.00 S/. 256.50 S/. 1,681.50 C S/. 1,681.50
VALOR DE VENTA
TIPO OPERACIÓN
D´Onofrio - Registro de Venta
FORMA DE PAGOOBSV.CREDITO
FACTURA CANT LETRASS/. 389.40 3 muy bienS/. 464.63 2 muy bien
S/. 1,947.00 3 Buena VentaS/. 84,075.00 0 Buena VentaS/. 38,940.00 3 Buena Venta
S/. 840.75 0 muy bienS/. 840.75 0 muy bien
S/. 1,947.00 3 Buena VentaS/. 9,735.00 3 Buena VentaS/. 8,407.50 0 Buena Venta
S/. 16,815.00 0 Buena VentaS/. 13,938.75 2 Buena Venta
S/. 336.30 0 muy bienS/. 5,044.50 0 Buena Venta
S/. 336.30 0 muy bienS/. 1,947.00 3 Buena Venta
S/. 504.45 0 muy bienS/. 672.60 0 muy bien
S/. 1,947.00 2 Buena VentaS/. 973.50 2 muy bienS/. 486.75 2 muy bienS/. 973.50 4 muy bienS/. 232.31 5 muy bienS/. 464.63 6 muy bienS/. 464.63 2 muy bien
S/. 1,681.50 0 Buena Venta