OdooWiki OCA HUB

Libros registro del IVA y del IRPF

l10n_es_vat_book folder_open OCA/l10n-spain open_in_new
Accounting License: AGPL-3

Módulo que calcula los libros de IVA e IRPF español.

Esto módulo introduce el menú "Libros de IVA y del IRPF" en Contabilidad -\> Informe -\> Declaraciones AEAT.

Es posible visualizar e imprimir por separado:

  • Libro Registro de Facturas Emitidas
  • Libro Registro de Facturas Recibidas

Es posible exportar los registros a archivo con extensión xlsx.

En el modo de visualización de los informes es posible navegar a los asientos contables relacionados con la factura.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Lets Spanish companies generate, review and export the VAT and IRPF register books (issued and received invoices) from their posted accounting entries, with tax summaries and an Excel export.

This module adds a new report type, the VAT Book, used to build the Spanish VAT and IRPF register books from accounting data.

Where it appears: a new menu "Libros del IVA y del IRPF" under the AEAT declarations area of Accounting, plus a configuration menu "AEAT vat book map" to define which taxes and accounts feed each book.

What users can do: - Create a VAT book for a period, choosing monthly or quarterly settlement. - Press calculate to collect posted journal entries in the period and split them into issued invoices, received invoices, and their refund (rectification) counterparts. - See a Summary tab with tax summaries per tax and totals per special group (R.Eq., IRPF), and invoice tabs listing each line with partner, VAT number, base and total. - Open the related journal entry from a line, and use search buttons on the tax summary to jump to the underlying journal items. - View or print separate issued and received invoice reports, and export the book to an Excel (xlsx) file, either as a draft or as the final BOE version once confirmed.

Automatic behaviours and rules: - The company must have a VAT number, otherwise calculation is blocked. - Lines without a partner or without a valid VAT number are flagged with a warning; confirming the book is refused while warnings remain. - Negative bases are automatically classified as refund invoices. - An option can automatically renumber received invoices by date and reference. - Records are restricted to the user's allowed companies.

Menus it adds

AEAT vat book mapLibros del IVA y del IRPF
Models and fields (7)
  • l10n.es.vat.book · new modelnumber, line_ids (Issued/Received invoices), error_count, summary_ids (Summary), auto_renumber (Auto renumber invoices received), issued_line_ids (Issued invoices), tax_summary_ids (Tax Summary), calculation_date, received_line_ids (Received invoices), issued_summary_ids (Issued Summary), received_summary_ids (Received Summary), vat_settlement_period, issued_tax_summary_ids (Issued Tax Summary), received_tax_summary_ids (Received Tax Summary), rectification_issued_line_ids (Issued Refund Invoices), rectification_received_line_ids (Received Refund Invoices)
  • l10n.es.vat.book.line · new modelref (Reference), move_id (Journal Entry), line_type, partner_id (Empresa), vat_number (NIF), base_amount (Base), vat_book_id (Vat Book id), entry_number, external_ref (External Reference), invoice_date, tax_line_ids (Tax Lines), total_amount (Total), exception_text, special_tax_group (Special group)
  • aeat.vat.book.map.line · new modelname, book_type, tax_xmlid_ids (Taxes), tax_agency_ids (Tax Agency), special_tax_group (Special group), fee_type_xlsx_column (Type xlsx column), fee_amount_xlsx_column (Base xlsx column), excluded_account_xmlid_id (Tax Account Restriction)
  • l10n.es.vat.book.summary · new modelbook_type, tax_amount, base_amount, vat_book_id (Vat Book id), total_amount, special_tax_group (Special group)
  • l10n.es.vat.book.line.tax · new modeltax_id (Tax), tax_rate (Tax Rate (%)), tax_amount (Tax fee), base_amount (Base), total_amount (Total), move_line_ids (Move Lines), special_tax_id (Special Tax), vat_book_line_id, deductible_amount, special_tax_group (Special group), base_move_line_ids (Move Lines (Base)), special_tax_amount (Special Tax fee), total_amount_special_include (Total w/Special)
  • l10n.es.vat.book.tax.summary · new modeltax_id (Account Tax), move_line_ids (Journal items), base_move_line_ids (Journal items (Base))
  • report.l10n_es_vat_book.l10n_es_vat_book_xlsx · new model

Text generated by AI (DeepSeek) from reading the Odoo 19.0 code on GitHub; it may contain mistakes, so check the code before deciding. The module is very large and only part of the code was read. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 8 confirmed, 1 with no information of 9 versions.

Sources · Odoo 19.0

Confirmed on 2026-11-03 in branch 19.0 of OCA/l10n-spain.

terminal Installation and usage

OCA documentation · Odoo 19.0

Para instalar este modulo necesitas:

  • account
  • base_vat
  • l10n_es
  • l10n_es_aeat
  • report_xlsx

Se instalan automáticamente si están disponibles en la lista de addons.

Consideraciones adicionales:

  • Es importante que en facturas que deban aparecer en los libros registros, no sujetos a IVA, informar el tipo de IVA 'No Sujeto' en facturas. Para evitar que los usuarios olviden informarlo es recomendable instalar el módulo 'account_invoice_tax_required'.

Los códigos de impuestos incluidos en el Libro de IVA pueden verse en: Contabilidad -\> Configuración -\> AEAT -\> Mapeo AEAT libro de IVA

Los clientes utilizados para ventas por caja deben tener marcado el campo "AEAT - Cliente anónimo" para que no se muestren advertencias por no tener NIF informado siguiendo lo especificado en el formato BOE.

  • Ve a Contabilidad \> Declaraciones AEAT \> Libro de IVA.
  • Crea un nuevo registro.
  • Escoge el periodo de tiempo para el libro.
  • Pulsa en "Calcular".
  • Escoge la opción de visualización o impresión preferida.
info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.