Revenue split by transaction currency. Highlights FX exposure for multi-currency accounts.
At a glance
Revenue split by transaction Currency Code. Highlights FX exposure on multi-currency Companies.
| What it counts | SUM(G/L Entry.Amount LCY) grouped by Currency Code from the originating Sales Invoice / Cash Receipt. |
| Tax treatment | Net of VAT. |
| Currency | Both transaction-currency total and Reporting Currency equivalent 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 on BC, 30D window 14 Mar to 12 Apr 26. Reporting currency GBP.| Currency | Revenue (transaction) | GBP equivalent | % of total |
|---|---|---|---|
| GBP | £2,640,000 | £2,640,000 | 54% |
| USD | $1,820,000 | £1,423,240 | 29% |
| EUR | €1,140,000 | £973,560 | 20% |
| AUD | A$420,000 | £218,400 | 4% |
| Less: elimination | (£366,400) | (£366,400) | -7% |
| Total | £4,888,800 | 100% |
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| FX Currency Exposure | Balance-sheet FX exposure. |
| Revenue by Company | Different cut. |
| Revenue Booked into GL | Total. |
| Intercompany Balance | Inter-company FX. |
Reconciling against the vendor’s own dashboard
Where to look in Business Central:Reports > Finance > Currency-wise Trial Balance Currency Exchange Rate table for rates used Adjust Exchange Rates batch log for revaluation historyWhy may differ:
| Reason | Direction | Why |
|---|---|---|
| FX cadence | Small | Card period-average; some BC reports period-end |
| OData freshness | Card 15 min behind |