📊 Partner & General Ledger Report

One wizard. Two powerful reports. Print or export a full Partner Ledger and General Ledger — grouped, totaled, and ready — directly from the Invoicing menu.

Odoo 18 Enterprise & Community PDF & Excel Group-Controlled Access No Extra Dependencies

⚠️ The Problem: Odoo's built-in reports are either locked behind the Enterprise license or too generic. There's no single place to get a clean, grouped partner ledger and general ledger together — with date filtering, totals, and export options — out of the box.

What This Module Does

📅 Date Range Filter Filter all data by a custom From / To date range directly from the wizard.

🤝 Partner Ledger Groups all posted journal items by partner — shows debit, credit, balance, and linked analytic accounts.

📒 General Ledger Groups all posted journal items by account code — shows debit, credit, and balance per account.

📄 PDF Export Clean, styled QWeb PDF report with section headers, column totals, and company branding.

📊 Excel Export Fully formatted XLSX file with colored headers, number formatting, and auto-sized columns.

🔒 Group-Controlled Access Menu and wizard are only visible to users with the Ledger Report Group permission enabled.

How It Works

Step 1 — Enable the Permission

Go to the user's settings and enable the Ledger Report Group checkbox. Only users with this permission can access the report.

Step 2 — Open the Report from the Menu

Navigate to Invoicing → Configuration → Ledger Reports → Print Ledger Reports. The menu only appears for authorized users.

Step 3 — Set the Date Range & Export

A clean wizard opens. Set your From and To dates, then click PDF or Excel to download the report instantly.

Step 4 — Get Your Reports

The Excel report opens as a ready-to-use XLSX file with two sections: Partner Ledger on top, General Ledger below — both with grand totals.

The PDF report is a print-ready document with a professional layout — ideal for sharing with management or auditors.

Report Structure

Partner Ledger Section

#	Column	Description
1	Partner	Partner name from posted journal items.
2	Analytic Accounts	All analytic accounts linked to that partner's lines.
3	Debit	Total debit for the partner in the selected period.
4	Credit	Total credit for the partner in the selected period.
5	Balance	Debit minus Credit.

General Ledger Section

#	Column	Description
1	Account Code	Chart of accounts code.
2	Account Name	Full account name.
3	Debit	Total debit for the account in the selected period.
4	Credit	Total credit for the account in the selected period.
5	Balance	Debit minus Credit.

Developed by MIR

Support: mrouk6348@gmail.com

Licensed under LGPL-3 · Odoo 18