Spanish Bank Statements Importation

Module for the importation of Spanish bank statements following the C43 normative of the 'Asociación Española de la Banca'.

Adds a wizard to the bank statements to perform the importation. The imported file gets attached to the given bank statement. It allows to define default accounting codes for the concepts defined in the C43 bank statement file.

The search of the entries to reconcile (and partner) is done like this:

1. Unreconciled entries with the given reference and amount. The reference is taken from the 'conceptos' or 'referencia2' fields of the statement.

2. Unreconciled entries with (a partner with) the given VAT number and amount. These fields are tested to find a valid spanish VAT:

   • First 9 characters of 'referencia1' (Banc Sabadell)
   • First 9 characters of 'conceptos' (La Caixa)
   • Characters [21:30] of 'conceptos' (Caja Rural del Jalón)

3. Unreconciled entries with the given amount.

If no partner is found, the default account defined for the concept is used.

The module also adds a wizard in Financial Management/Configuration/C43 bank statements to import the default statement concepts, that must be run after creating the spanish chart of accounts (l10n_es module).