Skip to main content
These examples use fictitious data, names and figures. Their content and format are illustrative; available results depend on the product you choose and the data you provide.

This case illustrates a possible project for discussion. Profitability, cash flow, receivables and simulation are not automatically included in Cortex: feasibility, data, scope, deliverables and pricing must be assessed first.

Demo reportSample report

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.

  • Not yet dueUSD 221,200
  • 1–30 daysUSD 58,900
  • 31–60 daysUSD 34,200
  • 61–90 daysUSD 19,800
  • Over 90 daysUSD 14,500

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.

Customers with the largest balances
CustomerTotal balanceOverdue balanceHistorical average delay
CL-018 · Restaurant chainUSD 89,200USD 38,40024 days
CL-042 · HotelUSD 41,300USD 15,20021 days
CL-007 · Educational institutionUSD 15,400USD 9,8009 days
CL-063 · Catering companyUSD 9,100USD 3,60012 days
CL-029 · Coffee shops (3 locations)USD 6,200USD 1,9006 days

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.

Top of the collection queue
InvoiceCustomerBalanceDays late
F-2201CL-018USD 8,400112
F-2274CL-091USD 3,80097
F-2301CL-018USD 2,30094
F-2385CL-042USD 7,90084
F-2412CL-007USD 6,10071

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

Priority: High

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.

Priority: High

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.

Priority: Medium

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

Proposed follow-up
IndicatorReference valueReview period
Total overdue balanceUSD 127,400 → proposed target USD 85,000 (a goal, not a projection)Biweekly receivables cut-off
Real collection period58 days → proposed target 48 days (a goal, not a projection)Monthly review

Management plan

Actions and receivable-recovery metrics.

Management plan
ActionSuggested ownerFollow-up metricPriority
Contact and document agreements with the 4 customers beyond 90 daysAdministration90+ balance recovered or under agreementHigh
Negotiate a formal calendar with CL-018 and CL-042Commercial managementCompliance with the agreed calendarHigh
Activate pre-due-date remindersAdministration% of invoices paid on timeMedium

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.

Other sample reports

Apply the question to your data

This case illustrates a possible project for discussion. Profitability, cash flow, receivables and simulation are not automatically included in Cortex: feasibility, data, scope, deliverables and pricing must be assessed first.

Receivables and collection priorities · Sample report · Valerian Data