Back to Details

revenue-concentration

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Revenue Concentration Risk

收入集中度风险

Overview

概述

Measure how dependent your business is on a small number of clients. Calculates each client's revenue share, computes the Herfindahl-Hirschman Index (HHI), and flags dangerous concentration levels.
衡量企业对少量客户的依赖程度。计算每位客户的收入占比，测算赫芬达尔-赫希曼指数（HHI），并标记危险的集中度水平。

Wilson Tools Used

使用的Wilson工具

  • transaction_search
    — find all revenue transactions and group by client or source to calculate per-client totals
  • transaction_search
    — 查找所有收入交易并按客户或来源分组，计算每位客户的总收入

Workflow

工作流程

  1. Ask for the analysis period (recommend 12 months for accuracy).
  2. Use 
    transaction_search
    to find all incoming payments (positive amounts).
  3. Group by vendor/payee name to get per-client revenue totals.
  4. Calculate each client's revenue share as a percentage of total.
  5. Compute the Herfindahl-Hirschman Index: HHI = sum of (each client's market share percentage squared).
  6. Generate the report:
REVENUE CONCENTRATION — [Period]
═══════════════════════════════════════════════════
Client              Revenue     Share    Cumulative
───────────────────────────────────────────────────
Acme Corp           $48,000     40.0%      40.0%
Beta LLC            $30,000     25.0%      65.0%
Gamma Inc           $18,000     15.0%      80.0%
Delta Co            $12,000     10.0%      90.0%
Other (3 clients)   $12,000     10.0%     100.0%
───────────────────────────────────────────────────
Total Revenue      $120,000    100.0%

Herfindahl Index (HHI):  2,550
Concentration Level:     HIGH
Top Client Dependency:   40.0%

Risk Assessment:
  - Losing Acme Corp would eliminate 40% of revenue
  - Top 2 clients = 65% of revenue
  - Top 3 clients = 80% of revenue
═══════════════════════════════════════════════════
  1. Interpret HHI:
    • Under 1,500: Low concentration (diversified)
    • 1,500-2,500: Moderate concentration
    • Over 2,500: High concentration (risky)
  2. Flag any single client above 25% as a key-person risk.
  3. Recommend target: no single client above 20%, top 3 clients below 50%.
  1. 询问分析周期（建议12个月以保证准确性）。
  2. 使用
    transaction_search
    查找所有入账款项（金额为正）。
  3. 按供应商/付款方名称分组，获取每位客户的总收入。
  4. 计算每位客户的收入占比，即其收入占总收入的百分比。
  5. 计算赫芬达尔-赫希曼指数：HHI = 每位客户市场份额百分比的平方之和。
  6. 生成报告：
REVENUE CONCENTRATION — [Period]
═══════════════════════════════════════════════════
Client              Revenue     Share    Cumulative
───────────────────────────────────────────────────
Acme Corp           $48,000     40.0%      40.0%
Beta LLC            $30,000     25.0%      65.0%
Gamma Inc           $18,000     15.0%      80.0%
Delta Co            $12,000     10.0%      90.0%
Other (3 clients)   $12,000     10.0%     100.0%
───────────────────────────────────────────────────
Total Revenue      $120,000    100.0%

Herfindahl Index (HHI):  2,550
Concentration Level:     HIGH
Top Client Dependency:   40.0%

Risk Assessment:
  - Losing Acme Corp would eliminate 40% of revenue
  - Top 2 clients = 65% of revenue
  - Top 3 clients = 80% of revenue
═══════════════════════════════════════════════════
  1. HHI指数解读：
    • 低于1500：低集中度（多元化）
    • 1500-2500：中等集中度
    • 超过2500：高集中度（存在风险）
  2. 将任何收入占比超过25%的单个客户标记为关键风险点。
  3. 建议目标：单个客户收入占比不超过20%，前三大客户收入占比低于50%。

Without Wilson

未使用Wilson的操作流程

  1. Export bank transactions as CSV for the past 12 months.
  2. Filter to income only (positive amounts in most bank exports).
  3. Add a "Client" column and tag each deposit with the source client.
  4. Pivot table: Rows = Client, Values = Sum of Amount. Sort descending.
  5. Revenue Share: 
    =ClientRevenue/TotalRevenue*100
    .
  6. HHI: In a new column, square each share: 
    =Share^2
    . Then 
    =SUM(SquaredShares)
    .
  7. For cumulative share, use 
    =SUM($B$2:B2)/TotalRevenue*100
    (assuming column B is revenue, sorted descending).
  8. The U.S. DOJ uses HHI for antitrust analysis with the same thresholds: under 1,500 = unconcentrated, 1,500-2,500 = moderate, over 2,500 = highly concentrated. The same logic applies to your revenue risk.
  1. 将过去12个月的银行交易导出为CSV文件。
  2. 筛选仅保留收入项（大多数银行导出中金额为正的记录）。
  3. 添加“客户”列，并为每笔存款标记来源客户。
  4. 创建数据透视表：行 = 客户，值 = 金额总和。按降序排序。
  5. 收入占比：
    =客户收入/总收入*100
    。
  6. HHI指数：在新列中计算每个占比的平方：
    =占比^2
    ，然后
    =SUM(平方后的占比)
    。
  7. 累计占比：使用
    =SUM($B$2:B2)/总收入*100
    （假设B列为收入，已按降序排序）。
  8. 美国司法部将HHI用于反垄断分析，采用相同阈值：低于1500 = 非集中，1500-2500 = 中等集中，超过2500 = 高度集中。该逻辑同样适用于收入风险评估。

Important Notes

重要说明

  • A perfectly equal distribution across 4 clients gives an HHI of 2,500 (still moderate). You need 7+ roughly equal clients to reach "low concentration."
  • Revenue concentration is not inherently bad if the top clients are contractually committed (annual contracts, retainers). The risk is losing a major client with no notice.
  • Track this quarterly. If a single client's share is growing, actively invest in diversifying your revenue base.
  • Consider both revenue concentration and profit concentration. A client generating 40% of revenue but 60% of profit is an even bigger risk.
  • 4个客户完全平均分配收入时，HHI指数为2500（仍属于中等集中度）。需要7个及以上收入大致相当的客户才能达到“低集中度”。
  • 如果顶级客户有合同承诺（年度合同、预付费），收入集中度本身并非坏事。风险在于无预警地失去重要客户。
  • 每季度跟踪该指标。如果单个客户的收入占比持续增长，需积极投入资源实现收入来源多元化。
  • 同时考虑收入集中度和利润集中度。某客户贡献40%收入但60%利润的话，风险会更大。