Name	Name	Last commit message	Last commit date
parent directory ..
i18n	i18n
models	models
readme	readme
report	report
security	security
static/description	static/description
tests	tests
views	views
README.rst	README.rst
__init__.py	__init__.py
__manifest__.py	__manifest__.py
pyproject.toml	pyproject.toml

Deltatech Average Payment Period

Tracks how long customers and suppliers actually take to pay, giving finance teams a concrete measure of cash-collection and payment efficiency.

For each reconciled journal entry the module records the exact payment date and computes the number of days elapsed since the invoice date. An aggregated pivot/graph report — Average Payment Period — is added directly to the Accounting Reports menu so managers can slice the data by partner, journal, or period at a glance.

Key features:

Payment Date — automatically derived from the reconciliation partner line and stored on each account.move.line.
Payment Days — difference (in days) between the invoice date and the payment date, weighted by the line amount for accurate averages across grouped data.
Plain Payment Days — simplified variant limited to customer invoices (out_invoice) and vendor bills (in_invoice), excluding credit notes, for cleaner KPI reporting.
Average Payment Period report — a dedicated pivot and graph view (menu: Accounting > Reporting > Average Payment Period) grouped by partner by default; filterable by date, partner, journal, and account.
Weighted average calculation — when grouping rows, the average is computed as sum(amount × days) / sum(amount) rather than a plain arithmetic mean, preventing distortion from small-amount outliers.

Table of contents

Usage
- Viewing the Average Payment Period report
- How Payment Days are populated
Bug Tracker
Credits
- Authors
- Maintainers

Usage

Viewing the Average Payment Period report

Open Accounting and navigate to Reporting > Average Payment Period.
The pivot view opens pre-grouped by Partner, showing for each partner:
- Balance — total reconciled amount.
- Payment Days — weighted-average days to payment across all reconciled lines.
- Plain payment days — average days for customer invoices and vendor bills only (credit notes excluded).
Use the search bar to filter by partner name, reference, or date range. The Date filter supports month/quarter/year buckets.
Switch to the Graph view for a visual comparison across partners or time periods.
Add or remove groupings (e.g. Date, Journal) via the Group By menu to break down the average by period or by journal type.

How Payment Days are populated

Payment Days are computed automatically whenever a journal entry line is fully reconciled:

The module looks at the full_reconcile_id of each account.move.line and finds the date of the matching counter line (credit side for debit lines and vice versa).
This date is stored as Payment Date on the journal entry line (visible in the Journal Items form under the Due Date field group).
The difference payment_date - invoice_date (in days) is stored as Payment Days.

No manual action is required; values update automatically on reconciliation and de-reconciliation.