OdooWiki OCA HUB

Bank statement import move lines

account_bank_statement_import_move_line folder_open OCA/bank-statement-import open_in_new
Accounting License: AGPL-3

This module adds a button to bank statement form view to open a wizard to allow filtering, selecting and importing lines form journal items into the bank statement.

auto_awesome What this module does

AI-generated from the code · Odoo 15.0

Adds an "Import Journal Items" button on open bank statements that opens a wizard to filter, select and turn existing journal items into bank statement lines.

When a bank statement is open, an "Import Journal Items" button appears on the statement form (visible to accounting users). It opens a wizard called "Choose Move Lines Filter Options" where you can narrow down which journal items to bring in.

In the wizard you can filter by partner, journals, target moves (all posted entries or all entries), whether the line is linked to an invoice or refund, whether to allow litigation (blocked) lines, and by date type — due date or move date. The wizard only looks at unreconciled payable and receivable lines of the current company, and it excludes lines that already belong to a payment.

  • "Add All Move Lines" automatically selects every journal item matching your filters; you can also pick lines manually in the list.
  • The list shows date, journal, partner, account, due date, debit, credit, residual amounts and currency.
  • "Create Statement Lines" converts the selected journal items into bank statement lines, copying the description, partner, reference, due date, currency and amount (debit positive, credit negative).

It extends account.move.line with the conversion logic and adds the new wizard model account.statement.line.create. No scheduled jobs or emails are involved.

Depends on

account
Models and fields (2)
  • account.move.line · extends an existing model
  • account.statement.line.create · new modelinvoice (Linked to an Invoice or Refund), due_date, date_type (Type of Date Filter), move_date, partner_id (Partner Related), journal_ids (Journals Filter), target_move (Target Moves), statement_id (Bank Statement), allow_blocked (Allow Litigation Move Lines), move_line_ids (Move Lines)

Text generated by AI (DeepSeek) from reading the Odoo 15.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 3 confirmed, 6 with no information of 9 versions.

Sources · Odoo 15.0

Confirmed on 2026-11-03 in branch 15.0 of OCA/bank-statement-import.

terminal Installation and usage

OCA documentation · Odoo 15.0

To configure this module, you need to:

  • Go to Settings > Users & Companies > Users.
  • Open the user that needs to use this feature.
  • Mark the check Show Full Accounting Features.
  • Go to Invoicing > Dashboard.
  • Create a new bank statement from a bank journal.
  • Click button "Import Journal Items".
  • Select filtering options.
  • Click on button "Add All Move Lines" to auto-select the move lines matching the selected criteria or click on Add an item to manually select the move lines filtered by the criteria.
  • Click on button "Create Statement Lines".

No verified information in OCA: Installation.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.