Revenue minus COGS over revenue. The single best margin-health number for the executive view.
At a glance
Gross Margin Percentage = (Revenue minus COGS) divided by Revenue, expressed as a percentage. The single best margin-health number for the Fortune 500 executive view. Calculated from Oracle ERP Cloud’s GL revenue and COGS posting.
| What it counts | (SUM(revenue_accounts) - SUM(cogs_accounts)) / SUM(revenue_accounts) × 100, where revenue accounts are the 4xxxx natural-account range and COGS are the 5xxxx range in the Fortune 500 standard COA. |
| Tax treatment | Net of tax on both sides. |
| Shipping | Configurable. If freight income posts to revenue and freight cost posts to COGS, both sides cancel out and margin is unaffected. If freight income posts to revenue but freight cost posts to expense, margin is overstated. The card respects the COA mapping. |
| Discounts | Already deducted at the line level, both sides. |
| Refunds | Credit Memos subtract from revenue; reversed COGS subtracts from COGS. Net margin impact is the original margin reversed. |
| Cancelled orders | Excluded from both sides. |
| Currency | Multi-Ledger: reporting ledger consolidated. |
| Business Unit scope | Respects dashboard filter. |
| Time window | 30D vsP |
| Alert trigger | drop >2pp vsP, sentiment margin |
| Roles | owner, finance |
Calculation
Calculated automatically from your Oracle ERP Cloud data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US Fortune 500 consumer-electronics distributor on Oracle ERP Cloud. 30-day window 14 Mar 26 to 12 Apr 26.| Component | This period | Prior period | Delta |
|---|---|---|---|
| Revenue (GL booked, net of tax) | $124,200,000 | $128,400,000 | -$4,200,000 |
| COGS (5xxxx natural accounts) | $94,800,000 | $96,400,000 | -$1,600,000 |
| Gross Profit | $29,400,000 | $32,000,000 | -$2,600,000 |
| Gross Margin % | 23.7% | 24.9% | -1.2pp |
- Gross Margin dropped 1.2 percentage points vsP, from 24.9% to 23.7%. Below the 2pp alert threshold so no Nerve Centre fire, but trending in the wrong direction.
- Both revenue and COGS fell, but COGS fell less. Revenue down 3.3%, COGS down 1.7%. The squeeze is on the cost side: input costs rising faster than passthrough pricing.
- Drill into Margin by SKU: likely 10 to 20 SKUs are pulling the average down. They might be commodity items where pricing competition is forcing margin compression.
- Cross-reference Margin Erosion Alerts: which specific items have lost the most margin. Often a vendor price increase that has not been passed through to customer pricing.
- Industry benchmark: consumer electronics distribution typically runs 18-25% gross margin. 23.7% is in the healthy band but the trend matters more than the absolute. A 1.2pp slide that becomes 3pp over the next quarter is the warning that turns into the SEC-filing footnote.
Sibling cards merchants should reference together
| Card | Why pair it with Gross Margin Percentage |
|---|---|
| Margin by SKU | Per-SKU margin distribution; identifies the bleeders. |
| Margin Erosion Alerts | The actionable subset; SKUs where margin compressed materially. |
| Total COGS | The denominator’s negative driver. |
| Revenue Booked into GL | The revenue side of the calculation. |
| Margin Compression | Threshold-based alert built on this card. |
| Landed Cost Variance vs Standard | Why COGS is moving, on the input-cost side. |
| Average Landed Cost per Unit | Per-unit cost trend feeding margin. |
Reconciling against the vendor’s own dashboard
Where to look in Oracle ERP Cloud:Reports and Analytics → OTBI → General Ledger Real Time Subject Area with calculated Gross Margin column Financial Reporting Center → Income Statement (Gross Profit line / Revenue line) Oracle Analytics Cloud (OAC) → Financial Performance DashboardOAC ships a pre-built Gross Margin tile for Fortune 500 customers; matches this card directly. Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Account range | Either | Card uses 4xxxx revenue, 5xxxx COGS by default. Custom COAs may use different ranges. |
| Service revenue mixed in | Either | If service revenue posts to a 4xxxx account but has no COGS counterpart (because labour cost hits a different range), margin can be overstated. |
| RMCS deferred revenue | Either | If revenue is deferred but COGS already booked, period margin compresses temporarily. |
| Standard cost variances | Either | Manufacturing-module variance accounts may post to COGS depending on SLA rules. |
| Period close timing | Either | COGS posting via Cost Management’s Create Accounting program runs on a schedule. Mid-period the COGS is incomplete. |
Known limitations / merchant FAQs
Healthy benchmark by vertical?- Fashion / apparel retail: 50 to 65%
- Electronics distribution: 18 to 25%
- Industrial B2B distribution: 22 to 32%
- Furniture / home goods: 38 to 50%
- Grocery / consumables: 25 to 35%
- SaaS / software: 70 to 85% The right benchmark for your business is your own trailing 12-month average. The trend matters more than the absolute.
transaction lines tagged to COGS accounts. Vortex IQ normalises across all three; Fortune 500 customers running cross-ERP comparisons (often during M&A integration) keep continuous margin reporting.