Receivables and collection priorities · Distribuidora Norte
Example business: Distribuidora Norte — a supplies wholesaler selling on 30- and 45-day credit to 142 business customers.
The ten sections organize this illustrative example. Each product report has its own scope and format.
Analysis overview
Company, period and receivables cut-off date.
- Company
- Distribuidora Norte (fictitious data)
- Invoiced period
- August 2024 – July 2025
- Receivables cut-off date
- July 31, 2025
- Population
- 386 open invoices from 97 customers.
Executive summary
Outstanding balance, overdue amounts and main priorities.
Outstanding receivables total USD 348,600, of which USD 127,400 (36.5%) are overdue. The real collection period averages 58 days against agreed 30–45. Five customers concentrate 54% of the overdue balance, and USD 14,500 is more than 90 days late: that is the portion with the most urgent management need.
- 78% of the overdue balance is under 60 days: still ordinary-management territory.
- Two large customers systematically pay 20+ days late and drive the average.
- The prioritization in element 7 orders follow-up by balance and days late.
Quality and reconciliation
Applied payments, balances and possible inconsistencies.
Applied payments reconcile against invoices with a USD 640 difference (0.02% of billing), attributable to unreferenced credit notes listed in the annex. Eight partially paid invoices are shown at their remaining balance.
- 1,914 invoices issued in the period; 386 open at the cut-off.
- Due dates present on 100% of invoices.
- There is no payment-promise log: prioritization does not incorporate them.
Key indicators
Total, overdue and upcoming receivables, and distribution of the delay.
Total receivables
USD 348,600
Overdue balance
USD 127,400
36.5% of receivables
Not yet due
USD 221,200
Real collection period
58
Average days; agreed: 30–45
Balance aging
Classification by brackets and due dates.
Aging is measured from each invoice’s due date, not its issue date. Most of the overdue balance is recent; the 90+ bracket is small but carries the highest deterioration risk.
Receivables by aging bracket
Open balance by days elapsed since the due date.
Explore with the pointer or keyboard. Tap a value to keep its detail visible.
Per-customer analysis
Concentration and observed payment behavior.
Receivables are concentrated: five customers hold 46% of the total balance and 54% of the overdue amount. Payment behavior was measured as the average delay of invoices paid over the last 12 months.
Follow-up prioritization
Invoices and customers ordered by explicit balance and delay criteria.
Invoices were ordered by an explicit criterion: oldest bracket first and, within each bracket, largest balance. The full 386-invoice list is in the annex; this excerpt shows the top five positions.
AI analysis
Interpretation of patterns and follow-up recommendations, without attributing uncalculated default probabilities.
Key findings
The overdue balance concentrates in customers who do pay
CL-018 and CL-042 hold USD 53,600 overdue, but their history shows consistent payment 21–24 days late. Based on what is observed, this is slow — not uncollectible — debt.
Evidence: Per-customer analysis (element 6).
The 90+ bracket comes from few cases
USD 14,500 beyond 90 days corresponds to 9 invoices from 4 customers. Two of them have paid nothing all year: they concentrate the real loss risk.
Evidence: Collection queue (element 7) and the annex detail.
Agreed terms are not being enforced
61% of invoices are paid after their due date and there is no record of pre-due-date collection activity. The delay looks tolerated rather than negotiated.
Evidence: Payment distribution in the annex and the quality section (element 3).
Business interpretation
Three different management tracks are mixed into one overdue figure: collecting the critical cases (4 customers beyond 90 days), agreeing calendars with the two slow-paying large accounts, and preventing new delay with pre-due-date reminders. Treating them alike wastes the team’s time on the wrong cases. This report does not calculate default probabilities; it orders follow-up by observed balance and delay.
Hypotheses and limitations
- CL-018’s constant delay may follow its own biweekly cash cycle; a commercial conversation would confirm it and allow aligning due dates.
- The unreferenced credit notes suggest unrecorded delivery disputes; if so, part of the overdue balance may be under discussion rather than delinquent.
Prioritized recommendations
Immediate action on the 4 customers beyond 90 days
Direct contact this week with a documented payment agreement; without a response in 15 days, evaluate suspending shipments and formal collection.
Agreed payment calendar with CL-018 and CL-042
Formalize the real term they already practice (60 days) in exchange for punctual payment, or apply agreed late interest. This removes 42% of the overdue from daily management.
Automatic reminder 5 days before the due date
An email with the invoice and its exact due date for all customers. The lowest-cost preventive measure against 1–30-day delay.
Proposed follow-up
Management plan
Actions and receivable-recovery metrics.
Methodology and annexes
Classification criteria and invoice detail.
Aging measured from the due date at the July 31, 2025 cut-off. Partial payments reduce the original invoice balance. The collection queue orders by aging bracket and then by balance; the criterion is explicit and adjustable. No default probabilities are calculated.
- Annex A: full list of 386 invoices with aging and queue position.
- Annex B: per-customer summary (97 customers) with payment behavior.
- Annex C: reconciliation differences and unreferenced credit notes.