account_statement_import_sheet_file

Purpose

This module enables the import of bank statements from TXT, CSV, or XLSX files into Odoo.

Features

account.statement.import.sheet.mapping: Defines configurable mappings for parsing sheet files, including separators, encodings, delimiters, and column assignments for various transaction fields.
account.statement.import: Extends the bank statement import wizard to support sheet mappings for TXT/CSV/XLSX file formats.
account.journal: Adds default sheet mapping configuration to journals and registers TXT/CSV/XLSX as available import formats.
parsing: Supports parsing of CSV and XLSX files with various encodings, delimiters, separators, and handles skipping headers, footers, offsets, and empty lines.
amount_types: Supports different amount representation types including simple values, absolute values with debit/credit indicators, and distinct debit/credit columns.
multi_currency: Handles multi-currency transactions with support for original currency and amount columns.
balance: Supports balance columns for automatic calculation of statement start and end balances.
amount_inverse_sign: Allows inverting the sign of amounts for files where amounts are represented inversely (e.g., credit card statements).
column_concatenation: Enables concatenating multiple columns into single fields using comma-separated column names or numbers.
no_header: Supports files without headers by specifying column numbers instead of names.
validation: Validates mapping configurations to ensure required fields are set based on selected amount types.