Skip to Content

Analytic Distribution in Accounting Reports

by
Odoo
v 19.0 Third Party 6
Download for v 19.0 Deploy on Odoo.sh
This module requires Odoo Enterprise Edition.
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Lines of code 128
Technical Name account_reports_analytic_distribution
LicenseLGPL-3
Websitehttps://leapai.ai
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Lines of code 128
Technical Name account_reports_analytic_distribution
LicenseLGPL-3
Websitehttps://leapai.ai

Analytic Distribution in Accounting Reports

Adds an Analytic column to the General Ledger and Partner Ledger reports, so you can see which analytic accounts (projects, departments, cost centres) are linked to every journal entry line — at a glance.

Odoo 19 General Ledger Partner Ledger Analytic Accounting LGPL-3

Overview

By default, Odoo's General Ledger and Partner Ledger show financial figures but hide the analytic dimension. This module adds a dedicated Analytic column to both reports, displaying the analytic accounts and split percentages for each journal entry line.

For the Partner Ledger — where receivable/payable lines rarely carry analytic data directly — the module automatically looks up the analytic distribution from the counterpart income/expense lines of the same journal entry, so the information is always visible without any manual setup.

Key Features

📒

General Ledger — Analytic Column

Each unfolded journal entry line now shows its analytic accounts with split percentages (e.g. Marketing (60%), Operations (40%)).

🤝

Partner Ledger — Analytic Column

Even when the receivable/payable line has no analytic, the module fetches it from the matching income/expense lines of the same move.

⚡

Batch SQL — No N+1 Queries

Analytic data is loaded in a single additional query per report page, keeping rendering fast even on large datasets.

🎨

Demo Data Included

Ships with 5 posted invoices & bills and 3 analytic accounts so the feature is immediately visible after installation with demo data.

Screenshot

General Ledger and Partner Ledger with Analytic column

General Ledger (top) and Partner Ledger (bottom) — the highlighted Analytic column shows project/cost-centre allocations per line.

How It Works

1

Install the module

Depends on account_reports and analytic. Both columns and expressions are added automatically via data records — no configuration required.

2

Open General Ledger

Go to Accounting → Reporting → General Ledger. Unfold any account to see the Analytic column on each journal entry line.

3

Open Partner Ledger

Go to Accounting → Reporting → Partner Ledger. Unfold any partner to see the Analytic column derived from the matching revenue/expense lines.

💡 Tip: The Analytic column respects the existing analytic filters on the General Ledger. Apply an analytic filter to focus on a specific project or cost centre and the column will reflect those values.

Technical Details

  • Inherits account.general.ledger.report.handler — overrides _report_custom_engine_general_ledger() to inject analytic_distribution via a batch query at the AML level.
  • Inherits account.partner.ledger.report.handler — uses the official _get_additional_column_aml_values() hook plus a post-processing step in _get_aml_values() for move-level fallback.
  • A shared helper _format_analytic_distribution() is added to account.report.custom.handler so all report handlers inherit it.
  • The Analytic column is defined as figure_type="string" and renders account names with optional percentage splits (e.g. Marketing (60%), Operations (40%)).
© 2026 LeapAI — LGPL-3 License Version 19.0.1.0.0  ·  Odoo 19

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, please use the developer contact information. They can usually be found in the description.