Accounts Receivable KPI Dashboard

Apex Industrial Components — Executive AR Scorecard & DSO Command Center

Updated 4 min ago
Days Sales Outstanding
47.2
+5.4 days
Target: 42 days
Collection Effectiveness
79.4%
+8.4%
13-week rolling
Total AR Balance
$84.2M
+3.1% MoM
vs. $81.7M prior
Past-Due AR %
28.3%
+4.2%
$23.8M past due
Weighted Avg Days Del.
18.7
+3.1
Past-due only
Top-10 Concentration
42.1%
+4.1%
Alert: >38% target
AR Turnover Ratio
7.73x
-0.51x
Annualized
Bad Debt Rate
0.87%
+0.12%
% of net revenue
Disputed AR
3.4%
-0.8%
$2.9M disputed
Cash Collected (WTD)
$4.2M
-8.7%
vs. $4.6M forecast
Current AR Ratio
71.7%
-4.2%
0-30 days bucket
Revenue Growth (QoQ)
+6.8%
+1.2%
AR quality check

DSO Trend — 52 Week View with Target Band

CEI Waterfall — 13-Week Rolling Performance

AR Aging Distribution — Current vs. Past-Due

Top 15 Customer AR Detail — Concentration & Aging Risk

Customer AR Balance % of Total DSO Past-Due % Risk Flag
Orion Manufacturing $11,948,000 14.2% 62 41.2% HIGH
Titan Industries Ltd $7,234,000 8.6% 51 28.3% MEDIUM
Phoenix Aerospace $5,892,000 7.0% 38 14.7% LOW
Atlas Engineering Corp $4,517,000 5.4% 44 22.1% MEDIUM
Zenith Components Inc $3,281,000 3.9% 35 9.2% LOW
Meridian Manufacturing $2,947,000 3.5% 58 35.8% HIGH
Vertex Industrial Group $2,615,000 3.1% 41 18.5% LOW
Apex Dynamics LLC $2,394,000 2.8% 49 26.4% MEDIUM
Summit Precision Parts $2,108,000 2.5% 32 7.3% LOW
Horizon Tech Solutions $1,876,000 2.2% 46 21.7% MEDIUM
Velocity Manufacturing $1,652,000 2.0% 37 11.8% LOW
Prism Automation Inc $1,489,000 1.8% 53 31.2% MEDIUM
Nova Industries Co $1,347,000 1.6% 39 15.3% LOW
Eclipse Manufacturing $1,213,000 1.4% 42 19.6% LOW
Nexus Components Ltd $1,087,000 1.3% 48 24.1% MEDIUM

Cash Collected vs. Forecast — Weekly Variance

AR Turnover Ratio — Annualized Trend

Top-10 Concentration Index

Orion Mfg 14.2%
Titan Ind 8.6%
Phoenix Aero 7.0%
Atlas Eng 5.4%
Zenith Comp 3.9%
5 Others 3.0%
Total Top-10: 42.1%

Disputed AR Breakdown

Bad Debt Rate Trend

WADD by Customer Segment — Delinquency Heatmap

Enterprise
Mid-Market
SMB
Strategic
0-30 days
2.1
1.8
3.2
1.4
31-60 days
14.7
11.3
18.2
9.8
61-90 days
28.4
22.1
31.6
19.7
90+ days
52.8
41.2
67.3
38.9

Current vs. Past-Due by Customer Tier

NetSuite AR sync: 4 min ago
HighRadius collections: 7 min ago
Bank receipts (Plaid): 2 min ago
Last full reconciliation: Today 8:47 AM EST • Data as of Week 52, 2024