Journal Presets UI

New CSV Import settings page on each bank journal for delimiter, encoding, date and number formats with sensible defaults.

Guided Column Mapping

Instantly align CSV headers to statement fields with reusable presets for date, debit, credit, and balance columns.

AI Anomaly Alerts

Queue AI jobs that analyze imported statements for payment gaps, abnormal balances, and reconciliation blockers.

Duplicate Transaction Shield

Automatic duplicate detection uses unique IDs, references, and amount/date combinations to flag risky rows before import.

Locale-Aware Amount Parsing

Honor journal-specific delimiter, decimal, and thousands separators so imports remain stable across international banks.

Transactional Savepoints

Every import runs behind database savepoints, so failed rows roll back cleanly without leaving orphan statements.

Downloadable Templates

Provide accountants with ready-to-use CSV templates that reinforce correct column order and formatting.

Journal-Level Controls

Toggle CSV import availability per bank journal with encoding, date format, and separator presets stored centrally.

Reconciliation Shortcuts

Jump directly into the reconciliation dashboard after import to clear outstanding entries while context is fresh.

Audit Trail Enrichment

Capture original filenames, import timestamps, and linked AI job references for future audits and reports.

Enterprise Test Coverage

Built-in tests verify CSV sample imports, duplicate warnings, and AI handoffs so upgrades remain dependable.

Installation & Setup

1. Install the module: Go to Apps -> Search for "oe_bank_import_csv" -> Click Install
2. Configure permissions: Navigate to Settings -> Users & Companies -> Grant Accounting roles access to Bank Feeds
3. Initial configuration: Open Accounting -> Configuration -> Journals -> enable CSV import and review delimiter, encoding, and date format

Basic Usage

1. Launch the wizard: Accounting -> Bank -> Import Statement -> select the CSV option and download the sample template if needed
2. Map CSV columns: Upload your bank CSV, check headers, and confirm debit/credit or amount mappings before importing
3. Review warnings: Address duplicate alerts or missing fields displayed in the wizard feedback box
4. Complete reconciliation: Click Finish to jump straight into the bank reconciliation dashboard with your new statement

Tips & Best Practices

• Save commonly used column mappings to accelerate future imports
• Keep journal presets aligned with your bank's export settings to avoid formatting errors
• Use the duplicate summary message to remove overlapping transactions before validation
• Trigger the AI analysis button after reconciliation to capture trend insights for controllers

Important Notes

CSV uploads should come directly from your banking portal without spreadsheet reformatting. If you must edit, preserve raw numeric values and avoid merging columns so the duplicate detector remains effective.

Q: Which Odoo versions does oe_bank_import_csv support?

A: This module supports Odoo 12 through 19 Community and Enterprise. Each version is maintained separately with version-specific compatibility.

Q: Can I import statements from multiple banks with different formats?

A: Yes. Configure delimiter, encoding, and date formats per journal. Each bank's preset persists so you can switch between institutions without manual adjustments.

Q: How does the AI integration add value to bank reconciliation?

A: The module tags each statement with an AI job that summarizes trends, highlights large payments, and flags unusual gaps in activity. Controllers receive actionable guidance before closing the period.

Why Choose Odoo Engineering