Data note: Source sheet contains only transaction-level fields (CN Date, CN No., Particulars, Bill Date, Bill No., Gross Total) — no District/Department/Category columns.
Customer/Party is used as the segmentation dimension throughout, and Financial Year / Calendar Year / Month drive time filtering. A few near-duplicate party names exist in the source (e.g. "ZEPTO LIMITED" vs "ZEPTO PRIVATE LIMITED") and are shown as-is.
Key Performance Indicators
Snapshot for the currently selected filters
Trend Analysis
Monthly movement in credit note volume and value
Monthly Trend — Value & Count
Credit note value (bars) vs number of notes (line)
Financial Year Comparison
Total value by FY
Customer Analysis
Where credit note value is concentrated
Top 10 Customers
By total credit note value
Value Concentration
Top 5 customers vs rest
Bottom 10 Customers
By total value (min. 2 CNs)
Processing & Seasonality
How quickly notes are raised, and quarterly patterns
CN Processing Lag
Days between Bill Date and CN Date
Quarter-wise Pattern
Total value by financial quarter (Q1=Apr-Jun)
Credit Note Register
Full transaction detail — searchable, sortable, exportable
| CN Date | CN No. | Customer / Party | Bill Date | Bill No. | Lag (days) | Gross Total (₹) |
|---|