The Margin Nobody Was Watching
Revenue is on every dashboard; margin is a division somebody does at month end. A supplier raises a price, the shelf price stays where it was, and three weeks of sales go out thin before anyone notices. How the margin-drop alert watches each item for you, and what it deliberately leaves alone.
In the second week of the month a distributor raised the price of 20-litre cooking oil. The new delivery was received, the moving-average cost rose with it, and the price on the till did not move. Sales of the item were up, so nobody looked twice. The month-end figures showed the margin on it had halved. The information was in the system the whole time; nobody was dividing one number by another every morning.
That is the trouble with margin. Sales reports show revenue, and revenue going up feels like good news. A margin only appears when someone takes revenue and cost for the same item over the same period and works out the difference, and in most small and mid-sized businesses that happens once a month, after the money has gone. The margin-drop alert does that sum every day, item by item, and tells the people who look after the accounts when one has moved.
What it measures
For each item, over a window of 30 days by default, the check adds up what it sold for and what it cost, and works out the realised gross margin: revenue less cost, as a share of revenue. Two sources count as sales.
- POS sales. Each line carries the cost the item had when it was sold, and that is the cost used. Where a line has no cost recorded, the item’s moving-average cost is used instead.
- Issued customer invoices. Invoice lines are costed at the item’s moving-average cost. Draft, cancelled and void invoices do not count.
When the alert says a cost moved and you want to know who moved it, from what and why, that is the valuation audit trail described in the cost that changed on a Tuesday. The alert tells you which item to look at; the trail tells you what happened to it.
Two ways to trip it
| Test | Default | What it catches |
|---|---|---|
| Below the floor | Margin under 15% | An item that has always been thin, or a price that never caught up with a cost increase |
| A sharp drop | More than 10 points below the previous window | A healthy item that has fallen fast, even while it is still above the floor |
Cooking oil, 20 litres, two 30-day windows
Illustrative figures. A phone charger that slid from 41% to 29% would pass the floor test comfortably and still be flagged by the drop test: twelve points is a change worth a question, whatever the level.
The noise it refuses to make
A margin alert that fires about everything is one nobody reads by the second week. Three rules keep it quiet.
- A minimum revenue. An item has to have sold at least 1,000 in your base currency in the window to be judged. Two units of a slow line can swing from 40% to 5% on one discounted sale, and that is not news. The drop test only compares against a previous window that also cleared the minimum.
- Once per item per window. When an item is flagged it is not flagged again every morning while the margin stays low. It comes back in the next window if the problem is still there.
- Only the people who can see the accounts. The alert goes through My alerts, and only to people with permission to view the accounts, by email, push or text as each of them chose. A text carries the count of items, never the item names or the margins.
Revenue going up feels like good news. It is only good news if you know what it cost.
What it leaves out, and why
Some sales would produce a margin figure that looks precise and means nothing. The check leaves them out rather than report them wrongly.
- Service items. Their cost is optional, so a service with no cost recorded would show a margin of 100%. That is an unknown, not a margin.
- Consignment and customer-owned stock. It is not valued in your books, so there is no cost of yours to set against the sale.
- Items with no cost at all. Same reason.
- Sales in a currency other than your base currency. Cost is held in the base currency. A dollar invoice for an item costed in shillings would need an exchange rate to compare, so it is not compared, rather than compared at a rate nobody chose.
Setting the thresholds
The floor, the drop, the window and the minimum revenue are set for the whole workspace on the My alerts page, by the people who can manage settings. A hardware business with naturally thin margins on cement might lower the floor; a pharmacy might raise it. Change them once, deliberately, and leave them alone long enough to learn what normal looks like.
What AWRA OpsHub does today
- Realised margin per item over a window, from POS lines and issued customer invoices.
- POS lines costed at the cost stamped on the line, or at moving-average cost where none was stamped, and invoice lines at moving-average cost.
- Two tests: below a floor, 15% by default, or more than 10 points down on the previous window.
- A 30-day window and a minimum revenue of 1,000 by default, changed by people who can manage settings.
- One alert per item per window, delivered through My alerts by email, push or text to people who can view the accounts.
- Service items, consignment and customer-owned stock, items with no cost and sales outside the base currency kept out of the calculation.
More we can add to your workspace
- Margin alerts by product category and by branch, for a range or a shop rather than a single item.
- Margin across currencies, converting sales in other currencies at a stated rate before comparing.
- Supplier price-change attribution, naming the receipt and the supplier price that moved an item’s cost.
Where we point you to a specialist
- We will not set your prices. The alert tells you a margin has moved; whether to reprice, go back to the supplier or accept a thinner margin on an item that brings customers in is a commercial decision that stays with you.
Category and branch alerts reuse the per-item calculation the margin check already runs.
Margin alerts at more levels
The check works item by item today. Three extensions come up most often from finance teams that rely on it.
Category and branch margins
The same floor and drop tests on a product range or a single shop.
Margin across currencies
Sales in other currencies converted at a stated rate and included.
Supplier price changes
The receipt and supplier price that moved the cost, named on the alert.
Before you trust the first alert
Do your fast-moving items all carry a cost?
Look for
Older items created without a purchase price.
Then
Those are left out. Receive or set a cost so they are watched.
Who can view the accounts in your workspace?
Look for
Finance, the owner, perhaps a branch manager.
Then
Only they can receive the alert. Check the role before relying on it.
What margin is normal for your trade?
Look for
Thin on staples, wide on accessories.
Then
Set the floor for your trade, not for the default.
How much of your trade is invoiced in dollars?
Look for
Export customers, NGO contracts.
Then
Those sales are not compared; watch them in the Sales by Item report.
Our position
Margin should be watched daily and per item, and most businesses watch it monthly and in total. Let the system do the division, flag an item when it is low or falling fast, ignore items too small to matter, and leave out sales where the figure would be invented. Then spend the human attention on the handful of items it names.
Watch every item’s margin
Switch on margin-drop alerts in My alerts, set a floor that fits your trade, and let the daily check name the items that moved.
Talk to us about marginFrequently asked questions
How does AWRA OpsHub calculate an item’s margin for the alert?
It adds up revenue and cost for the item over a window, 30 days by default, from POS sales and issued customer invoices. POS lines use the cost recorded on the line, or the moving-average cost where none was recorded; invoice lines use the moving-average cost.
When does a margin-drop alert fire?
When an item’s margin over the window is below the floor, 15% by default, or more than 10 points lower than in the previous window. Each item is flagged at most once per window.
Why was an item with a low margin not flagged?
It may have sold less than the minimum revenue, 1,000 in your base currency by default. Service items, consignment and customer-owned stock, items with no cost and sales in other currencies are also left out.
Who can change the margin thresholds?
People with permission to manage settings, on the My alerts page. The floor, the drop, the window and the minimum revenue apply to the whole workspace.
Who receives margin-drop alerts?
Only people who can view the accounts, by email, push or text message as each of them chose in My alerts.
