Age Analysis Report

Analysis of outstanding balances by age category

Total Outstanding: $48,750 • Accounts: 127
Back to Dashboard
Total Outstanding

$48,750

+5.8% vs Last Month

127 accounts
Current (0-30)

$18,250

-2.1% vs Last Month

58 accounts
31-60 Days

$12,480

+8.4% vs Last Month

34 accounts
61-90 Days

$9,850

+12.5% vs Last Month

22 accounts
90+ Days

$8,170

+15.2% vs Last Month

13 accounts
67.4%
Collection Rate
Age Analysis Report - As of December 15, 2024
Customer Invoice No Invoice Date Due Date Age (Days) Outstanding Amount Age Category Risk Level Last Payment Actions
HM
Howard Martenstyn
Individual
INV-202412-001 Dec 10, 2024 Jan 09, 2025 5 $1,250.00 Current Low Risk Dec 05, 2024
$500.00
ST
Sugeethan Thanigasalam
Corporate
INV-202411-015 Nov 15, 2024 Dec 15, 2024 30 $2,850.00 31-60 Days Medium Risk Oct 20, 2024
$1,000.00
AJ
Anne et Jean Green
Travel Agent
INV-202410-008 Oct 20, 2024 Nov 19, 2024 56 $4,500.00 61-90 Days High Risk Sep 15, 2024
$2,000.00
SB
Selina Bridget
Individual
INV-202409-003 Sep 05, 2024 Oct 05, 2024 101 $3,200.00 90+ Days Critical Risk Aug 10, 2024
$1,500.00
SK
Sachith Kapu
Corporate
INV-202412-005 Dec 12, 2024 Jan 11, 2025 3 $850.00 Current Low Risk Nov 30, 2024
$2,000.00
MD
Michael Davis
Individual
INV-202411-012 Nov 20, 2024 Dec 20, 2024 25 $1,680.00 31-60 Days Medium Risk Oct 25, 2024
$750.00
JS
Jennifer Smith
Corporate
INV-202410-020 Oct 10, 2024 Nov 09, 2024 66 $5,250.00 61-90 Days High Risk Sep 05, 2024
$1,500.00
RW
Robert Wilson
Individual
INV-202408-007 Aug 15, 2024 Sep 14, 2024 122 $1,750.00 90+ Days Critical Risk Jul 20, 2024
$800.00
EJ
Emily Johnson
Travel Agent
INV-202412-003 Dec 14, 2024 Jan 13, 2025 1 $3,200.00 Current Low Risk Dec 01, 2024
$1,500.00
TB
Thomas Brown
Group
INV-202411-025 Nov 25, 2024 Dec 25, 2024 20 $2,100.00 31-60 Days Medium Risk Oct 30, 2024
$1,000.00
Age Analysis Summary
Total Outstanding: $48,750
127 outstanding invoices 		Current (0-30): $18,250 (37.4%)
31-60 Days: $12,480 (25.6%)
61-90 Days: $9,850 (20.2%)
90+ Days: $8,170 (16.8%)
Showing 10 of 127 outstanding invoices as of December 15, 2024
Report Details & Analysis
Age Bucket Analysis
Current (0-30 days)
$18,250
37.4% of total • 58 accounts
31-60 Days
$12,480
25.6% of total • 34 accounts
61-90 Days
$9,850
20.2% of total • 22 accounts
90+ Days
$8,170
16.8% of total • 13 accounts
Risk Level Distribution
58
Low Risk
34
Medium Risk
22
High Risk
13
Critical Risk
Collection Analysis
Collection Performance: 67.4%

Overall collection rate is below target of 80%. Focus needed on 60+ day accounts.

90+ Days Aging

$8,170 in critical aging. Immediate action required for these 13 accounts.

Current Accounts

$18,250 in current aging. Good payment history with these 58 accounts.

Customer Type Analysis
Customer Type Accounts Outstanding Avg Age Collection Rate
Individual 45 $12,450 42 days 75.2%
Corporate 38 $18,750 38 days 78.5%
Travel Agent 24 $9,850 56 days 62.3%
Group 20 $7,700 45 days 73.8%
Total 127 $48,750 45 days 67.4%

Travel agents show the lowest collection rate and highest average age.

127
Outstanding Invoices
98
Unique Customers
45
Avg Days Outstanding
13
Critical Accounts