{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["MENU","D","I","E","ND","NC","DIARIO","MAYOR","BALANCE","GENERAL","RESULTADO","Hoja1"],"not_rendered":{"images":21,"macros":1,"defined_names":48},"read":"whole","date_system":"1900"}

{"sheet":"MENU","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[0,2,0,13],[1,1,1,3],[1,5,1,7],[1,10,1,12],[15,6,16,6]]}
[null,null,"NOMBRE DE LA EMPRESA X"]
[null,"CONTABILIZAR",{"$nulls":3},"REPORTES",{"$nulls":4},"CONFIGURACIONES"]
{"$rows_empty":13}
[{"$nulls":4},"SELECIONE EL CODIGO DE CTA",null,"1.1.1.1.002"]
[{"$nulls":4},"PARA PRESENTAR EL LIBRO MAYOR"]
[]
[null,"NOTA:"]
[]
[null,"ESTE ES LA VERSION BASICA Y NO TIENE TODAS LAS FUNCIONALIDADES…",{"$nulls":5},"SI QUIERES SABER COMO FUE CREADO ESTE SISTEMA Y TAMBIEN QUIERES"]
[null,"SI ESTAS INTERESADO EN LA VERSION COMPLETA VISITA LA PAGINA",{"$nulls":5},"APRENDER A CREAR PLANTILLAS AUTOMATICAS VISITA LA PAGINA:"]
[1,"http://aplicaexcelcontable.com/Alumnos/tu-plantilla-contable-2",{"$nulls":4},2,"http://aplicaexcelcontable.com/Alumnos/aplica-excel-contable-21"]

{"sheet":"D","index":1,"n_rows":61,"n_cols":31,"rows_kept":61,"merged":[[0,2,0,6],[0,26,0,30],[1,7,1,11],[2,26,2,30],[5,2,7,6],[5,26,8,30],[20,2,23,3]]}
[null,null,"ASIENTO DE DIARIO",{"$nulls":23},{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[null,null,"ASI-",{"$f":"MAX(DIARIO!B2:B1000)+1","v":3},{"$nulls":3},"PLAN DE CUENTAS"]
[null,null,"Nº ASIENTO:",2,"FECHA:","2012-02-01",{"$nulls":20},{"$f":"C1","v":"ASIENTO DE DIARIO"}]
[{"$nulls":29},"ASI Nº:",{"$f":"D3","v":2}]
[null,null,"CONCEPTO:",{"$nulls":23},"CONCEPTO:",null,null,"FECHA:",{"$f":"F3","v":"2012-02-01"}]
[null,null,"PRUEBA",{"$nulls":23},{"$f":"C6","v":"PRUEBA"}]
[]
[]
[null,null,"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[null,null,"1.1.2.1.002",{"$f":"IF(C10<>\"\",VLOOKUP(C10,PLAN,2,0),\"\")","v":"CUENTAS POR COBRAR EMPLEADOS"},500,null,"ALEX CARRILLO",{"$nulls":19},"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[null,null,"1.1.1.1.001","CAJA GENERAL",null,500,"ALEX CARRILLO"]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},"HAZ CLIC EN EL BONTON\n NUEVA LINEA"]
[null,null,"NOTAS:","TOTAL",{"$f":"SUM(E10:E19)","v":{"v":500,"d":"500.00 "}},{"$f":"SUM(F10:F19)","v":{"v":500,"d":"500.00 "}},{"$f":"IF(F21<>0,\"OJO ASIENTO NO CUADRA\",\"\")","v":""}]
[{"$nulls":5},{"$f":"E20-F20","v":0}]
{"$rows_empty":34}
[{"$nulls":27},"SUMAN",{"$f":"SUM(AC11:AC55)","v":0},{"$f":"SUM(AD11:AD55)","v":0}]
[]
[]
[]
[]
[{"$nulls":26},"               ELABORADO POR",null,"RIVISADO POR",null,"AUTORIZADO POR"]

{"sheet":"I","index":2,"n_rows":61,"n_cols":31,"rows_kept":61,"merged":[[0,2,0,6],[0,26,0,30],[1,7,1,11],[2,26,2,30],[5,2,7,6],[5,26,8,30],[20,2,23,3]]}
[null,null,"COMPROBANTE DE INGRESO",{"$nulls":23},{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[null,null,"CIN-",{"$f":"MAX(DIARIO!C2:C1000)+1","v":2},{"$nulls":3},"PLAN DE CUENTAS"]
[null,null,"INGRESO Nº:",null,"FECHA:","2013-09-22",{"$nulls":20},{"$f":"C1","v":"COMPROBANTE DE INGRESO"}]
[{"$nulls":29},"ASI Nº:",{"$f":"D3","v":0}]
[null,null,"CONCEPTO:",{"$nulls":23},"CONCEPTO:",null,null,"FECHA:",{"$f":"F3","v":"2013-09-22"}]
[{"$nulls":26},{"$f":"C6","v":0}]
[]
[]
[null,null,"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[{"$nulls":3},{"$f":"IF(C10<>\"\",VLOOKUP(C10,PLAN,2,0),\"\")","v":""},{"$nulls":22},"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},"HAZ CLIC EN EL BONTON\n NUEVA LINEA"]
[null,null,"NOTAS:","TOTAL",{"$f":"SUM(E10:E19)","v":0},{"$f":"SUM(F10:F19)","v":0},{"$f":"IF(F21<>0,\"OJO ASIENTO NO CUADRA\",\"\")","v":""}]
[null,null,"XXXSSX",null,null,{"$f":"E20-F20","v":0}]
{"$rows_empty":34}
[{"$nulls":27},"SUMAN",{"$f":"SUM(AC11:AC55)","v":0},{"$f":"SUM(AD11:AD55)","v":0}]
[]
[]
[]
[]
[{"$nulls":26},"               ELABORADO POR",null,"RIVISADO POR",null,"AUTORIZADO POR"]

{"sheet":"E","index":3,"n_rows":61,"n_cols":31,"rows_kept":61,"merged":[[0,2,0,6],[0,26,0,30],[1,7,1,11],[2,26,2,30],[3,5,3,6],[4,5,4,6],[5,2,7,6],[5,26,8,30],[20,2,23,3]]}
[null,null,"COMPROBANTE DE EGRESO",{"$nulls":23},{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[null,null,"CEG-",{"$f":"MAX(DIARIO!D2:D1000)+1","v":2},{"$nulls":3},"PLAN DE CUENTAS"]
[null,null,"EGRESO Nº:",null,"FECHA:",{"$nulls":21},{"$f":"C1","v":"COMPROBANTE DE EGRESO"}]
[null,null,"CHEQUE Nº:",null,"BENIFICIARIO",{"$nulls":24},"ASI Nº:",{"$f":"D3","v":0}]
[null,null,"CONCEPTO:",null,"CUENTA Nº:",{"$nulls":21},"CONCEPTO:",null,null,"FECHA:",{"$f":"F3","v":"00:00:00"}]
[{"$nulls":26},{"$f":"C6","v":0}]
[]
[]
[null,null,"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[{"$nulls":3},{"$f":"IF(C10<>\"\",VLOOKUP(C10,PLAN,2,0),\"\")","v":""},{"$nulls":22},"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},"HAZ CLIC EN EL BONTON\n NUEVA LINEA"]
[null,null,"NOTAS:","TOTAL",{"$f":"SUM(E10:E19)","v":0},{"$f":"SUM(F10:F19)","v":0},{"$f":"IF(F21<>0,\"OJO ASIENTO NO CUADRA\",\"\")","v":""}]
[{"$nulls":5},{"$f":"E20-F20","v":0}]
{"$rows_empty":34}
[{"$nulls":27},"SUMAN",{"$f":"SUM(AC11:AC55)","v":0},{"$f":"SUM(AD11:AD55)","v":0}]
[]
[]
[]
[]
[{"$nulls":26},"               ELABORADO POR",null,"RIVISADO POR",null,"AUTORIZADO POR"]

{"sheet":"ND","index":4,"n_rows":61,"n_cols":31,"rows_kept":61,"merged":[[0,2,0,6],[0,26,0,30],[1,7,1,11],[2,26,2,30],[5,2,7,6],[5,26,8,30],[20,2,23,3]]}
[null,null,"NOTA DE DEBITO",{"$nulls":23},{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[null,null,"N_D",{"$f":"MAX(DIARIO!E2:E1000)+1","v":1},{"$nulls":3},"PLAN DE CUENTAS"]
[null,null,"NOTA DEBIT. Nº:",null,"FECHA:",{"$nulls":21},{"$f":"C1","v":"NOTA DE DEBITO"}]
[{"$nulls":29},"ASI Nº:",{"$f":"D3","v":0}]
[null,null,"CONCEPTO:",{"$nulls":23},"CONCEPTO:",null,null,"FECHA:",{"$f":"F3","v":"00:00:00"}]
[{"$nulls":26},{"$f":"C6","v":0}]
[]
[]
[null,null,"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[{"$nulls":3},{"$f":"IF(C10<>\"\",VLOOKUP(C10,PLAN,2,0),\"\")","v":""},{"$nulls":22},"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},"HAZ CLIC EN EL BONTON\n NUEVA LINEA"]
[null,null,"NOTAS:","TOTAL",{"$f":"SUM(E10:E19)","v":0},{"$f":"SUM(F10:F19)","v":0},{"$f":"IF(F21<>0,\"OJO ASIENTO NO CUADRA\",\"\")","v":""}]
[{"$nulls":5},{"$f":"E20-F20","v":0}]
{"$rows_empty":34}
[{"$nulls":27},"SUMAN",{"$f":"SUM(AC11:AC55)","v":0},{"$f":"SUM(AD11:AD55)","v":0}]
[]
[]
[]
[]
[{"$nulls":26},"               ELABORADO POR",null,"RIVISADO POR",null,"AUTORIZADO POR"]

{"sheet":"NC","index":5,"n_rows":61,"n_cols":31,"rows_kept":61,"merged":[[0,2,0,6],[0,26,0,30],[1,7,1,11],[2,26,2,30],[5,2,7,6],[5,26,8,30],[20,2,23,3]]}
[null,null,"NOTA DE CREDITO",{"$nulls":23},{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[null,null,"N_C",{"$f":"MAX(DIARIO!F2:F1000)+1","v":1},{"$nulls":3},"PLAN DE CUENTAS"]
[null,null,"NOTA CREDTI. Nº:",null,"FECHA:",{"$nulls":21},{"$f":"C1","v":"NOTA DE CREDITO"}]
[{"$nulls":29},"ASI Nº:",{"$f":"D3","v":0}]
[null,null,"CONCEPTO:",{"$nulls":23},"CONCEPTO:",null,null,"FECHA:",{"$f":"F3","v":"00:00:00"}]
[{"$nulls":26},{"$f":"C6","v":0}]
[]
[]
[null,null,"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[{"$nulls":3},{"$f":"IF(C10<>\"\",VLOOKUP(C10,PLAN,2,0),\"\")","v":""},{"$nulls":22},"CODIGO","DESCRIPCION","DEBE","HABER","DETALLES"]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},"HAZ CLIC EN EL BONTON\n NUEVA LINEA"]
[null,null,"NOTAS:","TOTAL",{"$f":"SUM(E10:E19)","v":0},{"$f":"SUM(F10:F19)","v":0},{"$f":"IF(F21<>0,\"OJO ASIENTO NO CUADRA\",\"\")","v":""}]
[{"$nulls":5},{"$f":"E20-F20","v":0}]
{"$rows_empty":34}
[{"$nulls":27},"SUMAN",{"$f":"SUM(AC11:AC55)","v":0},{"$f":"SUM(AD11:AD55)","v":0}]
[]
[]
[]
[]
[{"$nulls":26},"               ELABORADO POR",null,"RIVISADO POR",null,"AUTORIZADO POR"]

{"sheet":"DIARIO","index":6,"n_rows":9,"n_cols":12,"rows_kept":9}
["FECHA","ASI Nº","ING. Nº","EGR Nº","ND Nº","NC Nº","CODIGO","CUENTAS","DESCRIPCION","DEBE","HABER","DETALLES"]
["2013-09-22",null,1,{"$nulls":3},"1.1.1.1.001","CAJA GENERAL","APERTURA",{"v":15000,"d":"15,000.00 "},null,"CARLOS WILSON"]
["2013-09-22",null,1,{"$nulls":3},"3.1.1.1.001","CAPITAL NEGOCIO X","APERTURA",null,{"v":15000,"d":"15,000.00 "},"CARLOS WILSON"]
["2012-02-01",1,{"$nulls":4},"1.1.1.2.001","EMPRESA X  CTA.CTE.#10012705215805","DEPOSITO",{"v":15000,"d":"15,000.00 "}]
["2012-02-01",1,{"$nulls":4},"1.1.1.1.001","CAJA GENERAL","DEPOSITO",null,{"v":15000,"d":"15,000.00 "}]
["2013-02-20",null,null,1,null,null,"1.3.2.1.001","INMUEBLES ENTREGADOS EN GARANTIA","PAGO POR 9 QQ DE ARROZ A 800 C/U.",{"v":7200,"d":"7,200.00 "}]
["2013-02-20",null,null,1,null,null,"1.1.1.2.001","EMPRESA X  CTA.CTE.#10012705215805","PAGO POR 9 QQ DE ARROZ A 800 C/U.",null,{"v":7200,"d":"7,200.00 "}]
["2012-02-01",2,{"$nulls":4},"1.1.2.1.002","CUENTAS POR COBRAR EMPLEADOS","PRUEBA",{"v":500,"d":"500.00 "},null,"ALEX CARRILLO"]
["2012-02-01",2,{"$nulls":4},"1.1.1.1.001","CAJA GENERAL","PRUEBA",null,{"v":500,"d":"500.00 "},"ALEX CARRILLO"]

{"sheet":"MAYOR","index":7,"n_rows":206,"n_cols":11,"rows_kept":206,"hidden":true,"merged":[[1,1,1,5],[3,0,3,10],[5,0,5,10]]}
[]
["FECHA:",{"$f":"TODAY()","v":"2014-03-13"}]
[]
[{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[]
["MAYOR GENERAL"]
[{"$nulls":6},"CUENTA:",{"$f":"IF(MENU!G16<>\"\",VLOOKUP(MENU!G16,PLAN,1,0),\"\")","v":"1.1.1.1.002"},{"$f":"IF(MENU!G16<>\"\",VLOOKUP(MENU!G16,PLAN,2,0),\"\")","v":"CAJA CHICA"}]
[]
["FECHA","ASI Nº","ING Nº","EGR Nº ","ND Nº","NC Nº","CODIGO","DESCRIPCION","DEBE","HABER","SALDOS"]
[{"$nulls":10},{"$f":"I10-J10","v":0}]
[{"$nulls":10},{"$f":"IF((I11-J11)<>0,(I11-J11+K10),\"\")","v":""}]
[{"$nulls":10},{"$f":"IF((I12-J12)<>0,(I12-J12+K11),\"\")","v":""}]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},{"$f":"IF((I76-J76)<>0,(I76-J76+K75),\"\")","v":""}]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},{"$f":"IF((I140-J140)<>0,(I140-J140+K139),\"\")","v":""}]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},""]
[{"$nulls":10},{"$f":"IF((I204-J204)<>0,(I204-J204+K203),\"\")","v":""}]
[{"$nulls":10},""]
[{"$nulls":10},""]

{"sheet":"BALANCE","index":8,"n_rows":159,"n_cols":22,"rows_kept":159,"merged":[[0,0,0,5],[2,0,2,5],[6,2,6,3],[6,4,6,5]]}
[{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[]
["BALANCE DE COMPROBACION"]
[]
["FECHA:",{"$f":"TODAY()","v":"2014-03-13"}]
[]
[null,null,"MOVIMIENTOS",null,"SALDOS"]
["CODIGO","CUENTAS","DEBITOS","CREDITOS","DEUDOR","ACREEDOR"]
[]
["1.","ACTIVO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},{"$f":"IF(C10>D10,C10-D10,\"\")","v":""},{"$f":"IF(C10<D10,D10-C10,\"\")","v":""},{"$nulls":15},{"$f":"A10&\"                    \"&B10","v":"1.                    ACTIVO"}]
["1.1.","ACTIVOS CIRCULANTES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},{"$f":"IF(C11>D11,C11-D11,\"\")","v":""},{"$f":"IF(C11<D11,D11-C11,\"\")","v":""},{"$nulls":15},{"$f":"A11&\"                \"&B11","v":"1.1.                ACTIVOS CIRCULANTES"}]
["1.1.1.","ACTIVOS DISPONIBLES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A12&\"            \"&B12","v":"1.1.1.            ACTIVOS DISPONIBLES"}]
["1.1.1.1.","CAJA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A13&\"        \"&B13","v":"1.1.1.1.        CAJA"}]
["1.1.1.1.001","CAJA GENERAL",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":{"v":15000,"d":"15,000.00 "}},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":{"v":15500,"d":"15,500.00 "}},"",{"v":500,"d":"500.00 "},{"$nulls":15},{"$f":"A14&\"  \"&B14","v":"1.1.1.1.001  CAJA GENERAL"}]
["1.1.1.1.002","CAJA CHICA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A15&\"  \"&B15","v":"1.1.1.1.002  CAJA CHICA"}]
["1.1.1.2.","BANCOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A16&\"         \"&B16","v":"1.1.1.2.         BANCOS"}]
["1.1.1.2.001","EMPRESA X  CTA.CTE.#10012705215805",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":{"v":15000,"d":"15,000.00 "}},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":{"v":7200,"d":"7,200.00 "}},{"v":7800,"d":"7,800.00 "},"",{"$nulls":15},{"$f":"A17&\"  \"&B17","v":"1.1.1.2.001  EMPRESA X  CTA.CTE.#10012705215805"}]
["1.1.2.","ACTIVOS EXIGIBLES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A18&\"             \"&B18","v":"1.1.2.             ACTIVOS EXIGIBLES"}]
["1.1.2.1.","CUENTAS POR COBRAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A19&\"         \"&B19","v":"1.1.2.1.         CUENTAS POR COBRAR"}]
["1.1.2.1.001","CUENTAS POR COBRAR CLIENTES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A20&\"  \"&B20","v":"1.1.2.1.001  CUENTAS POR COBRAR CLIENTES"}]
["1.1.2.1.002","CUENTAS POR COBRAR EMPLEADOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":{"v":500,"d":"500.00 "}},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},{"v":500,"d":"500.00 "},"",{"$nulls":15},{"$f":"A21&\"  \"&B21","v":"1.1.2.1.002  CUENTAS POR COBRAR EMPLEADOS"}]
["1.1.2.1.003","CUENTAS POR COBRAR OTROS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},"1.1.2.1.003  CUENTAS POR COBRAR OTROS"]
["1.1.2.1.004","ANTICIPO A JUSTIFICAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},"1.1.2.1.004  ANTICIPO A JUSTIFICAR"]
["1.1.3.","ACTIVOS REALIZABLES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A24&\"             \"&B24","v":"1.1.3.             ACTIVOS REALIZABLES"}]
["1.1.3.1.","INVENTARIO DE MATERIALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A25&\"         \"&B25","v":"1.1.3.1.         INVENTARIO DE MATERIALES"}]
["1.1.3.1.001","INV. DE ACCESORIOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A26&\"  \"&B26","v":"1.1.3.1.001  INV. DE ACCESORIOS"}]
["1.1.3.1.002","INV. DE PAPERIA Y UTILES  DE OFICINA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A27&\"  \"&B27","v":"1.1.3.1.002  INV. DE PAPERIA Y UTILES  DE OFICINA"}]
["1.1.3.1.003","INV. DE MATERIALES Y LIMPIEZA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},"1.1.3.1.003  INV. DE MATERIALES Y LIMPIEZA"]
["1.1.3.2.","INVENTARIO DE MERCADERIAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A29&\"         \"&B29","v":"1.1.3.2.         INVENTARIO DE MERCADERIAS"}]
["1.1.3.2.001","GRANOS BASICOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A30&\"  \"&B30","v":"1.1.3.2.001  GRANOS BASICOS"}]
["1.1.4.","OTROS ACTIVOS CIRCULANTES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A31&\"             \"&B31","v":"1.1.4.             OTROS ACTIVOS CIRCULANTES"}]
["1.1.4.1.","IMPUESTOS ANTICIPADOS Y RETENIDOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A32&\"         \"&B32","v":"1.1.4.1.         IMPUESTOS ANTICIPADOS Y RETENIDOS"}]
["1.1.4.1.001","IVA CREDITO TRIBUNAL",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A33&\"  \"&B33","v":"1.1.4.1.001  IVA CREDITO TRIBUNAL"}]
["1.1.4.1.002","ANTICIPO IMPUESTO A LA RENTA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A34&\"  \"&B34","v":"1.1.4.1.002  ANTICIPO IMPUESTO A LA RENTA"}]
["1.1.4.1.003","ANTICIPO RETENCION EN LA FUENTE",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},"1.1.4.1.003  ANTICIPO RETENCION EN LA FUENTE"]
["1.2.","ACTIVOS FIJOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A36&\"                 \"&B36","v":"1.2.                 ACTIVOS FIJOS"}]
["1.2.1.","ACTIVOS TANGIBLES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A37&\"             \"&B37","v":"1.2.1.             ACTIVOS TANGIBLES"}]
["1.2.1.1.","ACTIVOS DEPRECIABLES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A38&\"         \"&B38","v":"1.2.1.1.         ACTIVOS DEPRECIABLES"}]
["1.2.1.1.001","INMUEBLES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A39&\"  \"&B39","v":"1.2.1.1.001  INMUEBLES"}]
["1.2.1.1.002","INSTALACIONES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A40&\"  \"&B40","v":"1.2.1.1.002  INSTALACIONES"}]
["1.2.1.2.","ACTIVOS NO DEPRECIABLES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A41&\"         \"&B41","v":"1.2.1.2.         ACTIVOS NO DEPRECIABLES"}]
["1.2.1.2.001","TERRENO # 1",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A42&\"  \"&B42","v":"1.2.1.2.001  TERRENO # 1"}]
["1.2.1.3.","DEPRECIACION ACUMULDA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A43&\"         \"&B43","v":"1.2.1.3.         DEPRECIACION ACUMULDA"}]
["1.2.1.3.001","INMUEBLES DEP",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A44&\"  \"&B44","v":"1.2.1.3.001  INMUEBLES DEP"}]
["1.2.1.3.002","INSTALACIONES DEP",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A45&\"  \"&B45","v":"1.2.1.3.002  INSTALACIONES DEP"}]
["1.2.2.","ACTIVOS INTANGIBLES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A46&\"             \"&B46","v":"1.2.2.             ACTIVOS INTANGIBLES"}]
["1.2.2.1.","MARCAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A47&\"         \"&B47","v":"1.2.2.1.         MARCAS"}]
["1.2.2.1.001","SERVICIO DE EMPRESA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A48&\"  \"&B48","v":"1.2.2.1.001  SERVICIO DE EMPRESA"}]
["1.2.2.1.002","MARCA DE PRODUCTO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A49&\"  \"&B49","v":"1.2.2.1.002  MARCA DE PRODUCTO"}]
["1.2.2.2.","SOFTWARE",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A50&\"         \"&B50","v":"1.2.2.2.         SOFTWARE"}]
["1.2.2.2.001","SOFTWARE CONTABLE",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A51&\"  \"&B51","v":"1.2.2.2.001  SOFTWARE CONTABLE"}]
["1.3.","OTROS ACTIVOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A52&\"                 \"&B52","v":"1.3.                 OTROS ACTIVOS"}]
["1.3.1.","ACTIVOS DIFERIDOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A53&\"             \"&B53","v":"1.3.1.             ACTIVOS DIFERIDOS"}]
["1.3.1.1.","GASTOS DE CONSTITUCION",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A54&\"         \"&B54","v":"1.3.1.1.         GASTOS DE CONSTITUCION"}]
["1.3.1.1.001","GASTOS DE CONSTITUCION",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A55&\"  \"&B55","v":"1.3.1.1.001  GASTOS DE CONSTITUCION"}]
["1.3.1.2.","GASTOS DE CONSTRUCCION",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A56&\"         \"&B56","v":"1.3.1.2.         GASTOS DE CONSTRUCCION"}]
["1.3.2.","OTROS ACTIVOS VARIOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A57&\"             \"&B57","v":"1.3.2.             OTROS ACTIVOS VARIOS"}]
["1.3.2.1.","DEPOSITOD ENTREGADO EN GARANTIA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A58&\"         \"&B58","v":"1.3.2.1.         DEPOSITOD ENTREGADO EN GARANTIA"}]
["1.3.2.1.001","INMUEBLES ENTREGADOS EN GARANTIA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":{"v":7200,"d":"7,200.00 "}},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},{"v":7200,"d":"7,200.00 "},"",{"$nulls":15},{"$f":"A59&\"  \"&B59","v":"1.3.2.1.001  INMUEBLES ENTREGADOS EN GARANTIA"}]
["2.","PASIVO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A60&\"                     \"&B60","v":"2.                     PASIVO"}]
["2.1.","PASIVOS A CORTO PLAZO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A61&\"                 \"&B61","v":"2.1.                 PASIVOS A CORTO PLAZO"}]
["2.1.1.","CUENTAS POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A62&\"             \"&B62","v":"2.1.1.             CUENTAS POR PAGAR"}]
["2.1.1.1.","PROVEEDORES NACIONALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A63&\"         \"&B63","v":"2.1.1.1.         PROVEEDORES NACIONALES"}]
["2.1.1.1.001","INDUSTRIALES CXP",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A64&\"  \"&B64","v":"2.1.1.1.001  INDUSTRIALES CXP"}]
["2.1.1.2.","PROVEEDORES LOCALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A65&\"         \"&B65","v":"2.1.1.2.         PROVEEDORES LOCALES"}]
["2.1.1.2.001","PROVEEDOR X CXP",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A66&\"  \"&B66","v":"2.1.1.2.001  PROVEEDOR X CXP"}]
["2.1.1.3.","SERVICIOS POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A67&\"         \"&B67","v":"2.1.1.3.         SERVICIOS POR PAGAR"}]
["2.1.1.3.001","SERV. ENERGIA  CXP",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A68&\"  \"&B68","v":"2.1.1.3.001  SERV. ENERGIA  CXP"}]
["2.1.1.3.002","TELEFONO E INTERNET CXP",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A69&\"  \"&B69","v":"2.1.1.3.002  TELEFONO E INTERNET CXP"}]
["2.1.1.4.","OTRAS CUENTAS POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A70&\"         \"&B70","v":"2.1.1.4.         OTRAS CUENTAS POR PAGAR"}]
["2.1.1.4.001","CUENTAS VARIAS POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A71&\"  \"&B71","v":"2.1.1.4.001  CUENTAS VARIAS POR PAGAR"}]
["2.1.2.","NOMINA POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A72&\"             \"&B72","v":"2.1.2.             NOMINA POR PAGAR"}]
["2.1.2.1.","REMUNERACIONES POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A73&\"         \"&B73","v":"2.1.2.1.         REMUNERACIONES POR PAGAR"}]
["2.1.2.1.001","SUELDOS POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A74&\"  \"&B74","v":"2.1.2.1.001  SUELDOS POR PAGAR"}]
["2.1.2.1.002","DESCUENTOS POR ATRASOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},{"$f":"IF(C75>D75,C75-D75,\"\")","v":""},{"$f":"IF(C75<D75,D75-C75,\"\")","v":""},{"$nulls":15},{"$f":"A75&\"  \"&B75","v":"2.1.2.1.002  DESCUENTOS POR ATRASOS"}]
["2.1.2.1.003","LIQUIDACIONES POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A76&\"  \"&B76","v":"2.1.2.1.003  LIQUIDACIONES POR PAGAR"}]
["2.1.2.2.","INSS E INATEC POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A77&\"         \"&B77","v":"2.1.2.2.         INSS E INATEC POR PAGAR"}]
["2.1.2.2.001","APORTES PERSONAL Y PATRONAL CXP",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A78&\"  \"&B78","v":"2.1.2.2.001  APORTES PERSONAL Y PATRONAL CXP"}]
["2.1.2.2.002","INATEC POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A79&\"  \"&B79","v":"2.1.2.2.002  INATEC POR PAGAR"}]
["2.1.2.3.","PROVICIONES POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A80&\"         \"&B80","v":"2.1.2.3.         PROVICIONES POR PAGAR"}]
["2.1.2.3.001","DECIMO TERCER MES POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A81&\"  \"&B81","v":"2.1.2.3.001  DECIMO TERCER MES POR PAGAR"}]
["2.1.2.3.002","VACACIONES POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A82&\"  \"&B82","v":"2.1.2.3.002  VACACIONES POR PAGAR"}]
["2.1.2.3.003","INDEMNIZACIONES POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A83&\"  \"&B83","v":"2.1.2.3.003  INDEMNIZACIONES POR PAGAR"}]
["2.1.3.","OBLIGACIONES FISCALES POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A84&\"             \"&B84","v":"2.1.3.             OBLIGACIONES FISCALES POR PAGAR"}]
["2.1.3.1.","IMPUESTOS POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A85&\"         \"&B85","v":"2.1.3.1.         IMPUESTOS POR PAGAR"}]
["2.1.3.1.001","IMPUESTO A LA RENTA POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A86&\"  \"&B86","v":"2.1.3.1.001  IMPUESTO A LA RENTA POR PAGAR"}]
["2.1.3.1.002","IVA POR PAGAR (15%)",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A87&\"  \"&B87","v":"2.1.3.1.002  IVA POR PAGAR (15%)"}]
["2.1.3.2.","RETENCIONES FUENTE POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A88&\"         \"&B88","v":"2.1.3.2.         RETENCIONES FUENTE POR PAGAR"}]
["2.1.3.2.001","2% RET.FTE. SERVICIOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A89&\"  \"&B89","v":"2.1.3.2.001  2% RET.FTE. SERVICIOS"}]
["2.1.3.2.002","5% RET.FTE. SERVICIO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A90&\"  \"&B90","v":"2.1.3.2.002  5% RET.FTE. SERVICIO"}]
["2.1.3.2.003","2% RET. FTE DE COMPRAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A91&\"  \"&B91","v":"2.1.3.2.003  2% RET. FTE DE COMPRAS"}]
["2.1.3.2.004","10% RET.FTE.HONORARIOS PROFESIONALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A92&\"  \"&B92","v":"2.1.3.2.004  10% RET.FTE.HONORARIOS PROFESIONALES"}]
["2.1.3.3.","RETENCIONES IVA POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A93&\"         \"&B93","v":"2.1.3.3.         RETENCIONES IVA POR PAGAR"}]
["2.1.3.3.001","15% RET. IVA VENTAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A94&\"  \"&B94","v":"2.1.3.3.001  15% RET. IVA VENTAS"}]
["2.1.3.4.","OTROS IMPUESTOS POR PAGAR",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A95&\"         \"&B95","v":"2.1.3.4.         OTROS IMPUESTOS POR PAGAR"}]
["2.1.3.5.","RETENCIONES SOBRE SALARIO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A96&\"         \"&B96","v":"2.1.3.5.         RETENCIONES SOBRE SALARIO"}]
["2.1.3.5.001","RETENCIONES SOBRE SALARIO DGI  XP",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A97&\"  \"&B97","v":"2.1.3.5.001  RETENCIONES SOBRE SALARIO DGI  XP"}]
["2.2.","PASIVOS A LARGO PLAZO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A98&\"                 \"&B98","v":"2.2.                 PASIVOS A LARGO PLAZO"}]
["2.2.1.","PRESTAMOS A LARGO PLAZO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A99&\"             \"&B99","v":"2.2.1.             PRESTAMOS A LARGO PLAZO"}]
["2.2.1.1.","PRESTMOS SOCIOS LARGO PLAZO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A100&\"         \"&B100","v":"2.2.1.1.         PRESTMOS SOCIOS LARGO PLAZO"}]
["2.2.1.1.001","R.G. PMO LARGO PLAZO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A101&\"  \"&B101","v":"2.2.1.1.001  R.G. PMO LARGO PLAZO"}]
["3.","PATRIMONIO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A102&\"                     \"&B102","v":"3.                     PATRIMONIO"}]
["3.1.","PATRIMONIO NEGOCIO X",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A103&\"                 \"&B103","v":"3.1.                 PATRIMONIO NEGOCIO X"}]
["3.1.1.","CAPITAL SOCIAL",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A104&\"             \"&B104","v":"3.1.1.             CAPITAL SOCIAL"}]
["3.1.1.1.","CAPITAL PAGADO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A105&\"         \"&B105","v":"3.1.1.1.         CAPITAL PAGADO"}]
["3.1.1.1.001","CAPITAL NEGOCIO X",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":{"v":15000,"d":"15,000.00 "}},"",{"v":15000,"d":"15,000.00 "},{"$nulls":15},{"$f":"A106&\"  \"&B106","v":"3.1.1.1.001  CAPITAL NEGOCIO X"}]
["3.1.2.","RESERVAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A107&\"             \"&B107","v":"3.1.2.             RESERVAS"}]
["3.1.2.1.","RESERVAS PATRIMONIALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A108&\"         \"&B108","v":"3.1.2.1.         RESERVAS PATRIMONIALES"}]
["3.1.2.1.001","RESERVA FACULTATIVA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A109&\"  \"&B109","v":"3.1.2.1.001  RESERVA FACULTATIVA"}]
["3.1.2.1.002","RESERVA DE CAPITAL",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A110&\"  \"&B110","v":"3.1.2.1.002  RESERVA DE CAPITAL"}]
["3.1.2.1.003","RESERVA LEGAL",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A111&\"  \"&B111","v":"3.1.2.1.003  RESERVA LEGAL"}]
["3.1.3.","RESULTADOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A112&\"             \"&B112","v":"3.1.3.             RESULTADOS"}]
["3.1.3.1.","RESULTADOS ANTERIORES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A113&\"         \"&B113","v":"3.1.3.1.         RESULTADOS ANTERIORES"}]
["3.1.3.1.001","UTILIDADES ANTERIORES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A114&\"  \"&B114","v":"3.1.3.1.001  UTILIDADES ANTERIORES"}]
["3.1.3.1.002","PERDIDAS ANTERIORES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A115&\"  \"&B115","v":"3.1.3.1.002  PERDIDAS ANTERIORES"}]
["3.1.3.1.003","AMORTIZACION PERDIDAS ANTERIORES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A116&\"  \"&B116","v":"3.1.3.1.003  AMORTIZACION PERDIDAS ANTERIORES"}]
["3.1.3.2.","RESULTADOS DEL EJERCICIO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A117&\"         \"&B117","v":"3.1.3.2.         RESULTADOS DEL EJERCICIO"}]
["3.1.3.2.001","UTILIDADES DE EJERCICIO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A118&\"  \"&B118","v":"3.1.3.2.001  UTILIDADES DE EJERCICIO"}]
["4.","INGRESOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A119&\"                     \"&B119","v":"4.                     INGRESOS"}]
["4.1.","INGRESOS OPERACIONALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A120&\"                 \"&B120","v":"4.1.                 INGRESOS OPERACIONALES"}]
["4.1.1.","VENTAS GENERALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A121&\"             \"&B121","v":"4.1.1.             VENTAS GENERALES"}]
["4.1.1.1.","VENTAS NETAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A122&\"         \"&B122","v":"4.1.1.1.         VENTAS NETAS"}]
["4.1.1.1.001","VENTAS DE GRANOS BASICOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A123&\"  \"&B123","v":"4.1.1.1.001  VENTAS DE GRANOS BASICOS"}]
["5.","COSTOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A124&\"                     \"&B124","v":"5.                     COSTOS"}]
["5.1.","COSTOS OPERACIONALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A125&\"                 \"&B125","v":"5.1.                 COSTOS OPERACIONALES"}]
["5.1.1.","COSTO DE VENTA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A126&\"             \"&B126","v":"5.1.1.             COSTO DE VENTA"}]
["5.1.1.1.","COSTOS DE VENTAS GRANOS BASICO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A127&\"         \"&B127","v":"5.1.1.1.         COSTOS DE VENTAS GRANOS BASICO"}]
["5.1.1.1.001","COSTO GRANOS BASICO",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A128&\"  \"&B128","v":"5.1.1.1.001  COSTO GRANOS BASICO"}]
["6.","GASTOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A129&\"                     \"&B129","v":"6.                     GASTOS"}]
["6.1.","GASTOS OPERACIONALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A130&\"                 \"&B130","v":"6.1.                 GASTOS OPERACIONALES"}]
["6.1.1.","GASTOS DE ADMINISTRACION",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A131&\"             \"&B131","v":"6.1.1.             GASTOS DE ADMINISTRACION"}]
["6.1.1.1.","SUELDOS Y SIMILARES ADMON",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A132&\"         \"&B132","v":"6.1.1.1.         SUELDOS Y SIMILARES ADMON"}]
["6.1.1.1.001","SUELDOS Y SALARIOS ADMON",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A133&\"  \"&B133","v":"6.1.1.1.001  SUELDOS Y SALARIOS ADMON"}]
["6.1.1.1.002","COMPONENTE SALARIAL ADM",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A134&\"  \"&B134","v":"6.1.1.1.002  COMPONENTE SALARIAL ADM"}]
["6.1.1.1.003","HORA EXTRA ADM",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A135&\"  \"&B135","v":"6.1.1.1.003  HORA EXTRA ADM"}]
["6.1.2.","GASTOS DE VENTAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A136&\"             \"&B136","v":"6.1.2.             GASTOS DE VENTAS"}]
["6.1.2.1.","SUELDOS Y SIMILARES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A137&\"         \"&B137","v":"6.1.2.1.         SUELDOS Y SIMILARES"}]
["6.1.2.1.001","SUELDOS Y SALARIOS DE VENTAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A138&\"  \"&B138","v":"6.1.2.1.001  SUELDOS Y SALARIOS DE VENTAS"}]
["6.1.2.1.002","COMPROBANTE SALARIAL DE VTA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},{"$f":"IF(C139>D139,C139-D139,\"\")","v":""},{"$f":"IF(C139<D139,D139-C139,\"\")","v":""},{"$nulls":15},{"$f":"A139&\"  \"&B139","v":"6.1.2.1.002  COMPROBANTE SALARIAL DE VTA"}]
["6.1.2.1.003","HORAS EXTRAS VTAS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A140&\"  \"&B140","v":"6.1.2.1.003  HORAS EXTRAS VTAS"}]
["6.1.3.","GASTOS FINANCIEROS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A141&\"             \"&B141","v":"6.1.3.             GASTOS FINANCIEROS"}]
["6.1.3.1.","GASTOS BANCARIOS",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A142&\"         \"&B142","v":"6.1.3.1.         GASTOS BANCARIOS"}]
["6.1.3.1.001","GTOS BANC.X CHEQUERA",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A143&\"  \"&B143","v":"6.1.3.1.001  GTOS BANC.X CHEQUERA"}]
["6.1.3.1.002","GAST.X SERV.BANC.",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A144&\"  \"&B144","v":"6.1.3.1.002  GAST.X SERV.BANC."}]
["6.1.3.1.003","GAST. X DEVALUACION DE LA MONEDA FIN.",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A145&\"  \"&B145","v":"6.1.3.1.003  GAST. X DEVALUACION DE LA MONEDA FIN."}]
["6.1.4.","GASTOS GENERALES",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A146&\"             \"&B146","v":"6.1.4.             GASTOS GENERALES"}]
["6.1.4.1.","MANTENIMIENTO DE MUEBLES Y ENSERES GEN",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A147&\"         \"&B147","v":"6.1.4.1.         MANTENIMIENTO DE MUEBLES Y ENSERES GEN"}]
["6.1.4.1.001","MANT. DE MUEBLES GEN",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A148&\"  \"&B148","v":"6.1.4.1.001  MANT. DE MUEBLES GEN"}]
["6.1.4.1.002","MANT. DE ENSERES GEN",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A149&\"  \"&B149","v":"6.1.4.1.002  MANT. DE ENSERES GEN"}]
["6.1.4.2.","CONS. DE ENEGIA ELECTRICA GEN",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A150&\"         \"&B150","v":"6.1.4.2.         CONS. DE ENEGIA ELECTRICA GEN"}]
["6.1.4.2.01","CONS.ENEGIA ENEL GEN",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A151&\"  \"&B151","v":"6.1.4.2.01  CONS.ENEGIA ENEL GEN"}]
["6.1.4.3.","MOVILIZACIONE LOCALE GEN",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A152&\"         \"&B152","v":"6.1.4.3.         MOVILIZACIONE LOCALE GEN"}]
["6.1.4.3.003","VIATICOS GEN",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A153&\"  \"&B153","v":"6.1.4.3.003  VIATICOS GEN"}]
["6.1.4.3.004","PASAJES AEREOS GEN.",{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"","",{"$nulls":15},{"$f":"A154&\"  \"&B154","v":"6.1.4.3.004  PASAJES AEREOS GEN."}]
[null,null,{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"",""]
[null,null,{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"",""]
[null,null,{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*DEBE)","v":0},{"$f":"SUM(IF(CodigoD=CodigoB,1,0)*HABER)","v":0},"",""]
[null,"SUMAS TOTALES",{"$f":"SUM(C10:C157)","v":{"v":37700,"d":"37,700.00 "}},{"$f":"SUM(D10:D157)","v":{"v":37700,"d":"37,700.00 "}},{"v":15500,"d":"15,500.00 "},{"v":15500,"d":"15,500.00 "}]
[{"$nulls":3},{"$f":"C158-D158","v":0}]

{"sheet":"GENERAL","index":9,"n_rows":119,"n_cols":4,"rows_kept":119,"hidden":true,"merged":[[0,0,0,3],[2,0,2,3]]}
[{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[]
["BALANCE GENERAL"]
[]
["AL",{"$f":"TODAY()","v":"2014-03-13"}]
[]
["CODIGO","CUENTAS","DEBE","HABER"]
[{"$f":"BALANCE!A10","v":"1."},{"$f":"BALANCE!B10","v":"ACTIVO"}]
[{"$f":"BALANCE!A11","v":"1.1."},{"$f":"BALANCE!B11","v":"ACTIVOS CIRCULANTES"}]
[{"$f":"BALANCE!A12","v":"1.1.1."},{"$f":"BALANCE!B12","v":"ACTIVOS DISPONIBLES"}]
[{"$f":"BALANCE!A13","v":"1.1.1.1."},{"$f":"BALANCE!B13","v":"CAJA"}]
[{"$f":"BALANCE!A14","v":"1.1.1.1.001"},{"$f":"BALANCE!B14","v":"CAJA GENERAL"}]
[{"$f":"BALANCE!A15","v":"1.1.1.1.002"},{"$f":"BALANCE!B15","v":"CAJA CHICA"}]
[{"$f":"BALANCE!A16","v":"1.1.1.2."},{"$f":"BALANCE!B16","v":"BANCOS"}]
[{"$f":"BALANCE!A17","v":"1.1.1.2.001"},{"$f":"BALANCE!B17","v":"EMPRESA X  CTA.CTE.#10012705215805"}]
[{"$f":"BALANCE!A18","v":"1.1.2."},{"$f":"BALANCE!B18","v":"ACTIVOS EXIGIBLES"}]
[{"$f":"BALANCE!A19","v":"1.1.2.1."},{"$f":"BALANCE!B19","v":"CUENTAS POR COBRAR"}]
[{"$f":"BALANCE!A20","v":"1.1.2.1.001"},{"$f":"BALANCE!B20","v":"CUENTAS POR COBRAR CLIENTES"}]
[{"$f":"BALANCE!A21","v":"1.1.2.1.002"},{"$f":"BALANCE!B21","v":"CUENTAS POR COBRAR EMPLEADOS"}]
[{"$f":"BALANCE!A22","v":"1.1.2.1.003"},{"$f":"BALANCE!B22","v":"CUENTAS POR COBRAR OTROS"}]
[{"$f":"BALANCE!A23","v":"1.1.2.1.004"},{"$f":"BALANCE!B23","v":"ANTICIPO A JUSTIFICAR"}]
[{"$f":"BALANCE!A24","v":"1.1.3."},{"$f":"BALANCE!B24","v":"ACTIVOS REALIZABLES"}]
[{"$f":"BALANCE!A25","v":"1.1.3.1."},{"$f":"BALANCE!B25","v":"INVENTARIO DE MATERIALES"}]
[{"$f":"BALANCE!A26","v":"1.1.3.1.001"},{"$f":"BALANCE!B26","v":"INV. DE ACCESORIOS"}]
[{"$f":"BALANCE!A27","v":"1.1.3.1.002"},{"$f":"BALANCE!B27","v":"INV. DE PAPERIA Y UTILES  DE OFICINA"}]
[{"$f":"BALANCE!A28","v":"1.1.3.1.003"},{"$f":"BALANCE!B28","v":"INV. DE MATERIALES Y LIMPIEZA"}]
[{"$f":"BALANCE!A29","v":"1.1.3.2."},{"$f":"BALANCE!B29","v":"INVENTARIO DE MERCADERIAS"}]
[{"$f":"BALANCE!A30","v":"1.1.3.2.001"},{"$f":"BALANCE!B30","v":"GRANOS BASICOS"}]
[{"$f":"BALANCE!A31","v":"1.1.4."},{"$f":"BALANCE!B31","v":"OTROS ACTIVOS CIRCULANTES"}]
[{"$f":"BALANCE!A32","v":"1.1.4.1."},{"$f":"BALANCE!B32","v":"IMPUESTOS ANTICIPADOS Y RETENIDOS"}]
[{"$f":"BALANCE!A33","v":"1.1.4.1.001"},{"$f":"BALANCE!B33","v":"IVA CREDITO TRIBUNAL"}]
[{"$f":"BALANCE!A34","v":"1.1.4.1.002"},{"$f":"BALANCE!B34","v":"ANTICIPO IMPUESTO A LA RENTA"}]
[{"$f":"BALANCE!A35","v":"1.1.4.1.003"},{"$f":"BALANCE!B35","v":"ANTICIPO RETENCION EN LA FUENTE"}]
[{"$f":"BALANCE!A36","v":"1.2."},{"$f":"BALANCE!B36","v":"ACTIVOS FIJOS"}]
[{"$f":"BALANCE!A37","v":"1.2.1."},{"$f":"BALANCE!B37","v":"ACTIVOS TANGIBLES"}]
[{"$f":"BALANCE!A38","v":"1.2.1.1."},{"$f":"BALANCE!B38","v":"ACTIVOS DEPRECIABLES"}]
[{"$f":"BALANCE!A39","v":"1.2.1.1.001"},{"$f":"BALANCE!B39","v":"INMUEBLES"}]
[{"$f":"BALANCE!A40","v":"1.2.1.1.002"},{"$f":"BALANCE!B40","v":"INSTALACIONES"}]
[{"$f":"BALANCE!A41","v":"1.2.1.2."},{"$f":"BALANCE!B41","v":"ACTIVOS NO DEPRECIABLES"}]
[{"$f":"BALANCE!A42","v":"1.2.1.2.001"},{"$f":"BALANCE!B42","v":"TERRENO # 1"}]
[{"$f":"BALANCE!A43","v":"1.2.1.3."},{"$f":"BALANCE!B43","v":"DEPRECIACION ACUMULDA"}]
[{"$f":"BALANCE!A44","v":"1.2.1.3.001"},{"$f":"BALANCE!B44","v":"INMUEBLES DEP"}]
[{"$f":"BALANCE!A45","v":"1.2.1.3.002"},{"$f":"BALANCE!B45","v":"INSTALACIONES DEP"}]
[{"$f":"BALANCE!A46","v":"1.2.2."},{"$f":"BALANCE!B46","v":"ACTIVOS INTANGIBLES"}]
[{"$f":"BALANCE!A47","v":"1.2.2.1."},{"$f":"BALANCE!B47","v":"MARCAS"}]
[{"$f":"BALANCE!A48","v":"1.2.2.1.001"},{"$f":"BALANCE!B48","v":"SERVICIO DE EMPRESA"}]
[{"$f":"BALANCE!A49","v":"1.2.2.1.002"},{"$f":"BALANCE!B49","v":"MARCA DE PRODUCTO"}]
[{"$f":"BALANCE!A50","v":"1.2.2.2."},{"$f":"BALANCE!B50","v":"SOFTWARE"}]
[{"$f":"BALANCE!A51","v":"1.2.2.2.001"},{"$f":"BALANCE!B51","v":"SOFTWARE CONTABLE"}]
[{"$f":"BALANCE!A52","v":"1.3."},{"$f":"BALANCE!B52","v":"OTROS ACTIVOS"}]
[{"$f":"BALANCE!A53","v":"1.3.1."},{"$f":"BALANCE!B53","v":"ACTIVOS DIFERIDOS"}]
[{"$f":"BALANCE!A54","v":"1.3.1.1."},{"$f":"BALANCE!B54","v":"GASTOS DE CONSTITUCION"}]
[{"$f":"BALANCE!A55","v":"1.3.1.1.001"},{"$f":"BALANCE!B55","v":"GASTOS DE CONSTITUCION"}]
[{"$f":"BALANCE!A56","v":"1.3.1.2."},{"$f":"BALANCE!B56","v":"GASTOS DE CONSTRUCCION"}]
[{"$f":"BALANCE!A57","v":"1.3.2."},{"$f":"BALANCE!B57","v":"OTROS ACTIVOS VARIOS"}]
[{"$f":"BALANCE!A58","v":"1.3.2.1."},{"$f":"BALANCE!B58","v":"DEPOSITOD ENTREGADO EN GARANTIA"}]
[{"$f":"BALANCE!A59","v":"1.3.2.1.001"},{"$f":"BALANCE!B59","v":"INMUEBLES ENTREGADOS EN GARANTIA"}]
[{"$f":"BALANCE!A60","v":"2."},{"$f":"BALANCE!B60","v":"PASIVO"}]
[{"$f":"BALANCE!A61","v":"2.1."},{"$f":"BALANCE!B61","v":"PASIVOS A CORTO PLAZO"}]
[{"$f":"BALANCE!A62","v":"2.1.1."},{"$f":"BALANCE!B62","v":"CUENTAS POR PAGAR"}]
[{"$f":"BALANCE!A63","v":"2.1.1.1."},{"$f":"BALANCE!B63","v":"PROVEEDORES NACIONALES"}]
[{"$f":"BALANCE!A64","v":"2.1.1.1.001"},{"$f":"BALANCE!B64","v":"INDUSTRIALES CXP"}]
[{"$f":"BALANCE!A65","v":"2.1.1.2."},{"$f":"BALANCE!B65","v":"PROVEEDORES LOCALES"}]
[{"$f":"BALANCE!A66","v":"2.1.1.2.001"},{"$f":"BALANCE!B66","v":"PROVEEDOR X CXP"}]
[{"$f":"BALANCE!A67","v":"2.1.1.3."},{"$f":"BALANCE!B67","v":"SERVICIOS POR PAGAR"}]
[{"$f":"BALANCE!A68","v":"2.1.1.3.001"},{"$f":"BALANCE!B68","v":"SERV. ENERGIA  CXP"}]
[{"$f":"BALANCE!A69","v":"2.1.1.3.002"},{"$f":"BALANCE!B69","v":"TELEFONO E INTERNET CXP"}]
[{"$f":"BALANCE!A70","v":"2.1.1.4."},{"$f":"BALANCE!B70","v":"OTRAS CUENTAS POR PAGAR"}]
[{"$f":"BALANCE!A71","v":"2.1.1.4.001"},{"$f":"BALANCE!B71","v":"CUENTAS VARIAS POR PAGAR"}]
[{"$f":"BALANCE!A72","v":"2.1.2."},{"$f":"BALANCE!B72","v":"NOMINA POR PAGAR"}]
[{"$f":"BALANCE!A73","v":"2.1.2.1."},{"$f":"BALANCE!B73","v":"REMUNERACIONES POR PAGAR"}]
[{"$f":"BALANCE!A74","v":"2.1.2.1.001"},{"$f":"BALANCE!B74","v":"SUELDOS POR PAGAR"}]
[{"$f":"BALANCE!A75","v":"2.1.2.1.002"},{"$f":"BALANCE!B75","v":"DESCUENTOS POR ATRASOS"}]
[{"$f":"BALANCE!A76","v":"2.1.2.1.003"},{"$f":"BALANCE!B76","v":"LIQUIDACIONES POR PAGAR"}]
[{"$f":"BALANCE!A77","v":"2.1.2.2."},{"$f":"BALANCE!B77","v":"INSS E INATEC POR PAGAR"}]
[{"$f":"BALANCE!A78","v":"2.1.2.2.001"},{"$f":"BALANCE!B78","v":"APORTES PERSONAL Y PATRONAL CXP"}]
[{"$f":"BALANCE!A79","v":"2.1.2.2.002"},{"$f":"BALANCE!B79","v":"INATEC POR PAGAR"}]
[{"$f":"BALANCE!A80","v":"2.1.2.3."},{"$f":"BALANCE!B80","v":"PROVICIONES POR PAGAR"}]
[{"$f":"BALANCE!A81","v":"2.1.2.3.001"},{"$f":"BALANCE!B81","v":"DECIMO TERCER MES POR PAGAR"}]
[{"$f":"BALANCE!A82","v":"2.1.2.3.002"},{"$f":"BALANCE!B82","v":"VACACIONES POR PAGAR"}]
[{"$f":"BALANCE!A83","v":"2.1.2.3.003"},{"$f":"BALANCE!B83","v":"INDEMNIZACIONES POR PAGAR"}]
[{"$f":"BALANCE!A84","v":"2.1.3."},{"$f":"BALANCE!B84","v":"OBLIGACIONES FISCALES POR PAGAR"}]
[{"$f":"BALANCE!A85","v":"2.1.3.1."},{"$f":"BALANCE!B85","v":"IMPUESTOS POR PAGAR"}]
[{"$f":"BALANCE!A86","v":"2.1.3.1.001"},{"$f":"BALANCE!B86","v":"IMPUESTO A LA RENTA POR PAGAR"}]
[{"$f":"BALANCE!A87","v":"2.1.3.1.002"},{"$f":"BALANCE!B87","v":"IVA POR PAGAR (15%)"}]
[{"$f":"BALANCE!A88","v":"2.1.3.2."},{"$f":"BALANCE!B88","v":"RETENCIONES FUENTE POR PAGAR"}]
[{"$f":"BALANCE!A89","v":"2.1.3.2.001"},{"$f":"BALANCE!B89","v":"2% RET.FTE. SERVICIOS"}]
[{"$f":"BALANCE!A90","v":"2.1.3.2.002"},{"$f":"BALANCE!B90","v":"5% RET.FTE. SERVICIO"}]
[{"$f":"BALANCE!A91","v":"2.1.3.2.003"},{"$f":"BALANCE!B91","v":"2% RET. FTE DE COMPRAS"}]
[{"$f":"BALANCE!A92","v":"2.1.3.2.004"},{"$f":"BALANCE!B92","v":"10% RET.FTE.HONORARIOS PROFESIONALES"}]
[{"$f":"BALANCE!A93","v":"2.1.3.3."},{"$f":"BALANCE!B93","v":"RETENCIONES IVA POR PAGAR"}]
[{"$f":"BALANCE!A94","v":"2.1.3.3.001"},{"$f":"BALANCE!B94","v":"15% RET. IVA VENTAS"}]
[{"$f":"BALANCE!A95","v":"2.1.3.4."},{"$f":"BALANCE!B95","v":"OTROS IMPUESTOS POR PAGAR"}]
[{"$f":"BALANCE!A96","v":"2.1.3.5."},{"$f":"BALANCE!B96","v":"RETENCIONES SOBRE SALARIO"}]
[{"$f":"BALANCE!A97","v":"2.1.3.5.001"},{"$f":"BALANCE!B97","v":"RETENCIONES SOBRE SALARIO DGI  XP"}]
[{"$f":"BALANCE!A98","v":"2.2."},{"$f":"BALANCE!B98","v":"PASIVOS A LARGO PLAZO"}]
[{"$f":"BALANCE!A99","v":"2.2.1."},{"$f":"BALANCE!B99","v":"PRESTAMOS A LARGO PLAZO"}]
[{"$f":"BALANCE!A100","v":"2.2.1.1."},{"$f":"BALANCE!B100","v":"PRESTMOS SOCIOS LARGO PLAZO"}]
[{"$f":"BALANCE!A101","v":"2.2.1.1.001"},{"$f":"BALANCE!B101","v":"R.G. PMO LARGO PLAZO"}]
[{"$f":"BALANCE!A102","v":"3."},{"$f":"BALANCE!B102","v":"PATRIMONIO"}]
[{"$f":"BALANCE!A103","v":"3.1."},{"$f":"BALANCE!B103","v":"PATRIMONIO NEGOCIO X"}]
[{"$f":"BALANCE!A104","v":"3.1.1."},{"$f":"BALANCE!B104","v":"CAPITAL SOCIAL"}]
[{"$f":"BALANCE!A105","v":"3.1.1.1."},{"$f":"BALANCE!B105","v":"CAPITAL PAGADO"}]
[{"$f":"BALANCE!A106","v":"3.1.1.1.001"},{"$f":"BALANCE!B106","v":"CAPITAL NEGOCIO X"}]
[{"$f":"BALANCE!A107","v":"3.1.2."},{"$f":"BALANCE!B107","v":"RESERVAS"}]
[{"$f":"BALANCE!A108","v":"3.1.2.1."},{"$f":"BALANCE!B108","v":"RESERVAS PATRIMONIALES"}]
[{"$f":"BALANCE!A109","v":"3.1.2.1.001"},{"$f":"BALANCE!B109","v":"RESERVA FACULTATIVA"}]
[{"$f":"BALANCE!A110","v":"3.1.2.1.002"},{"$f":"BALANCE!B110","v":"RESERVA DE CAPITAL"}]
[{"$f":"BALANCE!A111","v":"3.1.2.1.003"},{"$f":"BALANCE!B111","v":"RESERVA LEGAL"}]
[{"$f":"BALANCE!A112","v":"3.1.3."},{"$f":"BALANCE!B112","v":"RESULTADOS"}]
[{"$f":"BALANCE!A113","v":"3.1.3.1."},{"$f":"BALANCE!B113","v":"RESULTADOS ANTERIORES"}]
[{"$f":"BALANCE!A114","v":"3.1.3.1.001"},{"$f":"BALANCE!B114","v":"UTILIDADES ANTERIORES"}]
[{"$f":"BALANCE!A115","v":"3.1.3.1.002"},{"$f":"BALANCE!B115","v":"PERDIDAS ANTERIORES"}]
[{"$f":"BALANCE!A116","v":"3.1.3.1.003"},{"$f":"BALANCE!B116","v":"AMORTIZACION PERDIDAS ANTERIORES"}]
[{"$f":"BALANCE!A117","v":"3.1.3.2."},{"$f":"BALANCE!B117","v":"RESULTADOS DEL EJERCICIO"}]
[{"$f":"BALANCE!A118","v":"3.1.3.2.001"},{"$f":"BALANCE!B118","v":"UTILIDADES DE EJERCICIO"}]
[]
[null,"TOTAL ACTIVOS"]
[null,"TOTAL PASIVOS + CAPITAL"]

{"sheet":"RESULTADO","index":10,"n_rows":50,"n_cols":4,"rows_kept":50,"hidden":true,"merged":[[0,0,0,3],[2,0,2,3]]}
[{"$f":"MENU!C1","v":"NOMBRE DE LA EMPRESA X"}]
[]
["BALANCE DE RESULTADO"]
[]
["AL",{"$f":"TODAY()","v":"2014-03-13"}]
[]
["CODIGO","CUENTAS","DEBE","HABER"]
[{"$f":"BALANCE!A119","v":"4."},{"$f":"BALANCE!B119","v":"INGRESOS"}]
[{"$f":"BALANCE!A120","v":"4.1."},{"$f":"BALANCE!B120","v":"INGRESOS OPERACIONALES"}]
[{"$f":"BALANCE!A121","v":"4.1.1."},{"$f":"BALANCE!B121","v":"VENTAS GENERALES"}]
[{"$f":"BALANCE!A122","v":"4.1.1.1."},{"$f":"BALANCE!B122","v":"VENTAS NETAS"}]
[{"$f":"BALANCE!A123","v":"4.1.1.1.001"},{"$f":"BALANCE!B123","v":"VENTAS DE GRANOS BASICOS"}]
[{"$f":"BALANCE!A124","v":"5."},{"$f":"BALANCE!B124","v":"COSTOS"}]
[{"$f":"BALANCE!A125","v":"5.1."},{"$f":"BALANCE!B125","v":"COSTOS OPERACIONALES"}]
[{"$f":"BALANCE!A126","v":"5.1.1."},{"$f":"BALANCE!B126","v":"COSTO DE VENTA"}]
[{"$f":"BALANCE!A127","v":"5.1.1.1."},{"$f":"BALANCE!B127","v":"COSTOS DE VENTAS GRANOS BASICO"}]
[{"$f":"BALANCE!A128","v":"5.1.1.1.001"},{"$f":"BALANCE!B128","v":"COSTO GRANOS BASICO"}]
[{"$f":"BALANCE!A129","v":"6."},{"$f":"BALANCE!B129","v":"GASTOS"}]
[{"$f":"BALANCE!A130","v":"6.1."},{"$f":"BALANCE!B130","v":"GASTOS OPERACIONALES"}]
[{"$f":"BALANCE!A131","v":"6.1.1."},{"$f":"BALANCE!B131","v":"GASTOS DE ADMINISTRACION"}]
[{"$f":"BALANCE!A132","v":"6.1.1.1."},{"$f":"BALANCE!B132","v":"SUELDOS Y SIMILARES ADMON"}]
[{"$f":"BALANCE!A133","v":"6.1.1.1.001"},{"$f":"BALANCE!B133","v":"SUELDOS Y SALARIOS ADMON"}]
[{"$f":"BALANCE!A134","v":"6.1.1.1.002"},{"$f":"BALANCE!B134","v":"COMPONENTE SALARIAL ADM"}]
[{"$f":"BALANCE!A135","v":"6.1.1.1.003"},{"$f":"BALANCE!B135","v":"HORA EXTRA ADM"}]
[{"$f":"BALANCE!A136","v":"6.1.2."},{"$f":"BALANCE!B136","v":"GASTOS DE VENTAS"}]
[{"$f":"BALANCE!A137","v":"6.1.2.1."},{"$f":"BALANCE!B137","v":"SUELDOS Y SIMILARES"}]
[{"$f":"BALANCE!A138","v":"6.1.2.1.001"},{"$f":"BALANCE!B138","v":"SUELDOS Y SALARIOS DE VENTAS"}]
[{"$f":"BALANCE!A139","v":"6.1.2.1.002"},{"$f":"BALANCE!B139","v":"COMPROBANTE SALARIAL DE VTA"}]
[{"$f":"BALANCE!A140","v":"6.1.2.1.003"},{"$f":"BALANCE!B140","v":"HORAS EXTRAS VTAS"}]
[{"$f":"BALANCE!A141","v":"6.1.3."},{"$f":"BALANCE!B141","v":"GASTOS FINANCIEROS"}]
[{"$f":"BALANCE!A142","v":"6.1.3.1."},{"$f":"BALANCE!B142","v":"GASTOS BANCARIOS"}]
[{"$f":"BALANCE!A143","v":"6.1.3.1.001"},{"$f":"BALANCE!B143","v":"GTOS BANC.X CHEQUERA"}]
[{"$f":"BALANCE!A144","v":"6.1.3.1.002"},{"$f":"BALANCE!B144","v":"GAST.X SERV.BANC."}]
[{"$f":"BALANCE!A145","v":"6.1.3.1.003"},{"$f":"BALANCE!B145","v":"GAST. X DEVALUACION DE LA MONEDA FIN."}]
[{"$f":"BALANCE!A146","v":"6.1.4."},{"$f":"BALANCE!B146","v":"GASTOS GENERALES"}]
[{"$f":"BALANCE!A147","v":"6.1.4.1."},{"$f":"BALANCE!B147","v":"MANTENIMIENTO DE MUEBLES Y ENSERES GEN"}]
[{"$f":"BALANCE!A148","v":"6.1.4.1.001"},{"$f":"BALANCE!B148","v":"MANT. DE MUEBLES GEN"}]
[{"$f":"BALANCE!A149","v":"6.1.4.1.002"},{"$f":"BALANCE!B149","v":"MANT. DE ENSERES GEN"}]
[{"$f":"BALANCE!A150","v":"6.1.4.2."},{"$f":"BALANCE!B150","v":"CONS. DE ENEGIA ELECTRICA GEN"}]
[{"$f":"BALANCE!A151","v":"6.1.4.2.01"},{"$f":"BALANCE!B151","v":"CONS.ENEGIA ENEL GEN"}]
[{"$f":"BALANCE!A152","v":"6.1.4.3."},{"$f":"BALANCE!B152","v":"MOVILIZACIONE LOCALE GEN"}]
[{"$f":"BALANCE!A153","v":"6.1.4.3.003"},{"$f":"BALANCE!B153","v":"VIATICOS GEN"}]
[{"$f":"BALANCE!A154","v":"6.1.4.3.004"},{"$f":"BALANCE!B154","v":"PASAJES AEREOS GEN."}]
[]
[null,"TOTAL INGRESOS"]
[null,"TOTAL EGRESOS"]
[null,"UTILIDAD O PERDIDA DEL EJERCICIO"]
[null,"SUMAS IGUALES"]
[]
[null,"RESULTADO DEL EJERCICIO",{"$f":"IF(D45>C46,\"UTILIDAD\",\"\")","v":""},{"$f":"IF(C46>D45,\"PERDIDA\",\"\")","v":""}]

{"sheet":"Hoja1","index":11,"n_rows":70,"n_cols":1,"rows_kept":70,"hidden":true}
["1.1.1.1.001"]
["1.1.1.1.002"]
["1.1.1.2.001"]
["1.1.2.1.001"]
["1.1.2.1.002"]
["1.1.2.1.003"]
["1.1.2.1.004"]
["1.1.3.1.001"]
["1.1.3.1.002"]
["1.1.3.1.003"]
["1.1.3.2.001"]
["1.1.4.1.001"]
["1.1.4.1.002"]
["1.1.4.1.003"]
["1.2.1.1.001"]
["1.2.1.1.002"]
["1.2.1.2.001"]
["1.2.1.3.001"]
["1.2.1.3.002"]
["1.2.2.1.001"]
["1.2.2.1.002"]
["1.2.2.2.001"]
["1.3.1.1.001"]
["1.3.2.1.001"]
["2.1.1.1.001"]
["2.1.1.2.001"]
["2.1.1.3.001"]
["2.1.1.3.002"]
["2.1.1.4.001"]
["2.1.2.1.001"]
["2.1.2.1.002"]
["2.1.2.1.003"]
["2.1.2.2.001"]
["2.1.2.2.002"]
["2.1.2.3.001"]
["2.1.2.3.002"]
["2.1.2.3.003"]
["2.1.3.1.001"]
["2.1.3.1.002"]
["2.1.3.2.001"]
["2.1.3.2.002"]
["2.1.3.2.003"]
["2.1.3.2.004"]
["2.1.3.3.001"]
["2.1.3.5.001"]
["2.2.1.1.001"]
["3.1.1.1.001"]
["3.1.2.1.001"]
["3.1.2.1.002"]
["3.1.2.1.003"]
["3.1.3.1.001"]
["3.1.3.1.002"]
["3.1.3.1.003"]
["3.1.3.2.001"]
["4.1.1.1.001"]
["5.1.1.1.001"]
["6.1.1.1.001"]
["6.1.1.1.002"]
["6.1.1.1.003"]
["6.1.2.1.001"]
["6.1.2.1.002"]
["6.1.2.1.003"]
["6.1.3.1.001"]
["6.1.3.1.002"]
["6.1.3.1.003"]
["6.1.4.1.001"]
["6.1.4.1.002"]
["6.1.4.2.01"]
["6.1.4.3.003"]
["6.1.4.3.004"]