Receivables overview

Loading data…

Outstanding by category and age

Outstanding by division

Largest balances

States by outstanding

Ageing analysis

All 15 SAP ageing buckets from ZFI_CUST_AGEING_ANALYSIS, net of credit items in each bucket.

Ageing bucket × category

click a bar to filter customers

State × age heatmap (₹ Cr, top 12 states)

Division × age (₹ Cr)

Geography

State → sales office → customer. Click a state to drill.

By state

By sales office

Customers

One row per SAP customer, all divisions combined. Debit and credit balances shown separately.

Debits & credits

What each party owes us (debit) against what we hold or owe them (credit): advances, dealer deposits, retention — plus security/EMD we have placed with them.

Special GL balances (ZBCL)

Dealer deposit and retention are money we hold (credit). SD / EMD given are money we have placed with customers (debit). WCT / ITDS / AMC are receivable from the customer.

Party ledger

Sorted by net exposure after deposits; click a row for the full picture

Last sale vs outstanding

When did we last bill this customer, and do they still owe us? Billing dates come from the Max Bill Date extract.

Customers

Outstanding by recency of last sale

Divisions

Credit control area (CCAr) rolled up to division per the control-area map. Click a division to filter customers.

Legal

Customers whose sales group has been moved to "Legal" in SAP — recovery is with the legal cell.

Legal accounts

Legal book by state

Suggested actions

Rule-based, derived only from the SAP dumps. Log promises, disputes and calls from any customer's drawer — they appear under the customer's Activity tab.

Queue

Analytics

Concentration, category mix and age — computed from the loaded dumps.

Concentration — top 20 customers

Weighted age by category (days)

Customer count vs value by category

Sales-office league (₹ Cr, top 12)

SAP dumps

What has been loaded, how it reconciles, and what the extracts don't yet give us.

Loaded extracts

Reconciliation & data quality

Upload history & remaining gaps

User management

Admin only. Sign-in is Google only, restricted to @jains.com accounts; roles are set here.