{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Catálogo","Balanza"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Catálogo","index":0,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[7,2,7,3],[8,2,8,3],[9,2,9,3]]}
[]
[]
[null,null,null,null,null,"Fecha","2016-03-04"]
[]
[]
[null,"1. Datos Generales"]
[]
[null,"RFC","TGM7101127J0"]
[null,"MES",1]
[null,"AÑO",2016]
[]
[null,"2. Cuentas"]
[]
[null,"Código Agrupador","Cuenta Contable","Descripción","Subcuenta Contable","Nivel ","Naturaleza"]
[null,101,200,"CAJA",null,1,"D"]
[null,102,202,"BANCOS",null,1,"D"]
[null,206,227,"ANTICIPOS",null,1,"D"]
[null,106,254,"DOCTOS. Y CTAS POR COBRAR DIV.",null,1,"D"]
[null,106,255,"CTAS.POR COBRAR INTERCOMPAÑIAS",null,1,"D"]
[null,188,260,"VALORES Y ACCIONES",null,1,"D"]
[null,169,269,"EQUIPO ANTICONTAMINANTE",null,1,"D"]
[null,153,272,"MAQUINARIA Y EQPO.DE TALLER",null,1,"D"]
[null,156,273,"EQUIPO DE COMPUTO",null,1,"D"]
[null,155,274,"MUEBLES Y ENSERES",null,1,"D"]
[null,154,275,"VEHICULOS EN SERVICIO",null,1,"D"]
[null,159,276,"INVERSION EN INMUEBLES",null,1,"D"]
[null,171,280,"DEPREC.EQPO.ANTICONTAMINANTE",null,1,"D"]
[null,171,282,"DEPREC.MAQUINARIA Y EQUIPO",null,1,"D"]
[null,171,283,"DEPREC.ACUM.EQUIPO DE COMPUTO",null,1,"D"]
[null,171,284,"DEPREC.ACUM.MUEBLES Y ENSERES",null,1,"D"]
[null,171,285,"DEPREC.ACUM.VEHICULOS SERVICIO",null,1,"D"]
[null,171,286,"AMORTIZAC.INVERSION INMUEBLES",null,1,"D"]
[null,173,290,"DEPOSITO SOBRE CONTRATO",null,1,"D"]
[null,173,291,"GASTOS PAGADOS POR ANTICIPADO",null,1,"D"]
[null,201,302,"CTAS.X PAGAR A PROVEEDORES",null,1,"A"]
[null,211,323,"IMPUESTOS Y RETENCIONES",null,1,"A"]
[null,213,324,"IMPTO.AL VALOR AGREGADO",null,1,"A"]
[null,216,325,"OTROS IMPTOS.POR PAGAR",null,1,"A"]
[null,259,327,"IMPUESTO SOBRE LA RENTA",null,1,"A"]
[null,210,328,"RVA GRATIFICACION EMPLEADOS",null,1,"A"]
[null,218,330,"ACREEDORES DIVERSOS",null,1,"A"]
[null,218,331,"OTROS GASTOS POR PAGAR",null,1,"A"]
[null,301,360,"CAPITAL SOCIAL",null,1,"A"]
[null,304,370,"UTILIDADES POR APLICAR",null,1,"A"]
[null,306,371,"RESERVA LEGAL",null,1,"A"]
[null,702,805,"OTROS INGRESOS VARIOS",null,1,"A"]
[null,702,808,"OTROS INTERESES GANADOS",null,1,"A"]
[null,701,857,"COMISIONES BANCARIAS",null,1,"D"]
[null,899,891,"IMPUESTO SOBRE LA RENTA",null,1,"D"]
[null,101.01,null,"CAJA CHICA",200001,2,"D"]
[null,101.01,null,"CAJA",200002,2,"D"]
[null,102.01,null,"BANCOMER",202001,2,"D"]
[null,102.01,null,"BANAMEX",202002,2,"D"]
[null,206.01,null,"ANTICIPO PAGOS",227001,2,"D"]
[null,106.01,null,"VARIOS",254001,2,"D"]
[null,106.01,null,"SINDICATO C.T.M.",254013,2,"D"]
[null,106.01,null,"ARAUJO RODRIGUEZ GUSTAVO",254145,2,"D"]
[null,106.01,null,"QUERETARO MOTORS SA DE CV",255001,2,"D"]
[null,106.01,null,"SERVICIOS Y TALLERES DE SAN JUAN",255005,2,"D"]
[null,106.01,null,"CHEVROLET INDUSTRIAL SA DE CV",255006,2,"D"]
[null,106.01,null,"SERVICIO DE TALLERES ZONA INDUSTRIAL",255007,2,"D"]
[null,106.01,null,"BUCAAR SA DE CV",255009,2,"D"]
[null,106.01,null,"PROMOTORA LEAL",255012,2,"D"]
[null,106.01,null,"RONDA AUTOMOTRIZ SA DE CV",255013,2,"D"]
[null,106.01,null,"ALECSA ITALIANOS DE QRO",255017,2,"D"]
[null,106.01,null,"RALLY CHAMPION SA DE CV",255018,2,"D"]
[null,188.03,null,"BANORTE CASA DE BOLSA",260001,2,"D"]
[null,188.03,null,"VECTOR CASA DE BOLSA S.A.",260002,2,"D"]
[null,169.01,null,"EQUIPO ANTICONTAMINANTE",269001,2,"D"]
[null,153.01,null,"MAQUINARIA Y EQPO.DE TALLER",272001,2,"D"]
[null,156.01,null,"EQUIPO DE COMPUTO",273001,2,"D"]
[null,155.01,null,"MUEBLES Y ENESERES",274001,2,"D"]
[null,154.01,null,"VEHICULOS EN SERVICIO",275001,2,"D"]
[null,159.01,null,"INVERSION EN INMUEBLES",276001,2,"D"]
[null,171.18,null,"DEPREC.EQPO.ANTICONTAMINANTE",280001,2,"D"]
[null,171.02,null,"DEPREC.MAQUINARIA Y EQPO.",282001,2,"D"]
[null,171.05,null,"DEPR. ACUM. EQUIPO DE COMPUTO",283001,2,"D"]
[null,171.04,null,"DEPR. ACUM. DE MUEBLES Y ENSER",284001,2,"D"]
[null,171.03,null,"DEPR. ACUM VEHICULOS EN SERVIC",285001,2,"D"]
[null,171.17,null,"AMORT INVERS. INMUEBLES",286001,2,"D"]
[null,173.01,null,"DEPOSITOS SOBRE CONTRATO",290001,2,"D"]
[null,173.01,null,"GASTOS PAGADOS POR ANTICIPADO",291001,2,"D"]
[null,173.01,null,"I.S.R. RETENIDO BANCARIO",291002,2,"D"]
[null,173.01,null,"RETENCION 2% IDE",291014,2,"D"]
[null,201.01,null,"DIVERSOS",302001,2,"A"]
[null,216.01,null,"IMPUESTO S PROD.DEL TRABAJO",323001,2,"A"]
[null,211.01,null,"SEGURO SOCIAL POR PAGAR",323002,2,"A"]
[null,211.02,null,"SAR",323003,2,"A"]
[null,211.03,null,"INFONAVIT",323004,2,"A"]
[null,210.01,null,"SUBSIDIO AL EMPLEO",323005,2,"A"]
[null,213.01,null,"PAGOS PROV IVA",324003,2,"A"]
[null,213.01,null,"IVA POR PAGAR",324005,2,"A"]
[null,213.01,null,"IVA FACTURADO",324006,2,"A"]
[null,213.01,null,"IVA POR ACREDITAR ",324007,2,"A"]
[null,213.01,null,"IVA ACREDITABLE",324008,2,"A"]
[null,216.03,null,"OTROS IMPUESTOS POR PAGAR",325001,2,"A"]
[null,216.03,null,"RETENCIONES IVA",325002,2,"A"]
[null,259.01,null,"IMPUESTO SOBRE LA RENTA",327001,2,"A"]
[null,210.07,null,"RVA GRATIFICACION EMPLEADOS",328001,2,"A"]
[null,218.01,null,"ACREEDORES DIVERSOS VARIOS",330001,2,"A"]
[null,218.01,null,"OTROS GASTOS X PAGAR",331001,2,"A"]
[null,218.01,null,"FONDO CAPACITACION",331003,2,"A"]
[null,301.01,null,"CAPITAL SOCIAL",360001,2,"A"]
[null,304.01,null,"UTILIDADES POR APLICAR",370001,2,"A"]
[null,304.01,null,"ACTUALIZ DE UTILIDAD X APLICAR",370002,2,"A"]
[null,306.01,null,"RESERVA LEGAL",371001,2,"A"]
[null,702.01,null,"OTROS INGRESOS SIN IVA",805001,2,"A"]
[null,702.01,null,"OTROS INGRESOS CON IVA",805002,2,"A"]
[null,702.01,null,"OTROS INTERESES GANADOS",808001,2,"A"]
[null,701.01,null,"COMISIONES PAGADAS",857002,2,"D"]
[null,899.01,null,"IMPUESTO SOBRE LA RENTA",891001,2,"D"]

{"sheet":"Balanza","index":1,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[7,2,7,3],[8,2,8,3],[9,2,9,3]]}
[]
[]
[null,null,null,null,null,null,"Fecha","2016-03-04"]
[]
[]
[null,"1. Datos Generales"]
[]
[null,"RFC","TGM7101127J0",null,null,"Tipo Envío","N"]
[null,"Mes",1,null,null,"Fecha Modificación"]
[null,"Año",2016]
[]
[null,"2. Cuentas"]
[]
[null,"Cuenta Contable","Saldo Inicial","Debe","Haber","Saldo Final"]
[null,200,0,0,0,0]
[null,202,28887.7,26000.13,348.13,54539.7]
[null,227,-62595.86,0,0,-62595.86]
[null,254,1920.98,0,0,1920.98]
[null,255,-1990928.24,0,26000,-2016928.24]
[null,260,51305.27,0,0,51305.27]
[null,269,277948.87,0,0,277948.87]
[null,272,1445039.42,0,0,1445039.42]
[null,273,311925.15000000002,0,0,311925.15000000002]
[null,274,76861.69,0,0,76861.69]
[null,275,407557.21,0,0,407557.21]
[null,276,1925323.84,0,0,1925323.84]
[null,280,-277948.87,0,0,-277948.87]
[null,282,-1421969.67,0,0,-1421969.67]
[null,283,-311925.33,0,0,-311925.33]
[null,284,-76862.38,0,0,-76862.38]
[null,285,-407557.42,0,0,-407557.42]
[null,286,-1180164.06,0,0,-1180164.06]
[null,290,51630.080000000002,0,0,51630.080000000002]
[null,291,42795.14,0.13,0,42795.27]
[null,302,-28863.58,0,0,-28863.58]
[null,323,26342.93,0,0,26342.93]
[null,324,45254.18,48,0,45302.18]
[null,325,1368,0,0,1368]
[null,327,-0.06,0,0,-0.06]
[null,328,178975.86,0,0,178975.86]
[null,330,-159547.45000000001,0,0,-159547.45000000001]
[null,331,-1957864.87,0,0,-1957864.87]
[null,360,-990200,0,0,-990200]
[null,370,3993447.73,0,0,3993447.73]
[null,371,-156.26,0,0,-156.26]
[null,805,0,0,0,0]
[null,808,0,0,0.13,-0.13]
[null,857,0,300,0,300]
[null,891,0,0,0,0]