informatica.xlsx

9
DATOS DEL PERSONAL Y SUELDO CODIGO APELLIDOS Y NOMBRES DNI Nacionalidad 0095001 Curo Sifuentes, Carmen 41764585 Peruana S 1 0095002 Salvador Diaz, Jenny 12345678 Peruana N 0 0095003 Acosta Cardenas, Maria 09831675 Peruana S 2 0095004 Acevedo Carhuas, David 08788490 Peruana N 0 0095005 Tarazona Vega, Jhony 08788490 Peruana S 2 0095006 Vargas Machuca, Jose 08804598 Peruana S 1 0095007 Carpio Conde, Lesly 07045617 Peruana S 3 0095008 Infante Castro, Jorge 085964523 Peruana N 0 0095009 Prado Baca, Jair 01156325 Peruana S 1 0095010 Benites Paredes, Angelica 019856311 Peruana S 1 CONCEPTO MONTO REFRIGERIO 50 MOVILIDAD 5% C, VIDA 10% ONP 13% CTS 8.33% ESSALUD 9% EN AFP CODIGO DE AFP

Upload: girasol-kenta

Post on 04-Feb-2016

1 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: INFORMATICA.xlsx

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

Page 2: INFORMATICA.xlsx

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

Page 3: INFORMATICA.xlsx

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

Page 4: INFORMATICA.xlsx

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

Page 5: INFORMATICA.xlsx

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

Page 6: INFORMATICA.xlsx

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

Page 7: INFORMATICA.xlsx

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

Page 8: INFORMATICA.xlsx

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