excel tesis

8
BASE IMPONIBLE NETO COBRADO Enero 58,645.41 5,864.54 52,780.87 Febrero 43,127.23 4,312.72 38,814.51 Marzo 31,016.89 3,101.69 27,915.20 Abril 37,082.00 3,708.20 33,373.80 Mayo 33,468.66 3,346.87 30,121.79 Junio 48,237.88 4,823.79 43,414.09 Julio 57,186.97 5,718.70 51,468.27 Agosto 57,677.88 5,767.79 51,910.09 Septiembre 53,023.48 5,302.35 47,721.13 Octubre 47,844.55 4,784.46 43,060.10 Noviembre 50,374.79 5,037.48 45,337.31 Diciembre 57,543.22 5,754.32 51,788.90 TOTAL 575,228.95 57,522.89 517,706.05 PERIODO TRIBUTARIO DETRACCION APLICADA 10%

Upload: edgar-huaman-galarza

Post on 10-Nov-2015

219 views

Category:

Documents


0 download

DESCRIPTION

1

TRANSCRIPT

Hoja1PERIODO TRIBUTARIOBASE IMPONIBLEDETRACCION APLICADA 10% NETO COBRADOEnero 58,645.415,864.5452,780.87Febrero43,127.234,312.7238,814.51Marzo31,016.893,101.6927,915.20Abril37,082.003,708.2033,373.80Mayo 33,468.663,346.8730,121.79Junio48,237.884,823.7943,414.09Julio57,186.975,718.7051,468.27Agosto57,677.885,767.7951,910.09Septiembre53,023.485,302.3547,721.13Octubre47,844.554,784.4643,060.10Noviembre50,374.795,037.4845,337.31Diciembre57,543.225,754.3251,788.90TOTAL575,228.9557,522.89517,706.05

Hoja2PERIODO TRIBUTARIOBASE IMPONIBLEIGV PRECIO PERIODO TRIBUTARIOBASE IMPONIBLEIGV PRECIO 18%DE VENTA18%DE COMPRAEnero 49,699.508,945.9158,645.41Enero 40,528.907,295.2047,824.100.81547902934789.65Febrero36,548.506,578.7343,127.23Febrero25,541.764,597.5230,139.2825583.95Marzo26,285.504,731.3931,016.89Marzo18,700.243,366.0422,066.2818399.85Abril31,425.425,656.5837,082.00Abril23,487.954,227.8327,715.7821997.794Mayo 28,363.275,105.3933,468.66Mayo 21,676.453,901.7625,578.2119854.289Junio40,879.567,358.3248,237.88Junio29,044.865,228.0734,272.9328615.692Julio48,463.538,723.4457,186.97Julio40,251.927,245.3547,497.2733924.471Agosto48,879.568,798.3257,677.88Agosto35,122.536,322.0641,444.5934215.692Septiembre44,935.158,088.3353,023.48Septiembre32,206.285,797.1338,003.4131454.605Octubre40,546.237,298.3247,844.55Octubre31,423.525,656.2337,079.7528382.361Noviembre42,690.507,684.2950,374.79Noviembre35,344.656,362.0441,706.6929883.35Diciembre48,765.448,777.7857,543.22Diciembre39,669.707,140.5546,810.2534135.808TOTAL487,482.1687,746.79575,228.95TOTAL372,998.7667,139.78440,138.54

Hoja3MESESREMUNERACIN BRUTADESCUENTOS ONP (13%)REMUNERAC NETAESSALUD 9%Enero5,680.00738.44,941.60511.2750Febrero5,680.00738.44,941.60511.26000Marzo5,680.00738.44,941.60511.2Abril5,680.00738.44,941.60511.2Mayo5,680.00738.44,941.60511.2Junio5,680.00738.44,941.60511.2Julio5,680.00738.44,941.60511.2Agosto5,680.00738.44,941.60511.2Septiembre5,680.00738.44,941.60511.2Octubre5,680.00738.44,941.60511.2Noviembre5,680.00738.44,941.60511.2Diciembre5,680.00738.44,941.60511.2TOTAL13,338.001,733.9411,604.061,200.42

Hoja4PERIODO TRIBUTARIOIGVESSALUD 9%TOTAL IMPUESTODETRACCIONES APLICADASDETRACCIONES NO APLICADASAVENTASCOMPRASPOR PAGARPAGAREnero 8,945.917,295.201,650.71511.22,161.915,864.543,702.63Febrero6,578.734,597.521,981.21511.22,492.414,312.721,820.31Marzo4,731.393,366.041,365.35511.21,876.553,101.691,225.14Abril5,656.584,227.831,428.74511.21,939.943,708.201,768.25Mayo 5,105.393,901.761,203.63511.21,714.833,346.871,632.04Junio7,358.325,228.072,130.25511.22,641.454,823.792,182.34Julio8,723.447,245.351,478.09511.21,989.295,718.703,729.41Agosto8,798.326,322.062,476.27511.22,987.475,767.792,780.32Septiembre8,088.335,797.132,291.20511.22,802.405,302.352,499.95Octubre7,298.325,656.231,642.09511.22,153.294,784.462,631.17Noviembre7,684.296,362.041,322.25511.21,833.455,037.483,204.03Diciembre8,777.787,140.551,637.23511.22,148.435,754.323,605.89TOTAL87,746.7967,139.7820,607.016,134.4026,741.4157,522.8930,781.48