Skip to content
TAQNIX
Odoo ModulesWordPress PluginsWordPress ThemesShopify ThemesApp TemplatesScripts & UtilitiesBlogSell on TAQNIX
ModuleOdooNew

Accounting Pro Management Reports for Odoo 19 Community – Profitability by Customer, Product and Salesperson, Executive Summary, Rolling 13-Month Profit and Loss, Customer Concentration

Gross profit and margin by customer, product and salesperson that tie to the Profit and Loss, a one-page executive summary with traffic lights, a rolling 13-month profit and loss and customer concentration inside Accounting Pro, on screen, in PDF and in Excel. Arabic included.

No reviews yet0 salesby TAQNIXUpdated Oct 29, 2026

Description

Management reports inside Accounting Pro

Accounting Pro Management Reports adds six management reports to Accounting Pro on Odoo 19 Community: who and what makes your gross profit, a one-page summary for the board, the last 13 months of the profit and loss, and how much of your revenue depends on a few customers. They open in the report screen of Accounting Pro, print as PDF and export to Excel like the other reports, and their totals equal the Accounting Pro Profit and Loss for the same period and filters.

Who really makes your profit

Profitability

  • Profitability by Customer: revenue, cost, gross profit, margin, documents, average document, share of revenue and open receivable per customer; rows by customer, partner tag, country or salesperson; one or two comparison periods; top N with Others, a minimum revenue and a salesperson filter
  • Profitability by Product: quantity, revenue, cost, gross profit, margin, average price and average cost per product or product category; services without cost at 100 %
  • Estimate missing costs: goods sold without any booked cost get quantity × the product's cost, in italics and apart from the Cost column, with a warning when the same cost may also be booked without a product
  • Profitability by Salesperson: revenue, cost, gross profit, margin, documents, customers and rank (by revenue, gross profit or margin)
  • A Not allocated or No product row keeps every total equal to the Profit and Loss
Margins by product and category

For the board

  • Executive Summary on one A4 page: revenue, cost of revenue, gross and net profit and their margins, bank and cash, receivables, payables, DSO, DPO and cash cover, against the previous period and the same period last year, with traffic lights at the levels you set; the top 5 customers, products and expense accounts
  • Rolling 13-Month Profit and Loss: the lines of the Profit and Loss month by month with total, average, 3-month average, month-over-month change and % of revenue
  • Customer Concentration: ABC classes, the share of the top N customers and the Herfindahl-Hirschman index with its reading, and the cumulative share of each customer
  • A Gross margin card on the Accounting Dashboard with its change in points and a 12-month trend
The board page on one A4

Everywhere in Accounting Pro

  • Click an amount for its journal items, a number of documents for the invoices
  • PDF and Excel with real numbers, favorites, scheduled reports by email and the financial package
  • A settings block per company: other income as revenue, rows before Others, ABC limits and the traffic-light levels
A rolling year, month by month

What it does not do

  • No allocation of operating expenses: the reports show gross profit, not a net profit per customer, product or salesperson
  • No link to sale orders, deliveries or stock moves: costs come from the journal items, each in its own period, and a customer or product gets only the cost booked with it
  • When the salesperson of an invoice differs from the customer's salesperson, the stock valuation cost of that sale goes to the customer's salesperson
  • The estimate uses today's product cost, counts a cost twice when it is also booked without a product (the report warns) and is never posted
  • Tags, countries and product categories are today's values; comparison columns only in Profitability by Customer; "all rows" stops at 2,000 rows, the rest go to Others
  • The year-end closing entries of the Accounting Pro Closing add-on are left out through a rule that add-on reads: the two add-ons were not tested together
  • The Excel files were not opened in Microsoft Excel and their estimated cells are not in italics; in an Arabic PDF a name mixing Latin and Arabic can show its parts in another order
From entries to decisions

Accurate

Revenue is the Income accounts (and Other Income when you choose), cost is the Cost of Revenue accounts, read from the same journal items and with the same function as the Accounting Pro Profit and Loss: posted entries (drafts when asked), the journal and analytic filters, other currencies at the rate of the end date. The rows share out the cents so that they add up to the Profit and Loss exactly.

How much rides on a few customers

Tested

101 automated tests of the add-on (628 with those of Accounting Pro): every report against the Profit and Loss with filters, comparison, drafts, credit notes, several currencies and a second company; exact figures, drill-downs, ABC limits, traffic lights, the one-page PDF with long names in English and Arabic, access rights, and a number of database queries that does not grow with the number of customers or products.

Gross margin, at a glance

Documented

Illustrated guide in English and Arabic and an Arabic translation of the whole add-on.

Six reports for owners and CFOs

What's included

  • taqnix_accounting_pro_profitability.zip: the Odoo 19 module (with Arabic translation)
  • Illustrated documentation in English and Arabic (HTML and PDF)
  • Automated tests, licence file (OPL-1) and changelog

Requirements

Odoo 19.0 with Accounting Pro 1.0.2 or later (taqnix_accounting_pro)

What's in the download

The files in the archive you can download after you buy.

  • Full source code
  • Documentation
  • Installation guide
  • Automated tests
  • Licence file
  • Changelog

Customer reviews

Write a review

No reviews yet. Bought this item? Be the first to review it.

Usage

Install and use it in a few lines.

engine = env["taqnix.acc.engine"]        # the management reports are Accounting Pro reports: same engine, same access rights

# Profitability by Customer for the year to date, with the same months of last year
table = engine.get_table("profit_customer", {"date": {"preset": "year_to_date"}, "compare": {"mode": "year", "count": 1}})
for row in table["rows"]:
    print(row["type"], [cell.get("text") for cell in row["cells"][:5]])    # account ['Gulf Cooling Services', '819,316.36', ...]

# the board figures of last month from the Executive Summary (figure and traffic light)
summary = engine.get_table("executive_summary", {"date": {"preset": "last_month"}})
for row in summary["rows"]:
    if row["id"] in ("revenue", "gp", "gm", "np", "bank", "cover"):
        print(row["cells"][0]["text"], row["cells"][1].get("text"), row["cells"][-1].get("text"))

Documentation

Setup, settings and troubleshooting, written by the author.

Open the documentation

Changelog

Every release, newest first.

v1.0.0

1.0.0 – Initial release

  • Profitability by Customer (rows by customer, partner tag, country or salesperson; one or two comparison periods; top N, minimum revenue and salesperson filter; open receivable), Profitability by Product (by product or category, quantities, average price and cost, estimate of missing costs shown apart) and Profitability by Salesperson (ranked), with totals equal to the Profit and Loss
  • Executive Summary on one A4 page: results, margins, bank and cash, receivables, payables, DSO, DPO, cash cover and top 5 lists against the previous period and the same period last year, with traffic lights
  • Rolling 13-Month Profit and Loss with total, average, 3-month average, month-over-month change and % of revenue; Customer Concentration with ABC classes, the top N share and the Herfindahl-Hirschman index
  • Accounting Pro screen, drill-down, PDF, Excel, favorites, scheduled reports and financial package for the six reports; a Gross margin card on the Accounting Dashboard; a settings block per company
  • Arabic translation and right-to-left screens, PDF and Excel

Frequently asked questions

What do I need to install it?

Odoo 19 (Community or Enterprise) with Accounting Pro 1.0.2 or later (taqnix_accounting_pro) already installed: this is an add-on of Accounting Pro and it does not work without it. No other app is needed, because every figure is read from the journal items. For a cost per customer and per product, the cost of revenue must be booked with the customer and the product, for example the cost of goods sold lines of the invoices or stock valuation entries.

Do the totals match my Profit and Loss?

Yes. Revenue (the Income accounts, and Other Income if you choose it in the settings) and cost of revenue are read from the same journal items with the same function as the Accounting Pro Profit and Loss, for the same period and filters. What cannot be given to a customer, product or salesperson stays in a Not allocated or No product row, so the totals equal the Profit and Loss; with several currencies the rows share out the cents so that they add up exactly.

Where does the cost of a customer or a product come from?

From the cost of revenue journal items that carry that customer or product, in the period of each item. Cost booked without them goes to Not allocated (no customer) or No product. For goods sold without any booked cost, the option Estimate missing costs adds the quantity sold × the product's cost today, in italics and apart from the Cost column; if the same cost is also booked without a product, the estimate counts it twice and the report shows a warning. The estimate is never posted.

How is a sale given to a salesperson?

Revenue goes to the salesperson of the invoice, credit note or receipt. A cost entry that is not an invoice, such as a stock valuation entry, goes to the salesperson of its customer, so when an invoice's salesperson differs from the customer's salesperson, the revenue and the cost of that sale land on different people. Documents without salesperson, vendor bills and entries without customer are shown as Not allocated.

What is in the Executive Summary?

One A4 page for the board: revenue, cost of revenue, gross profit and margin, operating expenses, net profit and margin, bank and cash, receivables, payables, days sales outstanding, days payables outstanding and cash cover, for the period, the previous period and the same period last year, with the change and green, amber or red lights for the two margins and the cash cover (levels in the settings), then the top 5 customers, products and expense accounts. In the PDF a long name ends with an ellipsis so that the summary stays on one page.

What does it not do?

It does not share out operating expenses (gross profit only, not a net profit per customer or product) and it does not read sale orders, deliveries or stock moves: costs come from the journal items, each in its own period. Tags, countries and product categories are today's values. Only Profitability by Customer has comparison columns, and "all rows" stops at 2,000 rows. The year-end closing entries of the Accounting Pro Closing add-on are left out through a rule that add-on reads, but the two add-ons were not tested together. The Excel files were not opened in Microsoft Excel.

How is it different from the Taqnix module “Project Profitability”?

That module stands on its own and measures each project (revenue, costs and margin, with the Project and Timesheets apps). This add-on needs Accounting Pro and measures the company by customer, product and salesperson from the journal items, with an executive summary, a rolling 13-month profit and loss and customer concentration in the Accounting Pro screen, PDF and Excel. They answer different questions.

Who can see the reports?

Users with the Accounting Pro reports access (given with Odoo's accounting roles) open the six reports; the settings block is for accounting administrators, and scheduled reports need the Accounting Pro designer and schedules right. Each user sees only the companies they have access to, and the journal items behind a figure stay in those companies.

Is it available in Arabic?

Yes. The add-on, its guide and its screens come in English and Arabic, and the screen, the PDF and the Excel file work right to left.

More from TAQNIX

  • App templateNew

    Taqnix POS Terminal – Offline-First Point of Sale PWA for Odoo 19: Next.js Source Code with Restaurant Tables, Kitchen Tickets, Loyalty and Arabic

    A point of sale for Odoo 19 that runs in the browser as an installable app and keeps selling when the network is gone: every order is saved on the device first and sent to Odoo once, with the same call Odoo's own POS uses. Variants and combos, split payments, receipts with barcode and QR, restaurant tables and kitchen tickets, dashboard, stock lookup, layaway, loyalty, English and Arabic. Full Next.js source code; no Odoo module to install.

    by TAQNIX
    No reviews yet
    Sales:0$399.00
  • ModuleNew

    UAE E-Invoicing (PINT AE) for Odoo 19 Community – PINT AE XML for Your ASP, Readiness Checks, UBL XSD and Schematron Validation, E-Invoice Outbox

    Prepare UAE e-invoices and credit notes in the PINT AE format (Peppol PINT AE Billing 1.0.4, UBL 2.1) for your Accredited Service Provider: TIN, TRN and tax categories, readiness checks per invoice and per batch, validation against the official XSD and Schematron, an outbox with statuses, a log and XML / ZIP export. It does not send anything. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$149.00
  • PluginNew

    AI Support Reply Drafts for WooCommerce – Order-Aware Customer Reply Drafts with Fact Checks

    Draft replies to customer messages on the WooCommerce order screen with your AI model, from the order facts and your own shop texts only. Missing facts become [CHECK] placeholders; nothing is sent without a click and a confirmation.

    by TAQNIX
    No reviews yet
    Sales:0$49.00
  • PluginNew

    AI Product Recommender and Bundles for WooCommerce – Related Products, Complete the Look & Add All to Cart

    Related products and “complete the look” bundles ranked by AI meaning similarity and what your customers bought together, with Add all to cart, a preview with the reasons, pins and exclusions.

    by TAQNIX
    No reviews yet
    Sales:0$49.00

Similar items

  • ModuleNew

    UAE E-Invoicing (PINT AE) for Odoo 19 Community – PINT AE XML for Your ASP, Readiness Checks, UBL XSD and Schematron Validation, E-Invoice Outbox

    Prepare UAE e-invoices and credit notes in the PINT AE format (Peppol PINT AE Billing 1.0.4, UBL 2.1) for your Accredited Service Provider: TIN, TRN and tax categories, readiness checks per invoice and per batch, validation against the official XSD and Schematron, an outbox with statuses, a log and XML / ZIP export. It does not send anything. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$149.00
  • ModuleNew

    Accounting Pro Group Consolidation for Odoo 19 Community – Multi-Company Consolidated Balance Sheet and P&L, Intercompany Elimination, Currency Translation, Non-Controlling Interest, PDF and Excel

    Consolidate the companies of one Odoo database inside Accounting Pro: currency translation with a translation reserve, intercompany elimination with visible differences, investment elimination with goodwill, non-controlling interests, runs that lock, five reports on screen, PDF and Excel. The method and its simplifications are listed. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$199.00
  • ModuleNew

    Accounting Pro GCC VAT Returns for Odoo 19 Community – UAE VAT 201 and KSA VAT Return Worksheets, FTA Audit File (FAF), Reconciliation, PDF and Excel

    UAE VAT 201 and KSA VAT return worksheets from your posted journal items inside Accounting Pro: boxes by emirate, reverse charge and imports, review and filing workflow with an audit log, reconciliation with the general ledger, transactions per box, FTA Audit File export, PDF and Excel. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$129.00
  • ModuleNew

    Accounting Pro Closing for Odoo 19 Community – Month-End Close Checklist, Lock Dates, Year-End Closing Entry and Profit Appropriation, Close Status in PDF and Excel

    Month-end and year-end close inside Accounting Pro: a close checklist with automatic checks, lock dates set the way Odoo supports with an audit log, the year-end closing entry and its reversal, profit appropriation with the statutory reserve percentages as settings (for UAE or Saudi rules), and a Close Status report on screen, in PDF and in Excel. Arabic included.

    by TAQNIX
    No reviews yet
    Sales:0$99.00