{"id":17340,"date":"2026-10-16T12:38:04","date_gmt":"2026-10-16T10:38:04","guid":{"rendered":"https:\/\/nailted.com\/blog\/?p=17340"},"modified":"2026-10-16T12:38:07","modified_gmt":"2026-10-16T10:38:07","slug":"plantilla-registro-jornada","status":"publish","type":"post","link":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/","title":{"rendered":"Plantilla de registro de jornada laboral en Excel (2026 y 2027)"},"content":{"rendered":"\n<style>\n.nl-app ul{list-style:none!important;margin:16px 0 8px!important;padding:0!important}\n.nl-app li{background:#fff;border-radius:10px;padding:14px 18px;margin:0 0 10px!important;line-height:1.6;box-shadow:0 1px 3px rgba(16,24,40,.07)}\n.nl-app li::marker{content:none}\n.nl-app li strong{display:inline-block;font-size:13px;letter-spacing:.04em;text-transform:uppercase;padding:2px 10px;border-radius:999px;margin-right:8px;line-height:1.7}\n.nl-app li:first-child strong{background:#E3F6EC;color:#0B6B43}\n.nl-app li:last-child strong{background:#FFF1E0;color:#9A4A06}\n.nl-summary li::marker{color:#189AF7}\narticle .schema-faq{display:grid;gap:12px;margin:8px 0 24px}\narticle .schema-faq-section{background:#F5F7FA;border-radius:12px;padding:20px 24px}\narticle .schema-faq-question{display:block;font-size:20px;line-height:1.35;color:#242424;font-weight:700;margin-bottom:8px}\narticle .schema-faq-answer{margin:0!important;line-height:1.65}\n.nl-errors{display:grid;grid-template-columns:repeat(auto-fit,minmax(240px,1fr));gap:16px;margin:8px 0 40px}\n.nl-err{background:#F5F7FA;border-radius:12px;padding:24px}\n.nl-err-n{width:36px;height:36px;border-radius:50%;background:#189AF7;color:#fff;font-weight:900;font-size:17px;display:flex;align-items:center;justify-content:center;margin-bottom:14px}\n.nl-err-t{font-size:19px!important;font-weight:900;color:#242424;line-height:1.3;margin:0 0 8px!important}\n.nl-err-p{font-size:16px!important;line-height:1.6;margin:0!important}\n.nl-cta{display:flex;flex-wrap:wrap;align-items:center;gap:32px;background:linear-gradient(135deg,#189AF7 0%,#0E5FA8 100%);border-radius:16px;padding:40px;margin:48px 0 24px;overflow:hidden}\n.nl-cta-txt{flex:1 1 300px;min-width:0}\n.nl-cta-k{color:#D6ECFF!important;font-size:14px!important;font-weight:700;letter-spacing:.06em;text-transform:uppercase;margin:0 0 10px!important}\n.nl-cta-h{color:#fff!important;font-size:32px!important;line-height:1.2!important;font-weight:900;margin:0 0 12px!important}\n.nl-cta-p{color:#EAF5FD!important;font-size:18px!important;line-height:1.6;margin:0 0 24px!important}\n.nl-cta-img{flex:1 1 280px;min-width:0}\n.nl-cta-img img{width:100%;height:auto;border-radius:10px;box-shadow:0 20px 40px rgba(5,30,70,.35);display:block}\n@media (max-width:600px){.nl-cta{padding:28px}.nl-cta-h{font-size:26px!important}}\na.nl-cta-btn{display:inline-flex;align-items:center;gap:12px;background:#ffffff!important;background-image:none!important;color:#0E5FA8!important;font-weight:900;font-size:17px;letter-spacing:.01em;padding:10px 10px 10px 26px;border-radius:999px;text-decoration:none!important;box-shadow:0 10px 24px rgba(5,30,70,.28),inset 0 0 0 1px rgba(255,255,255,.6);transition:transform .18s ease,box-shadow .18s ease}\na.nl-cta-btn .nl-arrow{display:inline-flex;align-items:center;justify-content:center;width:40px;height:40px;border-radius:50%;background:#189AF7;color:#ffffff;transition:transform .18s ease}\na.nl-cta-btn:hover{transform:translateY(-2px);box-shadow:0 14px 30px rgba(5,30,70,.34),inset 0 0 0 1px rgba(255,255,255,.6)}\na.nl-cta-btn:hover .nl-arrow{transform:translateX(3px)}\na.nl-cta-btn:focus-visible{outline:3px solid #ffffff;outline-offset:3px}\n.nl-cta-note{display:block;margin-top:14px;color:#D6ECFF;font-size:14px}\narticle h2 + .wp-block-group,article h2 + .nl-errors,article h2 + .schema-faq{margin-top:28px!important}\n.nl-app,.nl-summary{padding-bottom:28px!important}\n.nl-app figure{margin:28px 0!important}\n.nl-app figure figcaption{margin-top:12px!important;font-size:14px;color:#5F6670}\n.nl-app li:last-child{margin-bottom:0!important}\n.nl-app ul:last-child,.nl-summary ul:last-child{margin-bottom:0!important}\n.nl-app h3 + p{margin-bottom:16px!important}\n.nl-cta-h{margin-bottom:16px!important}\n.nl-feats{display:grid;grid-template-columns:1fr 1fr;gap:12px;margin:0 0 16px}.nl-feat{background:#fff;border-radius:10px;padding:16px 18px;box-shadow:0 1px 2px rgba(15,27,51,.06)}.nl-feat-t{font-weight:700;color:#0f1b33;font-size:17px;line-height:1.35;margin:0 0 6px}.nl-feat-p{margin:0;font-size:15.5px;line-height:1.55;color:#4a5672}@media (max-width:600px){.nl-feats{grid-template-columns:1fr}}\nh2+.nl-feats{margin-top:24px}.nl-feats{margin-bottom:40px}.nl-steps{display:grid;gap:12px;margin:24px 0 40px}.nl-step{display:flex;gap:16px;align-items:flex-start;background:#F5F7FA;border-radius:12px;padding:18px 20px}.nl-step-n{flex:0 0 36px;height:36px;border-radius:50%;background:#189AF7;color:#fff;font-weight:700;font-size:16px;display:flex;align-items:center;justify-content:center;margin-top:2px}.nl-step-t{margin:0 0 4px!important;font-weight:700;color:#0F1B33;font-size:17px;line-height:1.4}.nl-step-p{margin:0!important;color:#4A5672;font-size:15.5px;line-height:1.55}.nl-note{background:#EAF5FE;border-left:4px solid #189AF7;border-radius:12px;padding:22px 26px;margin:24px 0 24px}.nl-note-t{margin:0 0 12px!important;font-weight:700;color:#0F1B33;font-size:17px}.nl-note ul{margin:0!important;padding-left:20px}.nl-note li{margin:0 0 8px;color:#273249;line-height:1.6}.nl-note li:last-child{margin-bottom:0}.nl-cta{margin-top:48px!important;margin-bottom:48px!important}\n<\/style>\n<script>(function(){function t(){var p=document.getElementById(\"cu_17360\");if(!p)return;var n=p.querySelector(\"input[name=cu_popup_firstname]\");if(n)n.placeholder=\"Nombre\";var e=p.querySelector(\"input[name=cu_popup_email]\");if(e)e.placeholder=\"Email de trabajo\";p.querySelectorAll(\"*\").forEach(function(el){if(el.children.length===0&&\/No spam\/i.test(el.textContent))el.textContent=\"Sin spam. Puedes darte de baja cuando quieras.\";});}document.addEventListener(\"DOMContentLoaded\",t);window.addEventListener(\"load\",function(){t();setTimeout(t,800);setTimeout(t,2500);});document.addEventListener(\"click\",function(ev){if(ev.target.closest&&ev.target.closest(\"a[href='#cu_17360']\")){setTimeout(t,50);setTimeout(t,400);}});})();<\/script>\n\n\n\n<p>Si todav\u00eda registras la jornada en papel o en una hoja de c\u00e1lculo hecha a mano, esta plantilla te ahorra trabajo: calcula sola las horas de cada d\u00eda, las compara con la jornada pactada y te deja el resumen del mes listo para firmar.<\/p>\n\n\n\n<p>Est\u00e1 en Excel, incluye 2026 y 2027 y funciona tambi\u00e9n en Google Sheets. Te contamos qu\u00e9 incluye, c\u00f3mo usarla y qu\u00e9 exige la ley al registro de jornada.<\/p>\n\n\n\n<div class=\"wp-container-1 wp-block-group nl-summary has-background\" style=\"background-color:#EAF5FD;border-radius:12px;margin-top:0;margin-bottom:32px;padding-top:28px;padding-right:32px;padding-bottom:12px;padding-left:32px\"><div class=\"wp-block-group__inner-container\">\n<p style=\"margin-top:0;margin-bottom:12px\"><strong>En resumen<\/strong><\/p>\n\n\n\n<ul><li>Plantilla de registro de jornada en Excel con los 24 meses de 2026 y 2027, cada uno en su pesta\u00f1a.<\/li><li>Calcula horas trabajadas, previstas y diferencia, y marca solos los fines de semana y los festivos.<\/li><li>Incluye un resumen mensual para firmar y un resumen de cada a\u00f1o.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n\n\n\n<h2>Qu\u00e9 incluye la plantilla<\/h2>\n\n\n\n<div class=\"nl-feats\"><div class=\"nl-feat\"><p class=\"nl-feat-t\">2026 y 2027, mes a mes<\/p><p class=\"nl-feat-p\">Una pesta\u00f1a por mes, con sus d\u00edas y el d\u00eda de la semana ya puestos.<\/p><\/div><div class=\"nl-feat\"><p class=\"nl-feat-t\">Dos tramos por d\u00eda<\/p><p class=\"nl-feat-p\">Entrada y salida, y un segundo tramo para la jornada partida o la pausa de la comida.<\/p><\/div><div class=\"nl-feat\"><p class=\"nl-feat-t\">Fines de semana y festivos<\/p><p class=\"nl-feat-p\">Se marcan solos. A\u00f1ades los festivos de tu centro una vez y la plantilla los descuenta.<\/p><\/div><div class=\"nl-feat\"><p class=\"nl-feat-t\">Incidencias<\/p><p class=\"nl-feat-p\">Vacaciones, baja, permiso, ausencia justificada, festivo local o teletrabajo, con un desplegable.<\/p><\/div><div class=\"nl-feat\"><p class=\"nl-feat-t\">Horas extra a la vista<\/p><p class=\"nl-feat-p\">Cada d\u00eda compara las horas trabajadas con la jornada pactada y colorea la diferencia.<\/p><\/div><div class=\"nl-feat\"><p class=\"nl-feat-t\">Resumen para firmar<\/p><p class=\"nl-feat-p\">Total del mes con espacio para la firma de la persona y de la empresa, y un resumen de cada a\u00f1o.<\/p><\/div><\/div>\n\n\n\n<div class=\"nl-cta\"><div class=\"nl-cta-txt\"><p class=\"nl-cta-k\">Plantilla de registro de jornada<\/p><p class=\"nl-cta-h\">Descarga la plantilla de registro de jornada 2026 y 2027<\/p><p class=\"nl-cta-p\">Excel con los 24 meses de 2026 y 2027, horas extra, resumen mensual para firmar y resumen anual. Funciona tambi\u00e9n en Google Sheets.<\/p><a class=\"nl-cta-btn cu-popup\" href=\"#cu_17360\">Descargar plantilla<span class=\"nl-arrow\" aria-hidden=\"true\"><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M5 12h14\"><\/path><path d=\"M13 6l6 6-6 6\"><\/path><\/svg><\/span><\/a><\/div><div class=\"nl-cta-img\"><span class=\"placeholder-el\" data-svq-align=\"\"><img src=\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/plantilla-registro-jornada-2026-2027-portada-45x35.jpg\" alt=\"Vista previa de la plantilla de registro de jornada 2026\" loading=\"lazy\" class=\"lazy\" data-width=\"2048\" data-height=\"1600\" data-src=\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/plantilla-registro-jornada-2026-2027-portada.jpg\" style=\"height: 0; width: 2048px; padding-bottom: 78.13%;\"><span class=\"svq-img-loader\"><\/span><\/span><noscript><img src=\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/plantilla-registro-jornada-2026-2027-portada.jpg\" alt=\"Vista previa de la plantilla de registro de jornada 2026\" loading=\"lazy\"><\/noscript><\/div><\/div>\n\n\n\n<h2>C\u00f3mo usar la plantilla en 4 pasos<\/h2>\n\n\n\n<div class=\"nl-steps\"><div class=\"nl-step\"><div class=\"nl-step-n\">1<\/div><div><p class=\"nl-step-t\">Rellena la pesta\u00f1a \u00abDatos\u00bb<\/p><p class=\"nl-step-p\">Empresa, persona trabajadora y jornada diaria pactada. A\u00f1ade tambi\u00e9n los festivos de tu centro de trabajo.<\/p><\/div><\/div><div class=\"nl-step\"><div class=\"nl-step-n\">2<\/div><div><p class=\"nl-step-t\">Apunta la entrada y la salida<\/p><p class=\"nl-step-p\">Cada d\u00eda, la hora de inicio y de fin. Si hay pausa, usa el segundo tramo.<\/p><\/div><\/div><div class=\"nl-step\"><div class=\"nl-step-n\">3<\/div><div><p class=\"nl-step-t\">Marca las incidencias<\/p><p class=\"nl-step-p\">Vacaciones, baja o permiso, para que esos d\u00edas no cuenten como horas previstas.<\/p><\/div><\/div><div class=\"nl-step\"><div class=\"nl-step-n\">4<\/div><div><p class=\"nl-step-t\">Revisa y firma el total del mes<\/p><p class=\"nl-step-p\">La diferencia te muestra las horas extra. Las pesta\u00f1as \u00abResumen 2026\u00bb y \u00abResumen 2027\u00bb suman los doce meses de cada a\u00f1o.<\/p><\/div><\/div><\/div>\n\n\n\n<h2>Qu\u00e9 exige la ley al registro de jornada<\/h2>\n\n\n\n<div class=\"nl-note\"><p class=\"nl-note-t\">Lo que dice la normativa en Espa\u00f1a<\/p><ul><li>La empresa debe registrar cada d\u00eda la hora concreta de inicio y de fin de la jornada de cada persona (art\u00edculo 34.9 del Estatuto de los Trabajadores).<\/li><li>El registro se organiza por convenio, acuerdo de empresa o, si no hay ninguno, decisi\u00f3n de la empresa tras consultar a la representaci\u00f3n legal.<\/li><li>Los registros se conservan cuatro a\u00f1os, a disposici\u00f3n de la plantilla, sus representantes y la Inspecci\u00f3n de Trabajo.<\/li><li>En jornada parcial, el registro se totaliza cada mes y se entrega copia del resumen junto con la n\u00f3mina (art\u00edculo 12.4.c).<\/li><li>Quien teletrabaja tambi\u00e9n registra su jornada (art\u00edculo 14 de la Ley 10\/2021).<\/li><\/ul><\/div>\n\n\n\n<p>La ley no fija un formato concreto, as\u00ed que una hoja de c\u00e1lculo es v\u00e1lida hoy. Si te preguntas si el fichaje digital ser\u00e1 obligatorio, lo explicamos en nuestra gu\u00eda sobre el <a href=\"https:\/\/nailted.com\/blog\/es\/registro-horario-digital-obligatorio\/\">registro horario digital obligatorio<\/a>.<\/p>\n\n\n\n<h2>Cu\u00e1ndo se te queda corta una plantilla<\/h2>\n\n\n\n<p>Una plantilla funciona bien con pocas personas y horarios estables. Se queda corta en tres situaciones:<\/p>\n\n\n\n<div class=\"nl-feats\"><div class=\"nl-feat\"><p class=\"nl-feat-t\">Persigues hojas cada mes<\/p><p class=\"nl-feat-p\">Recoger y revisar la hoja de cada persona del equipo se convierte en una tarea fija.<\/p><\/div><div class=\"nl-feat\"><p class=\"nl-feat-t\">Hay personas en remoto o en varios centros<\/p><p class=\"nl-feat-p\">Cada una lleva su archivo y es dif\u00edcil tener una visi\u00f3n de conjunto.<\/p><\/div><div class=\"nl-feat\"><p class=\"nl-feat-t\">Necesitas demostrar los cambios<\/p><p class=\"nl-feat-p\">En una hoja de c\u00e1lculo no queda rastro de qui\u00e9n cambi\u00f3 un registro ni cu\u00e1ndo.<\/p><\/div><div class=\"nl-feat\"><p class=\"nl-feat-t\">Quieres ver las horas extra a tiempo<\/p><p class=\"nl-feat-p\">Con una hoja por persona, las horas extra se descubren a final de mes, no cuando se acumulan.<\/p><\/div><\/div>\n\n\n\n<p>Si est\u00e1s en ese punto, tienes nuestra <a href=\"https:\/\/nailted.com\/blog\/es\/sistema-fichaje-empresas\/\">gu\u00eda para elegir un sistema de fichaje<\/a> y nuestra <a href=\"https:\/\/nailted.com\/blog\/es\/mejores-apps-control-horario\/\">comparativa de apps de control horario<\/a>.<\/p>\n\n\n\n<h2>Preguntas frecuentes<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1792145043865\"><strong class=\"schema-faq-question\">\u00bfEs v\u00e1lido llevar el registro de jornada en Excel?<\/strong> <p class=\"schema-faq-answer\">La ley no exige un formato concreto. Lo que pide es un registro diario de inicio y fin de jornada, organizado y documentado, que se conserve cuatro a\u00f1os.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1792145043866\"><strong class=\"schema-faq-question\">\u00bfHay que firmar el registro de jornada?<\/strong> <p class=\"schema-faq-answer\">La ley no exige firmar cada d\u00eda. La plantilla incluye un espacio de firma mensual por si quieres dejar constancia, algo \u00fatil en jornada parcial, donde hay que entregar el resumen mensual con la n\u00f3mina.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1792145043867\"><strong class=\"schema-faq-question\">\u00bfCu\u00e1nto tiempo hay que guardar el registro?<\/strong> <p class=\"schema-faq-answer\">Cuatro a\u00f1os, a disposici\u00f3n de la plantilla, sus representantes y la Inspecci\u00f3n de Trabajo.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1792145043868\"><strong class=\"schema-faq-question\">\u00bfSirve para teletrabajo?<\/strong> <p class=\"schema-faq-answer\">S\u00ed. Quien teletrabaja tambi\u00e9n debe registrar su jornada, y puedes marcar esos d\u00edas como teletrabajo en la columna de incidencias.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1792145043869\"><strong class=\"schema-faq-question\">\u00bfFunciona en Google Sheets?<\/strong> <p class=\"schema-faq-answer\">S\u00ed. Las f\u00f3rmulas y los formatos est\u00e1n preparados para funcionar en Excel y en Google Sheets.<\/p> <\/div> <\/div>\n\n\n\n<div class=\"nl-cta\"><div class=\"nl-cta-txt\"><p class=\"nl-cta-k\">Control horario de Nailted<\/p><p class=\"nl-cta-h\">Registra la jornada sin perseguir a nadie<\/p><p class=\"nl-cta-p\">Con Nailted, el control horario forma parte de tu HRIS: fichaje o parte de horas, aprobaciones, alertas de horas extra e historial inmutable, conectado con ausencias y vacaciones.<\/p><a class=\"nl-cta-btn\" href=\"https:\/\/nailted.com\/es\/book-a-demo\">Solicita una demo<span class=\"nl-arrow\" aria-hidden=\"true\"><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M5 12h14\"><\/path><path d=\"M13 6l6 6-6 6\"><\/path><\/svg><\/span><\/a><\/div><div class=\"nl-cta-img\"><span class=\"placeholder-el\" data-svq-align=\"\"><img src=\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/control-horario-nailted-registro-jornada-hd-45x33.jpg\" alt=\"Control horario de Nailted\" loading=\"lazy\" class=\"lazy\" data-width=\"2000\" data-height=\"1450\" data-src=\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/control-horario-nailted-registro-jornada-hd.jpg\" style=\"height: 0; width: 2000px; padding-bottom: 72.50%;\"><span class=\"svq-img-loader\"><\/span><\/span><noscript><img src=\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/control-horario-nailted-registro-jornada-hd.jpg\" alt=\"Control horario de Nailted\" loading=\"lazy\"><\/noscript><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Descarga la plantilla de registro de jornada en Excel para 2026 y 2027: horas extra, resumen mensual para firmar y lo que exige la ley.<\/p>\n","protected":false},"author":16,"featured_media":17362,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"episode_type":"audio","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","cybocfi_hide_featured_image":""},"categories":[389],"tags":[],"series":[],"episode_featured_image":"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/plantilla-registro-jornada-2026-2027-portada.jpg","episode_player_image":"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2020\/11\/Company-culture-matters-1.jpg","download_link":"","player_link":"","audio_player":false,"episode_data":{"playerMode":"dark","subscribeUrls":{"spotify":{"key":"spotify","url":"https:\/\/open.spotify.com\/show\/1Bl7apd3ITSFD45mwUi1Og?si=T_w80oYURZ22ZGjPMD-LsQ","label":"Spotify","class":"spotify","icon":"spotify.png"},"itunes":{"key":"itunes","url":"https:\/\/podcasts.apple.com\/es\/podcast\/company-culture-matters-by-nailted\/id1545900885","label":"iTunes","class":"itunes","icon":"itunes.png"}},"rssFeedUrl":"https:\/\/nailted.com\/blog\/feed\/podcast\/company-culture-matters","embedCode":"<blockquote class=\"wp-embedded-content\" data-secret=\"rwPIgqhA10\"><a href=\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/\">Plantilla de registro de jornada laboral en Excel (2026 y 2027)<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/embed\/#?secret=rwPIgqhA10\" width=\"500\" height=\"350\" title=\"\u00abPlantilla de registro de jornada laboral en Excel (2026 y 2027)\u00bb \u2014 Nailted Blog\" data-secret=\"rwPIgqhA10\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/*! This file is auto-generated *\/\n!function(c,d){\"use strict\";var e=!1,o=!1;if(d.querySelector)if(c.addEventListener)e=!0;if(c.wp=c.wp||{},c.wp.receiveEmbedMessage);else if(c.wp.receiveEmbedMessage=function(e){var t=e.data;if(!t);else if(!(t.secret||t.message||t.value));else if(\/[^a-zA-Z0-9]\/.test(t.secret));else{for(var r,s,a,i=d.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),n=d.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),o=new RegExp(\"^https?:$\",\"i\"),l=0;l<n.length;l++)n[l].style.display=\"none\";for(l=0;l<i.length;l++)if(r=i[l],e.source!==r.contentWindow);else{if(r.removeAttribute(\"style\"),\"height\"===t.message){if(1e3<(s=parseInt(t.value,10)))s=1e3;else if(~~s<200)s=200;r.height=s}if(\"link\"===t.message)if(s=d.createElement(\"a\"),a=d.createElement(\"a\"),s.href=r.getAttribute(\"src\"),a.href=t.value,!o.test(a.protocol));else if(a.host===s.host)if(d.activeElement===r)c.top.location.href=t.value}}},e)c.addEventListener(\"message\",c.wp.receiveEmbedMessage,!1),d.addEventListener(\"DOMContentLoaded\",t,!1),c.addEventListener(\"load\",t,!1);function t(){if(o);else{o=!0;for(var e,t,r,s=-1!==navigator.appVersion.indexOf(\"MSIE 10\"),a=!!navigator.userAgent.match(\/Trident.*rv:11\\.\/),i=d.querySelectorAll(\"iframe.wp-embedded-content\"),n=0;n<i.length;n++){if(!(r=(t=i[n]).getAttribute(\"data-secret\")))r=Math.random().toString(36).substr(2,10),t.src+=\"#?secret=\"+r,t.setAttribute(\"data-secret\",r);if(s||a)(e=t.cloneNode(!0)).removeAttribute(\"security\"),t.parentNode.replaceChild(e,t);t.contentWindow.postMessage({message:\"ready\",secret:r},\"*\")}}}}(window,document);\n<\/script>\n"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Plantilla de registro de jornada en Excel (2026 y 2027)<\/title>\n<meta name=\"description\" content=\"Descarga la plantilla de registro de jornada en Excel para 2026 y 2027: horas extra, resumen mensual para firmar y lo que exige la ley.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Plantilla de registro de jornada en Excel (2026 y 2027)\" \/>\n<meta property=\"og:description\" content=\"Descarga la plantilla de registro de jornada en Excel para 2026 y 2027: horas extra, resumen mensual para firmar y lo que exige la ley.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/\" \/>\n<meta property=\"og:site_name\" content=\"Nailted Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/nailted\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-16T10:38:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-16T10:38:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/plantilla-registro-jornada-2026-2027-portada.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2048\" \/>\n\t<meta property=\"og:image:height\" content=\"1600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"David De Luis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@_nailted\" \/>\n<meta name=\"twitter:site\" content=\"@_nailted\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"David De Luis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/\"},\"author\":{\"name\":\"David De Luis\",\"@id\":\"https:\/\/nailted.com\/blog\/#\/schema\/person\/d255fab0bacfe23adc6db433a22abc72\"},\"headline\":\"Plantilla de registro de jornada laboral en Excel (2026 y 2027)\",\"datePublished\":\"2026-10-16T10:38:04+00:00\",\"dateModified\":\"2026-10-16T10:38:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/\"},\"wordCount\":911,\"publisher\":{\"@id\":\"https:\/\/nailted.com\/blog\/#organization\"},\"articleSection\":[\"Gesti\u00f3n de RRHH\"],\"inLanguage\":\"es\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/\",\"url\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/\",\"name\":\"Plantilla de registro de jornada en Excel (2026 y 2027)\",\"isPartOf\":{\"@id\":\"https:\/\/nailted.com\/blog\/#website\"},\"datePublished\":\"2026-10-16T10:38:04+00:00\",\"dateModified\":\"2026-10-16T10:38:07+00:00\",\"description\":\"Descarga la plantilla de registro de jornada en Excel para 2026 y 2027: horas extra, resumen mensual para firmar y lo que exige la ley.\",\"mainEntity\":[{\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043865\"},{\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043866\"},{\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043867\"},{\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043868\"},{\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043869\"}],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nailted.com\/blog\/#website\",\"url\":\"https:\/\/nailted.com\/blog\/\",\"name\":\"Nailted Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/nailted.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nailted.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/nailted.com\/blog\/#organization\",\"name\":\"Nailted Blog\",\"url\":\"https:\/\/nailted.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/nailted.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2020\/04\/blue@3x.svg\",\"contentUrl\":\"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2020\/04\/blue@3x.svg\",\"width\":125,\"height\":31,\"caption\":\"Nailted Blog\"},\"image\":{\"@id\":\"https:\/\/nailted.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/nailted\/\",\"https:\/\/twitter.com\/_nailted\",\"https:\/\/www.linkedin.com\/company\/nailted\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/nailted.com\/blog\/#\/schema\/person\/d255fab0bacfe23adc6db433a22abc72\",\"name\":\"David De Luis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/nailted.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7d6f02aa649314e0517cd98b253036c6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7d6f02aa649314e0517cd98b253036c6?s=96&d=mm&r=g\",\"caption\":\"David De Luis\"},\"url\":\"https:\/\/nailted.com\/blog\/author\/david\/\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043865\",\"position\":1,\"url\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043865\",\"name\":\"\u00bfEs v\u00e1lido llevar el registro de jornada en Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"La ley no exige un formato concreto. Lo que pide es un registro diario de inicio y fin de jornada, organizado y documentado, que se conserve cuatro a\u00f1os.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043866\",\"position\":2,\"url\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043866\",\"name\":\"\u00bfHay que firmar el registro de jornada?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"La ley no exige firmar cada d\u00eda. La plantilla incluye un espacio de firma mensual por si quieres dejar constancia, algo \u00fatil en jornada parcial, donde hay que entregar el resumen mensual con la n\u00f3mina.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043867\",\"position\":3,\"url\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043867\",\"name\":\"\u00bfCu\u00e1nto tiempo hay que guardar el registro?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Cuatro a\u00f1os, a disposici\u00f3n de la plantilla, sus representantes y la Inspecci\u00f3n de Trabajo.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043868\",\"position\":4,\"url\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043868\",\"name\":\"\u00bfSirve para teletrabajo?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"S\u00ed. Quien teletrabaja tambi\u00e9n debe registrar su jornada, y puedes marcar esos d\u00edas como teletrabajo en la columna de incidencias.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043869\",\"position\":5,\"url\":\"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043869\",\"name\":\"\u00bfFunciona en Google Sheets?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"S\u00ed. Las f\u00f3rmulas y los formatos est\u00e1n preparados para funcionar en Excel y en Google Sheets.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Plantilla de registro de jornada en Excel (2026 y 2027)","description":"Descarga la plantilla de registro de jornada en Excel para 2026 y 2027: horas extra, resumen mensual para firmar y lo que exige la ley.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/","og_locale":"es_ES","og_type":"article","og_title":"Plantilla de registro de jornada en Excel (2026 y 2027)","og_description":"Descarga la plantilla de registro de jornada en Excel para 2026 y 2027: horas extra, resumen mensual para firmar y lo que exige la ley.","og_url":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/","og_site_name":"Nailted Blog","article_publisher":"https:\/\/www.facebook.com\/nailted\/","article_published_time":"2026-10-16T10:38:04+00:00","article_modified_time":"2026-10-16T10:38:07+00:00","og_image":[{"width":2048,"height":1600,"url":"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2026\/10\/plantilla-registro-jornada-2026-2027-portada.jpg","type":"image\/jpeg"}],"author":"David De Luis","twitter_card":"summary_large_image","twitter_creator":"@_nailted","twitter_site":"@_nailted","twitter_misc":{"Escrito por":"David De Luis","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#article","isPartOf":{"@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/"},"author":{"name":"David De Luis","@id":"https:\/\/nailted.com\/blog\/#\/schema\/person\/d255fab0bacfe23adc6db433a22abc72"},"headline":"Plantilla de registro de jornada laboral en Excel (2026 y 2027)","datePublished":"2026-10-16T10:38:04+00:00","dateModified":"2026-10-16T10:38:07+00:00","mainEntityOfPage":{"@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/"},"wordCount":911,"publisher":{"@id":"https:\/\/nailted.com\/blog\/#organization"},"articleSection":["Gesti\u00f3n de RRHH"],"inLanguage":"es"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/","url":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/","name":"Plantilla de registro de jornada en Excel (2026 y 2027)","isPartOf":{"@id":"https:\/\/nailted.com\/blog\/#website"},"datePublished":"2026-10-16T10:38:04+00:00","dateModified":"2026-10-16T10:38:07+00:00","description":"Descarga la plantilla de registro de jornada en Excel para 2026 y 2027: horas extra, resumen mensual para firmar y lo que exige la ley.","mainEntity":[{"@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043865"},{"@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043866"},{"@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043867"},{"@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043868"},{"@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043869"}],"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/"]}]},{"@type":"WebSite","@id":"https:\/\/nailted.com\/blog\/#website","url":"https:\/\/nailted.com\/blog\/","name":"Nailted Blog","description":"","publisher":{"@id":"https:\/\/nailted.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nailted.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/nailted.com\/blog\/#organization","name":"Nailted Blog","url":"https:\/\/nailted.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/nailted.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2020\/04\/blue@3x.svg","contentUrl":"https:\/\/nailted.com\/blog\/wp-content\/uploads\/2020\/04\/blue@3x.svg","width":125,"height":31,"caption":"Nailted Blog"},"image":{"@id":"https:\/\/nailted.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/nailted\/","https:\/\/twitter.com\/_nailted","https:\/\/www.linkedin.com\/company\/nailted\/"]},{"@type":"Person","@id":"https:\/\/nailted.com\/blog\/#\/schema\/person\/d255fab0bacfe23adc6db433a22abc72","name":"David De Luis","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/nailted.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7d6f02aa649314e0517cd98b253036c6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7d6f02aa649314e0517cd98b253036c6?s=96&d=mm&r=g","caption":"David De Luis"},"url":"https:\/\/nailted.com\/blog\/author\/david\/"},{"@type":"Question","@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043865","position":1,"url":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043865","name":"\u00bfEs v\u00e1lido llevar el registro de jornada en Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"La ley no exige un formato concreto. Lo que pide es un registro diario de inicio y fin de jornada, organizado y documentado, que se conserve cuatro a\u00f1os.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043866","position":2,"url":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043866","name":"\u00bfHay que firmar el registro de jornada?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"La ley no exige firmar cada d\u00eda. La plantilla incluye un espacio de firma mensual por si quieres dejar constancia, algo \u00fatil en jornada parcial, donde hay que entregar el resumen mensual con la n\u00f3mina.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043867","position":3,"url":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043867","name":"\u00bfCu\u00e1nto tiempo hay que guardar el registro?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Cuatro a\u00f1os, a disposici\u00f3n de la plantilla, sus representantes y la Inspecci\u00f3n de Trabajo.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043868","position":4,"url":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043868","name":"\u00bfSirve para teletrabajo?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"S\u00ed. Quien teletrabaja tambi\u00e9n debe registrar su jornada, y puedes marcar esos d\u00edas como teletrabajo en la columna de incidencias.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043869","position":5,"url":"https:\/\/nailted.com\/blog\/es\/plantilla-registro-jornada\/#faq-question-1792145043869","name":"\u00bfFunciona en Google Sheets?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"S\u00ed. Las f\u00f3rmulas y los formatos est\u00e1n preparados para funcionar en Excel y en Google Sheets.","inLanguage":"es"},"inLanguage":"es"}]}},"_links":{"self":[{"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/posts\/17340"}],"collection":[{"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/comments?post=17340"}],"version-history":[{"count":6,"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/posts\/17340\/revisions"}],"predecessor-version":[{"id":17363,"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/posts\/17340\/revisions\/17363"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/media\/17362"}],"wp:attachment":[{"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/media?parent=17340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/categories?post=17340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/tags?post=17340"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/nailted.com\/blog\/wp-json\/wp\/v2\/series?post=17340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}