Skip to main content
Card class: Card

At a glance

Total Cost of Goods Sold over the period, drawn from Oracle’s COGS natural-account postings.
What it countsSUM(GL_JE_LINES posted to 5xxxx COGS accounts) in window.
CurrencyReporting ledger.
Time window30D vsP
Rolesowner, 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

30D COGS 94.8Mvsrevenue94.8M vs revenue 124.2M = 76.3% COGS ratio (23.7% gross margin). Pair with Gross Margin %.

Sibling cards merchants should reference together

CardWhy pair
Gross Margin %Margin from this.
Inventory TurnoverThis card is the numerator.

Reconciling against the vendor’s own dashboard

Where to look in Oracle ERP Cloud:
Income Statement Cost of Sales line OTBI → GL Real Time filter COGS accounts
Cross-connector reconciliation: Internal Oracle metric.

Known limitations / merchant FAQs

Includes freight cost? Configurable per COA mapping. SLA variance to COGS? Configurable per implementation.

Tracked live in Vortex IQ Nerve Centre

Total COGS is one of hundreds of KPI pulses Vortex IQ tracks across Oracle ERP Cloud 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 or book a demo to see this metric running on your own data.