Bank Statement Import: iFOBS (XLS)

by Kitworks Systems

20,00 €

Odoo Apps Dependencies	account, base
Community Apps Dependencies	Show Bank Statement Mixins
Technical Name	kw_bank_statement_ifobs_xls
License	OPL-1
Website	https://kitworks.systems/
Versions	17.0 18.0 19.0

What this module does

Imports iFOBS-platform legacy XLS exports (Raiffeisen, UniCredit, MTB Bank, AstraBank and other iFOBS-client banks) into account.bank.statement.line. The parser does not enforce which bank issued the file — any iFOBS-format XLS works.

Legacy XLS via iFOBS

Reads sheet 0 via xlrd.open_workbook. Excel-native datetime cells are parsed via xldate_as_tuple, with three text fallbacks (%d.%m.%Y, %Y-%m-%d, %d/%m/%Y).

Field mapping

Counterparty: name (col 4), account (col 2), EDRPOU (col 5), MFO (col 3). Description (col 6). Direction is detected by the Ukrainian-locale debit marker in column 1, so the export must be in Ukrainian locale.

Per-journal IBAN filter

A row is imported only if column 0 matches the journal’s bank account number — install one Odoo journal per account.

Deduplication and partner auto-create

Dedup key built from the row’s document reference (col 8). Optionally creates res.partner records by EDRPOU when auto_create_partner is enabled on the journal.