Excel Tesis
-
Upload
edgar-huaman-galarza -
Category
Documents
-
view
222 -
download
0
description
Transcript of Excel Tesis
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