Skip to main content
Card class: Card

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 countsSUM(G/L Entry.Amount) for COGS accounts (5000-5099) in window, post-Adjust-Cost batch.
CurrencyReporting Currency.
Time window30D vsP
Rolesowner, 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.24Mvsprior5.24M vs prior 4.94M (+6.1%). Revenue grew only 3.3%. COGS outpacing revenue indicates margin compression.

Sibling cards merchants should reference together

CardWhy pair
Gross Margin %Headline.
Margin Erosion AlertsSKU-level.
Average Landed CostCost-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:
ReasonDirectionWhy
Adjust Cost batch timingSmall
COGS account rangeEitherCard 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.

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 or book a demo to see this metric running on your own data.