Financial Dashboard
Track revenue, margins, receivables, and GST compliance
REVENUE MTD
₹2,34,56,780
Target: ₹2.5Cr
Gap: ₹15.4L
GROSS MARGIN
24.3%
↑ 1.2% vs Nov
Industry: 22%
OUTSTANDING
₹1,23,45,000
Overdue: ₹45L
36% of total
DSO (Days)
42 days
Target: <45 ✓
Trend: ↓ 3 days
Client-wise Revenue & Profitability
| Client | Revenue | % Share | Cost | Margin | Trend |
|---|---|---|---|---|---|
| Nexus Logistics | ₹45,23,000 | 19.3% | ₹34,12,000 | 24.6% | |
| RetailMax India | ₹38,67,000 | 16.5% | ₹32,45,000 | 16.1% | |
| PharmaCare Ltd | ₹32,12,000 | 13.7% | ₹24,89,000 | 22.5% | → |
| QuickCart | ₹28,90,000 | 12.3% | ₹23,12,000 | 20.0% | |
| FreshFoods Co | ₹24,56,000 | 10.5% | ₹21,34,000 | 13.1% |
AI Alert: RetailMax margin declining for 3 consecutive months
Recommendation: Review pricing structure
Activity-Based Costing
Cost per Pick:
₹12.50
Cost per Pack:
₹8.20
Cost per Pallet:
₹145.00
Cost per Sqft:
₹42.50/month
vs Last Month:
Pick: ↓5% ✓Pack: ↑2% Pallet: ↓3% ✓Sqft: ─ same
AR Aging Analysis
0-30 days₹78.5L
31-60 days₹28.2L
61-90 days₹12.3L
90+ days₹4.5L
Collection Prediction (AI)
Expected collection next 7 days:
₹52.3L (67% probability)
GST Analytics
CGST Collected
₹12,34,567
SGST Collected
₹12,34,567
IGST Collected
₹8,45,231
ITC Available:₹18,23,456
ITC Utilized:₹15,67,890
Balance:₹2,55,566
E-Way Bills Generated:1,234
Pending:23
Expired:0 ✓