> ## 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.

# Revenue by Company, Microsoft Dynamics 365

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

> Revenue split across Business Central companys. Available only when Multi-Company is enabled.

## At a glance

> Revenue Booked into GL split across BC Companies. Available only on multi-Company tenants. Identifies which Company concentrates revenue and which is dragging.

|                    |                                                                                                                                                                           |
| ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **What it counts** | `SUM(G/L Entry.Amount)` for revenue accounts, grouped by `Company Name`. Each row: Company, Local Currency revenue, Reporting Currency equivalent, % of total, vsP delta. |
| **Tax treatment**  | Net of VAT.                                                                                                                                                               |
| **Currency**       | Both Local and Reporting Currency shown.                                                                                                                                  |
| **Time window**    | `30D`                                                                                                                                                                     |
| **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

UK apparel parent + US + EU Companies, 30D window 14 Mar to 12 Apr 26.

| Company                        | Local revenue | GBP equivalent | % of total | vsP  |
| ------------------------------ | ------------- | -------------- | ---------- | ---- |
| UK Apparel Ltd                 | £2,640,000    | £2,640,000     | 54%        | +6%  |
| US Apparel Inc                 | \$1,820,000   | £1,423,240     | 29%        | -4%  |
| EU DTC BV                      | €1,140,000    | £973,560       | 20%        | +12% |
| Less: intercompany elimination | -£148,000     | -£148,000      | -3%        | n/a  |
| **Total**                      |               | **£4,888,800** | 100%       | +3%  |

EU growing 12% (online expansion), US contracting 4% (tariff impact). UK steady. Eliminations stay around 3% of consolidated. Power BI's standard pack cannot consolidate this in one tile.

## Sibling cards merchants should reference together

| Card                                                                                           | Why pair             |
| ---------------------------------------------------------------------------------------------- | -------------------- |
| [Revenue Booked into GL](/nerve-centre/kpi-cards/microsoft-dynamics/revenue-booked-into-gl)    | The total.           |
| [Companies List](/nerve-centre/kpi-cards/microsoft-dynamics/msd-subsidiaries-list)             | Master list.         |
| [FX Currency Exposure](/nerve-centre/kpi-cards/microsoft-dynamics/fx-currency-exposure)        | Currency mix.        |
| [Intercompany Balance](/nerve-centre/kpi-cards/microsoft-dynamics/msd-intercompany-balance)    | Elimination context. |
| [Company Performance](/nerve-centre/kpi-cards/microsoft-dynamics/msd-agency-subsidiary-health) | Health roll-up.      |

## Reconciling against the vendor's own dashboard

**Where to look in Business Central:**

> Per Company: **Reports > Finance > Income Statement** (Local Currency)
> Consolidation Company: **Reports > Finance > Consolidated Trial Balance**
> Power BI: one Company at a time

**Why may differ:**

| Reason              | Direction          | Why                                                  |
| ------------------- | ------------------ | ---------------------------------------------------- |
| **FX cadence**      | Small              | Card uses period-average; reports may use period-end |
| **Eliminations**    | Either             | Card applies if Consolidation Company selected       |
| **OData freshness** | Card 15 min behind |                                                      |

**Cross-connector reconciliation:**

Per-Company commerce revenue (Shopify, BigCommerce) compared against this card identifies Company-level gap concentration.

## Known limitations / merchant FAQs

**Single-Company tenants?**
Card hides automatically; nothing to slice.

**Inter-Company eliminations: visible per-Company?**
Yes via the elimination Company row.

**Power BI cannot do this?**
Standard content pack: one Company at a time. Multi-Company consolidation needs custom DAX or Premium roll-up.

**Currency consolidation: which rate?**
Period-average via Adjust Exchange Rates by default; configurable to period-end.

**Common Data Service / Dataverse: does it affect Company assignment?**
No. Companies are defined in BC's tenant database, not via CDS. CDS is the Customer/Item master sync, separate from financial Company structure.

***

### Tracked live in Vortex IQ Nerve Centre

*Revenue by Company* 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.