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.
The aged receivable and aged payable reports belong to Odoo Enterprise. Aged Receivable & Payable Report gives them to Community.
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
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
As of any date
A past date puts back the payments made after it: the report shows what was open then.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.