> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Top Customers by Revenue, Microsoft Dynamics 365

**Metrics type:** [Card](/nerve-centre/overview#metrics-types-explained)

## At a glance

> Top 10 Customers by 90-day revenue. Concentration check. The classic Pareto lens for Sales conversation.

|                    |                                                                                                      |
| ------------------ | ---------------------------------------------------------------------------------------------------- |
| **What it counts** | `SUM(Sales Invoice Header.Amount)` grouped by Customer No. in 90D window, ranked descending, top 10. |
| **Tax treatment**  | Net of VAT.                                                                                          |
| **Currency**       | Reporting Currency.                                                                                  |
| **Time window**    | `90D`                                                                                                |
| **Alert trigger**  | `-`                                                                                                  |
| **Roles**          | owner, finance                                                                                       |

## Calculation

Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

## Worked example

US distributor on BC, 90D window 14 Jan to 13 Apr 26.

| Rank             | Customer                 | 90D Revenue (USD) | % of total |
| ---------------- | ------------------------ | ----------------- | ---------- |
| 1                | Acme Tech Distribution   | \$4,820,000       | 22%        |
| 2                | NorthEast Components Inc | \$2,140,000       | 10%        |
| 3                | TechHub Wholesale        | \$1,820,000       | 8%         |
| 4-10             | (other top customers)    | \$4,640,000       | 21%        |
| **Top 10 total** |                          | **\$13,420,000**  | **61%**    |

Top 10 = 61% of revenue. Top 1 = 22%. Concentration risk: losing Acme would create a 22% revenue hole. Treasury should ensure adequate facilities; sales team should diversify.

## Sibling cards merchants should reference together

| Card                                                                                                  | Why pair                               |
| ----------------------------------------------------------------------------------------------------- | -------------------------------------- |
| [Top B2B Accounts](/nerve-centre/kpi-cards/microsoft-dynamics/msd-top-b2b-accounts)                   | B2B-only ranked list.                  |
| [Active Customers](/nerve-centre/kpi-cards/microsoft-dynamics/msd-active-customers)                   | Total count denominator.               |
| [Customer Credit Utilisation](/nerve-centre/kpi-cards/microsoft-dynamics/customer-credit-utilisation) | Credit risk on top customers.          |
| [Customer Churn Signals](/nerve-centre/kpi-cards/microsoft-dynamics/customer-churn-signals)           | Early warning if a top customer slows. |

## Reconciling against the vendor's own dashboard

**Where to look in Business Central:**

> **Reports > Sales > Top 10 Customer List**
> **Power BI > Sales Insights > Top Customers tile**

**Why may differ:**

| Reason                        | Direction          | Why |
| ----------------------------- | ------------------ | --- |
| **OData freshness**           | Card 15 min behind |     |
| **Multi-Company aggregation** | Card sums          |     |

**Cross-connector reconciliation:**

For DTC, pair with [shopify.top\_customers](/nerve-centre/shopify/top_customers). Shopify's anonymous customers may not match BC.

## Known limitations / merchant FAQs

**Concentration threshold for risk?**
Top 1 > 20% = high single-customer risk. Top 10 > 70% = high concentration; diversify or hedge.

**Top 10 vs Top 25?**
Card defaults to 10. Configurable.

**Multi-Company: same customer in two Companies?**
Aggregated by Customer No. across Companies. If your tenant has duplicate Customer No. semantics, configure dedup in field map.

**Anonymous DTC customers?**
DTC customers without a BC Customer record (handled via "DTC Default" customer) bucketed together; can be excluded from concentration calc.

**Privacy Blocked customers?**
Shown as "\[Privacy Blocked]" per BC's privacy controls.

***

### Tracked live in Vortex IQ Nerve Centre

*Top Customers by Revenue* is one of hundreds of KPI pulses Vortex IQ tracks across Microsoft Dynamics 365 and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English.

[Start for free](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.