Margin between warehouses
How to find the orders that eat your profit in 30 minutes
4
min read
Practical guides
Basics
At month-end the owner asks one thing: sales were strong, so where did the profit go?
For distributors it's usually a series of orders that look normal until someone breaks them down. One ships from the wrong warehouse and picks up extra logistics cost. Another gets discounted without anyone seeing the true cost of the batch.
On paper both still look like wins. In the P&L they're already eating margin.
The harder part is timing. Once accounting closes the month, the team is reconstructing where the loss happened. Below are 4 patterns that quietly drain profit in distribution, and a Monday-morning checklist for where to look first.
What this loss looks like in numbers that actually hurt
Rough numbers to show the shape of it. These are illustrative, not measured from a client:
12 orders in a quarter that came in below target margin, 500 EUR of margin lost on each. That's 6,000 EUR.
40,000 EUR sitting in stock that doesn't move. The report still counts it as an asset. For the owner it's money that can't restock a winning SKU or fund a calmer conversation with a supplier.
4 clients paying late while 3 deliveries slip. Cash gets tight exactly when the business needs it.
That's how profit leaks between warehouses. Each decision is made without the full economics of the order in view, and each one is still fixable at the moment it's made.
Finance teams usually analyse narrower layers of this separately: inventory shrinkage and carrying cost. For a business leader the question is concrete: which orders and which SKUs are pushing profit down right now?
4 places where margin usually disappears
1. The order ships from the wrong warehouse
The order is created against stock in warehouse A. By shipping time the item has gone to another priority order, so the team fulfils from warehouse B, pays for a transfer, loses a day, and never attaches that extra cost to the order.
What to check: every order in the quarter where the shipping warehouse differs from the one selected at order creation. Each case looks small on its own. The accumulated number is usually the first hidden hole in margin.
2. Dead stock pretends to be healthy inventory
An item hasn't sold in 6 months, but it's still active in the catalogue and still counted like normal stock. In the report it's inventory. In the business it's frozen money and a discount you'll have to give later just to clear the shelf.
What to check: SKUs with no outbound movement for more than 180 days, ranked by inventory value. The top of that list usually explains more than any aggregate warehouse KPI.
3. Discounts are given without a real cost check
The sales manager sees the price list and the client. The unit economics of the deal stay out of view: the purchase rate of the batch, allocated logistics cost, rebate logic, and the client's accumulated conditions.
On paper the discount looks small. At order level it can push margin to zero or below.
What to check: deals with negative margin, and deals below the target margin for their product category. If you can't pull that list without exporting to Excel and reconciling by hand, you're missing visibility into order economics.
What matters during review: the order in client context and the margin on a specific deal, on one PowERP screen. Demo screenshot.
4. FX loss hides between receipt and sale
The batch arrived in EUR, the sale was invoiced in PLN, and 2 or 3 weeks passed in between. The rate moved. Until the month closes, that erosion still looks like a normal deal.
What to check: orders where sales currency differs from purchase currency and a meaningful gap sits between stock receipt and sale. It matters most for distributors with thin margin, where a modest FX move eats the profit on popular SKUs.
Where to start on Monday morning
If time is short, start with 4 short lists:
Orders that involved a warehouse transfer or a changed shipping warehouse
SKUs with no movement for more than 180 days, ranked by inventory value
Deals with negative margin or margin below target
Sales where order currency differs from purchase currency
These 4 name the orders and the SKUs to put in front of sales, purchasing, and the warehouse. Each one is a filter over data you already have.
How to solve this without a separate BI project
You need a working connection between the order, the actual cost, the warehouse, and the stock movement. Without it the team goes back to manual analytics, and the answers arrive after the month is already closed.
PowERP covers part of this today:
Order-level margin at creation time: percentage and absolute value, visible before the deal moves further through the process.
Margin built from cost, price and the currency rate, so a discount gets judged against the deal's own numbers.
Multi-warehouse records: transfers between warehouses are recorded alongside receipts, write-offs and the stock archive.
Warehouse balances on the cash-flow forecast (Plus and Pro): the money tied up in stock sits next to the cash you're planning with.
Open it in the morning and you can see which deals and stock positions are pressuring profit.
Conclusion
When margin drops, the cause is usually ordinary. Profit leaks at the seams: between warehouses, between discount and actual cost, between purchase currency and sales currency, and inside stock that stopped moving.
If after a quarter you still can't name the orders and SKUs that hurt profit most, you can't see where the losses actually are.
