{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INICIO","CONTINGENCIAS","EXTRAS"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":6,"comments":1,"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":"INICIO","index":0,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[[13,2,13,5],[1,2,1,5],[5,2,5,5],[11,2,11,5],[12,2,12,5],[3,2,3,5]]}
[null,null,null,null,null,null,null,null,null,"MESES","AÑOS",null,{"$f":"+VLOOKUP(MES,J2:L13,3,0)","v":{"$error":"#N/A"}}]
[null,"RAZÓN SOCIAL","PERU CONTABLE SAC",null,null,null,null,null,"RER","ENERO",{"$f":"+K3-1","v":2011},1]
[null,null,null,null,null,null,null,null,"RMT","FEBRERO",2012,2]
[null,"RUC",20495637957,null,null,null,null,null,"RG","MARZO",2013,3]
[null,null,null,null,null,null,null,null,null,"ABRIL",2014,4]
[null,"DIRECCIÓN","Jr. Mateo Pumacahua N° 1163 - Jesús Maria",null,null,null,null,null,null,"MAYO",2015,5]
[null,null,null,null,null,null,null,null,null,"JUNIO",2016,6]
[null,"DATOS","FECHA","2017-06-21","N° ENVIO",1,null,null,null,"JULIO",{"$f":"YEAR(NOW())","v":2017},7]
[null,null,null,null,null,null,null,null,null,"AGOSTO",{"$f":"+K8+1","v":2018},8]
[null,null,null,null,null,null,null,null,null,"SETIEMBRE",{"$f":"+K9+1","v":2019},9]
[null,null,null,null,null,null,null,null,null,"OCTUBRE",{"$f":"+K10+1","v":2020},10]
[null,"Visita nuestra tienda",null,null,null,null,null,null,null,"NOVIEMBRE",{"$f":"+K11+1","v":2021},11]
[null,"Facebook",null,null,null,null,null,null,null,"DICIEMBRE",{"$f":"+K12+1","v":2022},12]
[null,"Correo"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"'215750841"]

{"sheet":"CONTINGENCIAS","index":1,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":true,"merged":[[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,4,19],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,4,12],[4,13,5,13],[4,5,5,5],[4,6,5,6],[1,0,1,2],[1,3,1,4],[2,0,2,2],[2,3,2,4],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4]]}
["Resumen diario de Comprobantes Físicos (Contingencia)"]
["FECHA(dd/mm/aaaa)",null,null,"2017-06-23"]
["N° DE ENVIO",null,null,1]
[null,"1","2 ","3","4 ",5,"6","7","8","9","10","11","12","13","14","15","16","17","18","19"]
["NÚMERO","MOTIVO","FECHA DE EMISIÓN","TIPO\n(TAB.10)","SERIE O COD. DUA","NÚMERO","NÚMERO FINAL (2)","TIPO DE IDENT.","RUC/DNI","DENOMINACIÓN O RAZÓN SOCIAL\n","BASE IMPONIBLE DE LA OPERACIÓN GRAVADA","IMPORTE TOTAL DE LA OPERACIÓN EXONERADA O INAFECTA",null,"ISC","IGV","OTROS TRIBUTOS","IMPORTE TOTAL","REFERENCIA DEL COMPROBANTE DE PAGO O DOCUMENTO ORIGINAL QUE SE MODIFICA"]
[null,null,null,null,null,null,null,null,null,null,null,"EXONERADA","INAFECTA",null,null,null,null,"TIPO\n(TAB.10)","SERIE","NUMERO"]
[1,"1","21/06/2017","01","0001",1,null,6,"20102420706","Comercial Fatmagul SAC","0.00","0.00","0.00","0.00","369.15","0.00","2420.00"]
[2,"1","21/06/2017","03","0001",3,null,1,"46237541","Pazos Atoche Luana","1101.69","0.00","0.00","0.00","198.31","0.00","1300.00"]
[3,"1","21/06/2017","07","0001",7,null,6,"20102420706","Comercial Fatmagul SAC","398.31","0.00","0.00","0.00","71.69","0.00","470.00","01","0001",1]
[4,"1","21/06/2017","08","0001",2,null,6,"20102420706","Comercial Fatmagul SAC","0.00","0.00","785.00","0.00","0.00","0.00","785.00","01","0001",1]
[5,"1","21/06/2017","12","TKF01",5411077,null,6,"20102420706","Comercial Fatmagul SAC","3023.73","0.00","0.00","0.00","544.27","0.00","3568.00"]
[6,"1","21/06/2017","12","TKB01",426589,428451,0,"0","Consolidado","4745.76","256.00","0.00","0.00","821.24","0.00","5823.00"]
[7,"1","21/06/2017","01","0001",2,null,6,"20102420706","Comercial Fatmagul SAC","1009.66","0.00","0.00","0.00","181.74","0.00","1191.40"]
[8,"1","21/06/2017","03","0001",4,null,0,"0","Clientes Varios","277.97","0.00","0.00","0.00","50.03","0.00","328.00"]
[9,"1","21/06/2017","01","0001",3,null,6,"20102420706","Comercial Fatmagul SAC","0.00","300.00","0.00","0.00","0.00","0.00","300.00"]
[10,"1","21/06/2017","01","0001",4,null,6,"20102420706","Comercial Fatmagul SAC","754.24","0.00","0.00","0.00","135.76","0.00","0.00"]

{"sheet":"EXTRAS","index":2,"n_rows":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":true,"merged":[[15,0,15,6],[1,9,1,10],[18,9,18,10],[10,9,10,10],[0,0,0,6],[1,0,3,6],[4,0,4,6],[5,0,5,4],[6,0,6,4],[7,0,8,6],[0,9,0,10],[10,0,10,6],[11,0,11,6],[12,0,12,6],[14,0,14,6]]}
["VALIDACIONES DEL RESUMEN DIARIO",null,null,null,null,null,null,null,null,"TABLAS SUNAT"]
["La validación se realiza por línea, en caso no cumplirse con la validación el resultado de la evaluación genera un archivo de errores, con los mensajes de validación. ",null,null,null,null,null,null,null,null,"MOTIVO"]
[null,null,null,null,null,null,null,null,null,1,"CONEXIÓN INTERNET"]
[null,null,null,null,null,null,null,null,null,2,"FALTA DE FLUIDO ELECTRICO"]
["El nombre del archivo de errores será:",null,null,null,null,null,null,null,null,3,"DESASTRES NATURALES",null,null,null,null,1,"21/06/2017","1","1",1,null,6,"20102420706","Comercial Fatmagul SAC","0.00","0.00","0.00","0.00","369.15","0.00","2420.00"]
["RRRRRRRRRRR-RF-DDMMAAAA-CCCCC_respuesta.zip",null,null,null,null,null,null,null,null,4,"ROBO",null,null,null,null,1,"21/06/2017","3","1",3,null,1,"46237541","Pazos Atoche Luana","1101.69","0.00","0.00","0.00","198.31","0.00","1300.00"]
[null,null,null,null,null,null,null,null,null,5,"FALLAS EN EL SISTEMA DE EMISION ELECTRONICA",null,null,null,null,1,"21/06/2017","7","1",7,null,6,"13246213133","Comercial Fatmagul SAC","398.31","0.00","0.00","0.00","71.69","0.00","470.00","01","0001",1]
["Es decir se utiliza la misma nomenclatura del envío pero se le adiciona \"_respuesta\".",null,null,null,null,null,null,null,null,6,"VENTAS POR EMISORES ITINERANTES",null,null,null,null,1,"21/06/2017","8","1",2,null,6,"20102420706","Comercial Fatmagul SAC","0.00","0.00","785.00","0.00","0.00","0.00","785.00","01","0001",1]
[null,null,null,null,null,null,null,null,null,7,"OTROS",null,null,null,null,1,"21/06/2017","12","TKF01",5411077,null,6,"20102420706","Comercial Fatmagul SAC","3023.73","0.00","0.00","0.00","544.27","0.00","3568.00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"21/06/2017","12","TKB01",426589,428451,0,"0","Consolidado","4745.76","256.00","0.00","0.00","821.24","0.00","5823.00"]
["CONTENIDO DEL ARCHIVO DE ERRORES Y/O ADVERTENCIAS",null,null,null,null,null,null,null,null,"CATALOGO N° 06",null,null,null,null,null,1,"21/06/2017","1","1",2,null,6,"20102420706","Comercial Fatmagul SAC","1009.66","0.00","0.00","0.00","181.74","0.00","1191.40"]
["La estructura del contenido del archivo esta definida por:",null,null,null,null,null,null,null,null,"0","DOC.TRIB NO DOMIC SIN RUC",null,null,null,null,1,"21/06/2017","3","1",4,null,0,"0","Clientes Varios","277.97","0.00","0.00","0.00","50.03","0.00","328.00"]
["Error| Fila| Columna| Valor",null,null,null,null,null,null,null,null,"1","DOC NACIONAL DE IDENTIDAD",null,null,null,null,1,"21/06/2017","1","1",3,null,6,"20102420706","Comercial Fatmagul SAC","0.00","300.00","0.00","0.00","0.00","0.00","300.00"]
["Ejemplo:",null,null,null,null,null,null,null,null,"4","CARNET DE EXTRANJERIA",null,null,null,null,1,"21/06/2017","1","1",4,null,6,"20102420706","Comercial Fatmagul SAC","754.24","0.00","0.00","0.00","135.76","0.00","0.00"]
["E200001| 2| 0 - Nro Columnas Encontradas: 18",null,null,null,null,null,null,null,null,"6","REG.UNICO DEL CONTRIBUYENTE"]
[null,null,null,null,null,null,null,null,null,"7","PASAPÓRTE"]
[null,null,null,null,null,null,null,null,null,"A","CD DIPLOMATICO DE IDENTIDAD"]
[]
[null,null,null,null,null,null,null,null,null,"TIPO DE DOCUMENTO TABLA 10"]
[null,null,null,null,null,null,null,null,null,"01","FACTURA "]
[null,null,null,null,null,null,null,null,null,"03","BOLETAS DE VENTAS"]
[null,null,null,null,null,null,null,null,null,"07","NOTA DE CREDITO"]
[null,null,null,null,null,null,null,null,null,"08","NOTA DE DEBITO"]
[null,null,null,null,null,null,null,null,null,"12 ","TICKETS "]