NYFLEX (2025-26) RECEIVABLES

FIFO BASIS  ·  346 RECORDS  ·  288 ACCOUNTS  ·  analytics/upload_20260307_121811.xlsx

2026-03-07 12:18:11
↑ UPLOAD NEW
Total Pending Receivables
17,272,160
288 accounts  ·  346 entries
Overdue (180+ Days)
11,933,398
69.1% of total receivables
Current (0–30 Days)
1,190,837
6.9% of total receivables
Collection Efficiency
-36.1%
₹-45.82L collected of billed
Aging Bucket Distribution
Transaction Type Breakdown
Receivables Aging Analysis
0–30 Days
₹11.91L
28 entries
6.9%
31–60 Days
₹11.59L
27 entries
6.7%
61–90 Days
₹13.62L
15 entries
7.9%
91–180 Days
₹16.26L
25 entries
9.4%
180+ Days
₹119.33L
251 entries
69.1%
Top 10 Debtors by Outstanding
Risk Concentration
⚠️
Top Debtor Alert
₹27.18L
Fibro Plastichem (India) Private Limited — 340 days outstanding. Immediate follow-up recommended.
📊
Aging Risk Score
HIGH
78.5% of receivables are over 90 days old. Provisioning review strongly advised.
🏢
Top 5 Debtor Share
46.5%
Top 5 accounts owe ₹80.26L. Concentration risk is elevated.
📅
Avg Days Outstanding
~249 days
Weighted average age. Industry benchmark for wholesale/distribution is typically 60–90 days.
💼
Opening Balance (OpBl)
₹106.62L
₹10,661,984 (61.7%) carried-forward balances — oldest and highest-risk items.
Near Recovery
₹11.91L
Fresh 0–30 day invoices. Act promptly to prevent further aging.
Detailed Ledger
# Account Salesman Date Type Bill No. Bill Amt (₹) Pending (₹) Days Recovery