Payments Due list

This module gives accountants a single screen listing all open credits and debits coming from reconcilable accounts. You reach it from the Accounting menu under 'Payments and due list'.

The list shows one line per journal item with useful columns such as the invoice, source document, partner, partner reference, payment terms, invoice date, due date, debit, credit, balance and the remaining amount still to be paid. Lines are colour-coded: green when fully reconciled, grey when reconciled without a full match, orange when the entry is not posted yet, and red when the line is posted, not reconciled and past its due date. The list is read-only: you cannot create or delete lines from it.

A search panel lets you filter by posted or unposted entries, invoices only, receivable or payable accounts, incoming or outgoing amounts, unreconciled, partially reconciled, fully reconciled, and overdue items. You can also group results by partner, account, invoice, due date, invoice date, entry date or salesperson, and use date filters.

The same data is available as a pivot table and a graph, measuring the remaining amount by journal and due date. The module also adds related fields on journal items: source document, invoice date, partner reference, payment terms and invoice salesperson, the last one being stored for grouping and filtering.