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

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

9.001643.70 1690.90 1489.60 2710.70 1508.60 742.30 0.00 9785.80

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

2240.00 473.00 0.00 0.00 2713.00

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

PROVEEDOR FAC Nº FECHA MONTO

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

0.00