Hello,

There is a free module available in Odoo called Accounting Customer Statements. Install that and you will be abale to generate the statements from the partner.

https://www.youtube.com/watch?v=XC8DLpfZfjw

Hello, the report you might be referring to is the Aged Receivable Report. You can access it from the Accounting > Reporting > Partner Reports > Aged Receivable module, and I believe the template is already in a standard format commonly used to show customer invoice aging. Below is the view of the Aged Receivable Report.  

If you're not satisfied with the default layout, would you be able to provide the desired template? Thank you.

Regards,

Appschef ​

Odoo (especially in Enterprise) does not include customer statements by default in Accounting. This feature — showing a customer's outstanding invoices, due amounts, and payment history — is not available out-of-the-box.

 Solution: Use Free or Paid Customer Statement Modules

You can enable customer statements in two ways:

1. Install Community Modules
   • Modules like account_financial_report, customer_statement, or partner_statement (available on the Odoo App Store).
   • These allow you to generate:
     • Open Invoices
     • Overdue Balances
     • Full ledger activity
2. Odoo Enterprise: Email Statements via Follow-Up
   • Navigate to Accounting > Customers > Follow-Up Reports
   • You can send payment reminders, but they are not full customer statements.
   • Limited layout/customization.

 How to Add Customer Statement Option (If Missing)

If you're on Odoo 18 and need more customization:

• Create a custom report using QWeb or Excel templates.
• Include:
  • Customer info
  • Invoice dates
  • Due amounts
  • Payments received
• Add a menu under Accounting > Reporting > Customer Statement

Hi,

Please refer to the following links:

1. https://www.cybrosys.com/blog/overview-of-customer-statement-in-odoo-18-accounting

2. https://www.cybrosys.com/slides/how-to-generate-customer-statements-report-in-odoo-18

Module:

1. https://odoo-community.org/shop/partner-statement-4804#attr=2869

2. https://odoo-community.org/shop/account-financial-reports-196#attr=942162

Hope it helps.