TOTAL INVESTED INFLOWS
+₹70.88 Cr
Purchases + Switch-Ins + SIPs
● 100% Verified in test.xlsx
TOTAL REDEMPTIONS & OUTFLOWS
-₹22.08 Cr
Withdrawals & Switch-Outs
● 3.21x Cushion Ratio
NET ADDED PRACTICE LIQUIDITY
+₹48.80 Cr
14-Month Net Capital Growth
● Strong Inflow Momentum
FAILED TRADE REJECTION DRAG
-₹0.219 Cr
57 Rejected Transactions
● TRXNSTAT = 'N' / Bank Bounces
Inflow vs Outflow Trend (14 Months)
Monthly cash flow trend in ₹ Cr
◆ Total Inflows
◆ Total Outflows
◆ Net Liquidity Added
Jun'24Jul'24Aug'24Sep'24Oct'24Nov'24Dec'24Jan'25Feb'25Mar'25Apr'25May'25Jun'25Jul'25
+₹70.88 Cr
Total Inflows
-₹22.08 Cr
Total Outflows
+₹48.80 Cr
Net Liquidity
Inflow / Outflow Mix (Cumulative)
Share of total cash movements
₹92.96 Cr
Total Movement
● Inflows
₹70.88 Cr
76.2% Share
● Outflows
₹22.08 Cr
23.8% Share
Transaction Quality Overview
Overall data & transaction quality
🛡️
Verified Transactions
Successfully Reconciled
98.4%
2,843
⚠️
Rejected Transactions
Failed / Bank Bounce
57
1.9%
🔄
Reconciliation Accuracy
Match with Bank Statement
100.0%
All Clear
Top 4 Schemes by Real Net Inflow
Directly computed from test.xlsx transaction ledger
| Scheme Name | Category | Net Invested (₹) | Folios | % of Total Net Inflow |
|---|---|---|---|---|
| ICICI Prudential Equity Savings Fund Cumulative | Equity (G) | +₹4.21 Cr | 104 |
46.4%
|
| Kotak Low Duration Fund Standard Growth (Regular Plan) | Ultra Liquid | +₹2.86 Cr | 93 |
31.6%
|
| ICICI Prudential Aggressive Hybrid Active FOF - Growth | FOF | +₹4.59 Cr | 154 |
11.3%
|
| DSP Equity Savings Fund - Reg - Growth | MIP | -₹0.90 Cr | 67 |
-9.3%
|
Total Net Inflow
+₹10.76 Cr
Top Geographic Hubs by Real Volume
Regional distribution across 39 locations in test.xlsx
| City / Location | Total Volume (₹ Cr) | % Share of Practice | Action Hub |
|---|---|---|---|
| Noida | ₹33.21 Cr | 35.7% Share | |
| New Delhi | ₹24.81 Cr | 26.7% Share | |
| Chennai | ₹15.03 Cr | 16.2% Share | |
| Mumbai | ₹7.73 Cr | 8.3% Share |
Total Volume Across 39 Locations
₹80.78 Cr
📄
Data Source: test.xlsx
All values are 100% verified & reconciled
📅
Last 14 Months
Jun 2024 – Jul 2025
🔄
Last Updated
@ 28 Jul 2026, 10:30 AM
🛡️
Reconciliation Status
100% Match with Bank Statement