Bank Statement XLS Import

It extends the existing bank statement spreadsheet import so that Microsoft Excel .xls files are accepted. When you upload a statement file in the accounting import screen, Odoo now recognises the .xls format and reads it with the same column mapping you configure for other spreadsheets.

• The module adds the .xls file type to the list of supported formats, so the import wizard accepts it.
• It reads the first sheet of the workbook, skips the header and footer rows you configure, and applies the column offset you set.
• Dates stored as real Excel date cells are converted into proper dates, so they are imported correctly instead of appearing as numbers.
• It uses the same column mapping (label, amount, date, partner, etc.) as the other spreadsheet imports, so no separate configuration is needed.

The feature appears in the bank statement import flow, on the account.statement.import.sheet.parser model, which handles the parsing behind the import wizard. No new menus or screens are added; the .xls option simply becomes available where you already import statements. The module requires the Python xlrd library to be installed on the server.