Margin Blindness: The Report Most Retailers Never See

Most retail owners run on the sales report. Daily sales per branch, maybe per category. It feels like control. But sales is only half of every transaction. The other half is what the item cost you, and if your system does not carry cost against every sale, you have margin blindness: steering by revenue and hoping the profit follows. Sometimes it does. Often it does not, and you find out at year end when the accountant delivers the news.

Two products, same sales, very different money

Take two SKUs that each did ₱100,000 in sales last month. Product A is a branded power tool: cost ₱88,000, margin ₱12,000. Product B is fasteners and consumables: cost ₱60,000, margin ₱40,000. On the sales report they look identical. In reality, B earned more than three times what A did. Now ask: which one gets the prime shelf? Which one does your purchaser fight to keep in stock? In a sales driven business, it is usually A, because big ticket items feel important. The margin report says otherwise. Now extend that across a few hundred SKUs and three branches. The gap between where your attention goes and where your profit comes from is usually the biggest free win available in an established retail business. No new customers required, no new branch. Just reallocating shelf space, stock, and push toward what actually earns.

What is the margin per product per branch report?

The report most retailers never see is simple to describe. For each product, at each branch, for each period: units sold, revenue, cost of those units, and the peso margin left over. Sortable. Comparable across branches and across months. To produce it, your system needs one discipline: every sale is recorded against a cost, and every delivery updates that cost. That is exactly what a proper inventory and sales system does automatically, and what a pile of spreadsheets almost never does, because nobody has time to marry the supplier invoices to the sales log by hand.

Which decisions does margin visibility change?

This is not a report you admire. It is a report you act on:

• Pricing. You find SKUs where a supplier price increase never made it into your selling price, and you have been quietly selling at a sliver of margin for months.
• Buying. You stop over ordering low margin items that merely look busy, and protect stock on the quiet SKUs that actually pay the rent.
• Branch strategy. The same SKU earning 28 percent in one branch and 12 percent in another is a question worth asking. Different suppliers? Unauthorized discounts? Local competition? Sometimes the answer is controlled branch level pricing.
• Promos. You discount from margin, not from feel, so a sale event moves dead stock instead of giving away your best earners.

Why you have never seen it

Not because it is advanced. Because it requires connected data. Sales in one file, purchases in another, and no per unit cost tracking in between means the report is technically possible and practically never produced. The businesses that have it are not smarter. Their systems simply record cost at the moment of sale, so the report is a query, not a project. If you cannot see margin per product per branch by tomorrow morning, that is not a reporting gap. It is a system gap, and it is fixable. Start smaller if you must: even margin per category per branch changes the weekly meeting. But per product is where the money is, because averages hide exactly the SKUs you need to see. A category can look healthy at 22 percent while its best seller quietly runs at 6 percent because of one unadjusted price. The average forgives. The detail collects.