Account Move Line XLSX export
This module extends the functionality of the journal items ('account.move.line') list view and allow you to export the selected lines.
auto_awesome What this module does
AI-generated from the code · Odoo 18.0Adds an "Export Selected Lines" action on Journal Items so you can download the selected journal item lines as an Excel (XLSX) file with many accounting columns and debit/credit/balance totals.
This module adds an Excel export directly on the Journal Items list (the account.move.line model). When you select one or more lines in that list, an "Export Selected Lines" action is available and produces an XLSX file.
The exported sheet is titled "Journal Items" and is set up for printing in landscape, fitted to one page wide, with a standard header and footer and frozen header row. It includes columns such as Entry, Name, Reference, Effective Date, Partner, Partner Reference, Account, Maturity Date, Debit, Credit, Balance, reconciliation reference, Reconcile Amount, Matched Debits, Matched Credits, Amount in Currency, Currency, Journal, Company Currency, Product, Product Reference, Unit of Measure, Quantity, Statement, Invoice, Residual Amount, Residual Amount in Currency, Notes, a blocked indicator and the line Id.
Debit, Credit and Balance columns are totalled at the bottom using spreadsheet formulas, with Balance computed as total Debit minus total Credit. Dates and amounts are formatted for readability.
The set of columns and their order can be adjusted by developers through the line model's export field list and template settings, but no configuration screen is provided by this module.
Depends on
Models and fields (1)
- report.account_move_line_report_xls.account_move_line_xlsx · new model
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 17.0
Confirmed on 2026-11-03 in branch 17.0 of OCA/account-financial-reporting.
terminal Installation and usage
OCA documentation · Odoo 18.0Usage
Source · Odoo 18.0To use this module, you need to:
- go to the list view of the journal items
- select the lines you wish to export
- click on the button on top to export
The Excel export can be tailored to your exact needs via the following methods of the 'account.move.line' object:
- _report_xlsx_fields Add/drop columns or change order from the list of columns that are defined in the Excel template. The following fields are defined in the Excel template: > move, name, date, journal, period, partner, account, date_maturity, > debit, credit, balance, reconcile, reconcile_partial, > analytic_account, ref, partner_ref, tax_code, tax_amount, > amount_residual, amount_currency, currency_name, company_currency, > amount_residual_currency, product, product_ref', product_uom, > quantity, statement, invoice, narration, blocked
- _report_xlsx_template Change/extend the Excel template.
No verified information in OCA: Installation, Configuration.
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.