August 2024
Segment Analytics
Which customers make money · which region is unprofitable · who subsidises whom. The P&L your Tally will never show you.
Key insight
15 customers gone quiet — last-year contribution ₹562,500 (147% of revenue). Either re-engage or accept the drop in forecasts.
Revenue (net)
₹383,000
35 customers
· 20 active
Top customer share
15.2%
HHI · portfolio risk
737
Diversified
Top-5 = 52.6% of revenue
At-risk revenue
₹562,500
15 customers quiet 6+ months
Customer ladder — who drives revenue
Top 15 by revenue · colour = relationship health · bar length = ₹ contribution
Active
Slowing (3+ mo)
Quiet (6+ mo)
Concentrated (> 25%)
Show full detail table (35 customers)
| # | Customer | Revenue (net) | % | Invoices | Last invoice | Outstanding | Tags |
|---|---|---|---|---|---|---|---|
| 1 | Shreearth Financial (Debtor) key | ₹450,000 | 15.2% | 8 | 2025-11-29 | ₹531,000 | Geo: Rajasthan |
| 2 | FINREP ADVISORS LLP | ₹425,000 | 14.4% | 2 | 2026-03-24 | ₹265,500 | Geo: Maharashtra |
| 3 | D S DODHIYA & CO | ₹332,000 | 11.2% | 6 | 2026-03-31 | ₹394,269 | Geo: Maharashtra |
| 4 | OTIF MULTI SOLUTIONS LLP | ₹185,000 | 6.3% | 9 | 2026-03-31 | ₹236,000 | Geo: Maharashtra |
| 5 | EKATRA RETAIL VENTURES PRIVATE LIMITED | ₹161,500 | 5.5% | 1 | 2026-02-10 | ₹181,140 | Geo: Maharashtra |
| 6 | GOLDSTANDARD WEALTH PRIVATE LIMITED quiet 10mo | ₹110,000 | 3.7% | 3 | 2025-06-16 | — | Geo: Maharashtra |
| 7 | INDO GERMAN CHAMBER OF COMMERCE | ₹100,000 | 3.4% | 1 | 2025-12-31 | ₹118,000 | Geo: Maharashtra |
| 8 | B.L.G INTERNATIONAL HING PRIVATE LIMITED | ₹100,000 | 3.4% | 1 | 2026-01-31 | ₹274,000 | Geo: Maharashtra |
| 9 | Shruthi & Co | ₹90,000 | 3.0% | 1 | 2026-03-06 | — | Geo: Karnataka |
| 10 | XTCY WORLD PRIVATE LIMITED | ₹77,500 | 2.6% | 3 | 2025-11-01 | ₹197,650 | Geo: Delhi |
| 11 | Suresh Bajaj | ₹75,000 | 2.5% | 2 | 2026-01-11 | ₹44,250 | Geo: Maharashtra |
| 12 | Sanjay Bajaj | ₹75,000 | 2.5% | 2 | 2026-01-11 | ₹44,250 | Geo: Maharashtra |
| 13 | Mindcraft Software Private Limited quiet 11mo | ₹70,000 | 2.4% | 1 | 2025-05-06 | — | Geo: Maharashtra |
| 14 | KA Sports and Events quiet 8mo | ₹60,000 | 2.0% | 1 | 2025-08-21 | ₹70,800 | Geo: Maharashtra |
| 15 | NK SARRAF & ASSOCIATES quiet 8mo | ₹52,000 | 1.8% | 2 | 2025-08-07 | ₹420,720 | Geo: Delhi |
| 16 | Pragati Software Pvt Ltd | ₹50,000 | 1.7% | 1 | 2026-02-21 | — | Geo: Maharashtra |
| 17 | RAPG Developments Private Limited | ₹45,000 | 1.5% | 1 | 2025-12-10 | — | Geo: Maharashtra |
| 18 | MELTING POT FOOD PRODUCTS PRIVATE LIMITED | ₹45,000 | 1.5% | 1 | 2026-02-04 | ₹105,700 | Geo: Maharashtra |
| 19 | CEID Consultants and Engineering Private Limited quiet 12mo | ₹45,000 | 1.5% | 1 | 2025-04-03 | — | Geo: Punjab |
| 20 | Santiago Ventures Private Limited | ₹40,000 | 1.4% | 2 | 2026-03-31 | ₹47,200 | Geo: Maharashtra |
| 21 | Golden Years Properties Private Limited | ₹40,000 | 1.4% | 1 | 2026-02-28 | ₹69,400 | untagged |
| 22 | SITNEM TRADING & INVESTMENT PRIVATE LIMITED quiet 6mo | ₹35,000 | 1.2% | 1 | 2025-10-24 | ₹41,300 | Geo: Maharashtra |
| 23 | Lowriston Retreat & Recreations Private Limited | ₹35,000 | 1.2% | 1 | 2025-11-21 | ₹41,300 | untagged |
| 24 | Indrones Solution Private Limited quiet 9mo | ₹35,000 | 1.2% | 1 | 2025-07-21 | ₹224,200 | Geo: Maharashtra |
| 25 | ADHAR BEVERAGES PRIVATE LIMITED | ₹35,000 | 1.2% | 1 | 2026-01-15 | ₹120,400 | Geo: Maharashtra |
| 26 | ATK Express quiet 9mo | ₹30,000 | 1.0% | 1 | 2025-07-08 | — | Geo: Maharashtra |
| 27 | Samson Freight Private Limited quiet 7mo | ₹20,000 | 0.7% | 1 | 2025-09-24 | — | Geo: Maharashtra |
| 28 | SATYA IRON & STEELS PRIVATE LIMITED quiet 7mo | ₹20,000 | 0.7% | 1 | 2025-09-24 | ₹23,600 | untagged |
| 29 | PK GLOBAL POWER PRIVATE LIMITED quiet 8mo | ₹20,000 | 0.7% | 1 | 2025-08-07 | ₹141,600 | untagged |
| 30 | Karyarthin Private Limited quiet 8mo | ₹20,000 | 0.7% | 1 | 2025-08-20 | — | Geo: Maharashtra |
| 31 | Acumen Consulting Services quiet 9mo | ₹20,000 | 0.7% | 1 | 2025-07-10 | — | Geo: Maharashtra |
| 32 | Xyron Technoloies Limited quiet 8mo | ₹15,000 | 0.5% | 1 | 2025-08-11 | ₹17,700 | Geo: Madhya Pradesh |
| 33 | Koshar Resources India Private Limited | ₹15,000 | 0.5% | 1 | 2025-11-29 | ₹88,200 | Geo: Maharashtra |
| 34 | KAPASI AND COMPANY | ₹15,000 | 0.5% | 1 | 2026-01-02 | — | Geo: Maharashtra |
| 35 | FINFAM PRIVATE LIMITED quiet 6mo | ₹10,500 | 0.4% | 1 | 2025-10-24 | ₹12,390 | Geo: Maharashtra |
Segment P&L matrix
Revenue per segment, shaded by net margin %. Red = losing, green = healthy. Driver-based allocation.
Each bar = a segment's revenue. Darker green = fatter margin. Amber = thin. Red = losing money.
| Geography | Customers | Revenue | % of firm | Operating Ex | EBITDA | EBITDA % | Net Margin | Net % | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Maharashtra
Strong margin (92%). Invest in scaling this segment.
|
25 | ₹2,109,000 | 550.7% |
₹176,239
revenue_pct
|
₹1,932,761 | 91.6% | ₹1,932,761 | 91.6% | |||||
|
Rajasthan
Strong margin (92%). Invest in scaling this segment.
|
1 | ₹450,000 | 117.5% |
₹37,604
revenue_pct
|
₹412,396 | 91.6% | ₹412,396 | 91.6% | |||||
|
Delhi
Strong margin (92%). Invest in scaling this segment.
|
2 | ₹129,500 | 33.8% |
₹10,822
revenue_pct
|
₹118,678 | 91.6% | ₹118,678 | 91.6% | |||||
|
Karnataka
Strong margin (92%). Invest in scaling this segment.
|
1 | ₹90,000 | 23.5% |
₹7,521
revenue_pct
|
₹82,479 | 91.6% | ₹82,479 | 91.6% | |||||
|
Punjab
Strong margin (92%). Invest in scaling this segment.
|
1 | ₹45,000 | 11.7% |
₹3,760
revenue_pct
|
₹41,240 | 91.6% | ₹41,240 | 91.6% | |||||
|
Madhya Pradesh
Strong margin (92%). Invest in scaling this segment.
|
1 | ₹15,000 | 3.9% |
₹1,253
revenue_pct
|
₹13,747 | 91.6% | ₹13,747 | 91.6% | |||||
| Untagged
Customers without a 'Geography' tag |
4 | ₹115,000 | 30.0% | Tag these customers to fold them into the matrix above. | |||||||||
Firm total
₹383,000
Revenue
Opex directly tagged
₹0
0.0% of opex
Opex allocated by revenue pct
₹237,200
Change driver via dropdown above
Margin waterfall — where every ₹100 of revenue lands
Subtotals in brand colour · green adds · red cuts · right column = % of revenue remaining
0%25%50%75%100%
Running ₹
%
Revenue
₹383,000
100.0%
Gross Profit
₹383,000
100.0%
(Less) Operating expenses
₹145,800
38.1%
EBITDA
₹145,800
38.1%
PBT (Profit Before Tax)
₹145,800
38.1%
PAT (Net Profit)
₹145,800
38.1%
Show numeric audit table
| Step | Amount | % of revenue | Running total | Running % |
|---|---|---|---|---|
| Revenue | ₹383,000 | ₹383,000 | 100.0% | |
| Gross Profit | ₹383,000 | ₹383,000 | 100.0% | |
| (Less) Operating expenses | −₹237,200 | -61.9% | ₹145,800 | 38.1% |
| EBITDA | ₹145,800 | ₹145,800 | 38.1% | |
| PBT (Profit Before Tax) | ₹145,800 | ₹145,800 | 38.1% | |
| PAT (Net Profit) | ₹145,800 | ₹145,800 | 38.1% |
Customers gone quiet (6+ months no invoice)
Former revenue that's now silent — reach out before they forget you
| Customer | Last-period revenue | Invoices | Last active | Months quiet |
|---|---|---|---|---|
| GOLDSTANDARD WEALTH PRIVATE LIMITED | ₹110,000 | 3 | 2025-06-16 | 10 |
| Mindcraft Software Private Limited | ₹70,000 | 1 | 2025-05-06 | 11 |
| KA Sports and Events | ₹60,000 | 1 | 2025-08-21 | 8 |
| NK SARRAF & ASSOCIATES | ₹52,000 | 2 | 2025-08-07 | 8 |
| CEID Consultants and Engineering Private Limited | ₹45,000 | 1 | 2025-04-03 | 12 |
| SITNEM TRADING & INVESTMENT PRIVATE LIMITED | ₹35,000 | 1 | 2025-10-24 | 6 |
| Indrones Solution Private Limited | ₹35,000 | 1 | 2025-07-21 | 9 |
| ATK Express | ₹30,000 | 1 | 2025-07-08 | 9 |
| Samson Freight Private Limited | ₹20,000 | 1 | 2025-09-24 | 7 |
| SATYA IRON & STEELS PRIVATE LIMITED | ₹20,000 | 1 | 2025-09-24 | 7 |
Total "quiet" revenue: ₹562,500 (146.9% of your revenue is from customers who've gone silent).
Drill-through — view a segment's details
Click any segment to see its filtered P&L, Working Capital, and Cash Flow
Maharashtra Working Capital
Rajasthan Working Capital
Delhi Working Capital
Karnataka Working Capital
Punjab Working Capital
Madhya Pradesh Working Capital
Per-segment P&L & CF drill-down will be wired into the existing P&L / CF pages during UI1 (the design-migration turn).