Arsalan YasinIf you work with Odoo’s accounting module regularly, you already know that the General Ledger can generate an overwhelming amount of detail. For most day-to-day reporting needs, especially when presenting financial data to management or preparing for an audit, a summary-only view is far more practical. As trusted Odoo Partners Australia, I see this requirement come up consistently across businesses of all sizes, and Odoo 19 handles it cleanly once you know where to look.
This guide walks you through the exact steps to configure, filter, and export a summary-only General Ledger in Odoo 19, covering both PDF and XLSX formats. Whether you are a functional consultant setting this up for a client or a business owner who needs a clean account balances report for a board meeting, this article has you covered.
What Is a Summary-Only General Ledger and Why Does It Matter?
The General Ledger is the master record of all financial transactions across every account in your chart of accounts. In its default detailed state, it displays every individual journal entry, debit credit totals, dates, references, and partner names. For a business running hundreds of transactions per month, this detailed view can easily run into dozens of pages.
A summary-only General Ledger collapses all of that transaction-level detail into a single row per account, showing only the opening balance, total debits, total credits, and closing balance for the selected period. This is the format most useful for management reporting ERP purposes, period-end sign-off, and quick financial health checks.
Understanding when to use summary versus detail is a fundamental skill for any functional consultant working with Odoo 19 financial reporting.
Summary View vs Detailed View: Knowing the Difference
In Odoo 19, the General Ledger defaults to the detailed view, where every account move line is visible. The summary view suppresses individual transactions and shows only the net position per account. Key differences include:
- Detailed view: Every journal entry is listed under its parent account. Best for transaction-level reconciliation and audit trail reviews.
- Summary view: One row per account with aggregated balances. Best for management reporting, high-level period reviews, and external distribution.
Neither view is superior in absolute terms. The right choice depends on what the report is being used for and who is reading it.
Navigating to the General Ledger in Odoo 19
Before configuring anything, you need to reach the correct report within the Odoo 19 accounting dashboard. The navigation path is straightforward but differs slightly from older versions, so it is worth confirming if you have recently upgraded.
Accessing the Accounting Module and Reports Menu
Follow these steps to open the General Ledger report:
- From the main Odoo menu, click Accounting.
- In the top navigation bar within the Accounting module, click Reporting.
- Under the Reporting dropdown, select General Ledger.
You will land on the General Ledger report page, which by default loads the current fiscal period in detailed view. The report toolbar at the top gives you access to all filter, grouping, and export controls you will use in the next steps.
If you do not see the Reporting menu, confirm that your user profile has the Accounting: Adviser or Accounting: Accountant access rights enabled. Standard user roles may not have visibility into financial reports.
Configuring the General Ledger for Summary-Only Output
This is the most important section of the process. Getting the configuration right before you export ensures the output file is clean, concise, and exactly what your audience needs. The Odoo 19 accounting module gives you several controls to achieve a true summary view.
Using the "Hide Line at 0" and Grouping Options
On the General Ledger report page, look for the options panel on the left side (or accessible via the settings gear icon, depending on your view). The key toggle to enable is:
- Unfold All / Fold All toggle: By default, Odoo expands all accounts to show their individual journal entries. Click Fold All to collapse every account to its summary row. This is the primary action that produces the summary-only view.
- Hide Lines at 0: Enable this option to exclude accounts with zero net activity for the period. This keeps the export clean by removing dormant accounts from the output, which is particularly useful for businesses with a large chart of accounts.
These two settings together give you the summary-only General Ledger that shows account balances by period without the transaction noise underneath.
Applying Date Filters and Comparison Periods
With the view folded, the next step is defining the date range for your report. Odoo 19’s Reporting filters work as follows:
- Click the Filters button in the top search bar area.
- Select a pre-defined period such as This Month, This Quarter, or This Financial Year, or set a custom date range using the Date option.
- To add a period comparison for trend analysis, click the Comparison menu and select a prior period. Odoo 19 will add comparison columns to the summary view automatically.
For a clean management report, most consultants recommend setting the filter to the full financial period being reported (e.g., the full quarter or financial year to date) without enabling comparison columns, unless the audience specifically needs year-on-year context. Keeping the output focused on a single period reduces visual clutter significantly.
Exporting the Summary General Ledger to PDF and XLSX
Once the report is configured in summary view with your chosen date filters, exporting is a two-click process in Odoo 19. Both PDF and XLSX formats are natively supported with no additional modules required.
Step-by-Step Export to PDF
- With the General Ledger in summary (folded) view, locate the PDF button in the top-right area of the report toolbar.
- Click PDF. Odoo 19 will generate a formatted PDF document reflecting the exact view on screen, including your active filters and the folded account summary rows.
- The PDF will either download automatically or open in a new browser tab for preview, depending on your browser settings.
- Save or share the file as required.
The PDF format is best for distributing reports to stakeholders who do not need to manipulate the data, such as board members, external accountants, or auditors reviewing period-end financials.
Step-by-Step Export to XLSX (Excel)
-
-
- With the report still in summary view, click the down arrow (dropdown) icon immediately to the right of the PDF button.
- From the dropdown, select XLSX.
- Odoo 19 will generate and download an Excel file containing the same summary data, with columns for account code, account name, opening balance, total debits, total credits, and closing balance.
- Open the file in Excel or Google Sheets to format, sort, or incorporate it into your reporting templates.
What the Exported File Contains
-
Regardless of format, the summary-only General Ledger export from Odoo 19 includes:
- Account code and account name
- Opening balance for the selected period
- Total debits posted during the period
- Total credits posted during the period
- Closing (ending) balance
- Any comparison period columns if the Comparison filter was activated
What it does not include (in summary view) is individual journal entries, partner references, move line descriptions, or invoice numbers. If your auditor or internal team needs transaction-level detail for specific accounts, you can unfold those individual accounts within the report before exporting, giving you a hybrid output where most accounts stay summarised and only flagged accounts expand.
Need help applying this to your business?
Practical Use Cases for Summary General Ledger Exports
Knowing how to produce the report is only half the picture. Understanding where to deploy it helps you advise clients and configure reports that genuinely serve the business.
End-of-Period Reporting for Management
One of the most common requests from finance managers and CFOs is a concise, one-page summary of account balances at month end or quarter end. The summary General Ledger is ideal for this purpose. It gives the reader a clear view of every active account’s net position without requiring them to navigate individual transactions.
For businesses using multi-company structures or multiple Odoo journals, applying additional group-by filters (such as grouping by journal or by account type) before exporting can produce a structured summary that maps directly onto internal reporting templates.
Audit Preparation and Compliance
During internal or external audit processes, auditors typically request a trial balance alongside a General Ledger summary to verify that account balances reconcile. Exporting a clean summary-only General Ledger from Odoo 19 satisfies this requirement quickly and in a format auditors can cross-reference against source documents.
The fiscal year close report is another scenario where a summary export is preferred. Presenting a clean XLSX file with opening and closing balances across all accounts gives your auditor the financial audit trail context they need at the account level, without generating a hundred-page detailed ledger that takes time to navigate.
Common Mistakes to Avoid When Exporting the General Ledger
Even experienced Odoo users make avoidable errors when working with GL exports. Here are the ones that come up most often:
Exporting before folding the view: If you click PDF or XLSX before collapsing the account rows, Odoo will export the full detailed view instead of the summary. Always confirm the report is fully folded before exporting.
Not setting a date filter: Without a date filter, Odoo defaults to showing all historical transactions. The resulting export will cover the entire life of your company’s accounting data, which is almost never what you need for a period report. Always set your date range first.
Including zero-balance accounts: Leaving “Hide Lines at 0” disabled means your export will include accounts with no activity for the period. For a clean management report, enabling this toggle before exporting saves time and reduces confusion for non-accounting readers.
Applying the wrong period comparison: Period comparison Odoo accounting columns are useful, but including them in a report destined for someone who only asked for the current period creates unnecessary confusion. Only enable comparison columns when the audience has specifically requested trend data.
Forgetting to check access rights before sharing: The General Ledger export contains sensitive financial data. Confirm the distribution list before sending XLSX files, particularly when the report is being shared externally via email.
Ready to Streamline Your Odoo Accounting Reporting?
If your team is spending too long manually compiling financial reports that Odoo 19 can generate in minutes, it is worth reviewing your current reporting configuration with an expert. Book a Consultation to discuss how your General Ledger, management reporting, and period-end workflows can be optimised for your business.
Conclusion
Exporting a summary-only General Ledger in Odoo 19 is a straightforward process once you know the three steps: navigate to the report, fold the account rows and apply the right filters, then export in your preferred format. The key is configuring the view correctly before exporting rather than trying to clean up the output afterwards.
For functional consultants, this is a valuable skill to document as part of your client training material. For business owners, understanding this report gives you on-demand visibility over your account balances by period without needing to ask your accountant to generate a manual summary.
Odoo 19’s native reporting engine is capable, well-structured, and export-ready. Used correctly, the summary General Ledger becomes one of the most relied-upon outputs in your financial reporting calendar.
You’re here because something matters.
If this decision impacts your operations, your team, or your growth
Let’s talk before it becomes harder to undo.
Frequently Asked Questions
1. Can I export the General Ledger summary for a specific account only in Odoo 19?
Yes. In the General Ledger report, use the search bar to filter by a specific account code or account name before folding and exporting. The resulting export will contain only the rows matching your filter, giving you a targeted account-level summary rather than the full chart of accounts.
2. What is the difference between the General Ledger summary and the Trial Balance in Odoo 19?
The Trial Balance in Odoo 19 is also a summary-level report showing debit and credit totals per account, but it is designed specifically to confirm that total debits equal total credits. The General Ledger summary goes further by showing opening and closing balances per account, making it more useful for period-end financial reporting and management review.
3. Does the summary General Ledger export include analytic account data?
By default, the summary export does not break down figures by analytic account. However, if you apply an analytic filter within the General Ledger report before exporting, Odoo 19 will reflect that filter in the output, giving you a view scoped to specific projects, cost centres, or analytic tags.
4. Is the XLSX export from the General Ledger in Odoo 19 suitable for further processing in Excel?
Yes. The XLSX file generated by Odoo 19 is a standard Excel-compatible format. You can open it in Microsoft Excel, Google Sheets, or any compatible spreadsheet tool and apply further formatting, formulas, or pivot tables as needed for management reporting ERP workflows.
5. Can I schedule automatic General Ledger exports in Odoo 19?
Odoo 19 does not natively support scheduled automatic exports of the General Ledger as a built-in feature. However, with the right configuration through Odoo’s automation tools or a custom integration, periodic exports can be triggered and delivered to a designated location or email. This is a common request during Odoo implementations and is worth raising with your consultant during setup.
Real Stories. Real Results.
See what our clients have to say — in their own words. These video testimonials share genuine experiences from business owners and teams who’ve transformed their operations with Odoo. From smoother workflows to faster decision-making, their stories reflect the real impact of getting the right system and guidance.