Portal Partner Ledger

Customers and vendors often call to ask for their balance and movements. This module adds an Account Statement page to the Odoo customer portal where each contact sees its own receivable and payable entries, with totals, running balance, filters and downloads. It plugs into Accounting and Portal, adds a company-level switch, and never shows data outside the contact's own commercial partner and allowed companies. It reduces support calls and gives partners a self-service view they can print or export.

1. 1

   Enable the portal ledger

   In the general settings the administrator turns on Partner Ledger in Portal for the company. Extra options control the scope, whether the matching number is shown, and whether PDF and Excel downloads are allowed. Nothing appears in the portal until it is enabled.

   • Setting: Account Statement in Portal
   • Choose the scope (receivable, payable or both)
   • Toggle Show Matching Number
2. 2

   Open My Account Statement

   The portal home shows an Account Statement entry, which opens /my/partner-ledger. The page lists the contact's entries with date, due date, journal, reference, label, debit, credit, matching number and running balance. Long lists are paginated.

   • Portal menu: My Account Statement
   • Columns include running balance
   • Pagination for long histories
3. 3

   Read the summary tiles

   Above the table the page shows total receivable, total payable and the net balance as tiles. The totals come from open (unmatched) items of the contact's commercial partner. An opening balance and a period balance are computed when a date range is applied.

   • Total receivable, total payable, net
   • Opening balance before the date range
   • Only the contact's own commercial partner
4. 4

   Filter the statement

   The search bar filters by receivable only, payable only or open items, and accepts a from and to date. The filter values are parsed and validated on the server. The totals and running balance follow the filter that is applied.

   • Filters: receivable, payable, open
   • Free date range
   • Companies limited to the user's allowed ones
5. 5

   Download the PDF statement

   The Download PDF button calls /my/partner-ledger/pdf and renders the QWeb report Portal Partner Ledger for the same filter. The report follows the portal user's language. It is available only if PDF download is allowed in settings.

   • Button: Download PDF
   • Same filter as the screen
   • Controlled by Allow PDF Download
6. 6

   Download the Excel statement

   The Download Excel button calls /my/partner-ledger/xlsx and returns an .xlsx file with the same rows as the statement. It is useful for partners that reconcile in their own spreadsheets. It is available only if Excel download is allowed in settings.

   • Button: Download Excel
   • Same rows as the screen
   • Controlled by Allow Excel Download

Back to version applications