> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Total COGS, Oracle ERP Cloud

**Metrics type:** [Card](/nerve-centre/overview#metrics-types-explained)

## At a glance

> Total Cost of Goods Sold over the period, drawn from Oracle's COGS natural-account postings.

|                    |                                                             |
| ------------------ | ----------------------------------------------------------- |
| **What it counts** | `SUM(GL_JE_LINES posted to 5xxxx COGS accounts)` in window. |
| **Currency**       | Reporting ledger.                                           |
| **Time window**    | `30D vsP`                                                   |
| **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

30D COGS $94.8M vs revenue $124.2M = 76.3% COGS ratio (23.7% gross margin). Pair with [Gross Margin %](/nerve-centre/kpi-cards/oracle-erp/gross-margin-percentage).

## Sibling cards merchants should reference together

| Card                                                                              | Why pair                    |
| --------------------------------------------------------------------------------- | --------------------------- |
| [Gross Margin %](/nerve-centre/kpi-cards/oracle-erp/gross-margin-percentage)      | Margin from this.           |
| [Inventory Turnover](/nerve-centre/kpi-cards/oracle-erp/inventory-turnover-ratio) | This 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](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.