Import French CFONB Bank Statements

When you open the standard bank statement import wizard, the list of supported file formats now includes an extra option: CFONB (French format, fixed-length text lines of 120 characters). You can select it and upload a CFONB text file.

The module reads the file line by line and checks that every line is exactly 120 characters long; otherwise it stops with an error message. It also checks that the file starts with the code '01' and that all lines belong to the same bank account and the same currency. Only single-account and single-currency files are accepted.

From the file it builds the statement: opening balance, closing balance, statement date, and one transaction per detail line, with date, label, reference, amount and note. Amounts are decoded from the special CFONB character encoding, including debit and credit signs. Additional information lines are appended to the transaction note and, when relevant, to its label.

The module also improves the matching between the imported account number and the bank account configured on the journal, so the correct journal can be found even when the account number is stored in a longer format. It touches the bank statement import wizard and the journal model, and adds the CFONB choice to the import format list.