> ## 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, Microsoft Dynamics 365

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

## At a glance

> Total Cost of Goods Sold posted to G/L COGS accounts (5000 to 5099) over the period. Feeds margin calculation.

|                    |                                                                                          |
| ------------------ | ---------------------------------------------------------------------------------------- |
| **What it counts** | `SUM(G/L Entry.Amount)` for COGS accounts (5000-5099) in window, post-Adjust-Cost batch. |
| **Currency**       | Reporting Currency.                                                                      |
| **Time window**    | `30D vsP`                                                                                |
| **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: COGS $5.24M vs prior $4.94M (+6.1%). Revenue grew only 3.3%. COGS outpacing revenue indicates margin compression.

## Sibling cards merchants should reference together

| Card                                                                                           | Why pair         |
| ---------------------------------------------------------------------------------------------- | ---------------- |
| [Gross Margin %](/nerve-centre/kpi-cards/microsoft-dynamics/gross-margin-percentage)           | Headline.        |
| [Margin Erosion Alerts](/nerve-centre/kpi-cards/microsoft-dynamics/margin-erosion-alerts)      | SKU-level.       |
| [Average Landed Cost](/nerve-centre/kpi-cards/microsoft-dynamics/average-landed-cost-per-unit) | Cost-side trend. |

## Reconciling against the vendor's own dashboard

**Where to look in Business Central:**

> **Reports > Finance > Income Statement** (Cost of Goods Sold line)
> **G/L Register filtered to COGS accounts**

**Why may differ:**

| Reason                       | Direction | Why                                                         |
| ---------------------------- | --------- | ----------------------------------------------------------- |
| **Adjust Cost batch timing** | Small     |                                                             |
| **COGS account range**       | Either    | Card uses 5000-5099; merchants with custom charts configure |

**Cross-connector reconciliation:**

No commerce-side counterpart.

## Known limitations / merchant FAQs

**Includes inventory write-downs?**
No, those typically hit dedicated write-down accounts.

**Item Charges (freight, duty)?**
Included if allocated to Items via the Item Charge Assignment.

**Manufacturing variances?**
Excluded from this card; tracked separately on [Landed Cost Variance](/nerve-centre/kpi-cards/microsoft-dynamics/landed-cost-variance-vs-standard).

***

### Tracked live in Vortex IQ Nerve Centre

*Total COGS* is one of hundreds of KPI pulses Vortex IQ tracks across Microsoft Dynamics 365 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.