Financial Control Tower Sandbox Data
Enterprise Grade Billing & Revenue ManagementERP Integration Monitor
SAP Connected
Oracle Active
Last Sync
10 mins ago
Pending
179
Failed
3
Posted Today
1,402
Executive Metrics
DSO DEMO
42 Days
-3 days YoYCEI (Collection Efficiency) DEMO
92.4%
-1.2% MoMAR Days Outstanding DEMO
38 Days
Target: 35Bad Debt Risk DEMO
High ($1.2M)
3 accounts exposedRevenue Leakage Risk DEMO
$85,400
Unbilled servicesAI Financial Assistant
Live Analysis
Anomalies & Risks
- CMA overdue > 90 days ($89K)
- MAERSK exceeded credit limit
- Reefer revenue dropped 8% this week
Predictions & Recommendations
- Pred. cashflow (14d): $820,000
- Recommended action: Place hold on COSCO
- Send automated dunning letters to 14 clients
Revenue Trend Analytics (12 Months)
DEMO DATARevenue Impact Analytics
Live DB DataBy Service Type
Handling$804,805.25
Storage$139,175.38
Demurrage$0.00
By Shipping Line (Demo)
Maersk Line$420,000
MSC$310,000
CMA CGM$180,000
Operational Impact (Live)
Live Status-
Containers Blocked by Finance Total units unable to move42
-
Pending Gate-Out (Unpaid) Trucks waiting at gate17
-
Daily Demurrage Accrual Uncollected daily risk$14,200/day
AR Aging Analytics
DEMO DATA| Bucket | Amount | Inv | % |
|---|---|---|---|
| 0-30 Days | $210,500 | 45 | 61% |
| 31-60 Days | $80,000 | 12 | 23% |
| 61-90 Days | $35,000 | 6 | 10% |
| 90+ Days | $19,600 | 2 | 6% |
Advanced Collections Center
Expected Cash This Week: $145,000
This Month: $820,000
| Priority Score | Customer (Drill Down) | Risk Level | Total Due Amount | Status | Action |
|---|---|---|---|---|---|
| Critical (99) | CUST-MAERSK | Over Limit | $1,727.20 | Open | Review & Collect |
| Critical (99) | CUST-YANGMING | Over Limit | $5,699.22 | PromiseToPay | Review & Collect |
| High (85) | CUST-COSCO | Good | $5,912.21 | Open | Review & Collect |
| High (85) | CUST-CMA | Good | $6,818.96 | Open | Review & Collect |
| High (85) | CUST-EVERGREEN | Good | $3,277.21 | Open | Review & Collect |
| Medium (45) | CUST-MAERSK | Good | $4,478.53 | Disputed | Review & Collect |
| Medium (45) | CUST-PIL | Good | $6,293.78 | Open | Review & Collect |
| Medium (45) | CUST-CMA | Good | $7,977.50 | Open | Review & Collect |
| Medium (45) | CUST-CMA | Good | $4,731.86 | Disputed | Review & Collect |
| Medium (45) | CUST-CMA | Good | $5,515.56 | Open | Review & Collect |