Skip to Content
Catalog / ACC · Accounting & Finance / Statement Of Account Print Out
Statement Of Account Print Out
statement_of_account_print_out

Statement Of Account Print Out

Print or export per-customer account statements and partner ledgers in PDF or Excel

v19.0.1.0.0 Abdelfatah Mohammad (AlshayebCo) Accounting & Finance

Adds three TransientModel wizards: account common report (base parameters), account common partner report (partner/currency/payment-state filtering), and account report partner ledger (the printable wizard, supporting statement vs ledger mode, output type, aging and cheque summaries). Two QWeb-PDF report actions and matching AbstractModel report classes build statement and ledger data via raw SQL through an inherited journal item _query_get (rewritten on the Odoo 19 Domain API). An XLSX path is served by an http controller at /report/statement_xlsx/<wizard_id> using xlsxwriter. contact is extended with action_open_statement_of_account, surfaced as a stat button on the partner form. Depends on odoo_check_managment for the check cheque-summary data and on account_reports.

Overview

Standard Odoo accounting reports do not produce the polished, per-partner account statement that finance teams hand to customers and suppliers. This module adds dedicated wizards that build a Statement of Account or a Partner Ledger for any partner over a chosen date range, journal set, currency, and posting status, complete with opening balance and running balance. Statements can include an aging breakdown, an outstanding/received/bounced cheque summary, and optional invoice line detail, then be printed as a branded landscape PDF or downloaded as a formatted Excel file. A one-click button on every contact form generates that partner's statement instantly.

Key Features

  • Generate a Statement of Account for a single partner with opening balance, dated transactions, and running balance.
  • Generate a multi-partner Partner Ledger covering receivable and/or payable accounts.
  • Filter by date range, journals, target moves (posted only or all entries), currency, and payment state.
  • Optional aging summary that buckets balances into 0-30, 31-60, 61-90, 91-120, and 121+ day periods.
  • Optional cheque summary listing received, under-collection, outstanding, and bounced cheques per partner.
  • Optionally expand each invoice into its product lines with quantity, unit price, discount, and subtotal.
  • Export any statement or ledger to a formatted, color-styled XLSX workbook in addition to PDF.
  • One-click 'Account Statement' button on every contact form for instant per-partner output.
  • Branded landscape A4 PDF layout with a 'Printed By' footer showing the user's name.
  • Multi-currency aware, producing a separate statement section per transaction currency.

Technical Details

Technical Name statement_of_account_print_out
Version 19.0.1.0.0
License LGPL-3
Domain ACC · Accounting & Finance

Menu Structure

Statement of Account
Custom Partner Ledger Print

Security

All three report wizard models grant full read/write/create/delete to any user, with no dedicated group; access is gated at the report level. The XLSX download controller requires the standard Accounting User group (account.group_account_user) and only lets the user who created the wizard download their own file.

Dependencies

base web account odoo_check_managment account_reports

External Dependencies

xlsxwriter