account_statement_import_sheet_file

Key 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.