Sale, purchase & invoice reports, grouped by category — not spreadsheets

One guided wizard turns sale orders, purchase orders and invoices into a print-ready, category-grouped report with subtotals, a grand total, drill-down to the source documents, and matching PDF, Excel and CSV exports — no manual pivot-table rebuilding every reporting cycle.

The problem

Odoo's native pivots can slice orders many ways, but they never produce a clean, print-ready document grouped by product category with subtotals and a grand total. Procurement, sales and finance teams export raw data to a spreadsheet and rebuild the grouping and formatting by hand every reporting cycle — and every existing marketplace app covers only one of sale, purchase, or invoice documents, so buyers end up patching together several single-purpose apps.

The solution

One report engine covers sale orders, purchase orders and customer/vendor invoices. A guided wizard collects the document type, date range, category and partner filters, previews the category-grouped breakdown on screen, then generates identical PDF, Excel and CSV exports — with drill-down to the underlying orders, period comparison, budgets and scheduled email delivery built in.

Capabilities

One report engine, three document types

Every capability below is implemented in the module.

01

Unified Sale, Purchase & Invoice Reporting

Run one report against sale orders, purchase orders, or customer/vendor invoices from a single wizard instead of buying a separate app per document type.

02

Category Hierarchy with Subtotals

Product categories roll up their sub-categories, each with its own subtotal, and the report closes with a bold grand total row for the whole selection.

03

Guided Wizard with Rich Filters

Filter by date range, categories, salespersons, vendors, partners and document state, then preview the result before printing or exporting anything.

04

Drill-Down to Source Documents

Click any category subtotal to open the underlying orders or invoice lines directly, turning a static summary into an auditable trail.

05

Matching PDF, Excel & CSV Exports

Print a branded PDF or export to XLSX or CSV with identical category grouping and totals, so the numbers never need to be re-checked between formats.

06

Comparison, Aging & Budget Variance

Compare a category against the previous period or the previous year, see 30/60/90+ day invoice aging, and track purchase spend against a per-category budget.

07

Customer, Vendor & Product Breakdown

See which customers or vendors drive each category, plus product-level aggregation, optional split by unit of measure, and a per-category discount summary.

08

Saved Templates & Category Budgets

Save a filter set as a reusable template for one-click re-runs, and define per-category purchase budgets to measure actual spend against plan.

09

Scheduled Email Delivery

Set up a recurring schedule and a daily cron sends the category report to the right stakeholders automatically — no one has to remember to run it.

Workflow

How it works

1

Open the wizard

Pick Sale, Purchase, Invoice or Vendor Bill as the document type, or load a saved template.

2

Set the filters

Narrow by date range, categories, salespersons or vendors, and choose breakdown options.

3

Preview the breakdown

Review category rows with subtotals and the grand total on screen before producing anything.

4

Export, save or schedule

Print the PDF, export Excel or CSV, drill down to source records, save as a template, or set up a recurring email delivery.

Questions

Frequently asked

No sales fog. If your question isn't here, email us and we'll answer it the same way.

Sale orders, purchase orders, and customer or vendor invoices — all from the same wizard, so a category-grouped view of revenue, spend or invoiced amounts uses one app instead of three.

Get the app

Buy it on the Odoo App Store

Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.

SO/PO/Invoice Report by Product Category

Category-grouped reports with subtotals across sale orders, purchase orders and invoices, from one guided wizard — with drill-down, budget variance, matching PDF/Excel/CSV and scheduled delivery.

Buy on Odoo App Store