Fees never reach the product view
Channel or payment fees stay in another source and never enter product margins. The report makes products look more profitable because the selling costs tied to them are invisible to the math.
Data analysis & dashboards
Find the costs missing from your product margins
Products look profitable because the report leaves out refunds, delivery costs or selling fees, so your decisions rest on partial math. We find the costs you have, apply your approved margin definition and show allocations and missing costs clearly.
Discuss this problemHow We Help
We start with the margin measure your finance and commercial owners want to use. Cost data may arrive later than sales, or it may apply to a whole order and not to each product. Those differences need clear handling before the numbers get combined. We trace sample returns and charges to their orders, then review allocation assumptions (how shared costs get split) with the right owner. Sample transactions then test the revised math. Estimated and unavailable costs stay clearly separate from costs confirmed as zero.
Signs This Is the Problem
Returns leave original profit intact
A refunded order keeps its original profit in the product view. You have given the customer their money back, but the report still counts that sale as an unchanged gain.
Shared shipping costs have no rule
Order-level shipping has no agreed way to split across products. Comparisons rest on unstated assumptions, so staff can't tell whether differences show real product performance or the way shared costs were left out.
What We Investigate
List your cost sources
We list the costs available and mark each one as actual, estimated or allocated. Source dates and links between records show whether each cost can be reliably tied to an order or product.
Trace return and fee links
We match refunds and channel charges to the original orders and lines. Missing references or late cost data can explain why an otherwise valid sale never receives its matching adjustment.
Review allocation assumptions
Allocation assumptions get reviewed with finance or the commercial owner. Shared delivery and other order-level costs need an approved rule before they can support meaningful product comparisons.
What We Repair
Bring approved costs into the model
We connect supported cost sources to the agreed margin model and keep the relevant dates and references. Evidence you don't have stays visible as missing and does not turn into a confirmed zero cost.
Make allocation rules explicit
We apply the approved allocation for shared charges and label estimates clearly. Staff can then compare products using the same assumptions, without unknowingly mixing cost bases that don't match.
Account for returns and late costs
We add reviewed returns and late costs using the agreed period treatment. Sample orders get recalculated so we can explain the change before staff compare revised past margins with earlier reports.
How We Verify the Fix
- A sample product margin includes the cost categories approved for that measure.
- A returned line changes margin using the agreed refund and cost treatment.
- An order-level shipping charge follows the documented allocation across its product lines.
- Missing or estimated costs stay visible and do not appear as confirmed zero values.
Questions About This Work
Can exact margin be calculated for every item?
Only with enough cost evidence at a suitable level. Shared charges may need an allocation, and delayed costs may start as estimates. We keep those distinctions visible, so staff do not mistake a convenient calculation for fully known product profit.
Who approves the allocation method?
Your finance or commercial owner chooses the allocation rule. We explain what the available data supports and test the math. Shipping or fees should not be spread by an arbitrary formula hidden in the system without the report owner's agreement.
Will earlier reports change?
They can, if the relevant costs are available and the revised definition includes them. We document that change and review comparisons with the owner. Adding costs that were left out before is different from an unexplained drop in how the products really perform.
Tell Us What Is Happening
Name your sales, cost and reporting platforms. Share one order, with private details removed, whose margin leaves out a known refund, shipping cost or fee, so we can trace the missing category and the approved calculation.
Explore Data Analysis More problems in Data analysis & dashboards
Ready to Get Started?
Tell us about your project and we'll get back to you within 24 hours.