Aged Receivable / Payable — Salesperson Column
Add a Salesperson column and Group by Salesperson option to Aged Receivable and Aged Payable reports in Odoo Accounting
In standard Odoo Accounting, the Aged Receivable and Aged Payable reports display outstanding balances grouped by partner — but there is no way to see which salesperson is responsible for each invoice or bill. Finance managers and sales managers have no visibility into which salesperson owns which outstanding balance, making it difficult to track collections or assign accountability per salesperson.
This module solves that by adding a dedicated Salesperson column to both the Aged Receivable and Aged Payable reports. The column is populated automatically from the salesperson assigned on the Sales & Purchase tab of each customer or vendor record — for example, Mitchell Admin for Acme Corporation and Marc Demo for Azure Interior — and appears on every invoice and bill line in the report.
Beyond just showing the salesperson per line, the module also adds a powerful Group by Salesperson option under the report's Options menu. When enabled, the report restructures itself to group all partners and their invoices under their respective salesperson — giving a complete view of each salesperson's outstanding receivables or payables at a glance.
For example, enabling Group by Salesperson on the Aged Receivable report shows Marc Demo with Azure Interior and Mitchell Admin with Acme Corporation — each with their full aged balance breakdown across At Date, 1-30, 31-60, 61-90, 91-120, Older, and Total columns. The same grouping is available on the Aged Payable report as well.
This module is ideal for sales managers, finance teams, and collection teams who need salesperson-level visibility into outstanding balances directly from Odoo's native Aged Receivable and Aged Payable reports — with full PDF and XLSX export support.
Salesperson Column
A dedicated Salesperson column is added to both Aged Receivable and Aged Payable reports — auto-populated from the partner's Sales & Purchase tab.
Group by Salesperson
Enable Group by Salesperson from the Options menu to restructure the entire aging report grouped under each salesperson with full balance breakdown.
Aged Receivable Report
Salesperson column and grouping work fully on the Aged Receivable report — track who owns each outstanding customer balance by salesperson.
Aged Payable Report
The same Salesperson column and Group by Salesperson option are available on the Aged Payable report — full visibility on vendor-side outstanding balances.
Auto-Populated from Partner
The salesperson is pulled automatically from the Sales & Purchase tab of each customer or vendor — no manual input required on any report.
PDF & XLSX Export
Export the salesperson column and grouped view to PDF or XLSX — share salesperson-level aging reports with management instantly.
Who Needs This Module?
Ideal for any Odoo business that wants salesperson-level accountability in aging reports
Sales Managers
Monitor which salesperson has the most outstanding receivables and follow up on collections by salesperson directly from the Aged Receivable report.
Finance & Accounts Teams
Get complete salesperson-level aging data in one report — no need to manually cross-reference invoices with salesperson assignments.
Collection Teams
Assign collection tasks by salesperson — use the grouped view to instantly see which salesperson's customers have the most overdue balances.
See It in Action
A complete visual walkthrough — from setting the salesperson on a customer record to viewing grouped aging reports by salesperson.
Set Salesperson on Customer Record
Open any customer in Accounting → Customers — for example Acme Corporation. Go to the Sales & Purchase tab and set the Salesperson field — for example Mitchell Admin. Save the record. This salesperson will automatically appear in the Aged Receivable report against all invoices for this customer.
Customers → Acme Corporation → Sales & Purchase → Salesperson → Mitchell Admin
Open Aged Receivable Report
Go to Accounting → Reporting → Aged Receivable from the top navigation menu. The Aged Receivable report opens showing all outstanding customer balances with their aged breakdown across At Date, 1-30, 31-60, 61-90, 91-120, Older and Total columns.
Accounting → Reporting → Partner Reports → Aged Receivable
Salesperson Column Visible on Every Line
The Aged Receivable report now shows a Salesperson column on every invoice line. For Acme Corporation, all invoices show Mitchell Admin as the salesperson. For Azure Interior, all invoices show Marc Demo. The salesperson is automatically pulled from each customer's record — no manual entry needed.
Aged Receivable → Salesperson column → Mitchell Admin / Marc Demo per line
Enable Group by Salesperson from Options
Click the Options button in the top filter bar of the Aged Receivable report. A dropdown appears with options including Unfold All, Show Account, Hide lines at 0, and the new Group by Salesperson option. Click Group by Salesperson to enable it.
Options → Group by Salesperson → Report restructures by salesperson
Aged Receivable Grouped by Salesperson
The Aged Receivable report is now grouped by salesperson. Marc Demo appears first with Azure Interior showing a balance of $31,750.00 in the 1-30 column and -$31,750.00 at date. Mitchell Admin appears next with Acme Corporation — each salesperson section shows the full aged balance breakdown with a subtotal per salesperson.
Aged Receivable → Group by Salesperson → Marc Demo / Mitchell Admin sections
Aged Payable Also Grouped by Salesperson
The same Group by Salesperson option is also available on the Aged Payable report. Enable it from Options and the Aged Payable report groups all vendor bills under their salesperson — for example Marc Demo with Azure Interior showing bills RBILL/2026/07/0001, BILL/2026/07/0001 and older entries, all with their aged balance breakdown. Export to PDF or XLSX at any time.
Aged Payable → Options → Group by Salesperson → Marc Demo with Azure Interior
Built by Odoo Experts.
Trusted by Businesses.
Dedicated Support
We stand behind every product we ship, responsive support when you need it most. ✦10-hour free trial included
Industry-Specific Expertise
Deep knowledge across manufacturing, retail, services, healthcare, and more — we don't apply generic ERP templates, we tailor solutions to your sector.
Fast & Phased Implementation
Our agile delivery model gets your core ERP live quickly, then scales with your needs — reducing risk and accelerating ROI.
Email us
sales@truodo.com
+91 99255 58791
linkedin.com/company/truodo-solutions
FAQ
Everything worth knowing before you install. Still unsure about something specific?
Built by Odoo Experts.
Trusted by Businesses.
Dedicated Support
We stand behind every product we ship, responsive support when you need it most. ✦10-hour free trial included
Industry-Specific Expertise
Deep knowledge across manufacturing, retail, services, healthcare, and more — we don't apply generic ERP templates, we tailor solutions to your sector.
Fast & Phased Implementation
Our agile delivery model gets your core ERP live quickly, then scales with your needs — reducing risk and accelerating ROI.
Email us
sales@truodo.com
+91 99255 58791
linkedin.com/company/truodo-solutions
10-Hour Free Trial Included
Try the Aged
Receivable / Payable Salesperson Column module risk-free. No credit card required.
Our
team will guide you through the entire setup and workflow.
Please log in to comment on this module