Macro Movement Timeline (49 Weeks)
Weekly trend of Total Receivables vs Trade Creditors vs Total Liabilities
Net Cash Flow Gap Movement
Surplus margin of Receivables over Total Payables over time
Debtors Concentration (Pareto 80/20)
Receivables exposure & key customer dependency
Creditors Concentration (Pareto 80/20)
Trade payables concentration & key supplier dependency
Collect Now (Overdue Debtors)
Ranked by Overdue Risk = Amount × Days Overdue
Pay Now / Pay This Week
Creditors with expired terms or maturing credit windows
Follow-up Queue (Stalled Balances)
Active balances with zero movement for 3+ weekly snapshots
👥 Sundry Debtors Aging Distribution
| # | Party Name | Location | Total Balance (₹) | 0–45 Days (₹) | 45–60 Days (₹) | 60–90 Days (₹) | 90–180 Days (₹) | >180 Days (₹) | Critical % (>90d) |
|---|
🏢 Supplier Credit Terms & Maturity Matrix
| # | Supplier Name | Location | Stated Credit Terms | Term Window | Total Payable (₹) | Status / Urgency |
|---|
Debtor Aging Bucket Evolution
Historical weekly shift across 0-45d, 45-90d, 90-180d, and >180d buckets
Top 10 Debtors (Latest Outstanding)
Major customer concentration and exposure
Top Suppliers & Creditors
Key vendors and trade balance
Supplier Credit Terms
Breakdown by agreed credit days (15d, 30d, 45d, 60d, 90d)
Operational Liabilities Breakdown
Salaries, Taxes (GST), Loans, Power, and Statutory fees
Party Directory
Party Balance Movement
Individual outstanding balance evolution over 49 weekly reporting cycles
Credit Note Deductions by Reason
Breakdown: Turnover Discount (T.O.D), Cash Discount (C.D), Breakage, Shortage
Deductions & Discount Insights
Credit notes issued directly impact net debtor cash collections. Turnover Discounts (T.O.D) and Cash Discounts (C.D) constitute the majority of commercial adjustments, while physical claims like Breakages and Shortages are tracked and resolved per shipment.
| Snapshot Date | Debtors (₹) | Creditors (₹) | Other Liab (₹) | Total Payables (₹) | Net Surplus Gap (₹) | Coverage |
|---|
| # | Party Name | Location | Pareto Tier | Total Balance (₹) | Cumulative % | 0-45 Days (₹) | 45-90 Days (₹) | 90-180 Days (₹) | >180 Days (₹) |
|---|
| # | Party Name | Location | Credit Terms | Pareto Tier | Total Payable (₹) | Cumulative % |
|---|