Aging Analysis (Aged Partner Balance)
An aging analysis report that categorizes outstanding partner balances into customizable time buckets, helping you manage overdue receivables and payables.
Purpose
The Aged Partner Balance report provides a clear view of outstanding receivables and payables organized by how long they have been overdue. This is essential for credit management, collections follow-up, and cash flow forecasting.
Generating the Report
Navigate to Accounting > Reporting > Financial Reports > Aged Partner Balance to open the wizard.
Wizard Parameters
| Parameter | Description |
|---|---|
| Company | Company to report on (required) |
| As of Date | Reference date for aging calculation (default: today) |
| Partner Type | Receivable (Customers), Payable (Suppliers), or Both |
| Target Moves | Posted Entries (default) or All Entries |
| Period Length (days) | Days per bucket (default: 30 days) |
| Bucket 1 / 2 / 3 / 4 | Aging bucket boundaries (configurable in Company Settings) |
| Partners | Filter by specific partners (optional) |
Click View Report to display the interactive view, Print PDF for a formatted document, or Export XLSX for a spreadsheet.
Aging Buckets
The report distributes outstanding balances into the following aging buckets:
| Bucket | Default Range | Description |
|---|---|---|
| Not Due | Future dated | Entries with maturity date after the "As of Date" |
| 0-30 | 0 - 30 days | Overdue up to 30 days |
| 30-60 | 30 - 60 days | Overdue 30 to 60 days |
| 60-90 | 60 - 90 days | Overdue 60 to 90 days |
| 90-120 | 90 - 120 days | Overdue 90 to 120 days |
| Over 120 | 120+ days | Severely overdue entries |
Aging bucket boundaries are configured in Accounting > Configuration > Settings > Dynamic Financial Reports. You can change them to any values (e.g., 15, 30, 45, 60 days) to match your business requirements.
Report Output
Each row shows a partner with their outstanding balance distributed across the aging buckets:
| Column | Description |
|---|---|
| Partner | Partner name |
| Not Due | Amount not yet due |
| 0-30 | Amount overdue 0-30 days |
| 30-60 | Amount overdue 30-60 days |
| 60-90 | Amount overdue 60-90 days |
| 90-120 | Amount overdue 90-120 days |
| Over 120 | Amount overdue 120+ days |
| Total | Total outstanding balance for the partner |
The bottom row displays grand totals across all partners for each aging bucket.
Use Cases
- Collections Management -- Identify customers with overdue balances and prioritize follow-up
- Credit Risk Assessment -- Review aging trends to assess customer creditworthiness
- Supplier Payment Planning -- Track upcoming and overdue payables for cash flow planning
- Audit Preparation -- Provide auditors with a clear breakdown of receivables and payables aging
Export Options
- View Report -- Opens an interactive list view with sorting and searching
- Print PDF -- Generates a professional landscape A4 PDF with company branding
- Export XLSX -- Downloads a formatted Excel file with frozen headers and number formatting
Contact SDLC Corp at sdlccorp.com/contact-us or email sales@sdlccorp.com