Skip to content
DevMarket
Odoo ModulesWordPress PluginsWordPress ThemesShopify ThemesApp TemplatesScripts & UtilitiesBlogSell on DevMarket
ModuleOdooNew

Aged Receivable & Payable Report for Odoo 19 Community – Customers and Vendors by Age, PDF and Excel

The aged receivable and aged payable reports for Odoo Community: each customer or vendor by age of the open balance, the invoices behind each figure, as of any date.

No reviews yet0 salesby TAQNIXUpdated Oct 23, 2026

Description

Who owes you, and since when

The aged receivable and aged payable reports belong to Odoo Enterprise. Aged Receivable & Payable Report gives them to Community.

Every customer, by age

Every partner, by age

  • Customers (what they owe you) and vendors (what you owe)
  • Six ages: not due, 1-30, 31-60, 61-90, 91-120 and over 120 days, from the due date or the invoice date
  • The total, the overdue amount and its share, and the amount over 90 days
The invoices behind each figure

The invoices behind each figure

  • Open items: invoices, credit notes and payments not yet applied, with days late
  • Open the invoice; filter overdue or over 60 days; group by partner, age or salesperson
To print or export

As of any date

A past date puts back the payments made after it: the report shows what was open then.

Choose, show, chase

Analyse and share

Pivot and graph by partner and age, a PDF with the invoices, and an Excel file with the summary and the open items. Filter by partners, salespeople and minimum balance.

Know who owes what

Tested

29 automated tests: the ages, partial payments, credit notes, payments on account, payable, past dates, filters, the PDF, Excel and access rights.

Documented

Illustrated guide in English and Arabic and an Arabic translation of the module.

What's included

  • taqnix_ar_ap_aging.zip: the Odoo 19 module (with Arabic translation)
  • Illustrated documentation in English and Arabic (HTML and PDF)
  • Automated tests, licence file (OPL-1) and changelog

Requirements

Odoo 19.0 Community with Invoicing.

What's in the download

The files in the archive you can download after you buy.

  • Full source code
  • Documentation
  • Installation guide
  • Automated tests
  • Licence file
  • Changelog

Customer reviews

Write a review

No reviews yet. Bought this item? Be the first to review it.

Usage

Install and use it in a few lines.

aging = env['taqnix.ar.ap.aging'].create({'kind': 'receivable', 'as_of': '2026-09-30', 'age_by': 'due'})
aging.action_compute()
for row in aging.partner_line_ids:
    print(row.partner_id.name, row.b0, row.b1, row.b5, row.total)

Documentation

Setup, settings and troubleshooting, written by the author.

Open the documentation

Changelog

Every release, newest first.

v1.0.0

1.0.0 – Initial release

  • Aged receivable and aged payable by partner in six ages
  • Age counted from the due date or the invoice date; as of any date
  • Open items with the invoices, credit notes and unapplied payments
  • Filters by partner, salesperson and minimum balance; pivot and graph
  • PDF with the invoices, Excel export, Arabic translation, automated tests

Frequently asked questions

What is an aged receivable report?

A list of the customers with what they owe you, split by how late it is: not due, 1-30, 31-60, 61-90, 91-120 and over 120 days. The aged payable report does the same for what you owe your vendors.

Can I see the invoices behind a figure?

Yes. Open items lists the invoices, credit notes and unapplied payments of a partner, with the due date, the days late and the amount, and opens the invoice.

Can I age from the invoice date instead of the due date?

Yes. Choose Age counted from: the due date (how late) or the invoice date (how old).

Can I run it for a past date?

Yes. Only the invoices of that date or before are counted and the payments made after it are put back, so you see what was open at the time.

How are credit notes and payments on account shown?

As negative amounts in the open items, reducing the balance of the partner.

Can I filter by salesperson?

Yes: by the salesperson of the invoice, and by partners and a minimum balance.

Can I print and export it?

Yes: a PDF with the summary and, if you want, the invoices under each partner, and an Excel file with the summary and the open items.

Does it work in Arabic?

Yes. Everything is translated and works right to left, and the documentation is in Arabic too.

More from TAQNIX

  • ModuleNew

    End of Service Benefits (Gratuity) for Odoo 19 Community – Configurable Calculator

    Calculate end-of-service gratuity in Odoo Community with a policy you configure: tiers by years of service, a cap, the share by reason of leaving, unpaid leave, leave pay, and a printable statement.

    by TAQNIX
    No reviews yet
    Sales:0$89.00
  • ModuleNew

    Petty Cash & Expense Vouchers for Odoo 19 Community – Imprest Funds with Approval

    Run petty cash funds in Odoo Community: expense vouchers with receipts and an approval limit, payment with the entry, replenishment up to the float, a cash book and printable vouchers.

    by TAQNIX
    No reviews yet
    Sales:0$79.00
  • ModuleNew

    Employee Custody & Assets for Odoo 19 Community – Handover, Return and Clearance

    Track who holds which company item in Odoo Community: handover and return slips with condition, overdue reminders, a Custody tab and a clearance sheet on the employee.

    by TAQNIX
    No reviews yet
    Sales:0$49.00
  • ModuleNew

    Journal Entries Import from Excel / CSV for Odoo 19 Community – Balance Checked

    Import journal entries from Excel or CSV into Odoo Community: accounts, partners, analytic, each entry checked for balance, drafts or posted, with a history and an undo.

    by TAQNIX
    No reviews yet
    Sales:0$59.00

Similar items

  • ModuleNew

    Petty Cash & Expense Vouchers for Odoo 19 Community – Imprest Funds with Approval

    Run petty cash funds in Odoo Community: expense vouchers with receipts and an approval limit, payment with the entry, replenishment up to the float, a cash book and printable vouchers.

    by TAQNIX
    No reviews yet
    Sales:0$79.00
  • ModuleNew

    Journal Entries Import from Excel / CSV for Odoo 19 Community – Balance Checked

    Import journal entries from Excel or CSV into Odoo Community: accounts, partners, analytic, each entry checked for balance, drafts or posted, with a history and an undo.

    by TAQNIX
    No reviews yet
    Sales:0$59.00
  • ModuleNew

    Payment & Receipt Vouchers for Odoo 19 – Amount in Words (English, Arabic), Invoices Settled, Signatures

    Print payment, receipt and journal vouchers from Odoo Community: the amount in words in English or Arabic, the invoices settled, the payment details and the signature boxes.

    by TAQNIX
    No reviews yet
    Sales:0$39.00
  • ModuleNew

    Bank Statement Import for Odoo 19 Community – CSV, Excel and OFX with Duplicate Check and Rules

    Import your bank statements into Odoo Community from CSV, Excel or OFX: columns found by their headers, every transaction checked, duplicates skipped, partners matched, rules for the counterpart account.

    by TAQNIX
    No reviews yet
    Sales:0$79.00