How to Use Partner Ledger Report in Odoo 19 Accounting: Complete Guide
The Partner Ledger Report in Odoo 19 Accounting offers a thorough overview of every receivable and payable transaction connected to every client and supplier. Each partner's outstanding balances, payments, invoices, credit notes, and journal entries are combined into a single comprehensive view. The report ensures correct reconciliation and follow-up by helping users track debtor and creditor positions. This complete step by step beginner guide walks through accessing, filtering, exporting, and interpreting the Partner Ledger Report for effective financial management.
What You'll Learn:
- How to access the Partner Ledger Report from the Reporting menu
- How to filter the report by date, account, partners, tags, and posted entries
- How to export the report as PDF and XLSX formats
- How to switch between Partner Ledger, Customer Statement, and Follow-Up reports
- How to understand each column including Journal, Account, Debit, Credit, and Balance
What Is the Partner Ledger Report?
The Partner Ledger Report is a crucial financial instrument in Odoo 19 Accounting for monitoring partner-related accounting activities and outstanding balances. It consolidates all receivable and payable transactions for each customer and supplier, including invoices, payments, credit notes, and journal entries. The report helps businesses track debtor and creditor positions, ensuring accurate reconciliation and timely follow-up on outstanding amounts.
For more accurate analysis, the report can be filtered by date, partner, account type, or other parameters. Whether you are an accountant tracking customer payments or a finance manager monitoring supplier payables, the Partner Ledger Report provides the transparency needed for effective financial control.
Accessing the Partner Ledger Report
To open the Partner Ledger Report in Odoo 19 Accounting, navigate through the Reporting menu. From the main dashboard, go to the Reporting menu, then choose Partner Ledger Report which is available under Partner Reports. This will open the full Partner Ledger view showing all partner transactions.
Once opened, the report displays a comprehensive table of all transactions. 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 sharing. There is also a Search bar that lets you quickly find specific data within the report.
Understanding the Filters
The Partner Ledger Report comes with several powerful filters that help you customize the report to your specific needs. Each filter allows you to narrow down the data for more targeted financial analysis.
Date Filter
Filter the report based on Month, Quarter, or Year. You can also add Custom Dates for precise date range selection, giving you full control over the reporting period.
Account Filter
Select specific accounts from the chart of accounts. Options include Receivable, Non-Trade Receivable, Payable, and Non-Trade Payable to customize which account types appear in the report.
Partners & Tags Filter
Choose a specific Partner name or Tags to narrow down the report. The report then shows the ledger details of only the selected partners, making it easy to focus on individual accounts.
Posted Entries Filter
Choose from Draft Entries to show unposted entries, Unreconciled Entries to see unmatched transactions, or Unfold All to expand every section of the report for complete visibility.
Report Type Filter
Switch between Partner Ledger Report, Customer Statement Report, and Follow-Up Report by choosing the appropriate option from the Report filter dropdown.
Currency Filter
Control how monetary values appear. Options include default total amounts, simplified format, thousands (K$), and millions (M$) for high-level financial analysis.
Report Type Options Explained
Partner Ledger Report
Shows all accounting entries including debits, credits, and running balances for clients and suppliers. Used for analysis of outstanding balances and partner-specific transactions. This is the most comprehensive view of partner financial activity.
Customer Statement Report
Generates a customer-facing summary that summarizes invoices, payments, and outstanding amounts. This is typically sent to customers as account summaries or payment reminders. It provides a clean, professional view of what a customer owes.
Follow-Up Report
Focuses on past-due customer invoices to assist collection efforts. Accountants can use it to send automated or manual follow-up messages and keep track of delinquent invoices. Essential for managing accounts receivable and reducing overdue payments.
Currency Display Options
The Currency filter lets you control how monetary values appear in the Partner Ledger Report. Only the unit or scale used to display the amounts is altered; the actual currency of the transactions remains unchanged. Each option serves a different analytical purpose:
| Option | Description | Use Case |
|---|---|---|
| In .$ (Default) | Full currency format with decimals (e.g., $47,007.50) | Most detailed view for day-to-day accounting |
| In $ (Simplified) | Currency without additional formatting | Streamlined views or cleaner exports |
| In K$ (Thousands) | All amounts shown in thousands ($47,000 becomes $47K) | High-level financial analysis with large numbers |
| In M$ (Millions) | All amounts shown in millions ($4,500,000 becomes $4.5M) | Condensing large financial datasets for executives |
Understanding the Report Columns
The Partner Ledger Report displays detailed transaction data across several columns. Each column provides specific information about the financial entries. Below is a complete breakdown of every column and its meaning:
| Column | Description |
|---|---|
| Journal | The accounting journal where the transaction was entered, such as Bank Journal, Invoice Journal, or POS Journal. Helps identify the entry's origin. |
| Account | The specific account from the chart of accounts connected to that entry, such as receivables, payables, or bank accounts. |
| Invoice Date | The date the invoice or bill was issued. Useful for monitoring reporting periods and billing schedules. |
| Due Date | The date when payment is expected. Helps track impending or past-due payments for effective receivables management. |
| Matching | The reconciliation reference or ID when payments are matched to invoices. Shows if a transaction has been fully or partially reconciled. |
| Debit | Amounts that increase the partner's receivables or expenses. These are amounts the partner owes, such as new invoices raised. |
| Credit | Amounts that reduce receivables, document payments, or refunds. These are amounts credited to or received from the partner. |
| Amount Currency | Displays the original currency amount if the transaction was recorded in a foreign currency. Essential for multi-currency environments. |
| Balance | The partner's current balance after every transaction. Positive values indicate the partner owes money; negative values indicate the company owes the partner. |
At the end of each partner's section, their total debit, credit, and balance are displayed. The report concludes with a grand total showing the company-wide debit, credit, and balance across all partners.
Practical Example: Invoice Creation and Reconciliation
To understand how the Partner Ledger Report tracks transactions in real time, let us walk through a practical example. We will create an invoice for a customer named Aamy Jacob, confirm it, and then reconcile the payment to see how each step reflects in the ledger.
Create an Invoice
Navigate to the Invoicing module and create a new invoice for the customer Aamy Jacob. Fill in the required details including product, quantity, and price, then confirm the invoice to post it to the accounting system.
Check the Partner Ledger Report
Open the Partner Ledger Report from the Reporting menu. You will see that the invoiced amount appears as a Debit entry in Aamy Jacob's ledger, reflecting the amount the customer now owes. The balance updates to show the outstanding receivable.
Reconcile the Invoice
When the customer makes the payment, record the payment in Odoo and reconcile it against the invoice. The reconciliation process matches the payment received to the outstanding invoice, clearing the receivable.
Verify in the Partner Ledger
Return to the Partner Ledger Report. The payment will now appear as a Credit entry credited to the Bank account. The balance for Aamy Jacob will update to reflect the payment, bringing the outstanding amount to zero (or showing the new running balance).
This practical example demonstrates how the Partner Ledger Report provides real-time visibility into the complete lifecycle of a transaction, from invoice creation through payment reconciliation. Each step updates the ledger automatically, giving you an accurate picture of your financial position at all times.
Accessing the Accounting Report Configuration
Next to the filters, there is an icon that leads to the Accounting Report configuration screen. This feature allows you to add customizations to the Partner Ledger Report, such as modifying the layout, adding additional columns, or changing the grouping of data. The Accounting Report customization is a powerful tool for tailoring the report to your specific business requirements.
Exporting the Partner Ledger Report
The Partner Ledger Report can be exported in two formats:
PDF Export
Export the report as a PDF document for sharing with stakeholders, sending to clients, or maintaining official records. The PDF format preserves the layout and formatting of the report.
XLSX Export
Export the report as an Excel spreadsheet for further analysis, data manipulation, or integration with other reporting tools. The XLSX format allows you to sort, filter, and chart the data.
To export, simply click the corresponding button placed at the top left side of the Partner Ledger Report screen. Both export options preserve the current filter settings, so you only export the data you need.
Frequently Asked Questions
What is the difference between Partner Ledger and Customer Statement reports?
The Partner Ledger Report shows all accounting entries including debits, credits, and running balances for internal financial analysis. The Customer Statement Report generates a customer-facing summary of invoices, payments, and outstanding amounts typically sent as account summaries or payment reminders.
Can I filter the Partner Ledger Report for a specific customer only?
Yes. Use the Partners filter to select a specific partner name or tag. The report will then display the ledger details of only the selected partners, making it easy to focus on individual accounts for targeted analysis or follow-up.
How do I see unreconciled entries in the Partner Ledger Report?
Enable the Unreconciled Entries option under the Posted Entries filter. This will add unreconciled transactions to the report, helping you identify which invoices or payments still need to be matched and cleared.
What does a negative balance mean in the Partner Ledger Report?
A negative balance in the Partner Ledger Report indicates that the company owes money to the partner, such as when a supplier has been overpaid or a credit note has been issued. Positive values indicate the partner owes money to the company.
Can I customize which columns appear in the Partner Ledger Report?
Yes. Click the Accounting Report icon next to the filters to open the customization screen. From there you can modify the layout, add or remove columns, and change grouping options to tailor the report to your specific business requirements.
Need Help with Odoo Accounting?
Our Odoo accounting experts can help you configure the Partner Ledger Report, set up automated reconciliation workflows, customize accounting reports for your business needs, and optimize 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.