{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["REPORTE","RESULTADO"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"REPORTE","index":0,"n_rows":70,"n_cols":17,"rows_kept":70}
[null,"Manejo de reportes contables"]
[null,"MOS Expert CPC Martín Cruz • +51 998 401 784 | Excel No Convencional"]
[]
[]
[null,"FECHA SALDO","CUENTA","ANEXO","DESCRIPCIÓN","TD","NÚMERO DOCUMENTO","FECHA DOCUMENTO","FECHA VENCTO","FECHA COMPROB.","COMPROBANTE","GLOSA","MO","DEBE US","HABER US","DEBE MN","HABER MN"]
[null,"31/12/2016","121201  ","10446148945       ","  10446148945         SALAZAR BRAVO JUNIOR RAFAEL ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10446148945       ","   FT 0010-0009062                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10446148945       ","                                                  ","FT","0010-0009062        ","19/01/2016","31/01/2016","19/01/2016","05-010228","SALAZAR BRAVO JUNIOR RAFAEL FT","MN",270.16,"             ",955.84,"             "]
[null,"31/12/2016","121201  ","10446148945       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009062        ","          ","          ","          ","         ","                              ","  ",270.16,"             ",955.84,"             "]
[null,"31/12/2016","121201  ","10446148945       ","   FT 0010-0009120                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10446148945       ","                                                  ","NA","0010-006274         ","28/01/2016","15/02/2016","28/01/2016","05-010387","SALAZAR BRAVO JUNIOR RAFAEL FT","MN","             ",263.54,"             ",932.42]
[null,"31/12/2016","121201  ","10446148945       ","          SALDO DEL DOCUMENTO                     ","NA","0010-006274         ","          ","          ","          ","         ","                              ","  ","             ",263.54,"             ",932.42]
[null,"31/12/2016","121201  ","10446148945       ","          SALDO DEL ANEXO: 10446148945            ","  ","                    ","          ","          ","          ","         ","                              ","  ",6.62,"             ",23.42,"             "]
[null,"31/12/2016","121201  ","10458679253       ","  10458679253         HUARACC ESPINOZA DIANA MARIE","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10458679253       ","   FT 0010-0009073                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10458679253       ","                                                  ","FT","0010-0009073        ","21/01/2016","10/02/2016","21/01/2016","05-010264","HUARACC ESPINOZA DIANA FT0010-","MN",505.84,"             ",{"v":1741.1,"d":"1,741.10"},"             "]
[null,"31/12/2016","121201  ","10458679253       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009073        ","          ","          ","          ","         ","                              ","  ",505.84,"             ",{"v":1741.1,"d":"1,741.10"},"             "]
[null,"31/12/2016","121201  ","10458679253       ","   FT 0010-0009125                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10458679253       ","                                                  ","FT","0010-0009125        ","28/01/2016","28/02/2016","28/01/2016","05-010392","HUARACC ESPINOZA DIANA FT0010-","MN",210.21,"             ",743.72,"             "]
[null,"31/12/2016","121201  ","10458679253       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009125        ","          ","          ","          ","         ","                              ","  ",210.21,"             ",743.72,"             "]
[null,"31/12/2016","121201  ","10458679253       ","   FT 0010-0009135                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10458679253       ","                                                  ","FT","0010-0009135        ","28/01/2016","15/03/2016","28/01/2016","05-010402","HUARACC ESPINOZA DIANA FT0010-","MN",303.67,"             ",{"v":1074.4,"d":"1,074.40"},"             "]
[null,"31/12/2016","121201  ","10458679253       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009135        ","          ","          ","          ","         ","                              ","  ",303.67,"             ",{"v":1074.4,"d":"1,074.40"},"             "]
[null,"31/12/2016","121201  ","10458679253       ","          SALDO DEL ANEXO: 10458679253            ","  ","                    ","          ","          ","          ","         ","                              ","  ",{"v":1019.72,"d":"1,019.72"},"             ",{"v":3559.22,"d":"3,559.22"},"             "]
[null,"31/12/2016","121201  ","10763295724       ","  10763295724         PANCHANA VILLAZANA NICOLLE W","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10763295724       ","   FT 0010-0009113                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10763295724       ","                                                  ","FT","0010-0009113        ","28/01/2016","10/03/2016","28/01/2016","05-010380","PANCHANA VILLAZANA NICOLLE FT0","MN",7.91,"             ",{"v":28,"d":"28.00"},"             "]
[null,"31/12/2016","121201  ","10763295724       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009113        ","          ","          ","          ","         ","                              ","  ",7.91,"             ",{"v":28,"d":"28.00"},"             "]
[null,"31/12/2016","121201  ","10763295724       ","          SALDO DEL ANEXO: 10763295724            ","  ","                    ","          ","          ","          ","         ","                              ","  ",7.91,"             ",{"v":28,"d":"28.00"},"             "]
[null,"31/12/2016","121201  ","10773788877       ","  10773788877         ACOSTA ADANAQUE LUIS ANDERSO","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10773788877       ","   FT 0010-0009137                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10773788877       ","                                                  ","FT","0010-0009137        ","28/01/2016","28/02/2016","28/01/2016","05-010404","ACOSTA ADANAQUE LUIS FT0010-00","MN",123.78,"             ",437.92,"             "]
[null,"31/12/2016","121201  ","10773788877       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009137        ","          ","          ","          ","         ","                              ","  ",123.78,"             ",437.92,"             "]
[null,"31/12/2016","121201  ","10773788877       ","          SALDO DEL ANEXO: 10773788877            ","  ","                    ","          ","          ","          ","         ","                              ","  ",123.78,"             ",437.92,"             "]
[null,"31/12/2016","121201  ","10803423224       ","  10803423224         QUIROZ DUEÑAS MADELEYNE     ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10803423224       ","   FT 0010-0009112                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10803423224       ","                                                  ","FT","0010-0009112        ","28/01/2016","15/03/2016","28/01/2016","05-010379","QUIROZ DUE¥AS MADELEYNE FT0010","MN",267.76,"             ",947.32,"             "]
[null,"31/12/2016","121201  ","10803423224       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009112        ","          ","          ","          ","         ","                              ","  ",267.76,"             ",947.32,"             "]
[null,"31/12/2016","121201  ","10803423224       ","   FT 0010-0009198                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10803423224       ","                                                  ","FT","0010-0009198        ","11/03/2016","31/03/2016","11/03/2016","05-030149","QUIROZ DUE¥AS MADELEYNE FT0010","MN",{"v":1152.2,"d":"1,152.20"},"             ",{"v":3887.51,"d":"3,887.51"},"             "]
[null,"31/12/2016","121201  ","10803423224       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009198        ","          ","          ","          ","         ","                              ","  ",{"v":1152.2,"d":"1,152.20"},"             ",{"v":3887.51,"d":"3,887.51"},"             "]
[null,"31/12/2016","121201  ","10803423224       ","          SALDO DEL ANEXO: 10803423224            ","  ","                    ","          ","          ","          ","         ","                              ","  ",{"v":1419.96,"d":"1,419.96"},"             ",{"v":4834.83,"d":"4,834.83"},"             "]
[null,"31/12/2016","121201  ","10806517203       ","  10806517203         MORALES QUISPITUPAC LAURA VI","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10806517203       ","   FT 0010-0009060                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","10806517203       ","                                                  ","FT","0010-0009060        ","18/01/2016","18/02/2016","18/01/2016","05-010216","MORALES QUISPITUPAC LAURA FT00","MN",811.14,"             ",{"v":2869.83,"d":"2,869.83"},"             "]
[null,"31/12/2016","121201  ","10806517203       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009060        ","          ","          ","          ","         ","                              ","  ",811.14,"             ",{"v":2869.83,"d":"2,869.83"},"             "]
[null,"31/12/2016","121201  ","10806517203       ","          SALDO DEL ANEXO: 10806517203            ","  ","                    ","          ","          ","          ","         ","                              ","  ",811.14,"             ",{"v":2869.83,"d":"2,869.83"},"             "]
[null,"31/12/2016","121201  ","20101709231       ","  20101709231         ALBERTO RAFAEL SOTO S.A.C.  ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20101709231       ","   FT 0010-0009068                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20101709231       ","                                                  ","FT","0010-0009068        ","20/01/2016","31/03/2016","20/01/2016","05-010243","ALBERTO RAFAEL SOTO S.A.C. FT0","MN",46.64,"             ",{"v":165,"d":"165.00"},"             "]
[null,"31/12/2016","121201  ","20101709231       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009068        ","          ","          ","          ","         ","                              ","  ",46.64,"             ",{"v":165,"d":"165.00"},"             "]
[null,"31/12/2016","121201  ","20101709231       ","          SALDO DEL ANEXO: 20101709231            ","  ","                    ","          ","          ","          ","         ","                              ","  ",46.64,"             ",{"v":165,"d":"165.00"},"             "]
[null,"31/12/2016","121201  ","20101724388       ","  20101724388         CONFECCIONES JONISA S R LTDA","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20101724388       ","   FT 0010-0009090                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20101724388       ","                                                  ","FT","0010-0009090        ","25/01/2016","28/02/2016","25/01/2016","05-010319","CONFECCIONES JONISA SRL FT0010","MN",{"v":145.3,"d":"145.30"},"             ",514.08,"             "]
[null,"31/12/2016","121201  ","20101724388       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009090        ","          ","          ","          ","         ","                              ","  ",{"v":145.3,"d":"145.30"},"             ",514.08,"             "]
[null,"31/12/2016","121201  ","20101724388       ","          SALDO DEL ANEXO: 20101724388            ","  ","                    ","          ","          ","          ","         ","                              ","  ",{"v":145.3,"d":"145.30"},"             ",514.08,"             "]
[null,"31/12/2016","121201  ","20299351140       ","  20299351140         INVERSIONES H.T.L. S.R.LTDA.","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20299351140       ","   FT 0010-0009063                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20299351140       ","                                                  ","FT","0010-0009063        ","19/01/2016","15/02/2016","19/01/2016","05-010229","INVERSIONES H.T.L. S.R.LTDA. F","MN",713.62,"             ",{"v":2448.42,"d":"2,448.42"},"             "]
[null,"31/12/2016","121201  ","20299351140       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009063        ","          ","          ","          ","         ","                              ","  ",713.62,"             ",{"v":2448.42,"d":"2,448.42"},"             "]
[null,"31/12/2016","121201  ","20299351140       ","          SALDO DEL ANEXO: 20299351140            ","  ","                    ","          ","          ","          ","         ","                              ","  ",713.62,"             ",{"v":2448.42,"d":"2,448.42"},"             "]
[null,"31/12/2016","121201  ","20392834177       ","  20392834177         AIXA INVERSIONES SAC        ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20392834177       ","   FT 0010-0009094                                ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20392834177       ","                                                  ","FT","0010-0009094        ","26/01/2016","31/03/2016","26/01/2016","05-010333","AIXA INVERSIONES SAC FT0010-00","MN",156.97,"             ",555.36,"             "]
[null,"31/12/2016","121201  ","20392834177       ","          SALDO DEL DOCUMENTO                     ","FT","0010-0009094        ","          ","          ","          ","         ","                              ","  ",156.97,"             ",555.36,"             "]
[null,"31/12/2016","121201  ","20392834177       ","   FT 0010-006276                                 ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ","             ","             ","             "]
[null,"31/12/2016","121201  ","20392834177       ","                                                  ","NA","0010-006276         ","07/01/2015","15/02/2015","04/02/2016","21-020197","DESCUENTO DE LETRAS           ","MN","             ",{"v":1187.84,"d":"1,187.84"},"             ",{"v":4150.3,"d":"4,150.30"}]
[null,"31/12/2016","121201  ","20392834177       ","          SALDO DEL DOCUMENTO                     ","NA","0010-006276         ","          ","          ","          ","         ","                              ","  ","             ",{"v":1187.84,"d":"1,187.84"},"             ",{"v":4150.3,"d":"4,150.30"}]
[null,"31/12/2016","121201  ","20392834177       ","          SALDO DEL ANEXO: 20392834177            ","  ","                    ","          ","          ","          ","         ","                              ","  ","             ",{"v":1030.87,"d":"1,030.87"},"             ",{"v":3594.94,"d":"3,594.94"}]

{"sheet":"RESULTADO","index":1,"n_rows":21,"n_cols":9,"rows_kept":21}
[null,"Manejo de reportes contables"]
[null,"MOS Expert CPC Martín Cruz • +51 998 401 784 | Excel No Convencional"]
[]
[]
[]
[null,null,"CUENTA NOMBRE","ANEXO","FECHA DOC","FECHA VCTO","DIAS","U$","MN"]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10446148945 - SALAZAR BRAVO JUNIOR RAFAEL","2016-01-19","2016-01-31",12,270.16,955.84]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10446148945 - SALAZAR BRAVO JUNIOR RAFAEL","2016-01-28","2016-02-15",18,-263.54,-932.42]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10458679253 - HUARACC ESPINOZA DIANA MARIELA","2016-01-21","2016-02-10",20,505.84,{"v":1741.1,"d":"1,741.10"}]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10458679253 - HUARACC ESPINOZA DIANA MARIELA","2016-01-28","2016-02-28",31,210.21,743.72]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10458679253 - HUARACC ESPINOZA DIANA MARIELA","2016-01-28","2016-03-15",47,303.67,{"v":1074.4,"d":"1,074.40"}]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10763295724 - PANCHANA VILLAZANA NICOLLE WHYNI","2016-01-28","2016-03-10",42,7.91,{"v":28,"d":"28.00"}]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10773788877 - ACOSTA ADANAQUE LUIS ANDERSON","2016-01-28","2016-02-28",31,123.78,437.92]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10803423224 - QUIROZ DUEÐAS MADELEYNE","2016-01-28","2016-03-15",47,267.76,947.32]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10803423224 - QUIROZ DUEÐAS MADELEYNE","2016-03-11","2016-03-31",20,{"v":1152.2,"d":"1,152.20"},{"v":3887.51,"d":"3,887.51"}]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","10806517203 - MORALES QUISPITUPAC LAURA VILMA","2016-01-18","2016-02-18",31,811.14,{"v":2869.83,"d":"2,869.83"}]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","20101709231 - ALBERTO RAFAEL SOTO S.A.C.","2016-01-20","2016-03-31",71,46.64,{"v":165,"d":"165.00"}]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","20101724388 - CONFECCIONES JONISA S R LTDA","2016-01-25","2016-02-28",34,{"v":145.3,"d":"145.30"},514.08]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","20299351140 - INVERSIONES H.T.L. S.R.LTDA.","2016-01-19","2016-02-15",27,713.62,{"v":2448.42,"d":"2,448.42"}]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","20392834177 - AIXA INVERSIONES SAC","2016-01-26","2016-03-31",65,156.97,555.36]
[null,null,"121201 - FACTURAS POR COBRAR EMITIDAS CARTERA TERCEROS M.N.","20392834177 - AIXA INVERSIONES SAC","2015-01-07","2015-02-15",39,{"v":-1187.84,"d":"-1,187.84"},{"v":-4150.3,"d":"-4,150.30"}]