{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Portada","Centralización","Libro de Remuneraciones","Resumen ","instructivo","Hoja1"],"not_rendered":{"charts":1,"images":18,"macros":1,"external_links":0,"defined_names":13,"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":"Portada","index":0,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":true,"merged":[[24,1,26,1],[3,4,3,9],[4,4,4,9],[5,4,5,9],[6,4,6,9],[7,4,7,9],[8,4,8,9],[9,4,9,9],[10,4,10,9],[15,1,15,9],[49,7,50,10],[42,7,44,10],[35,0,35,1],[29,0,29,1],[45,0,46,1]]}
[]
[null,null,null,null,"REMUNERACIONES MENSUALES"]
[]
[null,null,null,"Nombre/ Razón Social","NUBOX"]
[null,null,null,"RUT","11.111.111-1"]
[null,null,null,"Representante Legal","Alexander Russo"]
[null,null,null,"C.I. Representante Legal","1.111.111-1"]
[null,null,null,"Contador ","Dayana Huala"]
[null,null,null,"C.I. Contador","1.111.111-1"]
[null,null,null,"Mes","Marzo"]
[null,null,null,"Año Comercial",2021]
[]
[]
[]
[]
[null,"Ingresar Información de la Liquidación de Sueldo"]
[]
[]
[]
[null,null,null,"N°"]
[null,null,null,"Nombre"]
[null,null,null,"R.U.T"]
[null,null,null,"Fecha de Ingreso"]
[null,null,null,"Cargo"]
[null,"SELECCIONAR DE LA LISTA DESPLEGABLE",null,"Tipo de Contrato"]
[null,null,null,"Sistema de Salud"]
[null,null,null,"Nombre AFP"]
[null,null,null,"Días Trabajados"]
[null,null,null,"Sueldo Base",null,null,null,"DATO PRIMORDIAL PARA EL CÁLCULO DE LAS REMUNERACIONES"]
["CÁLCULO AUTOMÁTICO",null,null,"Gratificación Legal",{"$f":"+E29*25%","v":0}]
[null,null,null,"Horas Extras",0]
[null,null,null,"Horas Sábado",0]
[null,null,null,"Horas Feriados",0,null,null,"INGRESO MANUAL"]
[null,null,null,"Horas Menos",0]
[null,null,null,"Bonos Imponibles",0]
["CÁLCULO AUTOMÁTICO",null,null,"Total Imponible",{"$f":"+E29+E30+E31+E32+E33+E34+E35","v":0}]
[null,null,null,"Bono Movilización"]
[null,null,null,"Bono Colación"]
[null,null,null,"Bono Desgaste de Herramientas",0,null,null,"INGRESO MANUAL"]
[null,null,null,"Bono Perdida de Caja",0]
[null,null,null,"Asignación Familiar",0]
[null,null,null,"Total Haber",{"$f":"+E36+E37+E38+E39+E40+E41","v":0}]
[null,null,null,"AFP",{"$f":"+E36*10.77%","v":0},null,null,"INGRESAR INDICADORES SEGÚN CORRESPONDA AFP/SALUD /SEGURO DE CESANTÍA"]
[null,null,null,"Salud",{"$f":"+E36*7%","v":0}]
[null,null,null,"Seguro de Cesantía",{"$f":"+E36*0.6%","v":0}]
["CALCULO AUTOMÁTICO",null,null,"Total Descuentos",{"$f":"+E43+E44+E45","v":0}]
[null,null,null,"Alcance Líquido",{"$f":"+E42-E46","v":0}]
[null,null,null,"Anticipo de Sueldos"]
[null,null,null,"Sueldo Líquido",{"$f":"+E47-E48","v":0}]
[null,null,null,"2,4% Aporte Empleador  Seguro de cesantía",{"$f":"+E36*2.4%","v":0},null,null,"INGRESAR INDICADORES SEGÚN CORRESPONDA APORTE EMPLEADOR 2,4% /  ACC DE ACUERDO AL ACCIDENTE DEL TRABAJO PACTADA (0,95%)"]
[null,null,null,"0,95 % ACC.",{"$f":"+E36*0.95%","v":0}]

{"sheet":"Centralización","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":true,"merged":[[7,3,7,4],[9,3,9,4],[1,5,1,11],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4]]}
[]
[null,null,null,null,null,"CENTRALIZACIÓN DE REMUNERACIONES"]
[null,null,null,"Nombre/ Razón Social",null,{"$f":"+Portada!E4:J4","v":0}]
[null,null,null,"RUT",null,{"$f":"+Portada!E5:J5","v":0}]
[null,null,null,"Representante Legal",null,{"$f":"+Portada!E6:J6","v":0}]
[null,null,null,"C.I. Representante Legal",null,{"$f":"+Portada!E7:J7","v":0}]
[null,null,null,"Contador",null,{"$f":"+Portada!E8:J8","v":0}]
[null,null,null,"C.I. Contador",null,{"$f":"+Portada!E9:J9","v":0}]
[null,null,null,"Mes",null,{"$f":"+Portada!E10:J10","v":0}]
[null,null,null,"Año Comercial",null,{"$f":"+Portada!E11:J11","v":0}]
[]
[]
[null,null,"N° de Cuenta","Nombre de Cuenta","Debe","Haber"]
[null,null,3103001,"Remuneraciones",{"$f":"+'Libro de Remuneraciones'!S121","v":1000000}]
[null,null,3103016,"Movilización",{"$f":"+'Libro de Remuneraciones'!T121","v":180000}]
[null,null,3103015,"Colación",{"$f":"+'Libro de Remuneraciones'!$U$121","v":180000}]
[null,null,3103018,"Desgaste de Herramientas",{"$f":"+'Libro de Remuneraciones'!V121","v":0}]
[null,null,3103019,"Pérdida de Caja",{"$f":"+'Libro de Remuneraciones'!W121","v":0}]
[null,null,3103020,"Asignación Familiar",{"$f":"+'Libro de Remuneraciones'!X121","v":0}]
[null,null,3103007,"Aporte Patronal",{"$f":"+'Libro de Remuneraciones'!AG121","v":24000}]
[null,null,3103018,"Acc. Trabajo",{"$f":"+'Libro de Remuneraciones'!AH121","v":9500}]
[null,null,2107000,"Anticipo de Suelo",null,{"$f":"+'Libro de Remuneraciones'!AE121","v":1100}]
[null,null,2107001,"AFP X Pagar",null,{"$f":"+'Libro de Remuneraciones'!Z121","v":107699.99999999997}]
[null,null,2107002,"Salud X Pagar",null,{"$f":"+'Libro de Remuneraciones'!AA121","v":70000}]
[null,null,2108003,"Aporte Patronal X Pagar",null,{"$f":"+'Libro de Remuneraciones'!AG121","v":24000}]
[null,null,2108001,"Seguro de Cesantía X Pagar",null,{"$f":"+'Libro de Remuneraciones'!AB121","v":6000}]
[null,null,2107003,"Acc. Trabajo X pagar",null,{"$f":"+'Libro de Remuneraciones'!AH121","v":9500}]
[null,null,2106001,"Sueldos X Pagar",null,{"$f":"+'Libro de Remuneraciones'!AF121","v":1175200}]
[null,null,null,null,{"$f":"SUM(E14:E28)","v":1393500},{"$f":"SUM(F14:F28)","v":1393500}]

{"sheet":"Libro de Remuneraciones","index":2,"n_rows":121,"n_cols":34,"rows_kept":121,"cut":false,"hidden":true,"merged":[[1,5,1,12],[2,3,2,4],[3,3,3,4],[7,3,7,4],[9,3,9,4],[4,3,4,4],[5,3,5,4],[6,3,6,4]]}
[]
[null,null,null,null,null,"LIBRO DE REMUNERACIONES"]
[null,null,null,"Nombre/ Razón Social",null,{"$f":"+Portada!E4:J4","v":0}]
[null,null,null,"RUT",null,{"$f":"+Portada!E5:J5","v":0}]
[null,null,null,"Representante Legal",null,{"$f":"+Portada!E6:J6","v":0}]
[null,null,null,"C.I. Representante Legal",null,{"$f":"+Portada!E7:J7","v":0}]
[null,null,null,"Contador",null,{"$f":"+Portada!E8:J8","v":0}]
[null,null,null,"C.I. Contador",null,{"$f":"+Portada!E9:J9","v":0}]
[null,null,null,"Mes",null,{"$f":"+Portada!E10:J10","v":0}]
[null,null,null,"Año Comercial",null,{"$f":"+Portada!E11:J11","v":0}]
[]
[]
[null,null,"N°","Nombre","R.U.T","Fecha de Ingreso","Cargo","Tipo de Contrato","Sistema de Salud","Nombre AFP","Días Trabajados","Sueldo Base","Gratificación Legal","Horas Extras","Horas Sábado","Horas Feriados","Horas Menos","Bonos Imponibles","Total Imponible","Bono Movilización","Bono Colación","Bono Desgaste de Herramientas","Bono Perdida de Caja","Asignación Familiar","Total Haber","AFP","Salud","Seguro de Cesantía","Total Descuentos","Alcance Líquido","Anticipo de Sueldos","Sueldo Líquido","2,4% Aporte Empleador  Seguro de cesantía","0,95 % ACC."]
[null,null,1,"Jose Pino","22.222.222-2","2020-01-01","Analista Contable","Plazo Fijo","Fonasa ","Modelo",30,200000,{"$f":"+L14*25%","v":50000},0,0,0,0,0,{"$f":"+L14+M14+N14+O14+P14+Q14+R14","v":250000},60000,60000,0,0,0,{"$f":"+S14+T14+U14+V14+W14+X14","v":370000},{"$f":"+S14*10.77%","v":26924.999999999996},{"$f":"+S14*7%","v":17500},{"$f":"+S14*0.6%","v":1500},{"$f":"+Z14+AA14+AB14","v":45925},{"$f":"+Y14-AC14","v":324075},500,{"$f":"+AD14-AE14","v":323575},{"$f":"+S14*2.4%","v":6000},{"$f":"+S14*0.95%","v":2375}]
[null,null,2,"Ana Rojas","33.333.333-3","2015-02-01","Contadora","Plazo Indefinido","Fonasa ","Cuprum",30,300000,{"$f":"+L15*25%","v":75000},0,0,0,0,0,{"$f":"+L15+M15+N15+O15+P15+Q15+R15","v":375000},60000,60000,0,0,0,{"$f":"+S15+T15+U15+V15+W15+X15","v":495000},{"$f":"+S15*10.77%","v":40387.499999999993},{"$f":"+S15*7%","v":26250.000000000004},{"$f":"+S15*0.6%","v":2250},{"$f":"+Z15+AA15+AB15","v":68887.5},{"$f":"+Y15-AC15","v":426112.5},300,{"$f":"+AD15-AE15","v":425812.5},{"$f":"+S15*2.4%","v":9000},{"$f":"+S15*0.95%","v":3562.5}]
[null,null,3,"Ana Lira","33.333.333-3","2015-02-01","Contadora","Plazo Indefinido","Fonasa ","Cuprum",30,300000,{"$f":"+L16*25%","v":75000},0,0,0,0,0,{"$f":"+L16+M16+N16+O16+P16+Q16+R16","v":375000},60000,60000,0,0,0,{"$f":"+S16+T16+U16+V16+W16+X16","v":495000},{"$f":"+S16*10.77%","v":40387.499999999993},{"$f":"+S16*7%","v":26250.000000000004},{"$f":"+S16*0.6%","v":2250},{"$f":"+Z16+AA16+AB16","v":68887.5},{"$f":"+Y16-AC16","v":426112.5},300,{"$f":"+AD16-AE16","v":425812.5},{"$f":"+S16*2.4%","v":9000},{"$f":"+S16*0.95%","v":3562.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L14:L120)","v":800000},{"$f":"SUM(M14:M120)","v":200000},0,0,0,0,0,1000000,180000,180000,0,0,0,1360000,107699.99999999997,70000,6000,183700,1176300,{"$f":"SUM(AE14:AE120)","v":1100},{"$f":"SUM(AF14:AF120)","v":1175200},24000,9500]

{"sheet":"Resumen ","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,4,2,11],[3,4,3,11],[1,4,1,11],[4,4,4,11],[5,4,5,11],[6,4,6,11],[12,3,13,3],[7,4,7,11],[8,4,8,11],[9,4,9,11],[12,4,13,4]]}
[]
[null,null,null,null,"ANÁLISIS DEL GASTO DE REMUNERACIONES"]
[null,null,null,"Nombre/ Razón Social",{"$f":"+Portada!E4:J4","v":"NUBOX"}]
[null,null,null,"RUT",{"$f":"+Portada!E5:J5","v":"11.111.111-1"}]
[null,null,null,"Representante Legal",{"$f":"+Portada!E6:J6","v":"Alexander Russo"}]
[null,null,null,"C.I. Representante Legal",{"$f":"+Portada!E7:J7","v":"1.111.111-1"}]
[null,null,null,"Contador",{"$f":"+Portada!E8:J8","v":"Dayana Huala"}]
[null,null,null,"C.I. Contador",{"$f":"+Portada!E9:J9","v":"1.111.111-1"}]
[null,null,null,"Mes",{"$f":"+Portada!E10:J10","v":"Marzo"}]
[null,null,null,"Año Comercial",{"$f":"+Portada!E11:J11","v":2021}]
[]
[]
[null,null,null,"DESCRIPCIÓN","MONTOS"]
[]
[null,null,null,"N° Trabajadadores",{"$f":"COUNT('Libro de Remuneraciones'!C14:C120)","v":3}]
[null,null,null,"Monto Líquido a Pagar",{"$f":"+Centralización!F28","v":1175200}]
[null,null,null,"Gastos Obligaciones Previsionales",{"$f":"+'Libro de Remuneraciones'!AC121+'Libro de Remuneraciones'!AG121+'Libro de Remuneraciones'!AH121","v":217200}]
[null,null,null,null,{"$f":"+E16+E17","v":1392400}]

{"sheet":"instructivo","index":4,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":true,"merged":[[16,1,17,8],[14,1,15,8],[31,1,32,8],[22,1,24,8],[18,1,18,8],[25,1,25,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Notas iniciales"]
[null,"**Al abrir este archivo, recuerda habilitar el contenido para macros."]
[]
[]
[]
[null,"** Verificar las opciones avanzadas de tu excel para acceder al formato de trabajo de esta plantilla (Visual Basic)."]
[]
[null,"**Para guardar el archivo en el computador de trabajo, se debe guardar como documento habilitado para macros."]
[]
[null,"**Al guardar el documento aparecerá este mensaje, el cual deberás aceptar para respetar fórmulas."]
[]
[]
[]
[]
[]
[]
[null,"**Al abrir el documento se desplegará este mensaje. Haz clic en no actualizar, para mantener fórmulas"]
[]
[]
[]
[]
[]
[null,"**Recuerda revisar todos los mensajes de ayuda y alerta en las páginas dinámicas con las que se trabajarán en este libro. "]
[]
[null,"Ver vídeo explicativo ",null,"aquí"]

{"sheet":"Hoja1","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":true,"merged":[[3,10,6,10],[3,11,3,13],[4,11,4,13],[5,11,5,12]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"AFP","TASA COTIZACIÓN OBLIGATORIO AFP"]
[null,"Enero ",null,"Plazo Fijo",null,"Fonasa ",null,"Capital",null,null,null,"TASA AFP TRABAJADORES"]
[null,"Febrero",null,"Plazo Indefinido",null,"Isapre",null,"Cuprum",null,null,null,"DEPENDIENTES",null,"INDEPENDIENTES"]
[null,"Marzo",null,"Part Time",null,null,null,"Habitat",null,null,null,"TASA AFP","SIS (1) (2)","TASA AFP (3)"]
[null,"Abril",null,"Vinculo Laboral",null,null,null,"Modelo",null,null,"Capital",0.1144,1.9400000000000001E-2,0.1338]
[null,"Mayo",null,"Obra",null,null,null,"Provida",null,null,"Cuprum",0.1144,1.9400000000000001E-2,0.1338]
[null,"Junio",null,null,null,null,null,"Uno",null,null,"Habitat",0.11269999999999999,1.9400000000000001E-2,0.1321]
[null,"Julio",null,null,null,null,null,null,null,null,"PlanVital",0.1116,1.9400000000000001E-2,0.13100000000000001]
[null,"Agosto",null,null,null,null,null,null,null,null,"ProVida",0.1145,1.9400000000000001E-2,0.13389999999999999]
[null,"Septiembre",null,null,null,null,null,null,null,null,"Modelo",0.1077,1.9400000000000001E-2,0.12709999999999999]
[null,"Octubre",null,null,null,null,null,null,null,null,"Uno",0.1069,1.9400000000000001E-2,0.1263]
[null,"Noviembre"]
[null,"Diciembre"]