{"id":49500,"date":"2026-11-18T06:00:00","date_gmt":"2026-11-18T12:00:00","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=49500"},"modified":"2026-11-13T06:37:52","modified_gmt":"2026-11-13T12:37:52","slug":"plantilla-de-nomina","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/plantilla-de-nomina.html","title":{"rendered":"Plantilla de n\u00f3mina: 7 pasos imprescindibles en Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"49500\" class=\"elementor elementor-49500\" data-elementor-post-type=\"post\">\n\t\t\t\t<section class=\"elementor-element elementor-element-73778fe5 e-con e-atomic-element e-div-block-base e-default-section e-16df859-aeb7 \" data-id=\"73778fe5\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"73778fe5\" id=\"inicio-nomina\" data-e-type=\"e-div-block\" data-id=\"73778fe5\">\n    <div class=\"elementor-element elementor-element-225a18a3 e-con e-atomic-element e-grid-base e-default-div e-316d1203-ed71 \" data-id=\"225a18a3\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"225a18a3\" data-e-type=\"e-grid\" data-id=\"225a18a3\">\n    <div class=\"elementor-element elementor-element-ea7bb10 e-con e-atomic-element e-flexbox-base e-default-div e-d18951f-eb69 \" data-id=\"ea7bb10\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"ea7bb10\" data-e-type=\"e-flexbox\" data-id=\"ea7bb10\">\n    \t\t\t<p class=\"e-6c54d0cd-e0f3 e-paragraph-base e-default-p\" data-interaction-id=\"693dba3b\" data-e-type=\"widget\" data-id=\"693dba3b\">EXCEL \u00b7 ORGANIZACI\u00d3N DE PAGOS<\/p>\n\t\t\t\t\t<h1 data-interaction-id=\"4e751251\" class=\"e-370a86e2-96ad e-heading-base e-default-h1\" data-e-type=\"widget\" data-id=\"4e751251\">Plantilla de n\u00f3mina: 7 pasos imprescindibles en Excel<\/h1>\n\t\t\t\t\t<p class=\"e-320223c8-23b9 e-paragraph-base e-default-p\" data-interaction-id=\"799504ef\" data-e-type=\"widget\" data-id=\"799504ef\">Una <strong>plantilla de n\u00f3mina<\/strong> te ayuda a reunir los datos del per\u00edodo, organizar ingresos y deducciones y revisar el neto a pagar de cada empleado en una estructura uniforme.<\/p>\n\t\t\t\t\t<p class=\"e-24faf20c-6ba5 e-paragraph-base e-default-p\" data-interaction-id=\"668b6a69\" data-e-type=\"widget\" data-id=\"668b6a69\">Aprende a preparar el archivo en siete pasos, comprobar sus f\u00f3rmulas y utilizar los registros para elaborar recibos claros. Incluye un ejemplo ilustrativo y controles para detectar errores frecuentes.<\/p><div id=\"aplic-3748886720\" class=\"gas_fallback-ad_66423--placement_66425\" role=\"region\" aria-label=\"Publicidad\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-9769554880758744\" crossorigin=\"anonymous\"><\/script><insclass=\"adsbygoogle\" style=\"display:inline-block;width:728px;height:90px;\" data-ad-client=\"ca-pub-9769554880758744\" data-ad-slot=\"7268988160\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n\t\t<div class=\"elementor-element elementor-element-2e705de9 e-con e-atomic-element e-flexbox-base e-default-div e-1a02ef1e-c74c \" data-id=\"2e705de9\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2e705de9\" data-e-type=\"e-flexbox\" data-id=\"2e705de9\">\n    \t\t\t<a href=\"#pasos-nomina\" target=\"_self\" class=\"e-79d5e006-4979 e-button-base e-default-a\" data-interaction-id=\"d4895d7\" data-e-type=\"widget\" data-id=\"d4895d7\">\n\tVer los 7 pasos\n<\/a>\n\t\t\t\t\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/plantillas\/plantillas-gratis\" target=\"_self\" class=\"e-6ec06815-fcd2 e-button-base e-default-a\" data-interaction-id=\"57598f06\" data-e-type=\"widget\" data-id=\"57598f06\">\n\tExplorar plantillas de Excel\n<\/a>\n\t\t\n<\/div>\n\n<\/div>\n<div class=\"elementor-element elementor-element-10845b07 e-con e-atomic-element e-flexbox-base e-default-div e-436351bf-6e2a \" data-id=\"10845b07\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"10845b07\" data-e-type=\"e-flexbox\" data-id=\"10845b07\">\n    \t\t\t<img fetchpriority=\"high\" decoding=\"async\" class=\"e-image-base e-default-img e-228156c5-dfa1\" data-interaction-id=\"4ea7358f\" data-e-type=\"widget\" data-id=\"4ea7358f\" id=\"66974\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-excel-7-pasos.jpg\" width=\"1200\" height=\"800\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-excel-7-pasos.jpg 1200w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-excel-7-pasos-300x200.jpg 300w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-excel-7-pasos-1024x683.jpg 1024w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-excel-7-pasos-768x512.jpg 768w\" alt=\"Plantilla de n\u00f3mina en Excel: 7 pasos imprescindibles para organizar ingresos, deducciones y neto a pagar\"\/>\t\t\t\t\t<p class=\"e-50ce384a-dda2 e-paragraph-base e-default-p\" data-interaction-id=\"69e9d0e9\" data-e-type=\"widget\" data-id=\"69e9d0e9\">Organiza el per\u00edodo, los conceptos y las revisiones antes de registrar el pago.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/section>\n<nav class=\"elementor-element elementor-element-60fd719d e-con e-atomic-element e-div-block-base e-default-nav e-b4c3bea-11b5 \" data-id=\"60fd719d\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"60fd719d\" data-e-type=\"e-div-block\" data-id=\"60fd719d\">\n    \t\t\t<h2 data-interaction-id=\"4bd12c74\" class=\"e-5098db84-f862 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"4bd12c74\">Contenido de esta gu\u00eda<\/h2>\n\t\t<div class=\"elementor-element elementor-element-7a1018b7 e-con e-atomic-element e-grid-base e-default-div e-130b9264-8ece \" data-id=\"7a1018b7\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"7a1018b7\" data-e-type=\"e-grid\" data-id=\"7a1018b7\">\n    \t\t\t<a href=\"#que-es-nomina\" target=\"_self\" class=\"e-77e7f20c-4b43 e-button-base e-default-a\" data-interaction-id=\"d92368e\" data-e-type=\"widget\" data-id=\"d92368e\">\n\tQu\u00e9 es y para qu\u00e9 sirve\n<\/a>\n\t\t\t\t\t<a href=\"#columnas-nomina\" target=\"_self\" class=\"e-9458b57-9889 e-button-base e-default-a\" data-interaction-id=\"700f011e\" data-e-type=\"widget\" data-id=\"700f011e\">\n\tDatos y columnas\n<\/a>\n\t\t\t\t\t<a href=\"#pasos-nomina\" target=\"_self\" class=\"e-1bd054bf-6cc8 e-button-base e-default-a\" data-interaction-id=\"1305f011\" data-e-type=\"widget\" data-id=\"1305f011\">\n\t7 pasos imprescindibles\n<\/a>\n\t\t\t\t\t<a href=\"#ejemplo-nomina\" target=\"_self\" class=\"e-68e11eaa-6c01 e-button-base e-default-a\" data-interaction-id=\"1172fcc0\" data-e-type=\"widget\" data-id=\"1172fcc0\">\n\tF\u00f3rmulas y ejemplo\n<\/a>\n\t\t\t\t\t<a href=\"#recibos-nomina\" target=\"_self\" class=\"e-6a588536-a9e9 e-button-base e-default-a\" data-interaction-id=\"171f0185\" data-e-type=\"widget\" data-id=\"171f0185\">\n\tRecibos de n\u00f3mina\n<\/a>\n\t\t\t\t\t<a href=\"#errores-nomina\" target=\"_self\" class=\"e-1533bb7d-2fd2 e-button-base e-default-a\" data-interaction-id=\"3b9608af\" data-e-type=\"widget\" data-id=\"3b9608af\">\n\tErrores y revisi\u00f3n\n<\/a>\n\t\t\t\t\t<a href=\"#recursos-nomina\" target=\"_self\" class=\"e-26e48145-ea7c e-button-base e-default-a\" data-interaction-id=\"e2a00b2\" data-e-type=\"widget\" data-id=\"e2a00b2\">\n\tCat\u00e1logo de plantillas\n<\/a>\n\t\t\t\t\t<a href=\"#preguntas-nomina\" target=\"_self\" class=\"e-2dd7c9df-a0ab e-button-base e-default-a\" data-interaction-id=\"38bad995\" data-e-type=\"widget\" data-id=\"38bad995\">\n\tPreguntas frecuentes\n<\/a>\n\t\t\t\t\t<a href=\"#comentarios-nomina\" target=\"_self\" class=\"e-d2e27ef-1b1d e-button-base e-default-a\" data-interaction-id=\"4014dd2\" data-e-type=\"widget\" data-id=\"4014dd2\">\n\tComentarios\n<\/a>\n\t\t\n<\/div>\n\n<\/nav>\n<section class=\"elementor-element elementor-element-8bcb39a e-con e-atomic-element e-div-block-base e-default-section e-5be35aa8-e458 \" data-id=\"8bcb39a\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"8bcb39a\" id=\"que-es-nomina\" data-e-type=\"e-div-block\" data-id=\"8bcb39a\">\n    <div class=\"elementor-element elementor-element-24874879 e-con e-atomic-element e-flexbox-base e-default-div e-61488e4e-b97f \" data-id=\"24874879\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"24874879\" data-e-type=\"e-flexbox\" data-id=\"24874879\">\n    \t\t\t<h2 data-interaction-id=\"67cd89fa\" class=\"e-77fe22ad-34bf e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"67cd89fa\">Qu\u00e9 es una plantilla de n\u00f3mina y para qu\u00e9 sirve<\/h2>\n\t\t<div class=\"elementor-element elementor-element-1010d031 e-con e-atomic-element e-flexbox-base e-default-div e-2c43e240-62bf \" data-id=\"1010d031\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"1010d031\" data-e-type=\"e-flexbox\" data-id=\"1010d031\">\n    \t\t\t<img decoding=\"async\" class=\"e-image-base e-default-img e-4eec7ddb-835d\" data-interaction-id=\"1175a776\" data-e-type=\"widget\" data-id=\"1175a776\" id=\"62409\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2025\/04\/Roger-Perez-1.png\" width=\"141\" height=\"155\" srcset=\"\" alt=\"Roger P\u00e9rez, creador de Aplica Excel Contable\"\/>\t\t\t\t\t<p class=\"e-57cce9da-6664 e-paragraph-base e-default-p\" data-interaction-id=\"6781125c\" data-e-type=\"widget\" data-id=\"6781125c\">Hola, soy <strong>Roger P\u00e9rez<\/strong>. En esta gu\u00eda te comparto una forma de organizar el c\u00e1lculo de la n\u00f3mina, documentar sus conceptos y comprobar los importes antes de cerrar el per\u00edodo.<\/p>\n\t\t\n<\/div>\n\t\t\t<p class=\"e-40201f23-df5e e-paragraph-base e-default-p\" data-interaction-id=\"70e46812\" data-e-type=\"widget\" data-id=\"70e46812\">Es un archivo preparado para registrar los conceptos de pago de cada persona durante un per\u00edodo definido. Puede incluir identificaci\u00f3n, ingresos, deducciones, totales y datos de seguimiento del pago. En algunos lugares tambi\u00e9n se conoce como planilla de salarios.<\/p>\n\t\t\t\t\t<p class=\"e-100d25ac-706b e-paragraph-base e-default-p\" data-interaction-id=\"2c8991ca\" data-e-type=\"widget\" data-id=\"2c8991ca\">La plantilla de n\u00f3mina aporta una estructura reutilizable. Las f\u00f3rmulas ayudan a sumar y restar importes con la misma l\u00f3gica, mientras que los documentos y las revisiones permiten comprobar de d\u00f3nde procede cada concepto.<\/p>\n\t\t\t\t\t<p class=\"e-7e5d3625-2fba e-paragraph-base e-default-p\" data-interaction-id=\"1f5b276b\" data-e-type=\"widget\" data-id=\"1f5b276b\">Antes de utilizarla, define los conceptos, bases y reglas que correspondan a tu empresa y pa\u00eds. Esta gu\u00eda explica organizaci\u00f3n y operaciones de Excel con importes ficticios; los valores del ejemplo son datos de pr\u00e1ctica.<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"2782403f\" class=\"e-63ab76f8-2d23 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"2782403f\">Ventajas de una estructura consistente<\/h3>\n\t\t<ul class=\"elementor-element elementor-element-23f2e36c e-con e-atomic-element e-list-base e-list e-default-ul e-7d3c8442-95dd \" data-id=\"23f2e36c\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"23f2e36c\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"23f2e36c\">\n\t<li class=\"elementor-element elementor-element-5118ec99 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-5e887a5-60d4 \" data-id=\"5118ec99\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"5118ec99\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"5118ec99\">\n\t<div class=\"elementor-element elementor-element-4c2dec5b e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"4c2dec5b\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"4c2dec5b\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"4c2dec5b\">\n\t\t\t\t<p class=\"e-53967363-290f e-paragraph-base e-default-p\" data-interaction-id=\"5261adda\" data-e-type=\"widget\" data-id=\"5261adda\"><span>\u2022<\/span> <strong>Menos trabajo repetido:<\/strong> conserva encabezados, f\u00f3rmulas y formatos para el siguiente per\u00edodo.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-5b94fca7 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-34f549e8-1ec6 \" data-id=\"5b94fca7\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"5b94fca7\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"5b94fca7\">\n\t<div class=\"elementor-element elementor-element-69853b5a e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"69853b5a\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"69853b5a\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"69853b5a\">\n\t\t\t\t<p class=\"e-f11b609-c6e6 e-paragraph-base e-default-p\" data-interaction-id=\"21c4bf54\" data-e-type=\"widget\" data-id=\"21c4bf54\"><span>\u2022<\/span> <strong>Revisi\u00f3n m\u00e1s clara:<\/strong> separa las entradas de los resultados calculados.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-78092786 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-69131710-8605 \" data-id=\"78092786\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"78092786\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"78092786\">\n\t<div class=\"elementor-element elementor-element-400a933 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"400a933\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"400a933\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"400a933\">\n\t\t\t\t<p class=\"e-48fc73b2-e775 e-paragraph-base e-default-p\" data-interaction-id=\"730fc6a6\" data-e-type=\"widget\" data-id=\"730fc6a6\"><span>\u2022<\/span> <strong>Seguimiento:<\/strong> relaciona los importes con el empleado, el per\u00edodo y el documento que los respalda.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-1c15f0b7 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-133a36b3-14e8 \" data-id=\"1c15f0b7\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"1c15f0b7\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"1c15f0b7\">\n\t<div class=\"elementor-element elementor-element-2cbb4f3b e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"2cbb4f3b\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"2cbb4f3b\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"2cbb4f3b\">\n\t\t\t\t<p class=\"e-22b34998-7ce5 e-paragraph-base e-default-p\" data-interaction-id=\"2c9bc387\" data-e-type=\"widget\" data-id=\"2c9bc387\"><span>\u2022<\/span> <strong>Presentaci\u00f3n:<\/strong> prepara reportes y recibos a partir de registros que ya has comprobado.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-64dd48ce-5438 e-paragraph-base e-default-p\" data-interaction-id=\"dc5117e\" data-e-type=\"widget\" data-id=\"dc5117e\">Una plantilla de n\u00f3mina resulta m\u00e1s \u00fatil cuando tambi\u00e9n establece qui\u00e9n captura, qui\u00e9n revisa y cu\u00e1ndo se confirma el pago. Un resultado calculado debe poder explicarse y contrastarse con sus datos de origen.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-7ed2c929 e-con e-atomic-element e-div-block-base e-default-section e-2aab6585-b787 \" data-id=\"7ed2c929\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"7ed2c929\" id=\"columnas-nomina\" data-e-type=\"e-div-block\" data-id=\"7ed2c929\">\n    <div class=\"elementor-element elementor-element-63c6cbd e-con e-atomic-element e-flexbox-base e-default-div e-18c57fc4-c40c \" data-id=\"63c6cbd\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"63c6cbd\" data-e-type=\"e-flexbox\" data-id=\"63c6cbd\">\n    \t\t\t<h2 data-interaction-id=\"75e8c8e\" class=\"e-5e68b2ef-4330 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"75e8c8e\">Datos que debe organizar tu plantilla de n\u00f3mina<\/h2>\n\t\t\t\t\t<p class=\"e-3dbbd110-9efa e-paragraph-base e-default-p\" data-interaction-id=\"6af675c1\" data-e-type=\"widget\" data-id=\"6af675c1\">Empieza con los campos que necesitas para explicar el c\u00e1lculo. Mant\u00e9n una fila por empleado y per\u00edodo, o utiliza un registro de conceptos con identificadores que permitan resumirlo sin duplicar importes.<\/p>\n\t\t<div class=\"elementor-element elementor-element-243af677 e-con e-atomic-element e-grid-base e-default-div e-2f7fe2ab-b9d0 \" data-id=\"243af677\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"243af677\" data-e-type=\"e-grid\" data-id=\"243af677\">\n    <div class=\"elementor-element elementor-element-1b0c77df e-con e-atomic-element e-flexbox-base e-default-div e-668242aa-8230 \" data-id=\"1b0c77df\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"1b0c77df\" data-e-type=\"e-flexbox\" data-id=\"1b0c77df\">\n    \t\t\t<h3 data-interaction-id=\"3be63f7d\" class=\"e-4904f663-5355 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"3be63f7d\">Identificaci\u00f3n y per\u00edodo<\/h3>\n\t\t\t\t\t<p class=\"e-49c629da-60a0 e-paragraph-base e-default-p\" data-interaction-id=\"6acb8394\" data-e-type=\"widget\" data-id=\"6acb8394\">Registra un c\u00f3digo de empleado, el nombre, el per\u00edodo y la moneda. Si necesitas departamento o centro de costo para un reporte, conserva una clasificaci\u00f3n uniforme.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-a7066f4 e-con e-atomic-element e-flexbox-base e-default-div e-94a5b21-ab86 \" data-id=\"a7066f4\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"a7066f4\" data-e-type=\"e-flexbox\" data-id=\"a7066f4\">\n    \t\t\t<h3 data-interaction-id=\"7f5c3bbb\" class=\"e-445feca5-6ab3 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"7f5c3bbb\">Ingresos del per\u00edodo<\/h3>\n\t\t\t\t\t<p class=\"e-4d03823b-1b50 e-paragraph-base e-default-p\" data-interaction-id=\"52aaa222\" data-e-type=\"widget\" data-id=\"52aaa222\">Separa la base correspondiente al per\u00edodo y los conceptos adicionales que hayas determinado. Cada concepto debe tener una descripci\u00f3n y un respaldo que permitan revisar su importe.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-2589dd51 e-con e-atomic-element e-flexbox-base e-default-div e-6b04dcd0-5069 \" data-id=\"2589dd51\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2589dd51\" data-e-type=\"e-flexbox\" data-id=\"2589dd51\">\n    \t\t\t<h3 data-interaction-id=\"4e2a28eb\" class=\"e-519ae38f-152d e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"4e2a28eb\">Deducciones y retenciones<\/h3>\n\t\t\t\t\t<p class=\"e-58190df1-b102 e-paragraph-base e-default-p\" data-interaction-id=\"45120eb5\" data-e-type=\"widget\" data-id=\"45120eb5\">Identifica cada concepto por separado y documenta c\u00f3mo se obtuvo. Evita usar una sola cifra sin detalle cuando necesitas conocer sus componentes.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-ce9cab3 e-con e-atomic-element e-flexbox-base e-default-div e-5781055f-1918 \" data-id=\"ce9cab3\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"ce9cab3\" data-e-type=\"e-flexbox\" data-id=\"ce9cab3\">\n    \t\t\t<h3 data-interaction-id=\"262af914\" class=\"e-165e770c-7a54 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"262af914\">Resultados y seguimiento<\/h3>\n\t\t\t\t\t<p class=\"e-7d9dec58-f5da e-paragraph-base e-default-p\" data-interaction-id=\"2840c6f7\" data-e-type=\"widget\" data-id=\"2840c6f7\">Calcula total de ingresos, total de deducciones y neto a pagar. Conserva el estado, la fecha y la referencia del pago cuando se haya confirmado.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\t\t\t<p class=\"e-6b5f46a7-37f5 e-paragraph-base e-default-p\" data-interaction-id=\"6427b327\" data-e-type=\"widget\" data-id=\"6427b327\">En una plantilla de n\u00f3mina, los nombres y c\u00f3digos deben mantenerse consistentes entre el cat\u00e1logo, el c\u00e1lculo y los recibos. Utiliza identificadores \u00fanicos para evitar confundir personas con nombres parecidos.<\/p>\n\t\t\t\t\t<p class=\"e-5e3eadef-2902 e-paragraph-base e-default-p\" data-interaction-id=\"2e76c6c\" data-e-type=\"widget\" data-id=\"2e76c6c\">Distingue un cero confirmado de un dato que todav\u00eda falta. Una celda vac\u00eda puede indicar una captura pendiente; no la interpretes autom\u00e1ticamente como ausencia de un concepto sin revisar el caso.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-7b40260f e-con e-atomic-element e-div-block-base e-default-section e-2a7249b-8228 \" data-id=\"7b40260f\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"7b40260f\" id=\"pasos-nomina\" data-e-type=\"e-div-block\" data-id=\"7b40260f\">\n    <div class=\"elementor-element elementor-element-514d162e e-con e-atomic-element e-flexbox-base e-default-div e-6910483e-8572 \" data-id=\"514d162e\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"514d162e\" data-e-type=\"e-flexbox\" data-id=\"514d162e\">\n    \t\t\t<h2 data-interaction-id=\"3fdcca13\" class=\"e-3a351f10-b202 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"3fdcca13\">7 pasos imprescindibles para preparar tu plantilla de n\u00f3mina<\/h2>\n\t\t\t\t\t<p class=\"e-24f4822e-2a12 e-paragraph-base e-default-p\" data-interaction-id=\"7763ed7f\" data-e-type=\"widget\" data-id=\"7763ed7f\">Sigue este orden para construir una base que puedas revisar y mantener. Empieza con un ejemplo peque\u00f1o y a\u00f1ade nuevos conceptos cuando hayas comprobado c\u00f3mo afectan al resultado.<\/p>\n\t\t<div class=\"elementor-element elementor-element-b769676 e-con e-atomic-element e-flexbox-base e-default-div e-61a08f80-fab4 \" data-id=\"b769676\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"b769676\" data-e-type=\"e-flexbox\" data-id=\"b769676\">\n    \t\t\t<h3 data-interaction-id=\"22ed8757\" class=\"e-6d5c58f0-4031 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"22ed8757\">1. Define el per\u00edodo, la moneda y los responsables<\/h3>\n\t\t\t\t\t<p class=\"e-1a8797f-e5d6 e-paragraph-base e-default-p\" data-interaction-id=\"604d0be5\" data-e-type=\"widget\" data-id=\"604d0be5\">Antes de llenar la plantilla de n\u00f3mina, identifica el inicio y el fin del per\u00edodo. Utiliza una referencia \u00fanica para diferenciar una n\u00f3mina ordinaria de una correcci\u00f3n o un pago adicional.<\/p>\n\t\t\t\t\t<p class=\"e-5829e7d6-8828 e-paragraph-base e-default-p\" data-interaction-id=\"3038f97c\" data-e-type=\"widget\" data-id=\"3038f97c\">Define qui\u00e9n prepara los datos y qui\u00e9n revisa los importes. Mant\u00e9n visible la moneda y la precisi\u00f3n con la que presentar\u00e1s los resultados para que los reportes sean comparables.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-617f2209 e-con e-atomic-element e-flexbox-base e-default-div e-27983f95-85b2 \" data-id=\"617f2209\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"617f2209\" data-e-type=\"e-flexbox\" data-id=\"617f2209\">\n    \t\t\t<h3 data-interaction-id=\"44b6e1f0\" class=\"e-782386e5-dd14 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"44b6e1f0\">2. Prepara el cat\u00e1logo de empleados<\/h3>\n\t\t\t\t\t<p class=\"e-1e2953c1-b5be e-paragraph-base e-default-p\" data-interaction-id=\"2cb087f4\" data-e-type=\"widget\" data-id=\"2cb087f4\">Asigna un c\u00f3digo estable a cada empleado y conserva los datos necesarios para el proceso. Comprueba los c\u00f3digos duplicados antes de relacionarlos con las filas de c\u00e1lculo o los recibos.<\/p>\n\t\t\t\t\t<p class=\"e-189e6141-c23b e-paragraph-base e-default-p\" data-interaction-id=\"bbd1f40\" data-e-type=\"widget\" data-id=\"bbd1f40\">Si una persona cambia de departamento o tiene una modificaci\u00f3n para un per\u00edodo concreto, documenta desde cu\u00e1ndo se aplica. Conserva la informaci\u00f3n del per\u00edodo cerrado para poder reconstruirlo despu\u00e9s.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-63bcf90f e-con e-atomic-element e-flexbox-base e-default-div e-525cb56c-17c3 \" data-id=\"63bcf90f\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"63bcf90f\" data-e-type=\"e-flexbox\" data-id=\"63bcf90f\">\n    \t\t\t<h3 data-interaction-id=\"45f14414\" class=\"e-2ff1d0b-eea9 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"45f14414\">3. Organiza los ingresos y sus respaldos<\/h3>\n\t\t\t\t\t<p class=\"e-207dcf00-b2fd e-paragraph-base e-default-p\" data-interaction-id=\"659bed5d\" data-e-type=\"widget\" data-id=\"659bed5d\">En la plantilla de n\u00f3mina, separa la base del per\u00edodo de otros ingresos. Captura \u00fanicamente importes que puedas relacionar con un c\u00e1lculo o documento de origen.<\/p>\n\t\t\t\t\t<p class=\"e-15a17c24-e44b e-paragraph-base e-default-p\" data-interaction-id=\"1b87972f\" data-e-type=\"widget\" data-id=\"1b87972f\">Si necesitas convertir horas, d\u00edas o unidades en importes, conserva la cantidad, la base y la regla que utilizaste. Comprueba que esa regla corresponda al concepto y al per\u00edodo antes de extender la f\u00f3rmula a otras personas.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-3c4ac316 e-con e-atomic-element e-flexbox-base e-default-div e-488c858c-ac9f \" data-id=\"3c4ac316\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"3c4ac316\" data-e-type=\"e-flexbox\" data-id=\"3c4ac316\">\n    \t\t\t<h3 data-interaction-id=\"675b4277\" class=\"e-43a8185c-5aee e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"675b4277\">4. Configura las deducciones con par\u00e1metros identificados<\/h3>\n\t\t\t\t\t<p class=\"e-2794f67a-41b0 e-paragraph-base e-default-p\" data-interaction-id=\"3f43609e\" data-e-type=\"widget\" data-id=\"3f43609e\">Desglosa retenciones y otras deducciones en campos separados. Cuando un importe dependa de una tasa, base o l\u00edmite, identifica su fuente y vigencia junto al par\u00e1metro correspondiente.<\/p>\n\t\t\t\t\t<p class=\"e-3eaac8f4-985d e-paragraph-base e-default-p\" data-interaction-id=\"1490dd21\" data-e-type=\"widget\" data-id=\"1490dd21\">Los conceptos y reglas de una plantilla de n\u00f3mina deben adaptarse al caso de uso. Revisa la informaci\u00f3n vigente de las autoridades correspondientes y documenta cualquier cambio antes de utilizarlo en otro per\u00edodo.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-31256639 e-con e-atomic-element e-flexbox-base e-default-div e-22a8ed81-ee1e \" data-id=\"31256639\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"31256639\" data-e-type=\"e-flexbox\" data-id=\"31256639\">\n    \t\t\t<h3 data-interaction-id=\"3ba1b944\" class=\"e-6fb6cc82-a3dd e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"3ba1b944\">5. A\u00f1ade f\u00f3rmulas y validaci\u00f3n de datos<\/h3>\n\t\t\t\t\t<p class=\"e-39bf83e-b7d0 e-paragraph-base e-default-p\" data-interaction-id=\"6ac50439\" data-e-type=\"widget\" data-id=\"6ac50439\">Utiliza SUMA para obtener los totales y referencias de celda para calcular el neto. Mant\u00e9n los par\u00e1metros editables en celdas identificadas, en lugar de esconderlos dentro de muchas f\u00f3rmulas.<\/p>\n\t\t\t\t\t<p class=\"e-6d3030e5-f61e e-paragraph-base e-default-p\" data-interaction-id=\"757628e6\" data-e-type=\"widget\" data-id=\"757628e6\">La validaci\u00f3n de datos puede ayudar a seleccionar per\u00edodos o estados de una lista y restringir tipos de entrada. Microsoft explica c\u00f3mo <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/get-started\/apply-data-validation-to-cells\" target=\"_blank\" rel=\"noopener\">aplicar validaci\u00f3n de datos en Excel<\/a>. Prueba tambi\u00e9n lo que ocurre al pegar informaci\u00f3n.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-7e0cdc79 e-con e-atomic-element e-flexbox-base e-default-div e-633617c-4921 \" data-id=\"7e0cdc79\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"7e0cdc79\" data-e-type=\"e-flexbox\" data-id=\"7e0cdc79\">\n    \t\t\t<h3 data-interaction-id=\"3c1a252\" class=\"e-44df628a-8b8f e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"3c1a252\">6. Comprueba los recibos y el resumen<\/h3>\n\t\t\t\t\t<p class=\"e-2931d108-a388 e-paragraph-base e-default-p\" data-interaction-id=\"6fda9f4b\" data-e-type=\"widget\" data-id=\"6fda9f4b\">La plantilla de n\u00f3mina debe permitir comparar el detalle de cada persona con el resumen del per\u00edodo. Revisa que el recibo recupere el c\u00f3digo correcto y los mismos ingresos, deducciones y neto.<\/p>\n\t\t\t\t\t<p class=\"e-73697593-80ca e-paragraph-base e-default-p\" data-interaction-id=\"180f23e\" data-e-type=\"widget\" data-id=\"180f23e\">Comprueba los totales del archivo y los importes previstos para el pago. Registra la fecha y referencia del pago despu\u00e9s de confirmarlo y conserva la documentaci\u00f3n que corresponda.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-4ed8f08 e-con e-atomic-element e-flexbox-base e-default-div e-64a52d75-948d \" data-id=\"4ed8f08\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"4ed8f08\" data-e-type=\"e-flexbox\" data-id=\"4ed8f08\">\n    \t\t\t<h3 data-interaction-id=\"53b1ba1a\" class=\"e-3fa64bcf-5e2f e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"53b1ba1a\">7. Prueba, cierra el per\u00edodo y conserva una copia maestra<\/h3>\n\t\t\t\t\t<p class=\"e-3d4e83-33cb e-paragraph-base e-default-p\" data-interaction-id=\"384d19ea\" data-e-type=\"widget\" data-id=\"384d19ea\">Ensaya la plantilla de n\u00f3mina con un c\u00e1lculo que puedas comprobar a mano. Incluye casos con cero, datos pendientes, importes adicionales y una correcci\u00f3n para detectar diferencias antes del cierre.<\/p>\n\t\t\t\t\t<p class=\"e-7254d4fb-537e e-paragraph-base e-default-p\" data-interaction-id=\"7f0a28d9\" data-e-type=\"widget\" data-id=\"7f0a28d9\">Guarda el per\u00edodo cerrado con un nombre identificable. Conserva una copia maestra sin movimientos para el siguiente uso y diferencia las celdas de captura de las f\u00f3rmulas que quieres preservar.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-5d1dc79b e-con e-atomic-element e-div-block-base e-default-section e-1123dea2-ad5a \" data-id=\"5d1dc79b\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"5d1dc79b\" id=\"ejemplo-nomina\" data-e-type=\"e-div-block\" data-id=\"5d1dc79b\">\n    <div class=\"elementor-element elementor-element-1ef5aa5f e-con e-atomic-element e-flexbox-base e-default-div e-20b4f853-1e00 \" data-id=\"1ef5aa5f\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"1ef5aa5f\" data-e-type=\"e-flexbox\" data-id=\"1ef5aa5f\">\n    \t\t\t<h2 data-interaction-id=\"3f4e7d8d\" class=\"e-76995351-2ac8 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"3f4e7d8d\">F\u00f3rmulas y ejemplo pr\u00e1ctico de una plantilla de n\u00f3mina<\/h2>\n\t\t\t\t\t<p class=\"e-2a298d2b-e03e e-paragraph-base e-default-p\" data-interaction-id=\"32b8dfd4\" data-e-type=\"widget\" data-id=\"32b8dfd4\">El siguiente ejercicio utiliza importes ficticios para explicar sumas, deducciones y neto. No calcula tasas legales ni determina qu\u00e9 retenciones corresponden a una persona: esos conceptos ya se presentan como entradas del ejemplo.<\/p>\n\t\t<div class=\"elementor-element elementor-element-155ee18e e-con e-atomic-element e-flexbox-base e-default-div e-3ccc856e-e88f \" data-id=\"155ee18e\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"155ee18e\" data-e-type=\"e-flexbox\" data-id=\"155ee18e\">\n    \t\t\t<img decoding=\"async\" class=\"e-image-base e-default-img e-1ba4c9f4-de1b\" data-interaction-id=\"b178cf8\" data-e-type=\"widget\" data-id=\"b178cf8\" id=\"66975\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-ingresos-deducciones-neto.jpg\" width=\"1200\" height=\"800\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-ingresos-deducciones-neto.jpg 1200w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-ingresos-deducciones-neto-300x200.jpg 300w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-ingresos-deducciones-neto-1024x683.jpg 1024w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/plantilla-de-nomina-ingresos-deducciones-neto-768x512.jpg 768w\" alt=\"Plantilla de n\u00f3mina: ejemplo de 1200 de ingresos menos 150 de deducciones igual a 1050 de neto a pagar\"\/>\t\t\t\t\t<p class=\"e-1e59558d-f8e5 e-paragraph-base e-default-p\" data-interaction-id=\"3feac6c6\" data-e-type=\"widget\" data-id=\"3feac6c6\">Ejemplo ilustrativo: 1200 de ingresos \u2212 150 de deducciones = 1050 de neto a pagar.<\/p>\n\t\t\n<\/div>\n\t\t\t<h3 data-interaction-id=\"2b821a7a\" class=\"e-345c3f61-fd2c e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"2b821a7a\">Prepara las columnas del ejercicio<\/h3>\n\t\t<ul class=\"elementor-element elementor-element-9747c6 e-con e-atomic-element e-list-base e-list e-default-ul e-66eaa5e5-837a \" data-id=\"9747c6\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"9747c6\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"9747c6\">\n\t<li class=\"elementor-element elementor-element-26ca6c22 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-5d5c0fc9-ddac \" data-id=\"26ca6c22\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"26ca6c22\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"26ca6c22\">\n\t<div class=\"elementor-element elementor-element-3379e589 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"3379e589\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"3379e589\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"3379e589\">\n\t\t\t\t<p class=\"e-43c487ab-854d e-paragraph-base e-default-p\" data-interaction-id=\"78eb5a90\" data-e-type=\"widget\" data-id=\"78eb5a90\"><span>\u2022<\/span> <strong>A:<\/strong> Empleado, con el texto Empleado de ejemplo.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-4e17b3d9 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-20f42bbf-9be0 \" data-id=\"4e17b3d9\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"4e17b3d9\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"4e17b3d9\">\n\t<div class=\"elementor-element elementor-element-7928079 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"7928079\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"7928079\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"7928079\">\n\t\t\t\t<p class=\"e-7f73402a-3e7e e-paragraph-base e-default-p\" data-interaction-id=\"292db0cf\" data-e-type=\"widget\" data-id=\"292db0cf\"><span>\u2022<\/span> <strong>B:<\/strong> BasePeriodo, con un importe de <strong>1000<\/strong> en B2.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-52f9e71a e-con e-atomic-element e-list-item-base e-list-item e-default-li e-70c42fb0-d15c \" data-id=\"52f9e71a\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"52f9e71a\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"52f9e71a\">\n\t<div class=\"elementor-element elementor-element-77b09520 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"77b09520\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"77b09520\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"77b09520\">\n\t\t\t\t<p class=\"e-12d08c2d-c627 e-paragraph-base e-default-p\" data-interaction-id=\"def1569\" data-e-type=\"widget\" data-id=\"def1569\"><span>\u2022<\/span> <strong>C:<\/strong> OtrosIngresos, con <strong>200<\/strong> en C2.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-15d60fe2 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-337cb2be-35c0 \" data-id=\"15d60fe2\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"15d60fe2\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"15d60fe2\">\n\t<div class=\"elementor-element elementor-element-29e32162 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"29e32162\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"29e32162\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"29e32162\">\n\t\t\t\t<p class=\"e-192c617f-c66d e-paragraph-base e-default-p\" data-interaction-id=\"6cf7870e\" data-e-type=\"widget\" data-id=\"6cf7870e\"><span>\u2022<\/span> <strong>D:<\/strong> TotalIngresos, calculado con una f\u00f3rmula.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-24b54b13 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-4913eebf-416f \" data-id=\"24b54b13\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"24b54b13\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"24b54b13\">\n\t<div class=\"elementor-element elementor-element-7eefac65 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"7eefac65\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"7eefac65\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"7eefac65\">\n\t\t\t\t<p class=\"e-ca65b9d-a3d2 e-paragraph-base e-default-p\" data-interaction-id=\"2b9ba238\" data-e-type=\"widget\" data-id=\"2b9ba238\"><span>\u2022<\/span> <strong>E:<\/strong> Retencion, con <strong>100<\/strong> en E2 como dato ficticio.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-23afb698 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-4b385544-3f7b \" data-id=\"23afb698\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"23afb698\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"23afb698\">\n\t<div class=\"elementor-element elementor-element-7511d3b4 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"7511d3b4\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"7511d3b4\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"7511d3b4\">\n\t\t\t\t<p class=\"e-6c5b6b92-a113 e-paragraph-base e-default-p\" data-interaction-id=\"c9abed6\" data-e-type=\"widget\" data-id=\"c9abed6\"><span>\u2022<\/span> <strong>F:<\/strong> OtrasDeducciones, con <strong>50<\/strong> en F2.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-1dca214e e-con e-atomic-element e-list-item-base e-list-item e-default-li e-53594096-2a5d \" data-id=\"1dca214e\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"1dca214e\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"1dca214e\">\n\t<div class=\"elementor-element elementor-element-6cfbc02e e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"6cfbc02e\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"6cfbc02e\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"6cfbc02e\">\n\t\t\t\t<p class=\"e-78a484-ac64 e-paragraph-base e-default-p\" data-interaction-id=\"7c6df3f2\" data-e-type=\"widget\" data-id=\"7c6df3f2\"><span>\u2022<\/span> <strong>G:<\/strong> TotalDeducciones; <strong>H:<\/strong> NetoPagar.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<h3 data-interaction-id=\"27c4c263\" class=\"e-54031c2c-d732 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"27c4c263\">Suma los ingresos y las deducciones<\/h3>\n\t\t\t\t\t<p class=\"e-29a63843-8eb4 e-paragraph-base e-default-p\" data-interaction-id=\"5f40ebdc\" data-e-type=\"widget\" data-id=\"5f40ebdc\">En D2 introduce la primera f\u00f3rmula. En G2 utiliza la segunda. Los resultados esperados son <strong>1200<\/strong> de ingresos y <strong>150<\/strong> de deducciones:<\/p>\n\t\t\t\t\t<p class=\"e-3d26f8d9-dfc2 e-paragraph-base e-default-p\" data-interaction-id=\"41cb2b99\" data-e-type=\"widget\" data-id=\"41cb2b99\">=SUMA(B2:C2)<\/p>\n\t\t\t\t\t<p class=\"e-3dee8938-e4b3 e-paragraph-base e-default-p\" data-interaction-id=\"b2399a0\" data-e-type=\"widget\" data-id=\"b2399a0\">=SUMA(E2:F2)<\/p>\n\t\t\t\t\t<p class=\"e-3a180423-f9d6 e-paragraph-base e-default-p\" data-interaction-id=\"bbb12ca\" data-e-type=\"widget\" data-id=\"bbb12ca\">Microsoft documenta la <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/functions\/sum-function\" target=\"_blank\" rel=\"noopener\">funci\u00f3n SUMA<\/a> y el uso de referencias. Comprueba que las entradas sean num\u00e9ricas: una cantidad almacenada como texto puede quedar fuera de una suma y producir un total incompleto.<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"be6062f\" class=\"e-663c77d6-8960 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"be6062f\">Obt\u00e9n el neto a pagar<\/h3>\n\t\t\t\t\t<p class=\"e-28c56518-7f6d e-paragraph-base e-default-p\" data-interaction-id=\"241bd1a0\" data-e-type=\"widget\" data-id=\"241bd1a0\">En H2 resta el total de deducciones al total de ingresos. En esta plantilla de n\u00f3mina de pr\u00e1ctica debes obtener <strong>1050<\/strong>:<\/p>\n\t\t\t\t\t<p class=\"e-4f4343cd-9455 e-paragraph-base e-default-p\" data-interaction-id=\"45d7fe35\" data-e-type=\"widget\" data-id=\"45d7fe35\">=D2-G2<\/p>\n\t\t\t\t\t<p class=\"e-4d6ace70-99de e-paragraph-base e-default-p\" data-interaction-id=\"2f790fc9\" data-e-type=\"widget\" data-id=\"2f790fc9\">Aplica un formato num\u00e9rico o monetario adecuado para leer los importes. El formato de presentaci\u00f3n y el redondeo del c\u00e1lculo son decisiones diferentes; documenta el criterio que necesita tu proceso.<\/p>\n\t\t\t\t\t<p class=\"e-447f857a-8a19 e-paragraph-base e-default-p\" data-interaction-id=\"bc90750\" data-e-type=\"widget\" data-id=\"bc90750\">Si el ejercicio requiere calcular el neto con dos decimales, puedes usar esta variante. Microsoft explica la sintaxis de <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/functions\/round-function\" target=\"_blank\" rel=\"noopener\">REDONDEAR<\/a> en su ayuda:<\/p>\n\t\t\t\t\t<p class=\"e-40b6006-5684 e-paragraph-base e-default-p\" data-interaction-id=\"5ee9e514\" data-e-type=\"widget\" data-id=\"5ee9e514\">=REDONDEAR(D2-G2;2)<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"1945fb3f\" class=\"e-4cda110e-587b e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"1945fb3f\">Pon a prueba la plantilla de n\u00f3mina<\/h3>\n\t\t<ul class=\"elementor-element elementor-element-53a82bc5 e-con e-atomic-element e-list-base e-list e-default-ul e-7ddd735f-a5f8 \" data-id=\"53a82bc5\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"53a82bc5\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"53a82bc5\">\n\t<li class=\"elementor-element elementor-element-d102627 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-21cdaf50-6840 \" data-id=\"d102627\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"d102627\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"d102627\">\n\t<div class=\"elementor-element elementor-element-4027a46 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"4027a46\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"4027a46\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"4027a46\">\n\t\t\t\t<p class=\"e-307854f8-6832 e-paragraph-base e-default-p\" data-interaction-id=\"6bef9aea\" data-e-type=\"widget\" data-id=\"6bef9aea\"><span>\u2022<\/span> Cambia OtrosIngresos de 200 a <strong>250<\/strong>: el total de ingresos debe ser <strong>1250<\/strong> y el neto, <strong>1100<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-236b8f47 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-4f93b43b-bd54 \" data-id=\"236b8f47\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"236b8f47\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"236b8f47\">\n\t<div class=\"elementor-element elementor-element-61555946 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"61555946\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"61555946\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"61555946\">\n\t\t\t\t<p class=\"e-95ff4bc-aa3d e-paragraph-base e-default-p\" data-interaction-id=\"3496e428\" data-e-type=\"widget\" data-id=\"3496e428\"><span>\u2022<\/span> Restaura OtrosIngresos a 200 y cambia OtrasDeducciones de 50 a <strong>80<\/strong>: el total deducido debe ser <strong>180<\/strong> y el neto, <strong>1020<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-63c1fe23 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-60b21bc2-d70b \" data-id=\"63c1fe23\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"63c1fe23\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"63c1fe23\">\n\t<div class=\"elementor-element elementor-element-7409c2d4 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"7409c2d4\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"7409c2d4\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"7409c2d4\">\n\t\t\t\t<p class=\"e-34b82b0f-eef4 e-paragraph-base e-default-p\" data-interaction-id=\"2d73352d\" data-e-type=\"widget\" data-id=\"2d73352d\"><span>\u2022<\/span> En una copia de ensayo, introduce deducciones superiores a los ingresos y confirma que el saldo negativo quede visible para su revisi\u00f3n.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-254cb109-a60b e-paragraph-base e-default-p\" data-interaction-id=\"181a5937\" data-e-type=\"widget\" data-id=\"181a5937\">Los ejemplos utilizan nombres de funciones en espa\u00f1ol. Si tu instalaci\u00f3n utiliza ingl\u00e9s, SUMA se llama SUM y REDONDEAR se llama ROUND. Adapta tambi\u00e9n el separador de argumentos a la configuraci\u00f3n de tu Excel.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-143778f9 e-con e-atomic-element e-div-block-base e-default-section e-582595ae-46cd \" data-id=\"143778f9\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"143778f9\" id=\"recibos-nomina\" data-e-type=\"e-div-block\" data-id=\"143778f9\">\n    <div class=\"elementor-element elementor-element-7d39d48a e-con e-atomic-element e-flexbox-base e-default-div e-3c4c0aac-fcb9 \" data-id=\"7d39d48a\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"7d39d48a\" data-e-type=\"e-flexbox\" data-id=\"7d39d48a\">\n    \t\t\t<h2 data-interaction-id=\"2b1f6654\" class=\"e-68c20e1c-3120 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"2b1f6654\">Recibos claros a partir de tu plantilla de n\u00f3mina<\/h2>\n\t\t\t\t\t<p class=\"e-55031e0d-34b0 e-paragraph-base e-default-p\" data-interaction-id=\"28510e82\" data-e-type=\"widget\" data-id=\"28510e82\">Un recibo organizado permite identificar el per\u00edodo y explicar los importes de una persona. Puedes preparar una hoja de presentaci\u00f3n que recupere los datos por c\u00f3digo de empleado, manteniendo la relaci\u00f3n con la plantilla de n\u00f3mina revisada.<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"61196999\" class=\"e-62bdfb87-8f67 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"61196999\">Qu\u00e9 informaci\u00f3n organizar en el recibo<\/h3>\n\t\t<ul class=\"elementor-element elementor-element-416ceda e-con e-atomic-element e-list-base e-list e-default-ul e-63f8093f-cdc4 \" data-id=\"416ceda\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"416ceda\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"416ceda\">\n\t<li class=\"elementor-element elementor-element-3e7ea5cf e-con e-atomic-element e-list-item-base e-list-item e-default-li e-45023006-80b2 \" data-id=\"3e7ea5cf\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"3e7ea5cf\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"3e7ea5cf\">\n\t<div class=\"elementor-element elementor-element-4e27ccbf e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"4e27ccbf\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"4e27ccbf\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"4e27ccbf\">\n\t\t\t\t<p class=\"e-36b1bcdb-899a e-paragraph-base e-default-p\" data-interaction-id=\"1f9cee09\" data-e-type=\"widget\" data-id=\"1f9cee09\"><span>\u2022<\/span> Datos de la empresa y de la persona que permitan identificar el registro.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-43ad41a8 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-5bfac3dc-7d1c \" data-id=\"43ad41a8\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"43ad41a8\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"43ad41a8\">\n\t<div class=\"elementor-element elementor-element-349a02e1 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"349a02e1\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"349a02e1\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"349a02e1\">\n\t\t\t\t<p class=\"e-375c4022-e1fc e-paragraph-base e-default-p\" data-interaction-id=\"66844c15\" data-e-type=\"widget\" data-id=\"66844c15\"><span>\u2022<\/span> Per\u00edodo y referencia del recibo.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-3b0d95e8 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-21abd5c3-9908 \" data-id=\"3b0d95e8\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"3b0d95e8\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"3b0d95e8\">\n\t<div class=\"elementor-element elementor-element-58dd1276 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"58dd1276\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"58dd1276\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"58dd1276\">\n\t\t\t\t<p class=\"e-4a5443e1-f0cd e-paragraph-base e-default-p\" data-interaction-id=\"7c8a7949\" data-e-type=\"widget\" data-id=\"7c8a7949\"><span>\u2022<\/span> Detalle de los ingresos y deducciones utilizados en el c\u00e1lculo.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-3aaf0718 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-5b7f28b4-9304 \" data-id=\"3aaf0718\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"3aaf0718\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"3aaf0718\">\n\t<div class=\"elementor-element elementor-element-40ef5658 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"40ef5658\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"40ef5658\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"40ef5658\">\n\t\t\t\t<p class=\"e-6f01bae6-afa3 e-paragraph-base e-default-p\" data-interaction-id=\"5b348704\" data-e-type=\"widget\" data-id=\"5b348704\"><span>\u2022<\/span> Totales y neto a pagar con la moneda identificada.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-58208645 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-24d48471-5510 \" data-id=\"58208645\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"58208645\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"58208645\">\n\t<div class=\"elementor-element elementor-element-3bc266d4 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"3bc266d4\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"3bc266d4\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"3bc266d4\">\n\t\t\t\t<p class=\"e-1043304-26cc e-paragraph-base e-default-p\" data-interaction-id=\"6d12ef32\" data-e-type=\"widget\" data-id=\"6d12ef32\"><span>\u2022<\/span> Datos de pago y dem\u00e1s informaci\u00f3n que corresponda al formato aplicable.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-2e8e3b59-a647 e-paragraph-base e-default-p\" data-interaction-id=\"344e129d\" data-e-type=\"widget\" data-id=\"344e129d\">Revisa el formato y sus requisitos para el pa\u00eds y el proceso en que se utilizar\u00e1. Puedes a\u00f1adir un logotipo para identificar a la empresa, conservando un dise\u00f1o legible en pantalla, impresi\u00f3n o PDF.<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"37fecb58\" class=\"e-54dcb918-cae1 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"37fecb58\">Si utilizas un generador de recibos de n\u00f3mina<\/h3>\n\t\t\t\t\t<p class=\"e-38777859-40dd e-paragraph-base e-default-p\" data-interaction-id=\"698c64f4\" data-e-type=\"widget\" data-id=\"698c64f4\">Comprueba c\u00f3mo selecciona el empleado y el per\u00edodo, de d\u00f3nde obtiene los conceptos y c\u00f3mo se actualiza una correcci\u00f3n. Compara un recibo generado con su fila de origen antes de producir los dem\u00e1s.<\/p>\n\t\t\t\t\t<p class=\"e-3369cf02-ced2 e-paragraph-base e-default-p\" data-interaction-id=\"49cd8496\" data-e-type=\"widget\" data-id=\"49cd8496\">Utiliza una salida individual para cada empleado y conserva una versi\u00f3n identificable del registro revisado. Antes de compartir el documento, comprueba que corresponda a la persona y al per\u00edodo correctos.<\/p>\n\t\t\t\t\t<p class=\"e-4c9f1fab-ff70 e-paragraph-base e-default-p\" data-interaction-id=\"1ad548be\" data-e-type=\"widget\" data-id=\"1ad548be\">En la plantilla de n\u00f3mina, un estado como Pendiente o Pagado debe reflejar lo que ya se ha confirmado. Define qui\u00e9n puede modificarlo y c\u00f3mo se registra la referencia del pago para facilitar el seguimiento.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-320ffbdc e-con e-atomic-element e-div-block-base e-default-section e-6c94b2c3-5658 \" data-id=\"320ffbdc\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"320ffbdc\" id=\"errores-nomina\" data-e-type=\"e-div-block\" data-id=\"320ffbdc\">\n    <div class=\"elementor-element elementor-element-7a51ed8c e-con e-atomic-element e-flexbox-base e-default-div e-22c0a0a6-b4f3 \" data-id=\"7a51ed8c\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"7a51ed8c\" data-e-type=\"e-flexbox\" data-id=\"7a51ed8c\">\n    \t\t\t<h2 data-interaction-id=\"85bad98\" class=\"e-259a77cf-f3da e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"85bad98\">Errores que debes revisar en una plantilla de n\u00f3mina<\/h2>\n\t\t\t\t\t<p class=\"e-1e554761-9a3f e-paragraph-base e-default-p\" data-interaction-id=\"36104a17\" data-e-type=\"widget\" data-id=\"36104a17\">La plantilla de n\u00f3mina necesita controles adem\u00e1s de f\u00f3rmulas. Una suma correcta puede utilizar un c\u00f3digo equivocado, un concepto duplicado o informaci\u00f3n que pertenece a otro per\u00edodo.<\/p>\n\t\t<ul class=\"elementor-element elementor-element-b844f3 e-con e-atomic-element e-list-base e-list e-default-ul e-10076d0-6f7b \" data-id=\"b844f3\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"b844f3\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"b844f3\">\n\t<li class=\"elementor-element elementor-element-2f045ae7 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-379c197b-fb6c \" data-id=\"2f045ae7\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"2f045ae7\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"2f045ae7\">\n\t<div class=\"elementor-element elementor-element-57b5443f e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"57b5443f\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"57b5443f\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"57b5443f\">\n\t\t\t\t<p class=\"e-613b01ea-c963 e-paragraph-base e-default-p\" data-interaction-id=\"f0e675a\" data-e-type=\"widget\" data-id=\"f0e675a\"><span>\u2022<\/span> <strong>Duplicar una persona o un concepto:<\/strong> utiliza identificadores y comprueba el origen de los registros.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-1ca0efb4 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-422026a5-4ff8 \" data-id=\"1ca0efb4\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"1ca0efb4\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"1ca0efb4\">\n\t<div class=\"elementor-element elementor-element-734b738d e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"734b738d\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"734b738d\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"734b738d\">\n\t\t\t\t<p class=\"e-28455faa-bca2 e-paragraph-base e-default-p\" data-interaction-id=\"11d98f28\" data-e-type=\"widget\" data-id=\"11d98f28\"><span>\u2022<\/span> <strong>Mezclar per\u00edodos:<\/strong> conserva una referencia clara y revisa las fechas de cada entrada.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-2f33f0eb e-con e-atomic-element e-list-item-base e-list-item e-default-li e-33e4b833-bafa \" data-id=\"2f33f0eb\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"2f33f0eb\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"2f33f0eb\">\n\t<div class=\"elementor-element elementor-element-f8dc1a1 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"f8dc1a1\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"f8dc1a1\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"f8dc1a1\">\n\t\t\t\t<p class=\"e-5d12b8de-4ffe e-paragraph-base e-default-p\" data-interaction-id=\"304932ce\" data-e-type=\"widget\" data-id=\"304932ce\"><span>\u2022<\/span> <strong>Sumar importes como texto:<\/strong> comprueba el tipo de dato despu\u00e9s de copiar o importar informaci\u00f3n.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-2b571b29 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-6d18b7f1-12f6 \" data-id=\"2b571b29\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"2b571b29\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"2b571b29\">\n\t<div class=\"elementor-element elementor-element-28e17bb2 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"28e17bb2\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"28e17bb2\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"28e17bb2\">\n\t\t\t\t<p class=\"e-a4794b1-596d e-paragraph-base e-default-p\" data-interaction-id=\"7bc32342\" data-e-type=\"widget\" data-id=\"7bc32342\"><span>\u2022<\/span> <strong>Repetir una deducci\u00f3n:<\/strong> verifica que un mismo concepto no se haya descontado en m\u00e1s de una columna.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-251a5c46 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-8887193-e291 \" data-id=\"251a5c46\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"251a5c46\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"251a5c46\">\n\t<div class=\"elementor-element elementor-element-6a6f505a e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"6a6f505a\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"6a6f505a\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"6a6f505a\">\n\t\t\t\t<p class=\"e-2cf84371-48c3 e-paragraph-base e-default-p\" data-interaction-id=\"630d9f96\" data-e-type=\"widget\" data-id=\"630d9f96\"><span>\u2022<\/span> <strong>Aplicar un par\u00e1metro anterior:<\/strong> identifica la versi\u00f3n y vigencia de tasas, bases y l\u00edmites.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-7f309184 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-6f2d15b6-3aef \" data-id=\"7f309184\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"7f309184\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"7f309184\">\n\t<div class=\"elementor-element elementor-element-57c998fc e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"57c998fc\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"57c998fc\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"57c998fc\">\n\t\t\t\t<p class=\"e-44828006-b977 e-paragraph-base e-default-p\" data-interaction-id=\"e7dda38\" data-e-type=\"widget\" data-id=\"e7dda38\"><span>\u2022<\/span> <strong>Sobrescribir una f\u00f3rmula:<\/strong> diferencia las celdas editables y conserva una copia de la estructura original.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-44304c82 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-2a9fc4de-61e1 \" data-id=\"44304c82\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"44304c82\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"44304c82\">\n\t<div class=\"elementor-element elementor-element-76dc5aa e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"76dc5aa\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"76dc5aa\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"76dc5aa\">\n\t\t\t\t<p class=\"e-7d992bc1-778b e-paragraph-base e-default-p\" data-interaction-id=\"59793c0f\" data-e-type=\"widget\" data-id=\"59793c0f\"><span>\u2022<\/span> <strong>Ocultar saldos negativos:<\/strong> revisa las entradas y el concepto antes de cerrar la fila.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<h3 data-interaction-id=\"74c9bfbb\" class=\"e-71c4156c-8428 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"74c9bfbb\">Una revisi\u00f3n \u00fatil antes del cierre<\/h3>\n\t\t\t\t\t<p class=\"e-63d97370-b19c e-paragraph-base e-default-p\" data-interaction-id=\"577a7bc9\" data-e-type=\"widget\" data-id=\"577a7bc9\">Compara el n\u00famero de personas incluidas con el registro que corresponde al per\u00edodo. Revisa importes por empleado y totales generales. Documenta las diferencias y confirma que los recibos coincidan con los resultados aprobados.<\/p>\n\t\t\t\t\t<p class=\"e-79793335-57b7 e-paragraph-base e-default-p\" data-interaction-id=\"213ddc2c\" data-e-type=\"widget\" data-id=\"213ddc2c\">Utiliza datos ficticios al probar una plantilla de n\u00f3mina o compartir una consulta sobre sus f\u00f3rmulas. En los archivos de trabajo, limita la informaci\u00f3n a lo necesario para el proceso y el acceso a las personas que lo gestionan.<\/p>\n\t\t\t\t\t<p class=\"e-5c3f5b39-6fd9 e-paragraph-base e-default-p\" data-interaction-id=\"44ad3906\" data-e-type=\"widget\" data-id=\"44ad3906\">Si aparece un mensaje como #\u00a1REF!, #\u00a1VALOR! o #\u00a1DIV\/0!, revisa la causa en nuestra gu\u00eda de <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/errores-en-formulas-excel.html\">errores en f\u00f3rmulas de Excel<\/a>. Evita sustituir un error por cero sin explicar qu\u00e9 dato est\u00e1 pendiente.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-6ebcbfdf e-con e-atomic-element e-div-block-base e-default-section e-19f9d865-6cff \" data-id=\"6ebcbfdf\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"6ebcbfdf\" id=\"recursos-nomina\" data-e-type=\"e-div-block\" data-id=\"6ebcbfdf\">\n    <div class=\"elementor-element elementor-element-4b7de093 e-con e-atomic-element e-flexbox-base e-default-div e-6b59b267-2250 \" data-id=\"4b7de093\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"4b7de093\" data-e-type=\"e-flexbox\" data-id=\"4b7de093\">\n    \t\t\t<h2 data-interaction-id=\"4a566824\" class=\"e-45257381-ca3a e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"4a566824\">Explora el cat\u00e1logo de plantillas de Excel<\/h2>\n\t\t\t\t\t<p class=\"e-4957b404-4d63 e-paragraph-base e-default-p\" data-interaction-id=\"5f40518e\" data-e-type=\"widget\" data-id=\"5f40518e\">Si quieres conocer otras herramientas de Aplica Excel Contable, visita el cat\u00e1logo del blog. Cada recurso tiene su propia explicaci\u00f3n y opciones de acceso; revisa su contenido antes de incorporarlo a tu trabajo.<\/p>\n\t\t<div class=\"elementor-element elementor-element-1c9900bd e-con e-atomic-element e-flexbox-base e-default-div e-1c31839-dc00 \" data-id=\"1c9900bd\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"1c9900bd\" data-e-type=\"e-flexbox\" data-id=\"1c9900bd\">\n    \t\t\t<h3 data-interaction-id=\"6eaf8308\" class=\"e-4a3f73a0-ecf5 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"6eaf8308\">Encuentra recursos para organizar tus registros<\/h3>\n\t\t\t\t\t<p class=\"e-59c1b36f-fbe2 e-paragraph-base e-default-p\" data-interaction-id=\"59866940\" data-e-type=\"widget\" data-id=\"59866940\">Explora las plantillas disponibles y revisa las instrucciones de uso. Para practicar los c\u00e1lculos de esta gu\u00eda, puedes comenzar en una hoja nueva con los datos ficticios del ejemplo.<\/p>\n\t\t\t\t\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/plantillas\/plantillas-gratis\" target=\"_self\" class=\"e-75c7b7ca-f4df e-button-base e-default-a\" data-interaction-id=\"5565b0aa\" data-e-type=\"widget\" data-id=\"5565b0aa\">\n\tVer cat\u00e1logo de plantillas de Excel\n<\/a>\n\t\t\n<\/div>\n\t\t\t<p class=\"e-2d83f1cd-28f2 e-paragraph-base e-default-p\" data-interaction-id=\"4854998f\" data-e-type=\"widget\" data-id=\"4854998f\">Antes de adoptar una plantilla de n\u00f3mina, identifica qu\u00e9 conceptos necesitas, qu\u00e9 c\u00e1lculos puedes comprobar y qu\u00e9 cambios exige tu caso. Conserva una copia original para comparar el funcionamiento despu\u00e9s de personalizarla.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-76ceace4 e-con e-atomic-element e-div-block-base e-default-section e-2fc80248-2ce0 \" data-id=\"76ceace4\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"76ceace4\" id=\"preguntas-nomina\" data-e-type=\"e-div-block\" data-id=\"76ceace4\">\n    <div class=\"elementor-element elementor-element-258e92b0 e-con e-atomic-element e-flexbox-base e-default-div e-4ce44153-a6de \" data-id=\"258e92b0\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"258e92b0\" data-e-type=\"e-flexbox\" data-id=\"258e92b0\">\n    \t\t\t<h2 data-interaction-id=\"79b9a6ff\" class=\"e-16bba838-a9af e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"79b9a6ff\">Preguntas frecuentes sobre la plantilla de n\u00f3mina<\/h2>\n\t\t<div class=\"elementor-element elementor-element-3b301237 e-con e-atomic-element e-accordion-base  e-25fd4d01-5576 \" style=\"--e-accordion-icon-rotation: 180deg;\" data-id=\"3b301237\" data-element_type=\"e-accordion\" data-e-type=\"e-accordion\" data-interaction-id=\"3b301237\" data-e-type=\"e-accordion\" data-id=\"3b301237\">\n    <details class=\"elementor-element elementor-element-2b84579f e-con e-atomic-element e-accordion-item-base  e-7dfb2e15-6e20 \" data-id=\"2b84579f\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"2b84579f\" data-e-type=\"e-accordion-item\" data-id=\"2b84579f\" open>\n    <summary class=\"elementor-element elementor-element-5dda3b95 e-con e-atomic-element e-accordion-item-header-base  e-45a32cb6-9adf  e--selected\" data-id=\"5dda3b95\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"5dda3b95\" data-e-type=\"e-accordion-item-header\" data-id=\"5dda3b95\">\n    <span class=\"elementor-element elementor-element-336fe98 e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"336fe98\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"336fe98\" data-e-type=\"e-accordion-item-title\" data-id=\"336fe98\">\n    \t\t\t<h3 data-interaction-id=\"1a712e2d\" class=\"e-6cb251df-423a e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"1a712e2d\">\u00bfQu\u00e9 debe incluir una plantilla de n\u00f3mina en Excel?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-40008a36 e-con e-atomic-element e-accordion-item-content-base  e-1dd4216-ad65 \" data-id=\"40008a36\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"40008a36\" data-e-type=\"e-accordion-item-content\" data-id=\"40008a36\">\n    \t\t\t<p class=\"e-65f0647-a684 e-paragraph-base e-default-p\" data-interaction-id=\"4db642e6\" data-e-type=\"widget\" data-id=\"4db642e6\">Una estructura \u00fatil identifica al empleado y al per\u00edodo, separa ingresos y deducciones, calcula el neto y conserva datos de revisi\u00f3n y pago. Los conceptos concretos deben ajustarse al proceso y pa\u00eds de uso.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-60fb5e4a e-con e-atomic-element e-accordion-item-base  e-299c412-8739 \" data-id=\"60fb5e4a\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"60fb5e4a\" data-e-type=\"e-accordion-item\" data-id=\"60fb5e4a\" >\n    <summary class=\"elementor-element elementor-element-15595e0 e-con e-atomic-element e-accordion-item-header-base  e-674867cb-a032 \" data-id=\"15595e0\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"15595e0\" data-e-type=\"e-accordion-item-header\" data-id=\"15595e0\">\n    <span class=\"elementor-element elementor-element-4979cf4e e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"4979cf4e\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"4979cf4e\" data-e-type=\"e-accordion-item-title\" data-id=\"4979cf4e\">\n    \t\t\t<h3 data-interaction-id=\"61be3e2b\" class=\"e-1127b990-ae91 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"61be3e2b\">\u00bfLa plantilla de n\u00f3mina calcula los impuestos autom\u00e1ticamente?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-1e7eb2d7 e-con e-atomic-element e-accordion-item-content-base  e-3f5e3fcd-a5e0 \" data-id=\"1e7eb2d7\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"1e7eb2d7\" data-e-type=\"e-accordion-item-content\" data-id=\"1e7eb2d7\">\n    \t\t\t<p class=\"e-3973fa86-5a6c e-paragraph-base e-default-p\" data-interaction-id=\"3eaa9df1\" data-e-type=\"widget\" data-id=\"3eaa9df1\">Solo puede calcularlos si incorpora las reglas, bases y par\u00e1metros que correspondan al caso. En esta gu\u00eda las deducciones del ejemplo son importes ficticios de entrada, sin aplicar tasas legales.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-3af876e5 e-con e-atomic-element e-accordion-item-base  e-efae04f-af0b \" data-id=\"3af876e5\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"3af876e5\" data-e-type=\"e-accordion-item\" data-id=\"3af876e5\" >\n    <summary class=\"elementor-element elementor-element-5ea6b93f e-con e-atomic-element e-accordion-item-header-base  e-4a5e941-ee80 \" data-id=\"5ea6b93f\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"5ea6b93f\" data-e-type=\"e-accordion-item-header\" data-id=\"5ea6b93f\">\n    <span class=\"elementor-element elementor-element-760ea58a e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"760ea58a\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"760ea58a\" data-e-type=\"e-accordion-item-title\" data-id=\"760ea58a\">\n    \t\t\t<h3 data-interaction-id=\"1925ec60\" class=\"e-3c1fc9d8-467b e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"1925ec60\">\u00bfPuedo usar la misma plantilla para cualquier pa\u00eds?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-47078491 e-con e-atomic-element e-accordion-item-content-base  e-5c75e0ad-8378 \" data-id=\"47078491\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"47078491\" data-e-type=\"e-accordion-item-content\" data-id=\"47078491\">\n    \t\t\t<p class=\"e-6a29a64b-9b90 e-paragraph-base e-default-p\" data-interaction-id=\"3a750ef1\" data-e-type=\"widget\" data-id=\"3a750ef1\">Debes revisar y adaptar conceptos, reglas, formatos y fuentes vigentes para el lugar donde se utilizar\u00e1. Una estructura general de Excel sirve como punto de partida para organizar el trabajo.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-b8e1a20 e-con e-atomic-element e-accordion-item-base  e-3a339dee-c5cb \" data-id=\"b8e1a20\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"b8e1a20\" data-e-type=\"e-accordion-item\" data-id=\"b8e1a20\" >\n    <summary class=\"elementor-element elementor-element-79637899 e-con e-atomic-element e-accordion-item-header-base  e-60a45971-c3e7 \" data-id=\"79637899\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"79637899\" data-e-type=\"e-accordion-item-header\" data-id=\"79637899\">\n    <span class=\"elementor-element elementor-element-2defc1b0 e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"2defc1b0\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"2defc1b0\" data-e-type=\"e-accordion-item-title\" data-id=\"2defc1b0\">\n    \t\t\t<h3 data-interaction-id=\"76ff5c99\" class=\"e-1c7650eb-139c e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"76ff5c99\">\u00bfNecesito macros para sumar los importes y obtener el neto?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-1a4cdf38 e-con e-atomic-element e-accordion-item-content-base  e-2b5734c4-2017 \" data-id=\"1a4cdf38\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"1a4cdf38\" data-e-type=\"e-accordion-item-content\" data-id=\"1a4cdf38\">\n    \t\t\t<p class=\"e-2613f9cc-97cf e-paragraph-base e-default-p\" data-interaction-id=\"6b14bc16\" data-e-type=\"widget\" data-id=\"6b14bc16\">No. Las sumas y restas del ejemplo utilizan f\u00f3rmulas normales de Excel. Otras automatizaciones pueden tener requisitos diferentes que debes comprobar en cada archivo.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-6f18f01b e-con e-atomic-element e-accordion-item-base  e-2e3094c1-4031 \" data-id=\"6f18f01b\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"6f18f01b\" data-e-type=\"e-accordion-item\" data-id=\"6f18f01b\" >\n    <summary class=\"elementor-element elementor-element-69e7b07c e-con e-atomic-element e-accordion-item-header-base  e-603b9bef-984b \" data-id=\"69e7b07c\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"69e7b07c\" data-e-type=\"e-accordion-item-header\" data-id=\"69e7b07c\">\n    <span class=\"elementor-element elementor-element-4dd0e6b1 e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"4dd0e6b1\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"4dd0e6b1\" data-e-type=\"e-accordion-item-title\" data-id=\"4dd0e6b1\">\n    \t\t\t<h3 data-interaction-id=\"2de48a1f\" class=\"e-6a333e7a-d0b0 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"2de48a1f\">\u00bfC\u00f3mo compruebo que un recibo coincide con la n\u00f3mina?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-49f40345 e-con e-atomic-element e-accordion-item-content-base  e-c825261-a36f \" data-id=\"49f40345\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"49f40345\" data-e-type=\"e-accordion-item-content\" data-id=\"49f40345\">\n    \t\t\t<p class=\"e-7c13ced-9fb7 e-paragraph-base e-default-p\" data-interaction-id=\"34d91a36\" data-e-type=\"widget\" data-id=\"34d91a36\">Verifica el c\u00f3digo de empleado, el per\u00edodo, el detalle de conceptos, los totales y el neto. Compara la salida con el registro revisado y conserva una referencia de la versi\u00f3n utilizada.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-7d3bd27d e-con e-atomic-element e-accordion-item-base  e-71899805-7cad \" data-id=\"7d3bd27d\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"7d3bd27d\" data-e-type=\"e-accordion-item\" data-id=\"7d3bd27d\" >\n    <summary class=\"elementor-element elementor-element-5845f965 e-con e-atomic-element e-accordion-item-header-base  e-5ae02c37-6637 \" data-id=\"5845f965\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"5845f965\" data-e-type=\"e-accordion-item-header\" data-id=\"5845f965\">\n    <span class=\"elementor-element elementor-element-563010ff e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"563010ff\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"563010ff\" data-e-type=\"e-accordion-item-title\" data-id=\"563010ff\">\n    \t\t\t<h3 data-interaction-id=\"7b92e4ee\" class=\"e-74ec88eb-ab68 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"7b92e4ee\">\u00bfD\u00f3nde puedo explorar las plantillas del blog?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-70a4ee86 e-con e-atomic-element e-accordion-item-content-base  e-64b4b91b-a5e0 \" data-id=\"70a4ee86\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"70a4ee86\" data-e-type=\"e-accordion-item-content\" data-id=\"70a4ee86\">\n    \t\t\t<p class=\"e-70a820bf-f56e e-paragraph-base e-default-p\" data-interaction-id=\"76e087b8\" data-e-type=\"widget\" data-id=\"76e087b8\">Utiliza el bot\u00f3n del cat\u00e1logo incluido en esta gu\u00eda. All\u00ed puedes consultar los recursos disponibles y sus instrucciones de acceso y uso.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n\n<\/div>\n<script type=\"application\/ld+json\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"\\u00bfQu\\u00e9 debe incluir una plantilla de n\\u00f3mina en Excel?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Una estructura \\u00fatil identifica al empleado y al per\\u00edodo, separa ingresos y deducciones, calcula el neto y conserva datos de revisi\\u00f3n y pago. Los conceptos concretos deben ajustarse al proceso y pa\\u00eds de uso.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfLa plantilla de n\\u00f3mina calcula los impuestos autom\\u00e1ticamente?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Solo puede calcularlos si incorpora las reglas, bases y par\\u00e1metros que correspondan al caso. En esta gu\\u00eda las deducciones del ejemplo son importes ficticios de entrada, sin aplicar tasas legales.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfPuedo usar la misma plantilla para cualquier pa\\u00eds?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Debes revisar y adaptar conceptos, reglas, formatos y fuentes vigentes para el lugar donde se utilizar\\u00e1. Una estructura general de Excel sirve como punto de partida para organizar el trabajo.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfNecesito macros para sumar los importes y obtener el neto?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"No. Las sumas y restas del ejemplo utilizan f\\u00f3rmulas normales de Excel. Otras automatizaciones pueden tener requisitos diferentes que debes comprobar en cada archivo.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfC\\u00f3mo compruebo que un recibo coincide con la n\\u00f3mina?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Verifica el c\\u00f3digo de empleado, el per\\u00edodo, el detalle de conceptos, los totales y el neto. Compara la salida con el registro revisado y conserva una referencia de la versi\\u00f3n utilizada.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfD\\u00f3nde puedo explorar las plantillas del blog?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Utiliza el bot\\u00f3n del cat\\u00e1logo incluido en esta gu\\u00eda. All\\u00ed puedes consultar los recursos disponibles y sus instrucciones de acceso y uso.\"}}]}<\/script>\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-474aefd0 e-con e-atomic-element e-div-block-base e-default-section e-19643cec-6c48 \" data-id=\"474aefd0\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"474aefd0\" id=\"comentarios-nomina\" data-e-type=\"e-div-block\" data-id=\"474aefd0\">\n    <div class=\"elementor-element elementor-element-6207d57e e-con e-atomic-element e-flexbox-base e-default-div e-7ade4835-2aa1 \" data-id=\"6207d57e\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"6207d57e\" data-e-type=\"e-flexbox\" data-id=\"6207d57e\">\n    \t\t\t<h2 data-interaction-id=\"4f542\" class=\"e-7276056c-7ad9 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"4f542\">Comparte tu duda sobre la organizaci\u00f3n de la n\u00f3mina<\/h2>\n\t\t\t\t\t<p class=\"e-63dfd5a0-9f31 e-paragraph-base e-default-p\" data-interaction-id=\"5fb5a1ef\" data-e-type=\"widget\" data-id=\"5fb5a1ef\">Empieza con un per\u00edodo claro, datos identificados y c\u00e1lculos que puedas reproducir. Una plantilla de n\u00f3mina aporta m\u00e1s valor cuando el equipo puede explicar sus importes y repetir la revisi\u00f3n de forma consistente.<\/p>\n\t\t\t\t\t<p class=\"e-178258f6-43c9 e-paragraph-base e-default-p\" data-interaction-id=\"7f1b6584\" data-e-type=\"widget\" data-id=\"7f1b6584\">\u00bfQu\u00e9 necesitas organizar: los conceptos, los recibos o el seguimiento del pago? Deja tu pregunta en los comentarios y utiliza valores ficticios si quieres explicar un ejemplo.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Prepara una plantilla de n\u00f3mina en Excel con 7 pasos imprescindibles, f\u00f3rmulas de ingresos y deducciones, neto a pagar y revisi\u00f3n de recibos.<\/p>\n","protected":false},"author":1,"featured_media":66974,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"page_builder":"","footnotes":"","tve_updated_post":"","tve_custom_css":"","tve_user_custom_css":"","tve_globals":{},"tcb2_ready":1,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[21],"tags":[],"class_list":["post-49500","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-plantillas-excel"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/49500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=49500"}],"version-history":[{"count":4,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/49500\/revisions"}],"predecessor-version":[{"id":66979,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/49500\/revisions\/66979"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/66974"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=49500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=49500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=49500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}