Unpaid Invoices and Bills Report
One report of every customer invoice and vendor bill that is still unpaid or partly paid,
grouped per partner, as a PDF to file and an Excel workbook to work in. Choose the period,
the partners and the day the balance is taken: the report rebuilds what was due on that day,
even when the documents were paid afterwards.
----------------------------------------
Key Features
✔ Customer invoices, vendor bills or both
Receivable and payable in one run, each with its own totals and a net position.
✔ Balance as of any date
The amount due as it stood at the end of the chosen day; later payments are ignored.
✔ Period on the date you need
Filter by invoice date, due date or accounting date, with an open start or end.
✔ Per partner with subtotals
Every open document under its customer or vendor: total, settled, amount due, days overdue.
✔ Overdue age columns
Not due, three overdue periods and everything older. The length of a period is yours to set.
✔ PDF and Excel
A landscape PDF on your company letterhead and a formatted workbook with a summary sheet
and one detail sheet per side, with real numbers and dates.
✔ Credit notes deducted
Open credit notes and refunds reduce the partner total, or are left out if you prefer.
✔ Filters and shortcuts
Partners, journals, salespersons, overdue only; start the report from selected contacts;
open the same documents in the Odoo invoice list.
----------------------------------------
Benefits
- The month-end list of open items without exporting and reworking the invoice list
- Figures that match the books on the closing date, not on the day you print
- Instalments are aged one by one, so a payment plan is not shown as fully late
- Works right after installation; every option has a sensible default
----------------------------------------
Ideal For
- Accountants who close a period and need the open items per customer and vendor
- Credit controllers who review what is due and how late it is
- Auditors and managers who ask for the unpaid documents on a past date
----------------------------------------
Technical Highlights
- Reads Odoo's own journal items and reconciliations; nothing is stored or changed
- Respects the access rights and record rules of the user; one company per run
- Multi-currency: totals in the company currency, amount due in the document currency
- Depends on the Invoicing app only; Excel through the library Odoo ships; fully translatable
----------------------------------------
Supported Odoo Versions
- Odoo 19
- Odoo 20
----------------------------------------
Keywords
outstanding invoice report odoo, unpaid invoices report, open invoices per customer, unpaid
vendor bills report, open items list, receivable and payable by partner, overdue age columns,
balance as of date, invoice report pdf excel, community accounting report