OdooWiki OCA HUB

Account Move Line XLSX export

account_move_line_report_xls folder_open OCA/account-financial-reporting open_in_new
Accounting & Finance License: AGPL-3

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.0

Adds 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-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 4 confirmed, 5 with no information of 9 versions.

Sources · Odoo 15.0

Confirmed on 2026-11-03 in branch 15.0 of OCA/account-financial-reporting.

terminal Installation and usage

OCA documentation · Odoo 18.0

To 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.

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.