Bank statement import move lines
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 18.0This module lets accountants turn existing journal items (unreconciled receivable/payable entries) into bank statement lines. A wizard filters and selects the move lines, then creates the statement lines in one click.
This module adds a way to build bank statement lines from existing journal items instead of typing them manually.
From a bank statement form, a button "Import Journal Items" opens a wizard. The same option appears on the accounting journal dashboard. The wizard lets you filter the journal items by partner, journals, target moves (all entries or only posted ones), date type (due date or move date), and whether the entry is linked to an invoice or refund. You can then click "Add All Move Lines" to select everything matching the filters, or pick lines manually from the list.
When you confirm with "Create Statement Lines", the selected journal items are converted into bank statement lines on the chosen statement. If you started from a journal dashboard, a new statement is created automatically for that journal with today's date. The amount is taken from the debit or credit of each item, and the partner, reference, maturity date and currency are carried over.
The module only considers unreconciled receivable and payable items of the current company, and it excludes items already linked to payments. It touches account.move.line, account.bank.statement and the new wizard model account.statement.line.create.
Depends on
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), move_line_ids (Move Lines)
Text generated by AI (DeepSeek) from reading the Odoo 18.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-03Confirmation status: 4 confirmed, 5 with no information of 9 versions.
Sources · Odoo 14.0
Confirmed on 2026-11-03 in branch 14.0 of OCA/bank-statement-import.
terminal Installation and usage
OCA documentation · Odoo 18.0Configuration
Source · Odoo 18.0To configure this module, you need to:
- Go to Settings \> Users & Companies \> Groups.
- Search for the group Show Full Accounting Features.
- Add the user who needs to use this function.
Usage
Source · Odoo 18.0Journal entries can be imported in two ways, from a new bank statement or from an existing bank statement.
- Go to Invoicing > Dashboard.
- To import to a new statement, in the relevant bank journal click on ‘Import journal items’. To import from an existing bank statement, open the statement form and click on ‘Import journal items’.
- Select the filtering options.
- Click on the ‘Add all transaction lines’ button to automatically select the transaction lines matching the selected criteria or click on Add an item to manually select the transaction lines filtered by the criteria.
- Click the ‘Create extract lines’ button.
No verified information in OCA: Installation.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
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.