Retail margin management software answers a question the price list cannot: what did this item, this category, this supplier, this channel or this store actually earn once everything that eroded the margin is counted. It starts from what was sold at what price, subtracts the cost of the units that sold, and then applies the erosions, discounts, returns, shrink, cost increases, channel fees and any offsetting rebates, so the gap between planned and actual margin is visible and attributable. With Pentoggle, a retailer can describe how their margin actually leaks and generate the starting application around it.
This page is about margin after erosion. Sales and basic margin reporting are Retail Sales Analytics Software. Setting the price is Retail Pricing Management Software. The cost of stock sold comes from Retail Inventory Management Software. The erosions have their own pages: Retail Promotion and Discount Management Software, Retail Returns Management Software, Retail Loss Prevention Software, and Marketplace Order and Payment Management Software.
How cost of goods should be calculated, which cost method applies, how inventory is valued and how rebates and fees are treated in the accounts, differ by place and by the choices made with your accountant. This page describes an operational view and states none of that. The application applies the method your accountant has set; it does not choose it.
Most retailers already run an accounting system such as QuickBooks, Tally or Xero, which produces gross margin at the level the accounts require. That stays where it is. What is often still managed outside it is margin at the level decisions are made: which items, which suppliers, which channels, and why the number came out lower than the plan.
Key takeaways
- Planned margin and actual margin differ for reasons that can each be measured: discounts, returns, shrink, cost changes and channel fees. A single gross margin figure blends all of them and explains none.
- Cost has to be the cost of the units that sold, not a standard cost or the latest purchase price, or the margin is a story about assumptions rather than about the month.
- Erosions belong where they happened. A markdown belongs to the item; a channel fee belongs to the channel; shrink belongs to the store and the category. Spreading them evenly hides which decision caused them.
- Supplier rebates and promotional support are part of margin, and they are often forgotten because they arrive later and separately from the sales they relate to.
- A useful number is the gap between planned and actual margin by category, with the gap broken down by cause.
The spreadsheet is often not the problem
An owner who knows the mark-up on each range, watches the discount column and reads the accountant's gross margin each quarter has a working sense of what the store earns, and for a small store with stable costs and few channels it serves well.
The trouble starts at identifiable points.
When the cost is the last invoice
Margin is calculated on the current cost, but the units sold this month were bought at last quarter's price. The figure is right for next month and wrong for this one.
When discounts are a total
The month's discounts are known as one number. Which items carried them, which were planned promotions and which were manual, and which categories are now earning less than they were priced to earn, is not.
When shrink appears once a year
Stock loss is discovered at the annual count and taken as a single hit. It came from specific categories in specific stores over twelve months, and the margin reports for those months overstated what they earned.
When channels are treated alike
The same item sells in the store, on the website and on a marketplace. The sale price is similar; what remains after fees and returns is not. Margin by product is quoted without the channel, and the channel that earns least is the one growing fastest.
What margin management software holds
Sales at price achieved
Every unit sold, by item, channel and store, at the price actually paid, drawn from the POS and other channels.
Cost of units sold
The cost carried on the stock that sold, on the method your accountant has set, so cost matches the sale it relates to.
Planned margin
The margin the price list implied for each item at the time of sale, as the reference.
Erosions attributed
Discounts and markdowns by item and reason, returns and their outcome, shrink and write-offs by store and category, and cost variances against the agreed cost, each placed where it happened.
Channel costs
Marketplace fees, payment processing costs, shipping and fulfilment costs where they can be attributed, by channel.
Supplier rebates and support
Volume rebates, promotional funding, price protection and other supplier contributions, matched to the periods and items they relate to.
Margin views
Actual margin by item, category, supplier, channel and store, against planned, with the gap by cause.
Movers
Items and categories whose margin changed most against the previous period, and why.
Planned margin and actual margin
Every item carries a planned margin: the difference between the price it is listed at and the cost it was bought at. It is a real number and it is not what the store earned.
Between the plan and the outcome sit the erosions. Some units sold at a discount. Some sold and came back. Some left the store without being sold at all. Some were bought at a cost above the one the price was set against. Some sold through a channel that took a fee. And some of the erosion was offset by a rebate or promotional support that arrived from the supplier later.
Actual margin is the plan after all of that. The point of calculating it this way, rather than as a single gross figure, is that each erosion can be named and sized. A category earning less than planned because of returns is a different problem from one earning less because of markdowns, and the response is different in each case. A single margin percentage cannot say which.
The reference for planned margin should be what the price list said at the time of each sale, not what it says now, so that a price change during the month does not distort the comparison.
Cost has to be the cost of what sold
The largest single source of wrong margin figures in retail is using the wrong cost.
Using the latest purchase price applies this month's cost to units bought earlier at a different one. Using a standard cost set once a year applies a figure that may have drifted from every actual invoice since. Both produce a margin that is internally consistent and does not describe the month.
The cost that belongs against a sale is the cost carried on the stock that sold, which is the record described on Retail Inventory Management Software. How that cost is assigned when the same item was bought at several prices, whether by average, by first-in-first-out or by another method, is a choice to make with your accountant and apply consistently. The application applies it; it does not decide it.
Cost variance is worth separating out. Where the invoiced cost exceeded the agreed cost, as caught by the match on Retail Vendor Payment Software, the margin loss is attributable to a supplier rather than to a selling decision, and it belongs in the supplier's column rather than the item's.
Erosions belong where they happened
An erosion spread across the business as a percentage hides the decision that caused it. Attributed to its source, it becomes something a person can act on.
A markdown belongs to the item it was taken on, and to the reason: a planned promotion, a clearance, a manual discount at the counter. The three are different decisions by different people.
A return belongs to the item and to its outcome. A return that went back to sellable stock cost a transaction; one that was written off cost its full value; the margin effect is not the same.
Shrink belongs to the store and the category where the count found it, in the period it was found. Taking it once a year as one number, or spreading it evenly across everything, removes the information the count produced. Frequent cycle counts, as described on Retail Inventory Audit Software, are what make monthly attribution possible.
Channel fees belong to the channel. Marketplace commissions, payment processing costs and the cost of fulfilling online orders sit against the sales that incurred them, so that margin by channel is a real comparison. An item can earn a healthy margin in the store and a thin one on a marketplace at the same price, and that fact decides where the business should push volume.
Supplier rebates and promotional support belong to the periods and items they relate to, which is harder than it sounds because they usually arrive later, separately, and as a lump. Holding the agreement, tracking what has been earned, and matching the receipt back to the sales it relates to turns a pleasant surprise in the accounts into a margin the buyer can plan on.
Where margin looks different by business type
- Fashion Retail Software, where the planned margin at full price and the actual margin after the season's markdowns are two very different numbers.
- Grocery Store Software, where margins are thin, shrink and date write-offs are constant, and supplier promotional funding is a material part of what the store earns.
- Electronics Retail Software, where price protection, manufacturer rebates and attachment sales change the margin on a unit well after it was sold.
- D2C Brand Software, where margin by channel after fees, shipping and returns decides which channels to grow.
- Wholesale Distributor Software, where schemes, targets and rebates from manufacturers are central to the margin and have to be earned and claimed.
- Multi-Store Retail Software, where the same item's margin differs by store because of local pricing, local shrink and local markdowns.
Why retailers choose Pentoggle for margin management
Cost of what sold, on your accountant's method
Margin against the cost carried on the units that actually sold, not the last invoice or a standard set once.
Every erosion attributed
Discounts, returns, shrink, cost variance and channel fees placed where they happened, so the gap has causes rather than a percentage.
Rebates and support matched back
Supplier contributions held against the periods and items they relate to, so they are part of the margin rather than a surprise.
Planned against actual, by cause
The margin the price list implied for each sale, against what remained, with the difference broken down.
Sits around your accounting
QuickBooks, Tally, Xero and comparable systems continue producing gross margin at the level the accounts require, with valuation and treatment set by your accountant. Pentoggle adds margin at the level decisions are made.
A useful number for margin management
The gap between planned and actual margin by category, with the gap broken down by cause.
The gap itself is the erosion. The breakdown is what makes it useful: how much of it was markdowns, how much returns, how much shrink, how much cost variance, how much channel fees, how much offset by rebates.
Read it by category rather than by item for the regular view, because category is where buying, pricing and promotional decisions are made. Item level is for the investigation once a category has been flagged.
Read the movers. The categories whose gap widened most against the previous period, and the cause that grew, are the month's conversation. A gap that is stable and understood is a cost of doing business; one that is growing without explanation is not.
Ready to build retail margin management software?
You know your gross margin for the quarter.
You may not be able to say which categories earned less than they were priced to earn, or how much of that was markdowns, how much was returns and how much walked out of the store.
Describe your categories, your channels and where you think margin leaks to Pentoggle in plain English and generate a working first version in hours, then refine it around your process.