📦 VIEWING ARCHIVED FILE FROM old_analytics/ — UPLOADED 2026-03-06 09:52:30, ARCHIVED 2026-03-07 09:41:07 ← BACK TO HISTORY

MAAGNUM (2025-26) [ARCHIVE]

NY_BillsReceivables(FIFOBasis).xlsx  ·  305 RECORDS  ·  198 ACCOUNTS

📦 ARCHIVED: 2026-03-07 09:41:07
VIEW CURRENT →
Total Pending
13,181,644
198 accounts · 305 entries
Overdue 180+ Days
6,249,063
47.4% of total
Current 0–30 Days
3,657,807
27.7% of total
Collection Efficiency
17.8%
₹28.46L collected
Aging Bucket Distribution
Transaction Type Breakdown
Receivables Aging Analysis
0–30 Days
₹36.58L
81 entries
27.7%
31–60 Days
₹11.27L
35 entries
8.5%
61–90 Days
₹5.58L
21 entries
4.2%
91–180 Days
₹15.90L
43 entries
12.1%
180+ Days
₹62.49L
125 entries
47.4%
Top 10 Debtors
Risk Concentration
⚠️
Top Debtor
₹17.81L
PRAMOD SINGH GUNJIYAL — 339 days outstanding.
📊
Risk Score
MEDIUM
59.5% over 90 days. Monitor closely.
🏢
Top 5 Share
34.5%
Top 5 accounts owe ₹45.42L.
📅
Avg Days
~182 days
Weighted average age of receivables at time of archiving.
💼
Opening Balance
₹47.88L
36.3% of total were carried-forward balances.
Near Recovery
₹36.58L
Amount in 0–30 day bucket at time of this file.
Detailed Ledger
#AccountDateTypeBill No. Bill Amt (₹)Pending (₹) DaysRecovery