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% |
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Revenue Booked into GL | The total. |
| Companies List | Master list. |
| FX Currency Exposure | Currency mix. |
| Intercompany Balance | Elimination context. |
| Company Performance | 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 timeWhy 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 |