{"id":153,"date":"2026-09-25T19:43:45","date_gmt":"2026-09-25T19:43:45","guid":{"rendered":"http:\/\/felix"},"modified":"2026-09-25T19:43:45","modified_gmt":"2026-09-25T19:43:45","password":"","slug":"como-crear-facturas-de-forma-masiva-con-excel","status":"publish","type":"docs","link":"https:\/\/aprende.dora.ec\/?docs=como-crear-facturas-de-forma-masiva-con-excel","title":{"rendered":"2 Como crear Facturas de forma masiva con Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">2 Como crear Facturas de forma masiva con Excel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Descripci\u00f3n:<\/strong> Este procedimiento sirve para importar y emitir m\u00faltiples facturas de venta (y notas de cr\u00e9dito) de forma masiva en el sistema Dora a trav\u00e9s de una plantilla de Excel. Es ideal para optimizar tiempo cuando se requiere registrar grandes vol\u00famenes de ventas sin ingresarlas manualmente una por una en la interfaz.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Crear Facturas de forma masiva con Excel desde Dora\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/c_HeQ9Zc7Mc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Proceso<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Paso 1:<\/strong> Descargar la plantilla oficial En el men\u00fa principal de Dora, ve al m\u00f3dulo de Ingresos > Facturas. En la esquina superior derecha, haz clic en M\u00e1s opciones y selecciona Importar factura. Haz clic en Descargar modelo para obtener el archivo Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Paso 2:<\/strong> Configuraci\u00f3n de formato en Excel (Evitar errores) Abre el archivo descargado. Formatea las columnas de Establecimiento, Punto de emisi\u00f3n y Secuencial como formato de Texto (as\u00ed Excel no borrar\u00e1 los ceros a la izquierda, por ejemplo: 001, 001, 000000041). Regla clave: El archivo NO debe contener f\u00f3rmulas. Si usas f\u00f3rmulas para calcular subtotales o impuestos, selecciona los datos, c\u00f3pialos y p\u00e9galos como &#8220;Solo valores&#8221; antes de guardar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Paso 3:<\/strong> Llenado de los datos de la factura Datos del cliente: Ingresa la Raz\u00f3n Social y RUC\/C\u00e9dula. Si el cliente no existe en Dora, el sistema lo crear\u00e1 autom\u00e1ticamente con la informaci\u00f3n que coloques (correo, direcci\u00f3n, tel\u00e9fono). Productos: Coloca el c\u00f3digo del producto existente en tu cat\u00e1logo. Precios e impuestos: Asigna el precio unitario sin impuesto, descuento (colocar 0 si no aplica), subtotal, IVA y total. Forma de pago: Debe escribirse exactamente igual a como aparece descrita en el sistema Dora. Fecha de caducidad: Campo obligatorio requerido por el SRI (puedes colocar la misma fecha de emisi\u00f3n de la factura).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Paso 4:<\/strong> Casos especiales en la plantilla Facturas con m\u00faltiples productos (\u00edtems): Repite los mismos datos de la cabecera (secuencial, cliente, fecha) en varias filas, cambiando \u00fanicamente la informaci\u00f3n del producto. Los campos de Observaci\u00f3n, C\u00f3digo de Vendedor, Servicio y Propina solo se llenan en la primera l\u00ednea del producto; no es necesario repetirlos en las dem\u00e1s filas de la misma factura. Notas de cr\u00e9dito: Indicar la opci\u00f3n &#8220;Nota de Cr\u00e9dito&#8221;, vinculando el n\u00famero y la fecha del documento modificado. Recomendaci\u00f3n: Carga primero el Excel con las facturas de venta y, en una carga posterior, sube las notas de cr\u00e9dito para evitar errores de validaci\u00f3n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Paso 5:<\/strong> Limpieza previa y carga final Evita caracteres especiales: No utilices comillas (&#8220;, &#8216;), ampersands (&#038;) ni puntos innecesarios en las celdas. Elimina filas sobrantes: Selecciona y elimina las filas vac\u00edas que est\u00e9n debajo de tus datos para evitar que el sistema interprete que faltan informaci\u00f3n. Guarda el archivo Excel. En Dora, vuelve a la ventana de importaci\u00f3n y haz clic en Importar modelo.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>2 Como crear Facturas de forma masiva con Excel Descripci\u00f3n: Este procedimiento sirve para importar y emitir m\u00faltiples facturas de [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_category":[6],"doc_tag":[],"class_list":["post-153","docs","type-docs","status-publish","hentry","doc_category-facturas"],"year_month":"2026-09","word_count":483,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Felix Gomez","author_nicename":"felix","author_url":"https:\/\/aprende.dora.ec\/?author=2"},"doc_category_info":[{"term_name":"Facturas","term_url":"https:\/\/aprende.dora.ec\/?doc_category=facturas"}],"doc_tag_info":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Felix Gomez","author_link":"https:\/\/aprende.dora.ec\/?author=2"},"uagb_comment_info":0,"uagb_excerpt":"2 Como crear Facturas de forma masiva con Excel Descripci\u00f3n: Este procedimiento sirve para importar y emitir m\u00faltiples facturas de [&hellip;]","_links":{"self":[{"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=\/wp\/v2\/docs\/153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=153"}],"version-history":[{"count":0,"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=\/wp\/v2\/docs\/153\/revisions"}],"wp:attachment":[{"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=153"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_category&post=153"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/aprende.dora.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}