At a glance
| What it counts | Per-SKU (Revenue - COGS) / Revenue for the period. Lists Bottom 20 by margin and Top 20. |
| Tax treatment | Net of VAT. |
| Currency | Reporting Currency. |
| Time window | 30D |
| Alert trigger | any below break-even |
| 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, 30D 14 Mar to 12 Apr 26. Bottom 5 by margin:| SKU | Revenue | Margin% |
|---|---|---|
| ELEC-LAPTOP-A14 | $1.84M | 16% |
| ELEC-MONITOR-27 | $620K | 22% |
| ELEC-DOCK-USB4 | $480K | 24% |
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Gross Margin % | Headline. |
| Margin Erosion Alerts | Worst movers. |
| Top SKUs by Inventory Value | Where margin lives. |
Reconciling against the vendor’s own dashboard
Where to look in Business Central:Item Card > Statistics > Profit % Reports > Sales > Sales Statistics by ItemWhy may differ:
| Reason | Direction | Why |
|---|---|---|
| Adjust Cost batch timing | Small |