OdooWiki OCA HUB

Importación de extractos bancarios españoles (Norma 43)

l10n_es_account_statement_import_n43 folder_open OCA/l10n-spain open_in_new
Accounting & Finance License: AGPL-3

Importación y tratamiento de los extractos bancarios españoles que siguen la norma/cuaderno 43 de la 'Asociación Española de la Banca'. Puede consultarse la especificación del formato aquí.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Lets you import Spanish bank statements in the AEB Norm 43 (.n43) format into Odoo, with per-bank-journal options to choose which date to use, how to match partners, and which lines to skip.

This module adds a new file format to the standard bank statement import screen: AEB norm 43 (.n43), the Spanish bank standard. When you import such a file, Odoo reads the account header, the movements, the concept lines and the closing records, and creates a bank statement with its transactions.

On each bank journal, in the advanced settings, a new "Norm 43 options" section appears with three settings: - Date type: whether the transaction date comes from the value date or the operation date. - Partner search: how Odoo tries to find the customer or supplier behind a movement, using the concept text. You can pick None, CaixaBank, Santander, Sabadell or All (each bank writes the concept differently). - Exclude pattern: a regular expression; lines whose reference matches it are dropped from the import.

The import checks the file's internal totals: number of debit and credit records, debit and credit amounts, and the final balance (initial balance plus credit minus debit). If anything does not add up, the import stops with an error message. The file encoding is detected automatically, and the currency is taken from the file's currency code.

It touches account.journal (the new settings), account.statement.import (the import wizard) and the bank statement import screen.

Models and fields (2)
  • account.journal · extends an existing modeln43_date_type (Date type for N43 Import), n43_partner_search (Partner search for N43 import), n43_exclude_pattern (Exclude pattern for N43 import)
  • account.statement.import · extends an existing 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. View the code on GitHub

Availability by version

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

Confirmation status: 6 confirmed, 3 with no information of 9 versions.

Sources · Odoo 17.0

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

terminal Installation and usage

OCA documentation · Odoo 19.0
  • Vaya a Contabilidad (Facturación) \> Tablero, y escoja "Importar extracto" en el cuadro que corresponda con el diario de su banco.
  • Seleccione el archivo Norma 43 a importar.
  • Pulse en 'Importar'.
  • Aparecerá el asistente para conciliación inmediatamente después.

No verified information in OCA: Installation, Configuration.

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.