Skip to content

Margin Watch

Margin Watch answers an uncomfortable question: which of your live records are billing below what they cost you? It compares retail against carrier cost across the base and flags everything that is losing money, costing an unknown amount, or sitting below your margin floor.

It needs the CRM module and access to the carrier charge fields, because it exposes buy prices.

  • Find records that have drifted below cost after a carrier price rise
  • Find records whose cost is unknown, so you cannot tell whether they are profitable
  • Check the base against a target margin before a price review
  • Quantify the total profit leak

A mode filter chooses what “margin” means:

  • Configured - live active features priced as they are set up now, comparing the retail price against the recorded carrier cost. Use this to check your pricing.
  • Billed - the transactions actually generated in a date range, comparing what you billed against what it cost. Use this to check what really happened.

Configured mode answers “is our pricing right?”; billed mode answers “did we actually make money?” They can differ, which is usually the interesting part.

ColumnMeaning
RecordsHow many records are covered
RevenueRetail value
CostCarrier cost
MarginRevenue less cost
Margin %Margin as a share of revenue
Below Cost RecordsRecords priced below what they cost
Missing Cost RecordsRecords with no recorded carrier cost
Below Floor RecordsRecords under your configured margin floor
Profit LeakThe money the flagged records are costing you

Important: a record with no recorded carrier cost is counted as missing, never as free. Treating an unknown cost as zero would make a loss-making record look like pure profit, so the report separates the two and asks you to fill the gap.

The margin floor comes from the Margin Watch Floor (%) setting under the CRM module.

For general guidance, see Using Reports. Alongside the mode filter, the report takes the common customer filters and a date range for billed mode.