Transcript
Page 1: PLANTILLA  RENTA EN EXCEL

DELIA PILAR AGUIRRE GARCIA

MES: JULIO

RESUMEN IMPUESTOB/V FAC CON IGV SIN IGV

VENTAS 2713.00 9785.80 12498.80 RENTA 249.98 249.98COMPRAS 8561.14 IGV 708.78

FALTA COMPRAS EN: 3937.66 TOTAL 958.75 249.98

Page 2: PLANTILLA  RENTA EN EXCEL

80 81 82 83 84 8555.50 72.00 66.80 50.00 1508.60 442.3019.50 19.50 37.50 23.00 300.0010.00 27.00 42.50 40.0045.50 18.50 25.00 38.50

6.00 18.00 38.00 39.0022.00 9.00 52.30 77.5097.00 17.00 110.00 58.0013.00 12.50 45.50 24.0033.00 30.00 49.50 46.0075.00 17.00 5.00 43.50

2.40 29.50 24.80 8.5021.90 35.00 17.50 1.00

5.90 96.50 9.80 98.0013.00 33.00 9.00 226.0027.50 56.00 5.00 82.5020.50 17.50 57.00 12.00

124.60 26.00 60.50 17.00101.20 18.30 13.50 4.50

36.80 65.00 8.00 36.00173.00 54.30 23.50 52.50

19.50 126.50 22.50 22.1029.50 17.00 8.50 30.00

6.50 61.00 14.00 22.508.00 48.00 49.90 34.00

44.00 17.00 76.50 31.0013.50 29.00 12.50 5.00

6.50 5.00 17.00 20.8042.00 12.00 8.00 805.0020.00 48.00 12.50 19.5017.00 37.50 66.50 25.0040.00 55.00 22.50 9.0013.50 92.20 12.00 51.3022.50 22.00 71.80 8.5024.00 35.00 17.00 17.0015.00 37.00 25.50 71.8028.80 100.00 5.00 5.00

8.50 6.50 67.50 76.5019.50 21.60 9.80 20.5031.80 8.50 40.00 55.50

9.00 21.00 35.00 16.00132.00 26.00 19.40 22.50

41.50 168.00 50.00 22.0030.50 25.50 17.00 35.00

6.30 10.50 192.0025.00 40.50 35.0038.00 9.00 19.50

8.50 48.50 42.0039.50 10.20

Page 3: PLANTILLA  RENTA EN EXCEL

9.001643.70 1690.90 1489.60 2710.70 1508.60 742.30 0.00 9785.80

Page 4: PLANTILLA  RENTA EN EXCEL

41 4215.00 3.50 473.0014.50 26.5035.00 19.0019.50 28.0010.50 ,47.00 18.0032.70 19.50

138.00 7.5048.20 10.0045.00 11.00

103.50 75.0043.30 24.80

5.50 28.0018.00 10.0015.00 8.00

3.00 5.0010.30 7.50

5.70 10.0014.00 12.0026.50 8.5011.00 25.00

7.50 9.8020.00 9.0015.00 13.0060.00 27.4036.80 9.0012.50 40.5018.00 9.5021.70 58.3054.00 5.0035.00 19.0016.80 9.8016.00 5.0010.60 8.5018.00 35.0031.90 35.0035.00 37.50

9.00 36.7011.00 39.00

5.50 20.0015.00 21.00

5.00 5.0035.00 41.0018.40 21.00

9.50 7.8020.00 41.0040.00 ,

4.00 20.0020.00 15.5010.00 11.50

Page 5: PLANTILLA  RENTA EN EXCEL

2240.00 473.00 0.00 0.00 2713.00

Page 6: PLANTILLA  RENTA EN EXCEL

COMPRAS

MES: OCTUBRE

KOKY0.00

0.00

ALUVASEDI 260.00 597.40 857.40

DELTA 671.65 277.25 771.00 1109.00 1066.90 32.40 160.00 4088.20

0.00

OTROS 100.00 104.00 204.00

BOLSAS 23.00 34.00 57.00

OTROS 323.96 426.20 645.98 380.00 38.40 469.00 790.00 36.00 245.00 3354.54

TOTAL COMPRAS 8561.14

Page 7: PLANTILLA  RENTA EN EXCEL

PROVEEDOR FAC Nº FECHA MONTO

1 FALSEKOKY 1TIO SAM 2UNIVERSO EMPRESARIAL 3EL SOL 4PACHECO 5CORONA 6GUIDO 7

Page 8: PLANTILLA  RENTA EN EXCEL

0.00


Top Related