KPI Tree

Xero Metric

Accounting

Gross Profit Margin = (Revenue − COGS) / Revenue

Gross profit margin is the percentage of revenue left after subtracting the cost of goods sold. It shows how efficiently your business produces and delivers what it sells.

Full guide: definition, formula, and benchmarks
XeroAccounting

Gross Profit Margin

Gross profit margin is the percentage of revenue left after subtracting the cost of goods sold. It shows how efficiently your business produces and delivers what it sells.

How to calculate gross profit margin

Gross Profit Margin = (Revenue − COGS) / Revenue

Why gross profit margin matters for Xero users

Gross profit margin is the ceiling for every downstream profitability metric. A compressing margin signals rising input costs, pricing pressure, or a shift in product mix towards lower-margin lines, any of which will eventually squeeze operating profit and cash flow.

For Xero users, tracking gross margin by tracking category or product line reveals exactly which parts of the business are earning their keep and which are dragging the overall number down.

Understand and act on gross profit margin with KPI Tree

Query the Xero MCP profit and loss report or sync Xero revenue and cost of goods sold accounts into your warehouse and let KPI Tree calculate gross profit margin from the mapped accounts. Decompose the metric into revenue and COGS drivers, then further into product lines or tracking categories.

Assign ownership to your commercial lead and set alerts when margin deviates from its statistical baseline for two consecutive periods.

Get started with your Xero data

Query using MCP
MCP

Pull metrics from Xero directly through the Model Context Protocol.

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Xero data already lands.

Professional Services
FivetranSnowflakedbt

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

Empower your team to understand and act on Xero data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business