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

Customer and vendor statements (PDF/Excel/email/portal) and partner balance on invoices and bills

v19.0.3.2.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

  • Interactive statement screen: headline totals, one row per partner (balance, overdue, cheques, exposure, credit limit), unfold into transactions, open any document, filters as a bar or a side panel, works on phones.
  • Export exactly what the screen shows to PDF, Excel or email, for all matching partners or only the ticked ones.
  • Statement of Account per partner, one section per transaction currency, with opening, running and closing balance, plus a total in company currency.
  • Partner Ledger in company currency for many partners at once (partners with activity when none is selected).
  • Open Items mode: only documents still unpaid on a date, with remaining amount, due date and days overdue.
  • Aging summary (Not due, 1-30, 31-60, 61-90, 91-120, 120+) computed on what is still open at the end date.
  • Balance confirmation block with signature lines, ready for audit confirmations.
  • Optional invoice product lines and terms/notes on each document.
  • PDF (landscape) or formatted Excel output from the same data.
  • Send statements by email, for one partner or a whole selection from the contacts list.
  • Customers download their own statement from the portal.
  • Invoice and bill forms show the partner's previous balance, this document and the balance after it, plus overdue and credit-limit exposure for customers.
  • Optional company letterhead for customer-facing statements; filters by salesperson and partner tags.
  • Cheque summary when odoo_check_managment is installed (via the statement_of_account_check bridge).

Technical Details

Technical Name statement_of_account_print_out
Version 19.0.3.2.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

account portal mail

External Dependencies

xlsxwriter