How to Use Trial Balance Report in Odoo 19 Accounting: Complete Guide
The Trial Balance Report in Odoo 19 Accounting shows all account balances including debit and credit totals at a specified date to verify the correctness of financial inputs. In order to keep balanced books, it assists accountants in confirming that total debits match total credits. Before creating final financial statements, the report also helps identify inaccurate postings or anomalies. It summarises all ledger accounts to provide a brief picture of the company's financial situation. This complete step by step beginner guide walks through accessing, filtering, comparing, exporting, and interpreting the Trial Balance Report for accurate financial records.
What You'll Learn:
- How to access the Trial Balance Report from the Reporting menu
- How to filter the report by date range, journals, and posted entries
- How to compare the report with previous periods and custom dates
- How to export the report as PDF and XLSX formats
- How to understand Initial Balance, Debit, Credit, and Ending Balance columns
What Is the Trial Balance Report?
The Trial Balance Report is a fundamental financial statement in Odoo 19 Accounting that lists every account from the chart of accounts along with their debit and credit balances at a specific point in time. Its primary purpose is to verify that the total of all debit balances equals the total of all credit balances, ensuring the books are mathematically correct before generating financial statements.
The report is an essential step in the accounting cycle. It helps accountants identify errors such as incorrect postings, missing entries, or data entry mistakes before they flow into the Profit and Loss Statement or Balance Sheet. By providing a concise summary of every account's financial position, the Trial Balance acts as a checkpoint ensuring data integrity and seamless financial reporting.
Accessing the Trial Balance Report
To open the Trial Balance Report in Odoo 19 Accounting, navigate through the Reporting menu. From the main Accounting dashboard, go to the Reporting menu and choose Trial Balance Report. The report is available under the Ledger Reports section. This will open the full Trial Balance view displaying all account balances.
Once opened, the report presents a comprehensive table of accounts. At the top of the screen, you will find export buttons for PDF and XLSX formats, allowing you to download the report for offline analysis or distribution to stakeholders.
Understanding the Filters
The Trial Balance Report comes with several powerful filters that help you customise the data for precise financial analysis. Each filter serves a specific purpose in narrowing down the information displayed.
Date Filter
Filter the report based on Months, Quarters, or Year. You can also use Custom Dates for precise period selection, giving you full control over which accounting period to analyse.
Comparison Filter
Compare the current report against Previous Period, Same Period Last Year, or Custom Dates. This helps track financial changes and trends over time for better business analysis.
Journal Filter
Select a specific journal to filter the report by. All journals and multi-ledgers created in the system are visible in this dropdown, letting you analyse transactions from a particular journal only.
Posted Entries Filter
Choose from Draft Entries to include unposted entries, Unfold All to expand every account section, and Cash Basis Method to view entries on a cash rather than accrual basis.
Currency Filter
Controls how monetary values are displayed. Options include full amounts with decimals, rounded figures, values in thousands (K$), or millions (M$) for high-level financial analysis.
Comparison Options Explained
Previous Period
Compares the current report period with the immediately preceding period. For example, if the current report shows Q2 data, the comparison column will display Q1 data for side-by-side analysis.
Same Period Last Year
Shows data from the same period in the previous fiscal year alongside current data. This is useful for annual comparisons, identifying seasonal trends, and measuring year-over-year financial performance.
Custom Dates
Allows you to select any arbitrary date range for comparison. This flexibility is ideal for comparing specific project periods, campaign durations, or any custom time frame relevant to your analysis.
Currency Display Options
The Currency filter regulates how monetary values appear in the report. Only the display scale is altered; the actual currency of the transactions remains unchanged. Each option serves a different analytical purpose:
| Option | Description | Use Case |
|---|---|---|
| In .$ (Full) | Full currency format with decimals (e.g., 1,588.20) | Detailed day-to-day accounting work |
| In $ (Rounded) | Rounded full figures without decimals (e.g., 1,588) | Simplified views for quick scanning |
| In K$ (Thousands) | Values displayed in thousands (e.g., 1,588 > 1.59 K$) | High-level analysis with large figures |
| In M$ (Millions) | Values displayed in millions (e.g., 1,500,000 > 1.5 M$) | Executive summaries of large datasets |
Customising the Trial Balance Report
Users can customise the Trial Balance Report using the Account Reports configuration screen. This feature is accessible directly from the Trial Balance Report itself. To open it, click the settings icon located next to the filter section. The Account Reports configuration allows you to modify the report layout, add or remove columns, and change grouping options to tailor the report to your specific business requirements.
Understanding Initial Balance and Ending Balance
The Trial Balance Report displays two critical balance columns for each account: Initial Balance and Ending Balance. Understanding these two figures is essential for accurate financial analysis.
Initial Balance
Represents each account's opening balance at the beginning of the selected reporting period. It includes all posted transactions that occurred before the report's start date. This figure helps you understand each account's financial position before the period under analysis, serving as the baseline for evaluating period activity.
Ending Balance
Represents each account's closing balance at the conclusion of the selected reporting period. It is computed using this formula: Ending Balance = Initial Balance + (Debits - Credits) for the period. This balance shows each account's final financial position after applying all period transactions.
The report displays each account with its Initial Balance, total Debit, total Credit, and Ending Balance. At the bottom of the report, the total Credits and total Debits across all accounts are displayed. Before creating financial statements, you can verify that these totals match, confirming the books are balanced and accurate.
Exporting the Trial Balance Report
The Trial Balance Report can be exported as a PDF or XLSX format by clicking the corresponding buttons at the top of the report screen. The PDF export preserves the report layout and formatting for sharing with stakeholders or maintaining official records. The XLSX export enables further data manipulation in Excel, allowing you to sort, filter, and create charts for deeper analysis.
Tip:
- Use PDF export for sharing with management, auditors, or regulatory bodies
- Use XLSX export for internal analysis, data manipulation, or integration with other reporting tools
- Both export formats preserve your current filter settings so you only export the data you need
Frequently Asked Questions
What is the difference between Trial Balance and General Ledger in Odoo 19?
The Trial Balance shows a summary of each account's total debit and credit balances at a specific date. The General Ledger provides a detailed chronological list of every transaction for each account. The Trial Balance is used for verification, while the General Ledger is used for detailed audit trails.
How do I include draft entries in the Trial Balance Report?
Enable the Draft Entries option under the Posted Entries filter. This will include all unposted entries in the report, allowing you to preview the financial impact of draft transactions before they are posted to the accounting system.
What should I do if the Trial Balance shows unequal debits and credits?
Review the report for incorrect postings, missing journal entries, or data entry errors. Check the General Ledger for the affected accounts, verify reconciliations, and ensure all transactions are properly posted. Use the Journal filter to isolate specific transaction sources.
Can I compare the Trial Balance with the same period last year?
Yes. Use the Comparison filter and select Same Period Last Year. The report will display current period data alongside data from the same period in the previous fiscal year, enabling year-over-year financial performance analysis.
How is the Ending Balance calculated in the Trial Balance Report?
The Ending Balance is calculated as: Ending Balance = Initial Balance + (Total Debits - Total Credits) for the period. The Initial Balance is the opening balance at the start of the period, and the net activity adjusts it to reach the final closing balance.
Need Help with Odoo Accounting?
Our Odoo accounting experts can help you configure the Trial Balance Report, set up automated reconciliation workflows, customise accounting reports for your business needs, and optimise your entire Odoo financial management system.
About the author
Founder & Odoo Practice Lead, Braincuber Technologies
Founder of Braincuber. Has scoped and shipped 500+ Odoo implementations for US mid-market and global brands. Takes every founder call personally — no SDR layer between buyers and the people building the system.