Skip to Content

OE Finance: Bank Statement Importer

by
Odoo

$ 40.60

v 13.0 Third Party
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Community Apps Dependencies
Lines of code 2791
Technical Name oe_bank_statement_importer
LicenseOPL-1
Websitehttps://odooengineering.com
Versions 12.0 13.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Community Apps Dependencies
Lines of code 2791
Technical Name oe_bank_statement_importer
LicenseOPL-1
Websitehttps://odooengineering.com
Versions 12.0 13.0
Keywords: oe_bank_statement_importer, 20+ languages, multilingual, bank statement import, PNC CSV, reconciliation automation, duplicate detection, treasury management, AI insights, Odoo 12 accounting, cash application, finance operations, audit trail
Odoo Engineering

OE Finance: Bank Statement Importer

Automate PNC CSV imports with duplicate-proof reconciliation and AI-driven cash insights for controllers and treasury teams

Try It Out Contact Us

Enhanced Features in This Version

Professional Capabilities for Your Business

Import Preview Wizard

Review and validate every transaction in a preview table before committing - catch errors before they hit your books.

ZIP Batch Import

Upload one archive with multiple CSVs and process them all at once - ideal for multi-account or multi-journal workflows.

Smart Column Mapping

Per-journal mapping templates for date, description, and amount columns - save and reuse across imports.

Delimiter & Decimal Detection

Auto-detect commas, semicolons, tabs, and decimal separators - handles European and US formats without configuration.

Duplicate Shielding

Unique SHA1 hashing across date, amount, journal, and memo ensures you never import the same line twice.

PNC & Generic CSV Helpers

Tolerant header normalization for PNC Business Checking exports and generic CSV layouts from Chase, BOA, and others.

AI Statement Insights

Queue AI jobs to summarize import volumes, cash delta, and duplicate trends directly from each journal.

Multi-Company Awareness

Automatically assigns company context so imports stay isolated across subsidiaries and shared services teams.

Key Features & Capabilities

Everything you need for professional operations

PNC CSV Normalization

Automatically trims BOM markers, normalizes headers, and accepts both Amount or Deposit/Withdrawal layouts without manual edits.

Duplicate Shielding

Unique SHA1 hashing across date, amount, journal, and memo ensures you never import the same line twice.

Smart Amount Strategy

Automatically determines whether to use single amount columns or calculate net totals from split debit/credit pairs.

Guided Journal Helpers

On-form hints and notifications keep users aligned with the expected bank profile and highlight missing configuration.

Balance Reconstruction

Derives starting and ending balances from the last line when present, improving reconciliation ease.

Actionable Errors

Line-by-line feedback for invalid dates, malformed amounts, or missing headers keeps imports clean and auditable.

AI Statement Insights

Queue AI jobs to summarize import volumes, cash delta, and duplicate trends directly from each journal.

Multi-Company Awareness

Automatically assigns company context so imports stay isolated across subsidiaries and shared services teams.

Reconciliation Ready Output

Delivers clean statement payloads to Odoo's reconciliation widget with references, memos, and dates intact.

Secure Access Controls

Respects Odoo ACLs and record rules so only authorized users can queue AI analysis or import statements.

What's Included

Core Features

  • PNC-specific CSV parser with flexible column detection
  • Duplicate prevention using hashed unique_import_id values
  • Automatic balance_start and balance_end_real calculation

Additional Components

  • Backend CSS/JS assets for contextual journal guidance
  • AI job extension delivering bank statement analytics
  • Marketing collateral, screenshots, and documentation pack

Global Language Support (20+)

Available in 20+ languages: es_ES, fr_FR, it_IT, pt_BR, nl_NL, da_DK, de_DE, pl_PL, ar_001, zh_CN, ru_RU, ja_JP, tr_TR, id_ID, th_TH, vi_VN, ko_KR, pt_PT, sv_SE, cs_CZ.

How to Use This Module

Step-by-Step Instructions to Get Started

Installation & Setup

  1. Install the module: Go to Apps -> Search for "oe_bank_statement_importer" -> Click Install.
  2. Configure permissions: Ensure accounting users have access to import statements and queue AI analysis jobs.
  3. Select the bank profile: Open Accounting -> Configuration -> Journals, choose your PNC bank journal, and set Auto Import Bank to PNC Business Checking.

Basic Usage

  1. Prepare the CSV: Export the activity file from PNC Online Banking in UTF-8 CSV format without altering headers.
  2. Launch the wizard: From Accounting -> Bank -> Import Statement, upload the CSV and confirm the previewed transactions.
  3. Review the summary: Check duplicates skipped, errors reported, and balance totals before accepting.
  4. Reconcile quickly: Use Odoo's reconciliation widget to match lines against invoices and payments.

Tips & Best Practices

  • Automate exports from PNC weekly to keep reconciliation current.
  • Use the AI Analysis button after each close to summarize cash trends for leadership.
  • Archive source CSVs in Odoo Documents or your DMS for audit readiness.
  • Pair with oe_bank_import_csv to cover non-PNC banks using generic templates.

Important Notes

The parser is optimized for PNC Business Checking exports. Other banks may require header mapping or additional modules. Ensure CSV files use the US date locale (MM/DD/YYYY) for best results.

Frequently Asked Questions

Q: Which Odoo versions does this module support?

A: This module supports Odoo 12 through 19 (Community and Enterprise). Contact us for backports or custom version support.

Q: Does it work with banks other than PNC?

A: The parser is optimized for PNC Business Checking CSV exports. Other banks may work if their headers match, but we recommend pairing with our generic oe_bank_import_csv module for broader coverage.

Q: How does duplicate detection operate?

A: Each transaction receives a deterministic unique_import_id hash using journal, date, amount, description, and reference data. The wizard skips duplicates within the file and checks existing Odoo statements to prevent re-imports.

Launch Demo Instance

Explore OE Finance: Bank Statement Importer in a live environment

Try It Now

Proudly American-Owned & Operated

Built for American Businesses First

At Odoo Engineering, we understand the unique needs of American businesses. Our modules are designed with clear, English-first terminology and workflows that align with US business practices, while maintaining universal accessibility for companies worldwide.

Why Choose Odoo Engineering

Professional Excellence Enterprise-grade modules built to the highest standards 90-Day Warranty Full support and bug fixes guaranteed Clear Documentation English-first terminology that everyone understands
US Business Hours Support when American businesses need it most Clean Code Well-documented, easily extensible modules Expert Team Dedicated professionals focused on your success

Quality Odoo modules that are easily extended at reasonable prices – that's the Odoo Engineering promise.

Complete AI Business Intelligence Suite

Powered by our open-sourced oe_ai_job_base framework - Build or Buy AI Extensions

This module is part of our AI Business Intelligence ecosystem. Purchase individual modules or contact us for custom AI solutions built on this proven framework.

Data Cleaner

Auto-fixes addresses, names, phones with smart AI rules

Message Analysis

Sentiment, urgency, and topic extraction for partners

Advanced Search

Natural language queries across your database

QuickBooks Bridge

AI-guided sync with QuickBooks Online

Want something custom? We build AI integrations tailored to your business.

Support & Services

Get Help

Need assistance? Our support team is here to help with installation, configuration, and troubleshooting.

Contact Support

Custom Development

Looking for custom features or integrations? We offer professional Odoo development services.

Request Quote

Ready to Get Started?

Install OE Finance: Bank Statement Importer today and experience the difference quality makes.

Launch Demo Get in Touch

© 2025 Odoo Engineering. All rights reserved.

Professional Odoo modules built with excellence in the USA.

Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.