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

{"sheet":"Inicio","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,2,7,3],[8,2,8,4],[9,2,9,3]]}
[]
[null,"Producto:","Restaurar 621 - Excel"]
[null,"Versión:","1.0"]
[null,"Descripción:","Macros  para restaurar las declaraciones  del  PDT 621 (backup otorgado por la sunat)."]
[null,"Autores:","Daniel & Miguel"]
[]
[null,"Empresa:","Noticiero del Contador SAC"]
[null,"Web:","noticierocontable.com"]
[null,"Facebook:","Facebook.com/NoticieroContable"]
[null,"Grupo:","groups/noticierocontable"]
[]
[]
[null,"Espero que te sirva mucho esta herramienta  :)"]
[]
[null,"Saludos,"]
[]
[null,"Miguel Torres"]

{"sheet":"Declaracion","index":1,"n_rows":254,"n_cols":15,"rows_kept":254,"cut":false,"hidden":false,"merged":[[137,1,138,2],[137,3,138,11],[137,12,139,15],[139,1,140,2],[139,3,140,11],[141,1,141,2],[141,3,141,5],[141,6,141,11],[142,1,142,2],[142,3,142,5],[142,6,142,11],[88,1,88,2],[88,3,88,5],[88,6,88,11],[124,10,124,12],[124,13,124,15],[89,1,89,2],[89,3,89,5],[89,6,89,11],[93,10,93,12],[93,13,93,15],[110,10,110,12],[61,3,62,5],[61,10,61,11],[84,1,85,2],[84,3,85,11],[61,13,61,14],[76,7,76,9],[76,10,76,12],[76,13,76,15],[84,12,86,15],[86,1,87,2],[86,3,87,11],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[47,1,48,2],[60,6,60,11],[47,12,49,15],[49,1,50,2],[49,3,50,11],[51,1,51,2],[51,3,51,5],[51,6,51,11],[47,3,48,11],[52,1,52,2],[52,3,52,5],[52,6,52,11],[58,6,58,11],[59,6,59,11],[39,1,39,4],[34,1,36,1],[34,2,34,5],[34,6,34,9],[35,2,35,5],[35,6,35,9],[36,2,36,5],[36,6,36,9],[37,1,38,2],[37,3,37,5],[38,3,38,5],[19,5,19,7],[29,10,29,14],[31,1,33,1],[31,2,31,5],[31,6,31,9],[32,2,32,5],[32,6,32,9],[33,2,33,5],[33,6,33,9],[155,1,156,2],[155,3,156,11],[155,12,157,15],[157,1,158,2],[157,3,158,11],[5,1,5,2],[5,3,5,5],[5,6,5,11],[1,1,2,2],[1,3,2,11],[1,12,3,15],[3,1,4,2],[3,3,4,11],[30,10,30,11],[30,13,30,14],[6,1,6,2],[6,3,6,5],[6,6,6,11],[10,10,10,14],[11,10,11,11],[11,13,11,14],[12,1,19,1],[18,2,19,4],[18,5,18,7],[164,1,164,2],[164,7,164,8],[164,12,164,14],[159,1,159,2],[159,3,159,5],[159,6,159,11],[160,1,160,2],[160,3,160,5],[160,6,160,11],[233,1,233,2],[233,7,233,8],[233,12,233,14],[224,1,225,2],[224,3,225,11],[224,12,226,15],[226,1,227,2],[226,3,227,11],[228,1,228,2],[228,3,228,5],[228,6,228,11],[229,1,229,2],[229,3,229,5],[229,6,229,11]]}
[]
[null,"SUNAT",null,"PDT - IGV RENTA MENSUAL",null,null,null,null,null,null,null,null,"Copia para el\nContribuyente (Pag. 1)"]
[]
[null,"DECLARACION",null,"Periodo 09-2014"]
[]
[null,"PAGO",null,"RUC",null,null,"20547111665",null,null,null,null,null,"Fecha Pres : 21/10/2014"]
[null,621,null,"RAZON SOCIAL",null,null,null,null,null,null,null,null,"N° de Decl : 795917013"]
[]
[]
[]
[null,"IGV VENTAS",null,null,null,null,null,null,null,null,"IGV CUENTA PROPIA"]
[null,null,null,null,null,null,null,null,null,null,"BASE",null,null,"TRIBUTO"]
[null,"GRAVADAS"," Ventas Netas",null,null,null,null,null,null,null,100,268637,null,101,48355]
[null,null," Descuentos Concedidos",null,null,null,null,null,null,null,102,null,null,103]
[null,null," Ventas Asumidas Por El Estado",null,null,null,null,null,null,null,124,null,null,125]
[null,null," Desc.Concedidos y/o Dev.Ventas(Vta. asumidas por estado)",null,null,null,null,null,null,null,126,null,null,128]
[null,null," Ventas de bienes (ley 27037 inc. 11.1,12.1,12.3 y 12.4)",null,null,null,null,null,null,null,160,null,null,161]
[null,null," Descuentos y devoluciones (ley 27037)",null,null,null,null,null,null,null,162,null,null,163]
[null,null,"Exportaciones",null,null," Facturadas en el período",null,null,null,null,106]
[null,null,null,null,null," Embarcadas en el período",null,null,null,null,127]
[null," Ventas No Gravadas Sin Considerar Exportaciones",null,null,null,null,null,null,null,null,105]
[null," Ventas No Gravadas (Sin Efecto En Ratio)",null,null,null,null,null,null,null,null,109]
[null," Otras Ventas Inciso II",null,null,null,null,null,null,null,null,112]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,131,48355]
[]
[]
[]
[]
[null,"IGV COMPRAS"]
[null,null,null,null,null,null,null,null,null,null,"IGV CUENTA PROPIA"]
[null,null,null,null,null,null,null,null,null,null,"BASE",null,null,"TRIBUTO"]
[null,"NACIONALES","Destinada A Ventas\nGravadas Exclusivamente",null,null,null,"Compras Netas",null,null,null,107,240760,null,108,43337]
[null,null,"Destinadas A Ventas\nGravadas Y No Gravadas",null,null,null,"Compras Netas",null,null,null,110,null,null,111]
[null,null,"Destinada A Ventas No Gravadas Exclusivamente",null,null,null,"Compras Netas",null,null,null,113]
[null,"IMPORTADAS","Destinada A Ventas\nGravadas Exclusivamente",null,null,null,"Compras Netas",null,null,null,114,null,null,115]
[null,null,"Destinadas A Ventas\nGravadas Y No Gravadas",null,null,null,"Compras Netas",null,null,null,116,null,null,117]
[null,null,"Destinada A Ventas No Gravadas Exclusivamente",null,null,null,"Compras Netas",null,null,null,119]
[null,"NO GRAVADAS",null,"  Internas",null,null,"Compras Netas",null,null,null,120]
[null,null,null,"  Importadas",null,null,"Compras Netas",null,null,null,122]
[null,null,null,null,null,"TOTAL",null,null,null,null,null,null,null,178,43337]
[null,null,null,null,"CREDITO FISCAL ESPECIAL",null,null,null,null,null,null,null,null,172]
[null,null,null,null,"OTROS CREDITOS",null,null,null,null,null,null,null,null,169]
[null,null,null,null,"OTROS CREDITO IVAP",null,null,null,null,null,null,null,null,182]
[null,null,null,null,"Coeficiente",null,null,null,null,null,173]
[]
[]
[]
[null,"SUNAT",null,"PDT - IGV RENTA MENSUAL",null,null,null,null,null,null,null,null,"Copia para el\nContribuyente (Pag. 2)"]
[]
[null,"DECLARACION",null,"Periodo 09-2014"]
[]
[null,"PAGO",null,"RUC",null,null,"20547111665",null,null,null,null,null,"Fecha Pres : 21/10/2014"]
[null,621,null,"RAZON SOCIAL",null,null,null,null,null,null,null,null,"N° de Decl : 795917013"]
[]
[]
[]
[null,"PAGOS A CUENTA DE RENTA"]
[]
[null,null,null,null,null,null,"    Impuesto a la renta 3ra categoría"]
[null,null,null,null,null,null,"Coeficiente - Art. 85° inc. a) ",null,null,null,null,null,null,380,2.86E-2]
[null,null,null,null,null,null,"Porcentaje - Art. 85° inc. b)",null,null,null,null,null,null,315,1.5]
[null,null,null," Ingreso Neto",null,null,null,null,null,null,"BASE",null,null,"TRIBUTO"]
[null,null,null,null,null,null,null,null,null,null,301,268637,null,312,7683]
[]
[]
[null,"SUSPENSION DE PAGOS A CUENTA"]
[null,"¿Cuenta con una resolución aprobada y notificada de suspensión de pago"]
[null,"a cuenta de renta?",null,null,null,null,null,null,null,null,null,null,null,361]
[null,"Número de RI.",null,null,null,null,null,null,null,null,null,null,null,362]
[null,"Fecha de notificación",null,null,null,null,null,null,null,null,null,null,null,363]
[null,"coeficiente con el cual la SUNAT le aprobó la solicitud de suspensión de pagos",null,null,null,null,null,null,null,null,null,null,null,364]
[]
[]
[null,"RETENCIONES DE TRABAJADORES INDEPENDIENTES"]
[]
[]
[null,null,null,null,null,null,null,"MONTO DE RECIBOS",null,null,"MONTO DE 4TA",null,null,"MONTO IES"]
[null,null,null,"TOTAL",null,null,null,320,null,null,321,null,null,540]
[null,null,null,"Otras Retenciones Ind.",null,null,null,547,null,null,322,null,null,541]
[]
[]
[]
[]
[]
[null,"SUNAT",null,"PDT - IGV RENTA MENSUAL",null,null,null,null,null,null,null,null,"Copia para el\nContribuyente (Pag. 3)"]
[]
[null,"DECLARACION",null,"Periodo 09-2014"]
[]
[null,"PAGO",null,"RUC",null,null,"20547111665",null,null,null,null,null,"Fecha Pres : 21/10/2014"]
[null,621,null,"RAZON SOCIAL",null,null,null,null,null,null,null,null,"N° de Decl : 795917013"]
[]
[]
[null,"DETERMINACION DE LA DEUDA"]
[null,"IGV",null,null,null,null,null,null,null,null,"IGV Cta. Propia",null,null,"Imp. Vtas. Arroz Pilado"]
[null,null," IMPUESTO RESULTANTE O SALDO A FAVOR",null,null,null,null,null,null,null,140,5018,null,353]
[null,null," SALDO A FAVOR DEL PERIODO ANTERIOR",null,null,null,null,null,null,null,145,null,null,351]
[null,null," TRIBUTO A PAGAR O SALDO A FAVOR",null,null,null,null,null,null,null,184,5018,null,352]
[null,null," PERCEPCIONES DECLARADAS EN EL PERIODO",null,null,null,null,null,null,null,171,124]
[null,null," PERCEPCIONES DECLARADAS EN PERIODOS ANTERIORES",null,null,null,null,null,null,null,168]
[null,null," SALDO DE PERCEPCIONES NO APLICADAS",null,null,null,null,null,null,null,164,0]
[null,null," RETENCIONES DECLARADAS EN EL PERIODO",null,null,null,null,null,null,null,179,4509]
[null,null," RETENCIONES DECLARADAS EN PERIODOS ANTERIORES",null,null,null,null,null,null,null,176,409]
[null,null," SALDO DE RETENCIONES NO APLICADAS",null,null,null,null,null,null,null,165,24]
[null,null," COMPENSACION SALDO A FAVOR DEL EXPORTADOR",null,null,null,null,null,null,null,null,null,null,347]
[null,null," PAGOS PREVIOS",null,null,null,null,null,null,null,185,null,null,342]
[null,null," INTERES MORATORIO",null,null,null,null,null,null,null,187,null,null,343]
[null,null," TOTAL DEUDA TRIBUTARIA",null,null,null,null,null,null,null,188,0,null,344]
[null,null," IMPORTE A PAGAR",null,null,null,null,null,null,null,189,0,null,345]
[]
[]
[null,"RENTA",null,null,null,null,null,null,null,null,"Renta"]
[null,null," IMPUESTO RESULTANTE O SALDO A FAVOR",null,null,null,null,null,null,null,302,7683]
[null,null," SALDO A FAVOR DEL PERIODO ANTERIOR",null,null,null,null,null,null,null,303]
[null,null," TRIBUTO A PAGAR O SALDO A FAVOR",null,null,null,null,null,null,null,304,7683]
[null,null," RETENCIONES",null,null,null,null,null,null,null,326]
[null,null," RETENCIONES DE PERIODOS ANTERIORES",null,null,null,null,null,null,null,327]
[null,null," COMPENSACION SALDO A FAVOR DEL EXPORTADOR",null,null,null,null,null,null,null,305]
[null,null," IMP TEMP A LOS ACT NETOS",null,null,null,null,null,null,null,328]
[null,null," OTROS CREDITOS PERMITIDOS",null,null,null,null,null,null,null,306]
[null,null," PAGOS PREVIOS",null,null,null,null,null,null,null,317]
[null,null," INTERES MORATORIO",null,null,null,null,null,null,null,319]
[null,null," TOTAL DEUDA TRIBUTARIA",null,null,null,null,null,null,null,324,7683]
[null,null," IMPORTE A PAGAR",null,null,null,null,null,null,null,307,0]
[]
[null,"4ta CATEGORIA",null,null,null,null,null,null,null,null,"4ta Categoria",null,null,"IES"]
[null,null," TRIBUTO A PAGAR O SALDO A FAVOR",null,null,null,null,null,null,null,371,"",null,542,""]
[null,null," PAGOS PREVIOS",null,null,null,null,null,null,null,372,"",null,543,""]
[]
[null,null," INTERES MORATORIO",null,null,null,null,null,null,null,374,"",null,545,""]
[null,null," TOTAL DEUDA TRIBUTARIA",null,null,null,null,null,null,null,375,"",null,546,""]
[null,null," IMPORTE A PAGAR",null,null,null,null,null,null,null,379,"",null,551,""]
[]
[null,null," IMPOTE TOTAL A PAGAR",null,null,null,0]
[null,null," EFECTIVO",null,null,null,0]
[]
[]
[]
[null,"SUNAT",null,"PDT - IGV RENTA MENSUAL",null,null,null,null,null,null,null,null,"Copia para el\nContribuyente (Pag. 2)"]
[]
[null,"DECLARACION",null,"Periodo 09-2014"]
[]
[null,"PAGO",null,"RUC",null,null,"20547111665",null,null,null,null,null,"Fecha Pres : 21/10/2014"]
[null,621,null,"RAZON SOCIAL",null,null,null,null,null,null,null,null,"N° de Decl : 795917013"]
[]
[]
[null,"COEFICIENTE"]
[null,"COEFICIENTE SISTEMA A"]
[]
[null,null,"Impuesto determinado :",null,null,null,"40783"]
[null,null,"Ingresos Netos :",null,null,null,"1426306"]
[null,null,"Coeficiiente :",null,null,null,"0.0286"]
[]
[]
[]
[]
[null,"SUNAT",null,"PDT - IGV RENTA MENSUAL",null,null,null,null,null,null,null,null,"Copia para el\nContribuyente (Pag. 2)"]
[]
[null,"DECLARACION",null,"Periodo 09-2014"]
[]
[null,"PAGO",null,"RUC",null,null,"20547111665",null,null,null,null,null,"Fecha Pres : 21/10/2014"]
[null,621,null,"RAZON SOCIAL",null,null,null,null,null,null,null,null,"N° de Decl : 795917013"]
[]
[]
[null,"INFORMACION DEL COMPROBANTE DE PERCEPCION ",null,null,null,null,null,null,null,"DOCUMENTO QUE DIO ORIGEN A LA PERCEPCION"]
[null,"Ruc agente de percep.",null,"Serie","Número",null,"Fecha de Emisión","Importe del Comprobante",null,"Tipo     Serie     Número",null,"Fecha de Emisión","Valor Total  Comprobante Pago"]
[null,"20509777145",null,"0004","997",null,"02/09/2014",null,"1.69"]
[null,"20509777145",null,"0004","1001",null,"04/09/2014",null,"37.27"]
[null,"20509777145",null,"0004","1020",null,"12/09/2014",null,"33.56"]
[null,"20509777145",null,"0004","1028",null,"18/09/2014",null,"17.55"]
[null,"20509777145",null,"0004","1050",null,"29/09/2014",null,"33.56"]
[null,"5 Registros",null,null,"Total :",null,null,null,"123.63"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SUNAT",null,"PDT - IGV RENTA MENSUAL",null,null,null,null,null,null,null,null,"Copia para el\nContribuyente (Pag. 2)"]
[]
[null,"DECLARACION",null,"Periodo 09-2014"]
[]
[null,"PAGO",null,"RUC",null,null,"20547111665",null,null,null,null,null,"Fecha Pres : 21/10/2014"]
[null,621,null,"RAZON SOCIAL",null,null,null,null,null,null,null,null,"N° de Decl : 795917013"]
[]
[]
[null,"INFORMACION DEL COMPROBANTE DE RETENCION",null,null,null,null,null,null,null,"DOCUMENTO QUE DIO ORIGEN A LA RETENCION"]
[null,"Ruc agente de Retenc.",null,"Serie","Número",null,"Fecha de Emisión","Importe del Comprobante",null,"Tipo     Serie     Número",null,"Fecha de Emisión","Valor Total  Comprobante Pago"]
[null,"20100190797",null,"0941","26491",null,"12/09/2014",null,"41.04"]
[null,"20101250572",null,"0001","9877",null,"18/09/2014",null,"29.6"]
[null,"20166018022",null,"0001","2526",null,"28/08/2014",null,"67.12"]
[null,"20166018022",null,"0001","2534",null,"01/09/2014",null,"26.55"]
[null,"20296637697",null,"0007","768",null,"01/09/2014",null,"1261.76"]
[null,"20296637697",null,"0007","806",null,"19/09/2014",null,"111.63"]
[null,"20418453177",null,"0008","12728",null,"16/05/2014",null,"77.69"]
[null,"20431084172",null,"0001","716",null,"31/07/2014",null,"1093.22"]
[null,"20506342563",null,"0001","5319",null,"05/09/2014",null,"53.52"]
[null,"20506475288",null,"0001","1037",null,"19/09/2014",null,"135.43"]
[null,"20510992904",null,"0001","3429",null,"13/08/2014",null,"80.71"]
[null,"20510992904",null,"0001","3458",null,"10/09/2014",null,"35.4"]
[null,"20511535612",null,"0001","2458",null,"02/07/2014",null,"224.66"]
[null,"20511535612",null,"0001","2543",null,"17/07/2014",null,"435.06"]
[null,"20511535612",null,"0001","2714",null,"22/08/2014",null,"124.6"]
[null,"20538810682",null,"0001","334",null,"27/08/2014",null,"140.18"]
[null,"20538810682",null,"0001","343",null,"10/09/2014",null,"43.36"]
[null,"20538810682",null,"0001","346",null,"17/09/2014",null,"247.23"]
[null,"20538810682",null,"0001","350",null,"24/09/2014",null,"280.2"]
[null,"19 Registros",null,null,"Total :",null,null,null,"4508.96"]