📦 VIEWING ARCHIVED FILE FROM old_analytics/ — UPLOADED 2026-03-07 10:45:12, ARCHIVED 2026-03-07 12:18:11 ← BACK TO HISTORY

MAAGNUM (2025-26) [ARCHIVE]

NY_BillsReceivables(FIFOBasis) (1).xlsx  ·  227 RECORDS  ·  133 ACCOUNTS

📦 ARCHIVED: 2026-03-07 12:18:11
VIEW CURRENT →
Total Pending
10,066,438
133 accounts · 227 entries
Overdue 180+ Days
3,122,586
31% of total
Current 0–30 Days
3,885,196
38.6% of total
Collection Efficiency
23.2%
₹30.40L collected
Aging Bucket Distribution
Transaction Type Breakdown
Receivables Aging Analysis
0–30 Days
₹38.85L
78 entries
38.6%
31–60 Days
₹10.16L
27 entries
10.1%
61–90 Days
₹5.75L
18 entries
5.7%
91–180 Days
₹14.68L
31 entries
14.6%
180+ Days
₹31.23L
73 entries
31%
Top 10 Debtors
Risk Concentration
⚠️
Top Debtor
₹8.18L
Royal Bengal (Singing Bar) — 316 days outstanding.
📊
Risk Score
MEDIUM
45.6% over 90 days. Monitor closely.
🏢
Top 5 Share
31.6%
Top 5 accounts owe ₹31.79L.
📅
Avg Days
~134 days
Weighted average age of receivables at time of archiving.
💼
Opening Balance
₹20.26L
20.1% of total were carried-forward balances.
Near Recovery
₹38.85L
Amount in 0–30 day bucket at time of this file.
Detailed Ledger
#AccountDateTypeBill No. Bill Amt (₹)Pending (₹) DaysRecovery