Advance Financial Reports For Community
Dynamic General Ledger, Partner Ledger, Trial Balance, Ageing, P&L and Balance Sheet
Module index
Understand customer payment behaviour with a live average of invoice settlement days.
See how many days each customer takes to settle posted invoices in the current company. Paid invoices use the settlement date, while open and partially paid invoices count through today. The average appears directly below Tax ID on the customer form.
Install the module and open a customer from Invoicing. Billing users can read the indicator immediately; no settings or scheduled actions are required.
Screenshots illustrate the shared workflow in Odoo 20. Odoo 19 uses its native controls.
Follow the workflow below from the first action to the result. Screenshots use demonstration records; the descriptions explain what to do, what the screen shows and which normal Odoo steps still apply.
After installing the module, an invoicing user can open a customer in Contacts and read Average Payment Days. There is no separate calculation button or module setup form. The empty demo customer shows 0.00 because it has no qualifying posted customer invoices in the current company; this alone does not prove that the customer pays immediately.
Use the customerâs Invoiced smart button or filter customer invoices to that customer. The demonstration history contains two paid invoices, one posted open invoice and an old draft. The calculation uses qualifying posted customer invoices in the current company. Draft invoices, vendor bills and customer credit notes do not contribute to this average.
For a paid invoice, the module uses Invoice Date through the recorded settlement date. The shown invoice is dated September 29 and marked paid on October 9, giving 10 days. The second paid invoice in this example contributes 20 days. The metric measures elapsed calendar days from the invoice date, rather than days overdue after the due date.
A posted open or partially paid invoice counts from Invoice Date through today. Here the unpaid invoice dated October 19 is 30 days old on the demo capture date, November 18. Its 500.00 amount is still due. An invoice that remains open can increase the average as days pass, even if no new invoices are created.
Use Pay on the invoice and review the journal, amount and Payment Date before creating the payment. Complete the required normal accounting and reconciliation steps so Odoo records the invoiceâs settlement. The screenshot shows the payment dialog before confirmation. The module reads invoice and settlement information; it does not collect money, post payments automatically or replace payment reconciliation.
Reopen or refresh the customer to see the read-only average. For this example, the contributing durations are 10 days, 20 days and 30 days: (10 + 20 + 30) ÷ 3 = 20.00 days. The old draft is excluded. Each qualifying invoice contributes one duration, so this is an invoice-count average, not an amount-weighted calculation. Open-invoice figures use the date when they are viewed.
Switch Contacts to list view and open the column selector. Enable Average Payment Days to display the metric beside customer names. The field remains restricted to users with the applicable invoicing permission. This optional column lets staff review multiple customers without opening each contact.
The list now shows 20.00 for Demo Customer â Payment History and 0.00 for Demo Customer â No Invoices. Review the underlying invoices when interpreting a result: a zero may simply mean no qualifying history. The computation is scoped to the current company and rolls up invoice history to the commercial customer; it is not a combined cross-company average.
Legal
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE
Terms
By purchasing an app from OdooSphere, the customer agrees to the following terms.
All payments must be completed immediately through the website checkout. Orders are processed only after successful payment confirmation from the payment provider.
After payment confirmation, the purchased module will be delivered digitally as a ZIP file through email or the customer portal, where applicable.
Each purchased app includes 90 days of free support from the purchase date.
Apps are provided for the Odoo versions mentioned on the product page. The customer is responsible for selecting the correct Odoo version before purchase.
Since apps are digital products delivered after payment, purchases are generally non-refundable. Refunds may be considered only if payment was duplicated, the ZIP file was not delivered, or the app cannot work on the listed compatible Odoo version due to a confirmed issue in the delivered module.
The purchased app is licensed for use by the purchasing customer or company. Reselling, redistributing, publishing, or sharing the module with third parties is not allowed without written permission from OdooSphere.
Free updates are not guaranteed unless specifically mentioned on the product page. Bug fixes within the 90-day support period may be provided when the issue is confirmed to be caused by the purchased app.
OdooSphere is not responsible for business losses, data loss, downtime, third-party service issues, or problems caused by incorrect installation, custom changes, or incompatible modules.
Related modules
Reviews
Logged-in users can ask questions, discuss implementation details, and rate this module. Your rating updates the app score across the marketplace.