plantilla renta en excel
DESCRIPTION
RENTA - IGV BASICO PERO AYUDA A DETERMINAR DE MANERA APROXIMADA EL PAGO DE IMPUESTO MENSUALTRANSCRIPT
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