A Bad Margin Is Usually a Bad Input
A number that looks alarming is a question, not a verdict. Before you change a price or a plan, check the assumption the number was built on.
You run a product margin report. Most lines sit where you expect, somewhere in the forties. One line sits at nine percent. It glows red on the first screen.
The fast response is to act. Raise the price. Drop the item. Call the supplier and push back on cost. Each of those feels responsible. Each is wrong if the number itself is wrong.
What the report actually knows
A margin report doesn't know your products. It only knows the entries someone made. A margin needs a sale price and a cost per unit. The cost per unit comes from the item record: what you paid, and how many units that purchase covered.
Now suppose the item was set up so each purchase counts as one unit, but the supplier ships a case of twelve. The software believes every unit you sell cost you a full case. The margin on that line looks terrible. Nothing about the product is wrong. One field in the item record is.
Fix the unit of measure and the line jumps back into the forties. It may even be one of your better items. Had you raised the price, you would have made a healthy product harder to sell and blamed it for a problem it never had.
The report did its job
It is worth being fair to the report. It found the one line out of dozens that didn't fit. Nobody scanning a price list would have caught it. That is exactly what you want a report to do.
What it can't do is tell you why. It can't open the item record, call the supplier or read a packing slip. Somebody has to go and check what sits underneath the number.
The same pattern turns up all over a set of books:
- An expense category jumps because one bill was coded to the wrong account.
- A customer looks unprofitable because their refunds landed in sales instead of returns.
- A month looks like a loss because an annual insurance premium was expensed at once instead of spread over the year.
In each case the arithmetic is correct. The input is not.
How we handle a surprise
When a line on a report moves far from its own history, we flag it and trace it back to the source records before anyone acts. These are two separate steps. The flag points to the line. The source records explain it. Most bad decisions start when someone takes the first step and skips the second.
The takeaway: When one number looks shocking, find the record it was built from before you change a price or a plan.
Want these checks running on your books?
We set this up on your books and your rules, and nothing posts without your approval.
Book a call